Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

COGS adjustment due to wrong posting AX 2012 R3

Posted on by 40

Hi,

I have one sceanrio

User changed UOM of Item from each to Pack. Then posted the GRN for this Item. In PO UOM is each and unit price is for Pack.

e.g. Item A - UOM is ea and unit price is 10. Later one other UOM is added for the Item as Pack10 which has 10 qty of the item. 

PO  created is for Item A with UOM as ea. But in Unit price mentioned price as 100. Done the GRN. Now COGS is showing wrong value due to this. 

In item model group Weighted Avg by Date is selected with Include Physical Value is ticked. 

Material is already sold and financial monthly closing is done.  Also inventory recalculation is also done.

Can anyone suggest please how we can correct this.

I can think of reversing the GRN ?

or Doing Adjustment in inventory calculation? 

*This post is locked for comments

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: COGS adjustment due to wrong posting AX 2012 R3

    Hi Ajit,

    Can you tell if the invoice was already posted for this purchase order? If not, the closing did not take this transaction into account. Then you can still do corrections on it. If the invoice was posted, probably the cost was already corrected as I do assume that you have posted what was mentioned on the invoice.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans