Skip to main content
Question

Retrieving Supplier Balances via Postman

  • Jan 9, 2025 9:59 AM UTC
  • 6 replies
  • 105 views
  • Translate All

Forum|alt.badge.img

Hi All,

Is there a way to retrieve the Supplier Balance, Prepayment Balance, and Retained Balance details (as shown in the attached image) for a particular supplier through a Postman call?

Any guidance or suggestions would be greatly appreciated.

Thanks,
Lalith

6 replies

Dipak Nilkanth
Pro III
Forum|alt.badge.img+14

Hi ​@Lalith,

Have you tried with extending endpoint?

Try to extend endpoint and add those Balances field to the extended entity.
Hope, it helps!

Translate

Forum|alt.badge.img
  • Author
  • Freshman I
  • Jan 9, 2025 1:18 PM UTC

Hi ​@Nilkanth Dipak,
Thanks for your reply.

I’ve already attempted to retrieve the Supplier Balance, Prepayment Balance, and Retained Balance fields through the endpoint (with extending), but I encountered an issue. These three fields appear to belong to a table that does not exist in the database.

Additionally, I tried including these fields in a Generic Inquiry, but it returned an error due to the fields being non-existent in the database.

Please let me know if there’s an alternative way to retrieve these details.

Thanks.

Translate

Dipak Nilkanth
Pro III
Forum|alt.badge.img+14

​@Lalith, Yes, you are right. I believe The Vendor entity returns records in the form of a list, and those fields should be added to the specific record being returned, not the entire list.

Translate

Forum|alt.badge.img
  • Author
  • Freshman I
  • Jan 10, 2025 6:05 AM UTC

​@Nilkanth Dipak , If you know, could you please mention the API call details here for reference or just mentioned work around?

Thanks.

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • Apr 24, 2025 11:04 PM UTC

Hi ​@Lalith were you able to find a solution? Thank you!

Translate

Forum|alt.badge.img
  • Author
  • Freshman I
  • Apr 25, 2025 3:06 AM UTC

Hi ​@Chris Hackett still didn't.

 

Thanks.

 

Translate