Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
kothandaraman_nagarajan
Active Contributor

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

Labels in this area