Skip to main content
Question

Retrieving Supplier Balances via Postman

  • January 9, 2025
  • 6 replies
  • 70 views

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

DipakNilkanth
Pro III
Forum|alt.badge.img+13

Hi ​@Lalith,

Have you tried with extending endpoint?

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


Forum|alt.badge.img
  • Author
  • Freshman I
  • January 9, 2025

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.


DipakNilkanth
Pro III
Forum|alt.badge.img+13

@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.


Forum|alt.badge.img
  • Author
  • Freshman I
  • January 10, 2025

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

Thanks.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • April 24, 2025

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


Forum|alt.badge.img
  • Author
  • Freshman I
  • April 25, 2025

Hi ​@Chris Hackett still didn't.

 

Thanks.