Viewing 5 posts - 1 through 6 (of 6 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
Sorry for the bad post, reading article now to get understanding of how to properly post.
April 20, 2017 at 7:14 am
It is the backside of a purchased ERP system, I am just trying to create some reports....
September 27, 2016 at 4:14 pm
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
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
Viewing 5 posts - 1 through 6 (of 6 total)