Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting Oustanding A/R Balance 1

Status
Not open for further replies.

NeilN

IS-IT--Management
Jun 16, 2004
24
CA
Is there a API function that I can call that will give me the current A/R balance for a customer ID? If not, any suggestions as to how to get this info?
 
I assume you are refering to the AccpacCOMAPI. You can use the Fetch method. There are samples on how to do that on this forum. Or you can use ADO if you are just grabing information.
 
Yes I am, thanks. But what should I be fetching? Is there a table somewhere that holds the A/R balances?
 
From the customer view AR0024(ARCUS Table) grab the AMTBALDUEH field to give you the current AR Balance for a customer.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top