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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Negative Receipt on PO...
Microsoft Dynamics AX (Archived)

Negative Receipt on PO generating unexpected Voucher entries

(0) ShareShare
ReportReport
Posted on by Community Member

I'm hoping that someone can point me to an incorrect parameter setting on this scenario. 

Scenario:

A PO is created for items to be received, however, it is created with the incorrect unit price

PO01.jpg

The product is received at the incorrect price resulting in the GL entries of the PO amount hitting Inventory and Received not Invoiced. (and updating our MWA average cost).

PO02.jpg

PO03.jpg

The PO is Invoiced

PO05.jpg

The issue is caught and a negative line is placed on the PO to reverse the impact of the receipt

PO06.jpg

The negative receipt is posted,

PO07.jpg

The GL entries I expected was a reversal to 'Inventory' and 'Received not Invoiced', however, what I see are 3 entries - one to 'inventory' at my now new average cost, and two made to my 'Received not Invoiced' account - the full amount and the delta between my full amount and the average cost. Plus my MWA average cost on this item remains incorrect. 

PO08.jpg

As a result, the final invoicing is incorrect as well

PO09.jpg

I'm hoping that this is a parameter setting somewhere.  I expected the reversal of the PO and the update to my Average cost back down to what it was prior to the incorrect receipt.  Am I approaching this scenario in the wrong manner?

Any assistance is greatly appreciated.

Tom.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Tom,

    Can you check whether there have been other transactions recorded for this item between the receipt and the subsequent return that changed the MWA price?

    If this is the case the price difference is something 'normal' for this valuation model that does not know marking or a similar functionality.

    Please try track all inventory transactions in between those two postings to check if they explain the difference posted.

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Ludwig -

    In this case there were no other transactions.  I did the initial receipt at the incorrect price and immediately followed it with the reversal at the same price.  I was expecting a reversal at the cost that I originally received it at to begin with, is that an incorrect assumption?

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Tom,

    If there is no transaction 'in between' the reversal should use the same cost amount.

    Yet, can you let us know the posting type the 1733$ are posted with?

    In addition, are you aware of any automatic charges that might come in with the return?

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Ludwig -

    Perhaps it is worth taking a step back to describe what I'm trying to accomplish because I'm beginning to feel that what I'm expecting and what the system does are two different things.  Perhaps you can point me in the correct general direction:

    Business Problem:

    1. PO is created with correct quantity of the item, however, the unit price is incorrect
    2. We receive the PO and don't notice that the unit price is incorrect - the result is
      1. Average Cost is incorrect for the item in that Site/Warehouse
      2. The AP invoice generated for the PO is incorrect - (vendor balance is wrong)
    3. I use the negative receiving
      1. Create a negative offset for the original incorrect receipt (I was hoping that this corrected my average cost by reversing at the same cost as #2)
      2. Create a positive receipt at the corrected unit price (this impacts my average cost with the correct receiving amount)
      3. Generate the offset invoice - so that my vendor total is accurate.
    4. My question becomes, how do I correct my average cost since it is clear that #3.1 isn't going to correct it for me?

    Thanks -

    Tom.

  • Community Member Profile Picture
    Community Member on at

    One additional item to add, with step 3.1 it impacts my Journal with the 'average cost' it chooses to use vs. having a net 0 impact.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Tom,

    I think the issue is the inventory model and the correction posted because AX automatically adjusts the moving average price and posts the difference as variance. There is a functionality in the inventory module to correct the moving average price ('revaluation of moving average'). Yet, given these process steps, I am not sure whether this helps, as a lot of adjustments through the periodic function might be necessary. So, probably try testing whether the 'revaluation function' helps to get this fixed.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Thank you - I will look into that.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans