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 :
Microsoft Dynamics AX (Archived)

Incorrect issued cost - weight average method

(0) ShareShare
ReportReport
Posted on by 997

Hi all,

I use weighted avg.

2072.1.png

But when I recalculate and closing inventory, issued cost does not update. (PO receipt price is different)

Please tell me know what happen.

Thanks

Phung

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    Hi,

    Check the setup for Storage Dimension Group Financial Inventory (Yes) for the Item Model Group that the item belongs to. (Product information management > Setup > Dimension groups > Storage dimension groups.)

  • Guy Terry Profile Picture
    28,924 Moderator on at

    Inventory close will only revalue financially updated 'Issue' transactions (i.e. invoiced Sales orders), and it will only use financially updated 'Receipt' transactions to do that (i.e. invoiced purchase orders).

    If your issue transactions are not financially updated, or if you do not have financially updated receipt transactions, inventory close will not revalue.

  • Cam Phung Profile Picture
    997 on at

    Hi Sunder,

    The system calculate cost by site.

  • Cam Phung Profile Picture
    997 on at

    Hi Guy,

    I check cost price of issue transaction that have financial updated.

  • Suggested answer
    Mahmoud Hakim Profile Picture
    17,887 on at

    Can you check settlement from inventory closing and recalculation form ?

  • Guy Terry Profile Picture
    28,924 Moderator on at

    Hi,

    Can we see a screenshot of the Inventory transactions for the item, where it is not updating the cost?

  • Community Member Profile Picture
    on at

    HI,

    If Financial Inventory is NOT YES for Storage and Tracking dimensions, AX will calculate COGS by Weighted Average by Site only.

  • guk1964 Profile Picture
    10,888 on at

    Re Guy's comment - its not clear:

    Was the price difference updated on the PO before or after the receipt?

    Was that receipt financially invoiced before inventory close?

  • Cam Phung Profile Picture
    997 on at

    Hi Mahmoud Hakim,

    Item occur in settlement, but it the system does not occur any adjustment for this item.

    7633.111.png

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans