Using SAP B1 8.82
At my company we're having a little bit of trouble with our sales people selecting the right warehouse code. It's pretty straight forward but for some reason on about half of the sales orders that come into our centralized purchasing the warehouse code doesn't match the ship to address. For example if something is drop shipping, each line item should have the code "DS". If an order is shipping to one of our warehouses it should have the code "702". Still frequently we will see someone with a drop ship address in the logistics tab of the sales order and the 702 code in the warehouse code field. I'm trying to decide the best way to approach it. I assume there are several.
I don't think I have enough SAP expertise to even know what my options really are, but I figure the resolution has to either be something that works on the front end and forces them to pick the right code or does it for them automatically or it has to be something on the other end so that we can more quickly identify such mis-matches. I wrote a query that just pulls the warehouse code and the ship to address so the person doing purchasing could identify problem orders a little faster, but it's still kind of a manual task looking at each line and finding codes that don't match ship to addresses.
It may just be that we need to better train our sales people to enter their orders correctly, but if I could do anything to make it easier and more "fool-proof" I'd like to do so.
For some background, we have 21 different warehouse codes. There's 4 codes for each branch (5 branches) and each has a different address, and we have a drop ship code as well (obviously here the address is a unique one each time, but we have default ones for all of our business partners).