Applying Multiple Advance Payments Against a Purchase Invoice in Business Central

(8) Share

Report

Posted on by Dharmesh

354

Dear Experts,

I need to apply multiple advance bank payments against a single purchase invoice at the time of posting the purchase invoice using:

Application → Applies-to Doc. Type → Applies-to Doc. No.

However, Business Central currently allows applying only one payment through this option.

Is there any standard way to apply multiple advance payments against one purchase invoice?
This is required due to TDS deduction, where multiple advance payments must be adjusted against a single invoice.

Additionally, please guide me if anyone has implemented any customization or workaround to handle this requirement in Business Central.

A screenshot is attached for reference.

Looking forward to your guidance.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

Dhiren Nagar 2,904 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hi,

Follow the below steps exactly.

1. On your Application tab in Applies-To ID field enter anything like ABC or userid or any unique CODE.

2. Click on Applies-To Doc. No. field Assist button (three dots in the side of field).

3. On the Apply entry page, select the multiple lines you want to apply, click on Set Applies to ID.

4. Now if you open Page inspect you will notice that your unique Applies-To ID is also set on all those ledger entries.

5. Click on Cancel. Yes Cancel, do not click on Ok.

6. Now preview post/post your invoice.

Regards,

Dhiren.

2 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Kamal Khakhkhar 3,343 on at

Like (4)

Report
Copy link

Link copied!

Hii There as per requirement there is custom function requires as in base its not allow to update the multiple prepayment for document .

as for this we provided setup to customer for this through that they can create multiple prepayments as per their requirement.
also provided same in this
https://community.dynamics.com/forums/thread/details/?threadid=c699cbd8-cb0c-4ef4-8b4c-541f0fb11a85

if you found answer mark it answered.

Thank You,
Kamal Khakhkhar

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Pallavi Phade 5,506 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Namaste @Dharmesh

If there are multiple payments then you can go to Vendor Ledger Entries , Select the invocie and do "Apply Entries"

You can apply against the payment documents with partial amount as per pending invoice amount

And the post Application on desired posting date .

In this way you can apply multiple payment against single invoice from Vendor Ledger Entry screen

Warm Regards

Pallavi Phade

www.linkedin.com/in/pallaviphade131116

1 people found this reply helpful.

Was this reply helpful? Yes No
Dharmesh 354 on at

Like (1)

Report
Copy link

Link copied!

Thanks to @Dhiren Nagar, this is working as per my requirement. It really helped me and saved my time.

Thanks to @Kamal Khakhkhar for your reply. As mentioned, TDS is not applicable on prepayments; however, I require the TDS amount to be adjusted.

Thanks to @Pallavi Phade for your efforts and response. I need to adjust the TDS amount while posting the purchase invoice with a TDS difference. In this scenario, payment application is mandatory before posting the purchase invoice.

Thank you all for your support.

Was this reply helpful? Yes No
Suggested answer

Pallavi Phade 5,506 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Namaste @Dharmesh

In that case , solution number 1 will work .

Warm Regards

Pallavi Phade

www.linkedin.com/in/pallaviphade131116

Was this reply helpful? Yes No
Dharmesh 354 on at

Like (0)

Report
Copy link

Link copied!

Dear @Dhiren Nagar

I am facing an issue in this entry related to TDS adjustment.

The TDS amount is getting adjusted correctly, and the ledger entries are also showing properly in the TDS Ledger Entries. However, the Vendor Ledger Entries are not getting updated correctly.

For example:

-Total Invoice Amount: Rs. 5,00,000

-GST Amount: Rs. 90,000

-TDS Amount: Rs. 50,000

Two payments are applied as below:

-Payment of Rs. 2,00,000 with TDS amount of Rs. 20,000

-Payment of Rs. 2,00,000 with TDS amount of Rs. 20,000

Based on this, the system adjusts the TDS amount correctly (Rs. 10,000 against the remaining Rs. 1,00,000 balance).

However, in the Vendor Ledger Entries, the remaining amount is shown as Rs. 3,90,000. It appears that the system has adjusted only one payment entry of Rs. 2,00,000, while the other payment entry is not reflected correctly.

Kindly guide me on how to properly adjust the remaining amount in the Vendor Ledger Entries so that it matches the TDS adjustment.

Looking forward to your guidance.

Was this reply helpful? Yes No