Share
ReportHello,
I am trying to exclude data resulting from reversed manufacturing order receipts. Currently the data we are pulling includes reversed MRCs which results in duplicate values in the data every time we make a correction this way. Is there a table that records if an entry is the result of a reversed MRC. Or are we making corrections incorrectly by reversing MRCS in the first place?
Here is the SQL we are using
First Table:
SELECT IV00101.ITEMNMBR, IV00101.ITEMDESC, IV10200.QTYRECVD, IV10200.DATERECD
FROM BHPRD.dbo.IV00101 IV00101, BHPRD.dbo.IV10200 IV10200
WHERE IV10200.ITEMNMBR = IV00101.ITEMNMBR
Second Table:
SELECT IV30300.TRXSORCE, IV30300.DOCNUMBR, IV30300.DOCDATE, IV30300.ITEMNMBR, IV00101.ITEMDESC, IV30300.UOFM,
IV30300.TRXQTY, IV30300.UNITCOST
FROM BHPRD.dbo.IV00101 IV00101, BHPRD.dbo.IV30200 IV30200, BHPRD.dbo.IV30300 IV30300
WHERE IV30200.DOCNUMBR = IV30300.DOCNUMBR AND IV30200.TRXSORCE = IV30300.TRXSORCE AND IV00101.ITEMNMBR = IV30300.ITEMNMBR
*This post is locked for comments
All responses (
Answers (
291,269
