web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Revising the erroneous cost of an item due to wrong PO

(0) ShareShare
ReportReport
Posted on by 122

Hi. We recently had an issue where our purchaser posted a PO with the wrong unit price. He did a return for the PO (receiving & posting negative the exact quantity). 

It looked alright until we saw the voucher. 

ORIGINAL PO INVOICE VOUCHER

Trade Goods Inventory 2,727,200.00
Input VAT - Tax Receivable 409,080.00
Purchase expenditure for product 0.00
Accounts Payable - Trade Vendors -3,136,280.00

RETURN PO INVOICE VOUCHER

Trade Goods Inventory -1,069,958.09
Input VAT - Tax Receivable -409,080.00
Purchase expenditure for product -1,657,241.91
Accounts Payable - Trade Vendors 3,136,280.00

I am trying to understand if we did something wrong while making the return. Part of the original purchase amount has gone to the "Purchase Expenditure for product" account when making the return. What is the reason for this? 

Furthermore, the cost price of the item has been affected due to this PO. The actual amount of the transaction should be 2,727.20 instead of 2,727,200. This happened because the guy entered the unit in KG and the price in Metric Tons. 

1) Any advice on how to correct the return to remove the entire PO cost on the item? Purchase expenditure must be 0 as well. 

2) If the PO return is corrected and the item cost is recalculated, will the correct cost be reflected in inventory transfers and counting journals? 

Thanks in advance for your help and support!

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    300,982 Super User 2025 Season 2 on at

    Hi Vijay,

    When you have an issue with inventory costing, it would be recommended to tell which exact inventory valuation method you are using. As you mentioned the recalculation job, I do assume you are using an actual method like FIFO, LIFO, Weighted average.

    When you post the PO return without reference, it will deduct the inventory like sales order delivery or inventory losses. It will take the average price, until you do a recalculation/closing. If you are e.g.  using FIFO, there is no guarantee that the return will be linked to the original PO receipt. To enforce that, you can use the marking functionality to mark the PO receipt and return transactions. If you then perform the recalculation/closing it will first settle and adjust the marked transactions, then all others based on the costing method.

    As a summary:

    1) Use inventory marking to mark the PO receipt and return.

    2) The recalculation/closing will then correct the inventory cost.

  • VJ VM Profile Picture
    122 on at

    Dear André,

    Our inventory costing method is Weighted Average. Sorry, I forgot to mention. It's funny we tried a lot of things but did not think of the marking process. The issue is resolved now. Any points as to why the system pushed the return as Purchase expenditure for product? And why that specific amount? Thank you so much. 

  • André Arnaud de Calavon Profile Picture
    300,982 Super User 2025 Season 2 on at

    Hi Vijay,

    There is no automatic linking when you have a new PO line. So, the marking would be recommended to use here. You can also specify a return Lot ID (if available on the PO lines).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 659 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 533 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 289 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans