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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply