Recreating invoices from AccPac database

[DavidMWilliams]

We're using AccPac Advantage 5.1 on Windows, with SQL Server as the database.

I want to be able to re-generate invoices on our Web site (for clients, via a password-protected login). By invoices, I mean invoices we have sent to clients, not invoices received for us to pay.

Can anyone give me a hand working out the database, tables and fields I need?

Thanks !

David M. Williams
National I.T. Manager
Advantage Personnel Pty. Ltd.
AUSTRALIA

 

[sblocher]

Tables that contain invoice data are ARIBH and ARIBD. There are other related tables which may or may not be relevant to you. Best way may be to look at the design of the Crystal invoice report (ARDINVO.RPT).