Mohana's D365 Business Central & NAV Blog: Apply multiple invoice entries against a payment entry through APIs in D365 Business Central

Step 1: Get the Payment Journal Batch that we want to use in Business Central

We can get Payment Batch details using vendorPaymentJournals API

{

"value": [

{

"@odata.etag": "W/\"JzQ0O0R2KzNtQjdWREIybjJRRnV5b1hFVG44b3NqNlZqbDVVWVNHUWtQNzZ4L2c9MTswMDsn\"",

"id": "30e08afa-78f1-ea11-bb43-000d3a2e8412",

"code": "CASH",

"displayName": "Cash receipts and payments",

"balancingAccountId": "00000000-0000-0000-0000-000000000000",

"balancingAccountNumber": "10100",

"lastModifiedDateTime": "2020-09-08T02:14:48.853Z"

{

"@odata.etag": "W/\"JzQ0O0k4MlhkK29tK0w3STdOVE40dzdZRHhuTHNpSnppVTVJVWcxRTcvdjNSOWs9MTswMDsn\"",

"id": "32e08afa-78f1-ea11-bb43-000d3a2e8412",

"code": "GENERAL",

"displayName": "GENERAL",

"balancingAccountId": "00000000-0000-0000-0000-000000000000",

"balancingAccountNumber": "10100",

"lastModifiedDateTime": "2020-09-08T02:14:48.86Z"

{

"@odata.etag": "W/\"JzQ0O3pzQXAxMGt6bFVDN3ZUSlJQY1I0Zk0rOEFBY1NUUVhQM2dqelFqTEZHNEU9MTswMDsn\"",

"id": "34e08afa-78f1-ea11-bb43-000d3a2e8412",

"code": "PMT REG",

"displayName": "Bank Reconciliation",

"balancingAccountId": "00000000-0000-0000-0000-000000000000",

"balancingAccountNumber": "CHECKING",

"lastModifiedDateTime": "2020-09-08T02:14:48.87Z"

}

]

}

I am going to use General Batch from the above list

"id": "32e08afa-78f1-ea11-bb43-000d3a2e8412",

"code": "GENERAL",

Step 2: Create a payment entry in Payment Journal using APIs

We can use vendorPayments API for this along with vendorPaymentJournals API

Body of the Post command

{

"journalId": "32e08afa-78f1-ea11-bb43-000d3a2e8412",

"vendorNumber": "10000",

"documentNumber": "323",

"externalDocumentNumber": "125",

"amount": 2000,

"description": "apply entries"

}

Response

{

"@odata.context": "https://api.businesscentral.dynamics.com/v2.0/8f0f6868-04b3-4834-8f54-49b21664eb18/Sandbox/api/v2.0/$metadata#companies(e93b67c5-78f1-ea11-bb43-000d3a2e8412)/vendorPaymentJournals(32e08afa-78f1-ea11-bb43-000d3a2e8412)/vendorPayments/$entity",

"@odata.etag": "W/\"JzQ0O1ZCVUNIQVVGTnBEM2l4aHVIOUZzczg0a0crNlh2TTlvQVpGbXJoZVBHR1E9MTswMDsn\"",

"id": "b3897612-e097-ec11-80f1-002248290747",

"journalId": "32e08afa-78f1-ea11-bb43-000d3a2e8412",

"journalDisplayName": "GENERAL",

"lineNumber": 10000,

"vendorId": "c6ec91f4-78f1-ea11-bb43-000d3a2e8412",

"vendorNumber": "10000",

"postingDate": "2022-02-27",

"documentNumber": "323",

"externalDocumentNumber": "125",

"amount": 2000.00,

"appliesToInvoiceId": "00000000-0000-0000-0000-000000000000",

"appliesToInvoiceNumber": "",

"description": "apply entries",

"comment": "",

"lastModifiedDateTime": "2022-02-27T15:15:18.987Z"

}

We can find the Payment entry in Business Central page

Step 3: Apply the above payment against multiple existing invoices in Business Central

We can get the open Vendor Entries details using applyVendorEntries API along with above VendorPaymentJournals and vendorPayments

{

"value": [

{

"@odata.etag": "W/\"JzQ0O0FuSldSUCt1NHhvY044aThWZjhicUI5T2RmYWxuYmhDNFhDVE9zdnZzSm89MTswMDsn\"",

"id": "ce27de32-4514-eb11-bbf7-000d3a9b9997",

"applied": false,

"appliesToId": "",

"postingDate": "2020-04-06",

"documentType": "Invoice",

"documentNumber": "108211",

"externalDocumentNumber": "107215",

"vendorNumber": "10000",

"vendorName": "",

"description": "Invoice 107215",

"remainingAmount": -1069

{

"@odata.etag": "W/\"JzQ0O29NSkJma2tXQWNPOUdBd2RtVExLZHVxdXRaMjQ0c1JabEJaeE1rM0NqNjg9MTswMDsn\"",

"id": "d7dd2968-5514-eb11-bbf7-000d3a9b9997",

"applied": false,

"appliesToId": "",

"postingDate": "2020-04-06",

"documentType": "Invoice",

"documentNumber": "108212",

"externalDocumentNumber": "107216",

"vendorNumber": "10000",

"vendorName": "",

"description": "Invoice 107216",

"remainingAmount": -690

{

"@odata.etag": "W/\"JzQ0OzcvcU1pSDZMRkZjR1BqbjNOdDllSnhSY1lMOXAyS2w1TlBudzU1T1FCd0E9MTswMDsn\"",

"id": "a4145e6f-5514-eb11-bbf7-000d3a9b9997",

"applied": false,

"appliesToId": "",

"postingDate": "2020-04-06",

"documentType": "Invoice",

"documentNumber": "108213",

"externalDocumentNumber": "107217",

"vendorNumber": "10000",

"vendorName": "",

"description": "Invoice 107217",

"remainingAmount": -460

{

"@odata.etag": "W/\"JzQ0OzFmdG5obUdMOFhzV1NOSjFpaS9zR1psM2ZuRUxTNncxbnJCaVVDYkQrR1k9MTswMDsn\"",

"id": "3a6bed91-8714-eb11-bbf7-000d3a9b9997",

"applied": false,

"appliesToId": "",

"postingDate": "2020-04-06",

"documentType": "Invoice",

"documentNumber": "108214",

"externalDocumentNumber": "107218",

"vendorNumber": "10000",

"vendorName": "",

"description": "Invoice 107218",

"remainingAmount": -230

{

"@odata.etag": "W/\"JzQ0O1pEOWpLU0JFS3k5SnEwdzc3Z0VOL21ZTEZub1BRRTlZZStOT0g1aTJmRTQ9MTswMDsn\"",

"id": "15c60da4-8714-eb11-bbf7-000d3a9b9997",

"applied": false,

"appliesToId": "",

"postingDate": "2020-04-06",

"documentType": "Invoice",

"documentNumber": "108215",

"externalDocumentNumber": "107219",

"vendorNumber": "10000",

"vendorName": "",

"description": "Invoice 107219",

"remainingAmount": -230

{

"@odata.etag": "W/\"JzQ0O21VcEpndldlenZRdG1teXllbi9OcGRUQnFSWmVldlBwVDBFejlBVFkrYnc9MTswMDsn\"",

"id": "d6366f3e-8a14-eb11-bbf7-000d3a9b9997",

"applied": false,

"appliesToId": "",

"postingDate": "2020-04-06",

"documentType": "Invoice",

"documentNumber": "108216",

"externalDocumentNumber": "107220",

"vendorNumber": "10000",

"vendorName": "",

"description": "Invoice 107220",

"remainingAmount": -230

{

"@odata.etag": "W/\"JzQ0O1hzNHhuSWdFU2U5NHI3dXd5dEJZdzg5VXh0MmM1QnRrajg4Qm5SQlluMDQ9MTswMDsn\"",

"id": "a8e34451-8a14-eb11-bbf7-000d3a9b9997",

"applied": false,

"appliesToId": "",

"postingDate": "2020-04-06",

"documentType": "Invoice",

"documentNumber": "108217",

"externalDocumentNumber": "107221",

"vendorNumber": "10000",

"vendorName": "",

"description": "Invoice 107221",

"remainingAmount": -230

}

]

}

Now, I would like to apply the above payment against invoices 108211 and 108212 which have remaining about as 1069 and 690 respectively.

Before that let’s check the apply entries page in Business Central

Now call the below Patch APIs

https://api.businesscentral.dynamics.com/v2.0/8f0f6868-04b3-4834-8f54-49b21664eb18/Sandbox/api/v2.0/companies(e93b67c5-78f1-ea11-bb43-000d3a2e8412)/vendorPaymentJournals(32e08afa-78f1-ea11-bb43-000d3a2e8412)/vendorPayments(b3897612-e097-ec11-80f1-002248290747)/applyVendorEntries(ce27de32-4514-eb11-bbf7-000d3a9b9997)

Don’t forget to add header “If-Match” as *

Body as

{

"applied": true

}

Response:

{

"@odata.etag": "W/\"JzQ0O2szUE5KRGVUeXZ3VVQzK0U5RE5KaFFlN3BobGFBL0YyRmVmSlBmR3lLcTA9MTswMDsn\"",

"id": "ce27de32-4514-eb11-bbf7-000d3a9b9997",

"applied": true,

"appliesToId": "323",

"postingDate": "2020-04-06",

"documentType": "Invoice",

"documentNumber": "108211",

"externalDocumentNumber": "107215",

"vendorNumber": "10000",

"vendorName": "",

"description": "Invoice 107215",

"remainingAmount": -1069

}

Now verify in Business Central

Applies-to ID field will have Payment Document No. field

Execute 2^nd API call with 2^nd Invoice

Response:

{

"@odata.etag": "W/\"JzQ0O2x2eGF3aFBCeTl3WjlSZ1RrbUQrc09GSGVVZEZ6RmozM0NoL3pvQk11YlU9MTswMDsn\"",

"id": "d7dd2968-5514-eb11-bbf7-000d3a9b9997",

"applied": true,

"appliesToId": "323",

"postingDate": "2020-04-06",

"documentType": "Invoice",

"documentNumber": "108212",

"externalDocumentNumber": "107216",

"vendorNumber": "10000",

"vendorName": "",

"description": "Invoice 107216",

"remainingAmount": -690

}

Verify in Business Central.

Second invoice line also has Applies-to ID as payment document no.

Step 4: Post the payment journal in Business Central

Go to Vendor Ledger Entries and verify the application

Payment Entry

Click on Applied Entries

Notice that 2 invoices are applied to the payment

Mohana's D365 Business Central & NAV Blog

Sunday 27 February 2022

Apply multiple invoice entries against a payment entry through APIs in D365 Business Central

No comments:

Post a Comment