Shahbazomeara
asked on
How to add records into invoice.dta data file of sage from VB6
I need to open data file with extension DTA, which is actually a data file of sage accounting software. I have been searching, if I could find any way to Add data into Invoice table of sage from VB but I could not find.
I thought might be is there any other way could open directly the data file to add data into Invoice file, OR if you know any other way I could add data into sage database.
I know ODBC data connection is read only, and to use sage data object I need registeration key which could be bought from sage for £1500. I don't want to spend that much money.
Hope fully anybody will be able to help me in this matter.
Regards
I thought might be is there any other way could open directly the data file to add data into Invoice file, OR if you know any other way I could add data into sage database.
I know ODBC data connection is read only, and to use sage data object I need registeration key which could be bought from sage for £1500. I don't want to spend that much money.
Hope fully anybody will be able to help me in this matter.
Regards
moorhouselondon
You don't need to is the ideal answer. Think of it the other way round (which is the way I do it in practice). Suppose you have a customer who wants extra info which is not in Sage. Have separate tables which contain the info you want, when you print out an invoice you do it from your data, adding in the bits you want from the Sage data. The resulting invoice is contained within your program, not in Sage.
ASKER
Thanks for your reply,
I will try to explain you what I need to do.
I have developed a software for Travel Agents which stores and print Invoices. Most of the travel agents who use my software they use Sage Instant Accounting software to manage their accounts, Its mean they will print invoice on my software and manaully enter the invoice information into sage to do posting to all relevant accounts.
That's why to reduce the manual work I am looking at the ways to import invoice information to sage.
If you could help me in this matter, I will be very greatful.
regards
I will try to explain you what I need to do.
I have developed a software for Travel Agents which stores and print Invoices. Most of the travel agents who use my software they use Sage Instant Accounting software to manage their accounts, Its mean they will print invoice on my software and manaully enter the invoice information into sage to do posting to all relevant accounts.
That's why to reduce the manual work I am looking at the ways to import invoice information to sage.
If you could help me in this matter, I will be very greatful.
regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.