We have an issue that I would guess that others may have come across, but I have not been able to come up with a good solution for to this point.
We create a Sales order. The client then creates several POs for each ‘Option’ for the machine that is being purchased. This is broken down in their system by PO while in our system, it is simply a single Sales Order for the full amount.
In the simplest form, One Sales Order - referencing Multiple customer POs. Currently we add as many of the customer POs into the PO field (x50) and then make a note in the comment field of what each of the POs are for and the dollar amount.
I have created a UD Field on the Orderdtl table to record the Customer PO number which would require us to enter each particular line individually. If we did this, then Line one would be the full amount, and the rest would be 0.00 per line associated with the PO Number and part description.
I need these POs separated by lines so that I may be able to kick them out to a report that can be sent to the customer.
Does anyone else have a solution to a situation similar to this? I welcome any ideas.
Thanks