web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Ended production order...
Microsoft Dynamics AX (Archived)

Ended production order did not consume all the picked material

(0) ShareShare
ReportReport
Posted on by J Mazuchowski 135

For AX 2009, we have a production order that has been ended, however not all the material that was picked for the order has been consumed. Some of the picking tickets were consumed properly but several were not. There for these items are showing as deducted in inventory, but there is no financial update for them. How can I force a financial update of these items and record the consumption cost to the project they are related to?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Fredrik Sætre Profile Picture
    Fredrik Sætre 12,644 on at

    Do they have a physical date in the transactions, but not a Financial?

    Do you use "Accept errors" when posting report as finished journals?

    Have you tried marking them against eachother?

    Maybe you can try to do an Inventory closing for this particular produced item and see what happens.

  • Suggested answer
    Weaveriski Profile Picture
    Weaveriski 23,620 Moderator on at

    Once it is ended "you" can push no more costs through directly, the WIP revalue has been done and is locked. However if they pick list is posted the lack of financial information will be because the system does not know the end value. You need to process the purchase invoices related to the receipts and run the inventory close. If you manually received the stock unrelated to a purchase order it would take the cost according to your costing method, which may leave your only choice to revalue the finished item through the inventory close.

  • J Mazuchowski Profile Picture
    J Mazuchowski 135 on at

    The items that were picked have physical transactions and are in a deducted state. There was no financial update when the PO was eneded.

    There is nothing to mark them against.

    I did a close and the deducted items will not settle.

    Thank you for your input.

  • J Mazuchowski Profile Picture
    J Mazuchowski 135 on at

    All the items that were picked have been purchase received and invoiced. So the "costing" of inventory is not the issue for us.

    I think the production order's consumption method was changed from finished goods to consume as picked. The items that were picked and not consumed were never financially updated or costed when the production order was ended.

    Thank you for your input.

  • Weaveriski Profile Picture
    Weaveriski 23,620 Moderator on at

    So you have unposted picks? What is the flag "finished goods to consume as picked" mean - can you give us more information on that? You can backflush but ultimately if the inventory transaction is deducted and the picking list is posted it should then be sold. Are you saying the production order is ended and you have lines that are of a status "deducted"?

  • J Mazuchowski Profile Picture
    J Mazuchowski 135 on at

    The picks were posted physically and I can see in inventory that they are deducted, but they were never financially updated and moved to sold. They will not settle when I close inventory.

    I think the production order was sent to accumulate the material and when we finished the order, put it into finished goods inventory. That is not what we would normally do. We normally use the production order to pick material and consume directly to a project. In this order, the first two pick tickets were picked posted physically, the items updated to deducted. the last two picks were picked, the items updated to sold and consumed directly to the project.

    The items on the first two picks are "lost" we don't have any record of them on  the project. No finished goods were added to inventory when the order was finished or ended.

    On the GL side I have an entry to credit the inventory account and debit WIP, but that is it.

  • Weaveriski Profile Picture
    Weaveriski 23,620 Moderator on at

    Another element is now projects. I believe in AX2009 the components were never seen against the project, it was the reporting and subsequent use of the production item, but not my area I am afraid - Something has gone wrong with the projects integration of production and in reality only someone digging around in your system maybe able to answer and correct it - doing it on here is nearly impossible given the elements in play. Can you report it to your partner? Have you any customizations in the production and project area?

  • J Mazuchowski Profile Picture
    J Mazuchowski 135 on at

    You are right on. This may be too difficult to solve here. Something when wrong along the way. I do appreciate taking your time to help!

  • Mark Prouty Profile Picture
    Mark Prouty 1,312 on at

    Did you ever find a method to financially end these transactions?

  • J Mazuchowski Profile Picture
    J Mazuchowski 135 on at

    Honestly, It has been so long, I don't recall if we did or not.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans