Dear all,
To get projected MRP procurement cost for specified MRP scenario, just copy and paste below query into query generator.
SELECT
T1.[MsnCode] AS 'Scenario',
T0.[DueDate] AS 'Due Date',
T0.[ItemCode] AS 'Item#',
T2.[ItemName] AS 'Desc',
T0.[Quantity] AS 'PO Qty',
T3.[Price] AS 'Price',
T0.[Quantity]*T3.[Price] AS 'AP Cost'
FROM
ORCM T0 INNER JOIN OMSN T1 ON T0.[ObjAbs] = T1.[AbsEntry]
INNER JOIN OITM T2 ON T0.ItemCode = T2.ItemCode
INNER JOIN ITM1 T3 ON T2.ItemCode = T3.ItemCode
INNER JOIN OPLN T4 ON T3.PriceList = T4.ListNum
WHERE
T1.[MsnCode] =[%0] AND T4.[ListName] =[%1]
ORDER BY
T0.[DueDate]
Hope helpful.
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |