Hi all,
We are looking to find the “recommended solution” or best way to do this on apps10 as im sure someone would have come across this problem.
The issue is linking shipment ID’s or Customer orders to Freight purchase orders so we can track PO spending on freight companies against what the customer gets charged etc etc.
For example; 1 customer order is converted into a shipment and then a PO is later manually raised which contains the freight cost depending on the company being used but there is no link between the Freight purchase order and the original order/shipment.
Shipments can contain multiple customer orders for the SAME customer.
Freight Purchase orders can contain multiple lines for different customers & orders.
Customer orders can contain multiple freight line charges depending on order size.
One PO line can have multiple shipment ID’s but only be for the same customer.
Current thinking is to have a custom field on purchase order no part tab for customer order no whereby each line is assigned. However this would be a manual task and writing validation against it is not bullet proof as there is limited data to link the two together.
Im aware we can peg a customer order line to PO but i dont think this would solve this problem and be user friendly. Happy to be corrected of course.
Other thinking was to an event that auto generated the PO depending on freight supplier with a rmb and inserted into the PO the customer order no in a new cf line. Just seems excessive.
So any thoughts/ ideas for a holy grail solution would be appreciated.
Thanks
