Sales Order Consumption Posting

(0) Share

Report

Posted on by Community Member

Hi,

I have a production order which is properly ended & cost amount financial being correctly updated in Inventory transactions. But still the Cost of Goods Sold posting don't happen during the Sales Invoice Posting. This happens only on some cases, not for all the sales orders.

But after performing the Inventory Recalculation, Sales Order Consumption is getting posted correctly. But his loses track of Voucher #.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

Brandon Wiese 17,788 on at

Like (0)

Report

RE: Sales Order Consumption Posting

You're almost certainly using a actual cost method, i.e. FIFO, which means the cost of goods realized during the initial posting of the invoice depends upon the state of inventory on-hand. If you have no inventory on-hand quantity (or it's negative), then the inventory cost price of the released product is used instead. I suspect the cost price of the item in your example if probably $0, and so no sales consumption occurs in the invoice voucher. Then, upon inventory recalculation, the system adjusts the value of the inventory issue transaction behind the invoice, and posts and adjustment to cost of goods accordingly. Yes, this happens on a different voucher, but it is easily associated with the invoice, since the adjustment is made directly to the inventory issue transaction itself. This is all standard AX functionality under actual costing.

You can mitigate most of this effect by keeping an accurate inventory cost price on your released products when using actual cost.

What is your concern with how this works, specifically?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Sales Order Consumption Posting

Costing method used is weighted average, also physical & financial negative inventory is not allowed. Include physical value is also enabled in item model

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Sales Order Consumption Posting

Hi Vidya Dharan,

Have you checked the setup cost price of your item as Brandon suggested?

Is there still something open/unclear?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Sales Order Consumption Posting

Hi Ludwig,

Are you referring to the below field to be enabled?

Was this reply helpful? Yes No
Brandon Wiese 17,788 on at

Like (0)

Report

RE: Sales Order Consumption Posting

We're talking about the field called "Price" which appears just below where you screenshot cuts off, under Price unit and Price quantity.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Sales Order Consumption Posting

so for the released products which has got the cost price updated, CoGs will get posted automatically ?

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Sales Order Consumption Posting

Hi Vidya Dharan,

Yes, once you setup a cost price, the posting will be created unless you have some other modifications in your system.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Sales Order Consumption Posting

So in other words, if i enable the check mark "Latest Cost Price" will that Cost Price will be updated automatically in Released Products?

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Sales Order Consumption Posting

Hi,

The check mark for the latest cost price is not that important. What matters is that you have a cost price specified.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Sales Order Consumption Posting

Thank You Ludwig

Was this reply helpful? Yes No