Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anish20in
Starting Member
18 Posts |
 Posted - 2012-04-09 : 09:20:20
|
| Hi All- I have a requirement to create a sales bill using SQL Server 2008 and Crystal report. The current sales bill is in Tally 9. I had import the Tally tables in to SQL Server 2008. Please provide me an SQL query for getting Sales Bill data from Tally tables. I hope a single query can do this. Please help me ASAP.Regards,Kunjappy |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2012-04-09 : 10:14:15
|
| Follow the "How to ask" link ASAP and you may get some help.How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
anish20in
Starting Member
18 Posts |
Posted - 2012-04-09 : 10:27:42
|
| For example - the SQL SELECT to fetch Voucher entries (Stock details) is" SELECT all vchmain.vchid,vchmain.vchnumber,vchmain.reference,vchmain.vchdate,mv.name as vchtype,mv.parent as basevchtype,ms.name as stockitem, vchinv.actualqty,vchinv.billedqty,mu.name as unit,vchinv.rate,vchinv.amount, vchinv.discount FROM vchinv,masterstockitem ms,vchmain,mastervouchertype mv,masterunit mu WHERE vchmain.companyguid='6f273852-3e2d-477b-9800-8d13d6fae87b' and vchinv.itemguid=ms.masterguid and vchinv.unitguid=mu.masterguid and vchinv.vchguid=vchmain.vchguid and vchmain.vchtypegui "The same way, any idea to get Query for Sales Bill informations ???Regards,Kunjappy |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2012-04-09 : 13:07:21
|
| Since I have no idea of what the schema looks like, I have no idea how to help.How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
anish20in
Starting Member
18 Posts |
Posted - 2012-04-10 : 07:26:23
|
| I need to create a Sales bill report. I need to pull the data from Tally to SQL Server 2008. My query is, what are the tables used for creating Sales Bill? . Can you provide the query for getting the Sales Bill datas from the DB(imported from Tally to SQL 2008). I check this query for SQL SELECT to fetch Voucher entries (Stock details). The same way, query to fetch data for sales bill???RTSLink DLL or DX-Fusion is best option for my requirement??????Kunjappy |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-04-10 : 10:01:52
|
We have no idea what is Tally and how the schema looks like. Looks like you want to know about the schema related to "Sales Bill", if this is the case you should be asking your question to their technical support.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
|
|
SQL Query for Getting Tally Sales Bill Details