I recently put together a specification for customization, which is intended to automatically issue materials to work-centers as work orders move through their routing steps. This customization relies on a custom Production Management window which handles the work-flow of completing routing steps, ordering rework and picking the routing step to return the work order to if rework is necessary, etc.
The customization also issues additional material automatically, if rework is required for a previously completed step. This paperless system enables the flow of work orders from one work center to the next by pointing and clicking.
The customization also issues additional material automatically, if rework is required for a previously completed step. This paperless system enables the flow of work orders from one work center to the next by pointing and clicking.
Prior to signing off the CFO asked a series of questions about the impact this would have on financial transactions - in order to sum up the changes, I found it necessary to create an overview of what happens when processing a manufacturing work order to compare and contrast standard to custom.
This is a simple overview, which doesn't cover automated data collection, or outsourced manufacturing, but it does cover straight forward work order processing in Dynamics GP succinctly.
Standard GP
Manufacturing Process - Make to Order
A Work Order must be released
prior to performing any transactions against it – nothing can be done to a work order
prior to it being released other than changing it's status.
Valid Manufacturing Order Status are:
Quote/Estimate
Open
Hold
Cancelled
Partially Received
Complete
Closed
Valid Manufacturing Order Status are:
Quote/Estimate
Open
Hold
Cancelled
Partially Received
Complete
Closed
Manufacturing transactions can be entered using the Component Transaction Entry window.
Transactions > Manufacturing > Component Transaction Entry
Transactions > Manufacturing > Component Transaction Entry
Transaction Types allowed in the Component Transaction Entry window are Allocation, Issues and Scrap (and the reverse of these transactions)
Alternatively the Picklist window can be used to backflush (or reverse-backflush) materials for work orders.
Transactions > Manufacturing > Picklist
Transactions > Manufacturing > Picklist
Backflush - is the process of assuming the materials consumed by a work order are consistent with the quantities defined in the item's Bill of Materials
(Qty Made * Quantities to make one item = Total Material Consumed)
Backflushing is easiest way to conduct manufacturing operations and the least accurate. Backflusing assumes everything goes to plan all the time - in my experience it rarely does.
Since it is unnecessary to Allocate or Issue materials to work orders - most material transactions are optional.
(Qty Made * Quantities to make one item = Total Material Consumed)
Backflushing is easiest way to conduct manufacturing operations and the least accurate. Backflusing assumes everything goes to plan all the time - in my experience it rarely does.
Since it is unnecessary to Allocate or Issue materials to work orders - most material transactions are optional.
Optional Transaction 1 – Raw Materials
can be Allocated to the Work Order
This can be done manually or automatically. To configure Dynamics GP to allocate Raw Material Inventory automatically when a work order is released use the following setting
The automatic function in GP allocates all required materials immediately
Setup > System Defaults > Manufacturing Orders
This can be done manually or automatically. To configure Dynamics GP to allocate Raw Material Inventory automatically when a work order is released use the following setting
The automatic function in GP allocates all required materials immediately
Setup > System Defaults > Manufacturing Orders
Allocation – Decreases inventory on hand, but has no financial impact (no GL transactions are posted)
Optional Transaction 2 – Raw Materials can be Issued to the Work Order, Issues move Raw Materials Inventory (RMI) to Work in Process (WIP) manually –
Standard GP functionality cannot automate material issues.
Issues – Decrease the inventory on hand, AND have a financial impact
(Credit Raw Materials Inventory and Debit Work In Process)
Optional Transaction 3 – Raw Materials can be scrapped
(Credits Raw Materials Inventory and Debits Scrap)
Optional Transaction 4 – Cancel MO:
Users must manually reverse issues and allocations of materials
(Credit WIP and Debit Raw Materials Inventory [RMI])
AND/OR use Scrap, to write off materials that can’t be return to inventory.
(Credit RMI and Debit Scrap - see Optional Transaction 3 above)
Optional Transaction 5 – Rework.
Material must manually be issued to the MO
(Credit Raw Materials Inventory and Debit WIP)
This is done until workers get the Work Order right – variance posted later.
Optional Transaction 6 – customer wants an alternative configuration
Materials are manually added or removed - a.k.a. Soft Bill Changes
(Credit/Debit Raw Materials Inventory and Debit/Credit WIP)
Added items Credit RMI and Debit WIP
Removed items Debit RMI and Credit WIP
(Credit/Debit Raw Materials Inventory and Debit/Credit WIP)
Added items Credit RMI and Debit WIP
Removed items Debit RMI and Credit WIP
Manufacturing Order Receipts
move Raw Materials Inventory or WIP to Finished Goods Inventory, depending on whether backflushing is being used or issues were
done respectively.
(Credit WIP/RMI and Debit Finished Goods Inventory)
(Credit WIP/RMI and Debit Finished Goods Inventory)
Manufacturing Order is Completed – no more data can be collected against the MO, no more materials issued, or receipts reported. No Financial Transaction happens at this step. This is very important, as failing to Close Completed work orders will not provide an accurate picture of inventory or finances related to inventory.
Manufacturing Order is Closed – WIP variance transactions cleared to Variance Account. Closing work orders is and absolutely necessary step!
(Credit WIP and Debit Material Variance and Finished Goods Inventory)
Finished Goods Allocated / Fulfillment of Sales Order
Item Ships and is Invoiced –
Move Finished Good from Inventory to COGS
(Credit Finished Goods Inventory and Debit Cost of Goods Sold [COGS])
Feel free to ask questions or take umbrage with my assertions. I hope this gets you where you're going.
(Credit Finished Goods Inventory and Debit Cost of Goods Sold [COGS])
Feel free to ask questions or take umbrage with my assertions. I hope this gets you where you're going.
This is extremely helpful! Thank you!
ReplyDeleteHarry, can you explain whether backflushing can be used in conjunction with Issuing materials? I created a BOM with all backflushed materials. I issued the materails to the MO. When I do a partial MO receipt, the materials for the entire MO are applied to the partial receipt. I've tested an MO receipt where I did not issue the raw materials to the MO, and the backflushing during MO receipt process worked as expected (the % of materials used matches the % of the MO completed). Any advice?
ReplyDeleteAlicia, backflushing does not work with material issues. Material issues create transactions the MOP10213 table, which would not be relieved by the backflushing process, as this is not how backflushing is designed to work in Dynamics GP. Backflushing is intended to eliminate the need for users to do material transactions in the system, which is a major simplification of the Manufacturing process. If you're going to use backflushing, do not allocate of issue materials to the MO.
ReplyDeleteThank you! This is the first clear explanation for this "problem" I thought I had. Again, thank you!!
ReplyDeleteYou are quite welcome!
ReplyDeleteHarry,
ReplyDeleteI have a question about backflushing. We have many finished goods setup where we backflush all of the components. If there is missing inventory for any of the components were not receiving a warning message. The MO Receipt is just processed. Is there a way to prevent this from happening or a warning that can be turned on?
Chad -
ReplyDeleteIn Manufacturing >> Setup >> Manufacturing Orders, which opens the Manufacturing Order Preferences Default Window, there is a setting (checkbox) in the scrolling window at the bottom, which enables this warning, aptly named 'Display Low Component Backflushing Warning' - make sure this box is checked.
Great! Thank you Harry!!!
ReplyDeleteGlad I could help - you are welcome!
ReplyDeletei have an issue in manufacturing components screen, when ii release the MO and go to the component screen to issue the raw materials , i can't found them to proceed, however , i can do that on the GP server!!
ReplyDeleteany help please
This was extraordinarily helpful. Thanks, Harry!
ReplyDeleteThat was extremely helpful as i was having major problems with backflush as some were working as they should and some i still had to issue to the picking document prior to receiving the MO.
ReplyDelete