PO price change report

Does Lawson not have any can report that shows price changes? Last PO price and the changed PO price? My skills with Crystal are pretty basic but I need to find something. Would anyone have a Crystal report showing this they would share? Any help is appreciated.

0712050808501819.doc

Find more posts tagged with

Infor Lawson Supply Chain Group - Discussion

Comments

dechevar

Would the MA278 work?

Run Cost Variance Analysis (MA278) to compare the invoice unit cost to the purchase order cost or standard cost and reports the variances in summary or detail.

You can select only those items approved within a certain time period to be printed. This field is used to enter the beginning approval date (invoice date) of the invoice range. You can also select only those items for a specific vendor, buyer group, buyer, purchase class, location, or item.

unknown

I don't work with Crystal but as of v10 there is a POAGMAUDIT table that tracks all changes to PO25.6. You filter for Base Cost in R_Desc field or by fld_nbr (here it's 13 but I'm not sure if that changes based on version). Then you use Update_Date to enter your date range.

jason-vance

PO195 shows price changes made to PO25

unknown

Here is a query I use in Crystal Reports...just change the name of the DB if it isn't PROD10

SELECT "POAUDIT"."COMPANY", "POAUDIT"."PO_NUMBER", "POAUDIT"."AUDIT_ACTION", "POAUDIT"."UPDATE_DATE", "POAUDIT"."BEFORE_IMAGE", "POAUDIT"."AFTER_IMAGE", "POAUDIT"."PO_LINE_NBR", "POAUDIT"."R_DESC"

FROM "PROD10"."dbo"."POAUDIT" "POAUDIT"

WHERE "POAUDIT"."R_DESC"='Unit Cost' AND "POAUDIT"."PO_LINE_NBR">=1 AND "POAUDIT"."UPDATE_DATE">=CONVERT(DATETIME, '2019-01-01 00:00:01', 120) AND "POAUDIT"."AUDIT_ACTION"='C'

unknown

Thanks a bunch!

RAD Overview.pdf

Copyright © 2025 Infor. All rights reserved.