Finance | Project Operations, Human Resources, ...

Accounts receivable - Penny difference in customer payments

(0) Share

Report

Posted on by Tone Ramm

Hi all,

I'm working on a support case for a customer regarding penny difference.

On the same date they receive 3 payments from on of their customers, all of which have penny differences less than NOK 1,00. The payments are imported into a customer payment journal using a file from their bank.

In the AR parameters, D365 has been set up clear penny differences up to NOK 1,00 upon posting of the payment.

For two of the invoices involved, the penny difference is automatically posted as expected.

However, for one of the invoices, the balance of the invoice equals the penny difference after posting of the payment, and this is something our customer experiences from time to time.

Have anyone encountered this before? Looking forward to hearing from you.

Br/Tone

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Tone,

Were the three invoices treated equally at the time when the payment was settled or did you set some different parameters e.g. for a full settlement or in regards to the use of cash discounts?

Best regards,

Ludwig

Was this reply helpful? Yes No
Tone Ramm 19 on at

Like (0)

Report

Hi Ludwig,

All tree invoices and payments are treated as equally as possible. The project invoices are posted on the same day, and the same with the payments. No changes in the setup har been done.

Below a clipping of the transaction, the green ones are settled as expected, the yellow not.

Br/Tone

Was this reply helpful? Yes No
André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (1)

Report

Hi Tone,

As the journal has been posted, it would not be visible anymore what exact settings were done for the settlement. It could be caused by the reason provided by Ludwig, but it could be also a bug. Are you able to reproduce this issue in a test environment?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi Tone,

Many thanks for the update.

If you can reproduce the issue in a demo/test environment then there is a certain likelihood for a bug. In this case, I would recommend contacting the MS support and show/share things with them.

Best regards,

Ludwig

Was this reply helpful? Yes No
Tone Ramm 19 on at

Like (0)

Report

Hi André,

As the payments were posted in the same journal, I do not think a possible change in the setup could be the root cause.

Yes, I was able to reproduce the issue in a fresh UAT-environment. I received the payment file from our customer and the same issue occured.

I suspect it could be a bug, but wanted to check if others have encountered this before going ahead with a developer.

Br/Tone

Was this reply helpful? Yes No
Tone Ramm 19 on at

Like (0)

Report

Hi Ludwig,

Yes, been able to reproduce the issue, so it is likely that it is caused by a bug. Thank you for taking the time to assist me.

Br/Tone

Was this reply helpful? Yes No
Tone Ramm 19 on at

Like (0)

Report

Thank you for your assistance, André.

Br/Tone

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Tone,

Would be great if you could open a support case with MS and keep us updated about the outcome.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Tone Ramm 19 on at

Like (1)

Report

Hi Ludwig,

I'll keep you updated on the outcome.

Kind regards

Tone

Was this reply helpful? Yes No
Suggested answer

Unknown User 10 on at

Like (0)

Report

Hi Tone K Ramm ,

Did you find a fix for this issue? Im facing the same problem with customer payments, would be great help if you could share your experience.

Was this reply helpful? Yes No