Hi. Is there any Rest API in Acumatica that returns the AP Vendor Balance? This value is not available in the vendor table so not sure how to expose via a GI and can’t find a Rest API that has it.
Thanks!
Answer
Fetching AP Vendor Balance
Best answer by ricoybanez
You can create a Generic Inquiry
Table Name = PX.Objects.AP.APInvoice
Data Field = CuryDocBal (this is the Balance Amount)
Group by = VendorID
G.I. Preview
+3
You can create a Generic Inquiry
Table Name = PX.Objects.AP.APInvoice
Data Field = CuryDocBal (this is the Balance Amount)
Group by = VendorID
G.I. Preview
Rico P. Ybanez
That worked. Thanks.
The only caveat is taking in consideration the doc type column value so can + or - the value depending on the doc type value.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.