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

(0) Share

Report

Posted on by ewills

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

All responses (4)

Answers (0)

Guy Terry 28,626 Super User 2024 Season 2 on at

Like (0)

Report

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 400 on at

Like (0)

Report

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

Hi Ewills,

your problem is fixed ?

Thanks
Barry-Wehmiller AX Pro 460 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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.