What DB Field can I find the Open AR Amount in?

[DanFuhrmann]

I need to Sync down a customers Open AR Amount from a ACCPAC ERP Advantage 5.5 database.

Looking at the ARCUST Table I see that there are alot of fields that start with AMTBAL... I believe the value of one of these fields are what I want.

Is there any documents that map/describe the tables fields? What is the best way for me to find out where the "Outstanding Balance" amount on the Activity page of the A/R Customers form is getting pulled from?

Thanks.

 

[ettienne]

Yes the are document on the Accpac website, look for Accpac Object Model.
You are looking for:
ARCUS.AMTBALDUET = balance due in customer currency
ARCUS.AMTBALDUEH = balance due in functional currency

 

[ettienne]

Sorry that should be Application Object Model.

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