Fetching Posted Payments - API/Odata

Like (1) Share

Report

Posted on 4 Jun 2024 06:59:53 by CU04060653-0

I've been trying to fetch all posted payments using the V2 Apis.

The /customerpayments and /vendorpayments endpoint return only the draft payments (journal lines).
I am now trying to fetch the posted payments from the VendorLedgerEntries and Cust_LedgerEntries endpoints using Odata but i only get the contact and invoice document numbers. Is there any way from which i can directly get the posted payments with the proper contact and invoice platform unique id.

If not possible, how can i create a custom web service to fetch the posted payments.

All responses (2)

Answers (0)

Aaron Bauldree 19 on 04 Jun 2024 at 20:46:53

Like (0)

Report
Fetching Posted Payments - API/Odata

To fetch posted payments via API, you're looking in the right place by checking the Customer Ledger Entries. While I'm not familiar with the exact data on that page, I can share my experience with custom API pages for similar data.

If you need more details about the Customer and Invoice for each payment, you have a couple of options:

Request Ledger Entries and Loop Through: You can request the Ledger Entries and then loop through them, making separate API calls to fetch the customer and invoice details. While this method works, it can be somewhat heavy and less efficient.

Create a Custom API Page: A better approach would be to expand the custom API page for the Customer Ledger Entries to include the necessary fields from the Customer and Invoice tables. Once you've created this custom page in BC, you can publish it as a Web Service.

By creating a custom API page, you can directly get the posted payments with the proper contact and invoice platform unique IDs.
gdrenteria 16,961 Most Valuable Professional on 04 Jun 2024 at 09:02:12

Like (0)

Report

Fetching Posted Payments - API/Odata

Hi

I hope this can help you and give you some hints.

Where are Applied Customer Entries? - Business Central/NAV - Dynamics User Group

BR

GR