Visma Business can retrieve locations in various ways; it is simple to let BxLogistics retrieve the location from the default location instead of the order line.
- Log in to the customer's BxAdmin.
- Click on SQL Integration.
- Select Picking.
- Then choose Pickinglist Lines.
- Under select, locate "ol.loc location," and comment it out be adding two -- in front.
- Add "bal.nrmloc location," under select
- Add "left join stcbal bal on bal.prodno = ol.prodno and stcno = ol.frstc" under from
- Click Save and then Run Query to save and execute the query. If you get the correct results and no error messages, everything should be in order.
If there are multiple departments/warehouses, also add "and bal.stcno = ol.frstc" (left join stcbal bal on bal.prodno = ol.prodno and bal.stcno = ol.frstc) to lock order lines by warehouse to avoid duplicate products.