Sage 100

Can someone confirm if this is working as designed or an issue? Sage 100 Advanced 2017 - In Item Maintenance/Inquiry the ""Quantity on PO"" is not populated if there is a WO number filled in for the item on PO Details. If I remove the Work Order number, then the QTY on PO populates. Is this correct? Does adding the WO number make Sage think that the quantity is not on PO because it is assigned for a Work Order? That doesn't seem right but you never know. Any input is appreciated!

Probably WAD. When you receive the items, they bypass inventory, like Job Cost items.

I agree with Beth. The logic is that an item purchased for a W/O is not for inventory, so it is not an ""inventory"" PO. When a W/O item is received on a PO, it goes to WIP, not inventory.

Thank you for your help! Your answers make sense so I can explain to the client that Sage is behaving logically (for once).

Just want to add this is because the PO and WO are integrated. If Sage increased Qty on PO and Qty on WO, it would be a duplicate of inventory items; thus, the receipt of goods for PO increases the sub-contractor field is the WO screens (I think) since the PO is not really receiving inventory (it is receiving the service to make the WO).

However, Item Maintenance does not show a Qty on WO either. Both Qty on PO and Qty on WO show a 0 if the PO detail has a work order filled in. These are actual inventory items, not services/sub-contractor does that change what you are thinking?

I'm guessing it's a WO component, not a parent item thus nothing appears ON WO.

I agree with that - and what i meant by sub-contractor - is that WO has several buckets that it populates for costs (material, labor, overhead, subcontractor) and i believe when a PO is integrated to a WO, the costs populate into the sub-contractor bucket (even if the item is an inventory item).

Ah - that makes sense. Thanks so much for your help!

A PO with a reference to a WO - when the ROG is processed the goods post directly to the WO and not to IM. This allows for materials to be allocated to a work order and as such are not part of 'common' inventory.

To clarify, Item Maintenance has two fields; ""On WO"" and ""Req for WO"". The On WO is when item is being produced by a WO. Req for WO is an item as a component on a WO. These are the soft supply and demand on the inventory item.