Viewing 5 posts - 1 through 5 (of 5 total)
Something like this?SELECT SO.ORDER_DATE, SOL.SYS_DELIVERY_DATE, SOL.SYS_SHIPPING_DATE, SO.ORDER_NUMBER, SOL.ORDER_LINE_NUMBER, SOL.PART_CODE, SLQ.ORDER_QUANTITY, SLQ.UNIT_OF_MEASURE
FROM SALES_ORDERS SO
INNER...
April 20, 2017 at 7:50 am
#1939080
Sorry for the bad post, reading article now to get understanding of how to properly post.
April 20, 2017 at 7:14 am
#1939065
It is the backside of a purchased ERP system, I am just trying to create some reports....
September 27, 2016 at 4:14 pm
#1903507
Sorry I am not relaying clear information. I want all records with UOM_Control = 'S' and only UOM = 'LBS' where UOM_control = 'C'
September 27, 2016 at 10:06 am
#1903399
I only want to value the inventory of LBS on the items with the 'C' for the UOM COntrol. Thanks
September 27, 2016 at 9:48 am
#1903394