What you really need is a stock file that holds all the details of each item in a seperate record. You should include fields for supplier, on sales order, on purchase order & on shelf.
When you create a sales order this should add the quantity to the on sales order, you can then create purchase orders for each supplier that has a positive number in the on sales order field. When processing the purchase order then the quantity is moved from on sales order to on purchase order and therefore it won't appear on the next purchase order.
Hope this helps
If you print your Purchase Order, using the line items table, and add a sub-summary on change of Product Code, then your PO will show one line per item (having also removed the Body Part) and use a summary field to sub-total the Quantity on the Sub-Summary part next to the Product name field.
This should do it, without too many changes to your system.
Best wishes - Alan Stirling, London, UK
Thank you for your insights. I have no trouble creating a summary field to display when printing the order, but that means I must always use a preview to see the combined items. Also, when I check in the order upon arrival I want to only need to check for the one Purchase Order line item that has the 2 combined line items on it.
I was thinking of running a script to add single Sales Order Line Items into the Purchase Order Line Items table and if there was a duplicate then the quantity would be increased appropriately. This way the original Sales Order Line Items are not changed except for a change of purchase and Sales Order line status to "arrived".
I think there is still a step I am missing.