Hi All,
A problem we often encourter is sending out 2 items separately.
For Example, we have Supplier A which are drop ship, but we share their warehouse and we have our own items in the same warehouse..... so when a order comes through it goes to both vendors...
When a order comes through, both vendors show 1 item not 2, so we only ship that item out.. costing us double the shipping cost :h_a_w:- Because we could just get the item from the supplier and sending it in one package.
If we had a flag of some sort, it could show us in Vendor Centre on the PO, to help us Identify 2 Orders from 2 different Suppliers.
So Far I have managed to bring in the Supplier name on the SO in a column next to the items. So I can see Item A - Supplier C, Item B - Supplier G etc... but can't think of a way to look at the line numbers, If I could then maybe write something like this
case when {line1.suppliername} is equal to line2, line3 etc then 0 else end.
Can anyone help?Thanks