Accpac Data Structure and Crystal Reports 1

[JoAnnW]

Hi,

I am a newbie and was wondering if anyone out there could let me know if there is some place to get hold of the data structure for Accpac.

I am trying to create ad-hoc reports in Crystal Reports, querying Accpac Advantage Series v5.2A, via Pervasive SQL database. (I do not have a very strong IT background but am willing to learn)

I have figured out that the first 2 characters of the table names correspond to the various areas, ie. OE= Order Entry, AR= Accounts Receivable, AP = Accounts Payable, PO = Purchase Orders, etc.

There are so many tables and so many fields that I am having difficulty in narrowing down my search for the correct field to create my reports.

So far the only thing I have found is an on-line course with sage, which will be held in Sept. 07.

Any help that someone can provide me would be greatly appreciated.

Thanks,

Jo-Ann Woollard
Mixology Canada Inc.

 

[irenavassilia]

Hope this helps:

http://www.priceconsulting.ab.ca/cgi-bin/accpac.cgi

 

[JoAnnW]

Thank you for that, It does help a little however there is no mention to the VM tables.

I am also trying to get a better understanding of the different fields since there are several references to data with different extentsions(ex - amtbalduet, amtbaldueh, amtbalhit, etc.)

Any more help would be greately appreciated.

Thank you.

 

[ettienne]

Option #1:
If you are registered with Sage Accpac then you can grab the AOM (Accpac Object Model) from their website:

http://support.accpac.com/techsupport/aom/advantage.asp

The company who you ar edoing the reports for should have a login ID for the Sage Accpac website. This does not include 3rd party modules like VM.

Option #2:
Click Start, Run and type in ACCPACVIEWINFO and press ENTER. This gives you all the info to the Accpac tables, including VM (which is Techisoft Service Manager). Once you have the screen open you will see a tree with all the modules (AP, AR, ...), expand AP and you will see all the RotoIDs (AP0001, AP0002, ...). Click AP0001 and look at the DllName, this gives you the table name APP01, and the Description gives you Company Options. Just run down the list of RotoIDs until you find the table you need, and then you have the complete structure at your finger tips.

Option #3:
Attach the Accpac tables to an Access database and browse around, you will eventually figure out the structure.

 

[JoAnnW]

Thank you for your help

Ettienne - your advise was extremely helpful. Thanks a million.

Jo-Ann