Finance | Project Operations, Human Resources, ...

Amount discrepancy between product receipt and invoice

(0) Share

Report

Posted on by preeti_02

A customer has raised an issue regarding discrepancies between the product receipt and the invoice. For example, the product receipt is posted for $ 64.88 and the invoice is posted for $ 64.82.
This causes a balance of $ 0.06 to be displayed in their Accrued purchases report. This has happened for a lot of their POs. The customer would like to know how to clear this balance of 0.06.
I am not able to correct the product receipt as I cannot change the amount to be 0.06. Also cannot post a dummy invoice for 0.06 as this will cause the amount to be an open vendor balance.
Just wondering if anyone can help to find a solution for this issue.

I have the same question (0)

All responses (3)

Answers (0)

MATTGUO 22,349 Moderator on at

Like (0)

Report

Hello Preeti,

Which specific report are you talking about( Accrued purchases excluding sales tax report )?

If the PO is invoiced, the accrual purchase should be reversed. And the report should not display the record if select the correct Cutoff date.

Could you share some voucher screenshots of product receipt and invoice and the report?

Which version are you using?

Was this reply helpful? Yes No
SThakur 412 on at

Like (0)

Report

Why don't you do a credit adjustment note for the purchase order and reinvoice?

The general journal also lets you create a purchase credit note that has details of the original invoice.

Also, if this is recurring issue for one vendor or multiple vendors that need to be addressed within the team to understand the root cause before you offer any solution.

To avoid such situations you can look into the two way or three way matching setup in Dynamics 365 F&O which helps in handling such discrepancies better an ability to setup the price tolerances and matching policies.

docs.microsoft.com/.../accounts-payable-invoice-matching

Thanks,

Shilpi

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

Hello preeti_02,

Couple of questions.

1) After posting the invoice with value discrepancy; which main account is recorded in voucher to capture this 0.06 balance amount?

2) What is the type of that main account that records the balance 0.06 in posted invoice voucher?

3) What is the "Posting type" recorded for that main account in posted invoice voucher which is carrying the amount 0.06?

4) Is there any tax amount recorded during product receipt and invoice posting. If 'Yes', then is there any changes made in the calculated tax amount during invoice posting?

5) Item which is posted here is a stocked or non-stocked item?

6) Is there any main account selected for item wise or item group wise in purchase order posting type Stock variation in inventory posting profile setup?

Before coming to any conclusion; appreciate if you can share any screenshot of the posted invoice voucher which will be helpful to understand what went wrong here!

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No