On Hand Stock not updating after Production order has been completed

(0) Share

Report

Posted on by dapdomma

Hello,

Please I discovered that after I have " ENDED" the Production Order using the Production Control Module, Finished Goods are not updated on the "On Hand Stock " under Stock and Warehouse Management .

This could not allow us to invoice Sales Order.

Kindly assist.

Thank you

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Can you elaborate? At what stage are you reporting the goods as finished? Have you checked the status and information of the inventory transactions related to the production order?

If it would not allow you to invoice the sales order, what error do you get?

Was this reply helpful? Yes No
dapdomma on at

Like (0)

Report

Hi Andre,

I am reporting the Goods as finished after Estimation,Release, Start, Report as Finished,End on All Work Order in Production Control and this was not reflecting in Stock and Warehouse Management (Inventory.

Please see the error displayed during Invoice,

Was this reply helpful? Yes No
André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

It seems like your additional information is not complete...

Was this reply helpful? Yes No
dapdomma on at

Like (0)

Report

Hi Please see the error below,

Thanks Alot

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like (0)

Report

You have insisted in AX terms that the full costs are known. This is only true of a production order when every component is fully invoiced. You now need to go through every line and reference back to the transaction consumed by your costing method and validate if the financial cost is fully realised.

In basic terms you are waiting for purchase invoices that impact on the cost of your final product, and because you have set the item model group up to insist on final costing prior to invoice then all costs need to be finalised.

When was the last time you ran the inventory close? What is your costing method?

I am also guessing from the message you allow negative inventory. Is this a live system or are you playing in a test system?

Was this reply helpful? Yes No
dapdomma on at

Like (0)

Report

Hello ,

Thank you for your mail.

1. Please how do I know the full costs are known as mentioned above.

2. How do go through every line and reference back to the transaction consumed by your costing method and validate if the financial cost is fully realised.

3. Please I don't understand "In basic terms you are waiting for purchase invoices that impact on the cost of your final product, and because you have set the item model group up to insist on final costing prior to invoice then all costs need to be finalised. "

4. inventory close was never run

5. Please how do I detect the costing method?

6. This Live System but I have a Backup server.

7. Please which book you can recommend for me to buy online.

Thank you

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like (0)

Report

Assuming you are a customer so you have a partner who can help you? You are starting to get into areas that are going to raise continual questions.

Question 1. What is the business reason for configuring the item model group to not allow negative inventory?

Question 2. Why are you not running the inventory close - it has to be run to push costs through, and you cannot be running a live system with financial negative inventory not set and never running the costing whilst using production unless you are in your first month of live!

Okay to answer your questions.

1. It means every item you use has the purchase invoice processed, AND I believe the inventory close is run - as you dont run it you never push the costs through, so unless the purchase invoice is processed before you use it, you have a serious processing issue/gap.

2. Open the production order and go to the Production BOM. Select the line and then stock - transactions. Then go to Stock and Cost explorer. Any open issues are not financially closed and need to be - this means the cost has not been invoiced of the original inbound entry. Your item model group setting means you have to clear this up before selling it.

3. The item model group financial negative inventory you have unchecked. This means if you purchase something before you sell it you must have received the invoice. The same is true of a manufactured item, but there are many components, so potentially many invoices that go into the finished product, all have to be updated and the inventory close run to update the finished product cost.

4. Run it, you cannot work without it running (unless you are standard costed).

5. Go to the item, find the item model group and go to the record. On the stock model fast tab the stock model tells you the costing method.

6. Do all of this on test.

7. Take training, if you have a valid maintenance agreement use customersource or DLP. There is no one book that tells you everything about a system this large.

Steve

Was this reply helpful? Yes No