Hope, that would help someone. Just adding on the scenario suggested by @DConcannon the real example of quantity conversion.We ended up using [SOShipLine.OrderUOM] as UOM and these formulas on the pick list for quantities with some help from https://stackoverflow.com/questions/60057883/uom-and-uom-ratio-incorrect-on-pick-ticket.Replace =[SOShipLine.Qty]With =IIf( [LineINUnit.UnitMultDiv]='M',[SOShipLine.Qty]/[LineINUnit.UnitRate],[SOShipLine.Qty]*[LineINUnit.UnitRate])Replace =IsNull([SOShipLineSplit.UOM],[SOShipLine.UOM])With =IsNull( IIf( [LineSplitINUnit.UnitMultDiv]='M', [SOShipLineSplit.Qty]/[LineSplitINUnit.UnitRate], [SOShipLineSplit.Qty]*[LineSplitINUnit.UnitRate]),IIf( [LineINUnit.UnitMultDiv]='M',[SOShipLine.Qty]/[LineINUnit.UnitRate],[SOShipLine.Qty]*[LineINUnit.UnitRate]))And add the following tables to your SchemaThe only downside we see, it converts according to the current settings. So it doesn’t respect any historical data in case you changed the unit con
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.