x Want to participate? Join the group to interact

Sage 300

Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

General Discussion Customer Balance

Customer Balance

Posted By Andrew1986 over 2 years ago

In Sage 300 the Customer has three balances:

But via API Sage 300 returns only the Outstanding A/R Balance.
How to receive A/R Pending Balance and Total Outstanding Balance via API?

Top Replies

Jay Converse Acumen over 2 years ago in reply to Andrew1986 +1

Sorry, I don't use the WebAPI, it has too many holes. If you do a Get on ARInvoiceBatches you should be able to find the unposted records.

Jay Converse Acumen over 2 years ago

Query unposted AR invoices in ARIBH
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Andrew1986 over 2 years ago in reply to Jay Converse Acumen

Could you clarify the Endpoint name that I should call?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Jay Converse Acumen over 2 years ago in reply to Andrew1986

Sum records in ARIBH for that customer where the corresponding ARIBC.BTCHSTTS=1
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Andrew1986 over 2 years ago in reply to Jay Converse Acumen

Jay,

I am so sorry. I don't have much experience with Sage 300 API.

Could you provide an example of how to do it? I mean the example of a full endpoint.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Jay Converse Acumen over 2 years ago in reply to Andrew1986

Sorry, I don't use the WebAPI, it has too many holes. If you do a Get on ARInvoiceBatches you should be able to find the unposted records.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Cancel
Andrew1986 over 2 years ago in reply to Jay Converse Acumen

Thank you!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel