Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012
Upgrading to Microsoft Dynamics AX 2012
Data Import, Export, and Migration
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
SSRS and SSAS Integration
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?
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.
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.
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.
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.
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"?
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.
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?
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!
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics