Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[John Arnold]

I was asked this question by a co-worker.  I’m looking for a good response…  In other words, help…

Theoretical question:

 Let’s say I have 10 X units and allocate them to an open MO.

 That open MO is worked on for a week and then closed making 10 Y unites

 Where can those 10 X units found in GP during that week?

                They are not in the Raw Material inventory once allocated?

                For that week does GP show I have zero X units and zero Y units?

 If I run a perpetual report in the middle of the week how is that accounted for?

Thanks!

——————————
John Arnold
US Digital
Vancouver WA
——————————

[John Kirsch]

John,

Allocating items does not remove them from on hand.  After allocation, you will see them as allocated quantity therefore removing them from quantity available.  To remove them from on hand, you would need to post and issue transaction in manufacturing.  At that point you would see 0 on hand and would still have 0 on hand of the finished good as you describe.  You would see the value of the raw materials in your WIP account.  Hope this helps. 

——————————
John Kirsch
Senior Consultant
Wipfli
Green Bay
——————————
——————————————-

[Andrew Kennedy]

Hi John,
The answer depends on if the BOM is set up to Backflush or not.  If set to backflush then the components are on hand in their original location with a quantity allocated until the MO is received.  The components are removed at that point and backflushed through the WIP GL into the Finished Good.

If the BOM is not set to backflush then the components are issued to WIP via the component transaction entry.  This transaction makes a GL entry to move the value of component X units into the WIP account found on the finished good Y Unit and makes an inventory adjustment to remove the X component from the issue from location.  As far as the on hand quantity of the component X it is removed from inventory through the component transaction and will not appear on the stock status report.

Hope this helps.

——————————
Andrew Kennedy
Principal Consultant
Socius
Brecksville OH
——————————
——————————————-

[Richard Ward]

John,

Both of the answers above are correct…and as one of the respondents suggested it really depends upon how you have your BOM set up.

If you are NOT backflushing component costs, and you are posting Component Issue transactions to move the parts into WIP, then the system keeps track of those parts in table MOP1000.  That table has the MO that issued them, the date, qty, etc. It also has the unit cost element breakdown of the standard cost…probably more information than you need.

You should be able to reconcile the quantites in that file extended by your standard cost to the total value in your GL WIP Inventory account.

——————————
Richard Ward
Vice President – Controller IPD
Storm Industries, Inc.
Torrance CA
——————————
——————————————-

[Keith Paul]

John,
Building on Richard Wards reply, you will need to calculate the qty balance remaining in the WIP Site: QTYRECVD minus QTYSOLD .

Regards,

——————————
Keith Paul
VP Business Management Systems
Unicom Engineering, Inc.
Plano TX
——————————
——————————————-

[Maria Frandzeskakis]

Hi John,

Just in case it hasn’t already been mentioned, there are so WIP Smartlists under Manufacturing that you may find helpful.

Best regards,

——————————
Maria Frandzeskakis
IT Manager
MIP Inc.
Anjou QC
——————————
——————————————-