Finance | Project Operations, Human Resources, ...

Accounts payable penny difference account invoice vs payment

(0) Share

Report

Posted on by Vinod Kumar Reddy

283

Hi Team,

We have scenario like for vendor we have to pay $10000 invoice amount but the vendor paid is $9997. it is not cash discount.

Question 2: how to account the difference of $3?

Question 3: if suppose i want to take difference of $3 from future invoice how to set up?

Thanks,

Vinod

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Vamsi Pranith 682 on at

Like (0)

Report

Did you try setting up cash discount and see if that works? It looks like, you want to have an invoice for $10000 but pay only $9997and that is only doable if you use cash discount.

Was this reply helpful? Yes No
Vinod Kumar Reddy 283 on at

Like (0)

Report

Thanks for reply Vamsi , it is not a cash discount i want to set up like $3 vendor will not pay so that is penny amount so how system will clear full payment with $9997.

Was this reply helpful? Yes No
Suggested answer

Vamsi Pranith 682 on at

Like (0)

Report

I'm trying to vision what you want to do. So you are saying you want to short pay the vendor, instead of the full amount reduce some out and pay, in your case $9997 instead of $10000? Why is that the vendor would have to be short paid? Any particular business reason? I'm trying to see what the reason could be. Nevertheless, when you do the settlement on the payment journal, there should be something called as Amount to settle. You can enter how much ever you want to settle and have the payment journal posted. Check if that solves your requirement.

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

pls see if this helps

community.dynamics.com/.../penny-difference-rounding-amount-in-purchase-order-invoice-in-microsoft-dynamics-365-finance-and-operations-apps

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Vindod,

What you can make use of is the full settlement function.

Here is an example how this works:

1. Pay $97 for an open invoice of $100

2. Open the settlement form and make sure the full settlement checkbox is marked

3. Post the payment and check the voucher.

Result: The complete invoice amount is settled. The $3 difference is posted as follows:

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,194 Super User 2025 Season 2 on at

Like (0)

Report

Hi Vinod,

You got the reply for question 2. For question 3, you can leave the remaining amount open by not settling the $3. However, you can't settle it with another invoice. You can only settle it with a payment or credit note.

PS: Do you also have a question number 1?

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

Hi Vinod,

Two options:

1. Settlement Reminder feature: Using this you can account this difference in any Main account with reason code. Here is the blog for the same:

exploredynamics365.home.blog/.../

2. Settle with next Invoice: While selecting next invoice , select this as well with that, system will give net amount for payment and it will get settled. So, lets see next invoice for 500 USD when you will select next invoice plus this , net payable will be 497

Was this reply helpful? Yes No