Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

No Sales Consumption for some parts in SO invoice AX 2012 FIFO

Posted on by 5,990

For some of the SO that we invoiced, voucher doesn't show the COG.  Is this because that we haven't closed the inventory as  yet.  We didn't set the cost price for these BoM i.e. cost price is zero - from the manage cost section of the released product.  

I know that when the inventory is closed, the actual cost price of the item is applied - so COG is adjusted based on this. However, when we run the Inventory recalculation, would it not update the cost price and hence the COG?  

Appreciate your help.  

*This post is locked for comments

  • Guy Terry Profile Picture
    Guy Terry 28,606 Super User 2024 Season 2 on at
    RE: No Sales Consumption for some parts in SO invoice AX 2012 FIFO

    Hi inadir,

    What problem are you having? Might be best to start a new question with your scenario.

  • inadir Profile Picture
    inadir 400 on at
    RE: No Sales Consumption for some parts in SO invoice AX 2012 FIFO

    Hi Ewills,

    your problem is fixed ?

    Thanks

  • RE: No Sales Consumption for some parts in SO invoice AX 2012 FIFO

    Hi, first ensure that the following setups are done:

    Item model group:

    1. Post Physical inventory to Ledger - Check mark

    2. Post Financial Inventory to ledger - Check mark

    Inventory model group action pane:

    1. Incude Physical value - Check mark - Which will consider the Physical values (Received not invoiced / Report as finished not ended) for arriving the Avg cost price.

    Whenever an outbound entry is getting posted , such as; Sales packing slip/Sales Invoice, Purchase return/Purchase debit note, Transfer shipment and Movement journal with Negative Qty posting, system will pick the cost price from On-hand Inventory cost price field. If that is zero then it will pick the cost price from the "Price" field on the manage inventory tab. If both are zero then the cost price of the outbound entry will be zero.

    Finally, all the cost prices will be adjusted according to the Inventory model (FIFO or LIFO,etc.,) based on the actual entry used for the consumption, by running the inventory recalculation/inventory closing process.

    Hope this helps,

    Shantanoo, Barry-Wehmiller International Resources

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: No Sales Consumption for some parts in SO invoice AX 2012 FIFO

    Hi, first check if in the item model groups the "post financial inventory" is flagged.

    If yes the reasons I could think of are 2: these items are only received or production orders are not ended and on the item model group flag "include physical value" is deselected;

    or you actually received / reported as finished these items with zero cost, you can check it also on the released product form, tab manage inventory, on-hand inventory and then "on hand" tab, field name cost price, or check the item transactions to see if they have zero cost.

    Last thing when you run a recalculation or an inventory closing the cost price based on the selected costing model on the item model group gets recalculated and the cogs gets updated too.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans