Link between production orders

Finance and Operations/AX User Forum
1

Hy everybody!

How should I proceed in order to have my bulk production order, linked with the finished product production order? I want to be able to know from which production order number the bulk material came from. It´s like doing traceability backward, but is there a simple way to have that information?

Many thanks!

2

Hi,

Are you using the Dimension ‘Batch’ on your items?

3

Yes I am… I was thinking in using the Containerized packaging functionality, but I´m still doing the research…

4

Perhaps I don’t understand what you are asking, but if you have Batch enabled, can’t you use AX tracing functionality?

If you have R2 CU6 or later, you have the Item tracing functionality

http://blogs.msdn.com/b/dynamicsaxscm/archive/2013/08/13/new-item-tracing-functionality-in-microsoft-dynamics-ax-r2-cu6.aspx

https://technet.microsoft.com/en-us/library/dn313036.aspx

Or, if an older version of AX, you have the inventory ‘Trace’

https://technet.microsoft.com/en-us/library/aa550267.aspx

5

Yes maybe I should have told what my necessity is, I’m designing a report for the finished products work orders where I need to show the bulk production order number that was used in each order. I was trying to find a link between the two of them without using the batch number as the key, something more simple. Thanks!

6

Do I understand right that items made on Bulk works orders are consumed by Finished Product works orders?

On the Inventory transaction(s) of items produced by Bulk WOs (created by the RaF journal), there is a Lot ID. Does this Lot ID match the ‘Reference lot’ of the inventory transaction(s) that relate to the consumption on the Finished Product WOs?

It would be easy enough to check one or two. Goto the RaF journal of a Bulk WO (where you know the item has already been consumed). On the Line, do Inventory → Transactions. Make a note of the LotId.

Go to Inventory management → Inquiries → Transactions → Transactions. Do a Filter on ‘Reference lot’. Put in the LotId you noted above. What Inventory transaction is shown?

7

Thanks a lot Guy

8

I will use Containerized packaging functionality.

Doing so, in ProdTable the field PmfConsOrdId link bulk and packaging orders together with the same Id, and field OmfBulkOrd (0/1 type) identifies the bulk order from the packaging one.

9

It is PmfBulkOrd