Contracts - 12 Month Spend

FYI, there is an AMT_ORDERED field in the Povagrmtln (line) table that might give me the total I need.

The data in AMT-ORDERED represents the total $ ordered for the agreement or agreement line since the agreement has been active. So if you have a multi-year agreement that amount could be for more than 12 months. I use POLINE and MAINVDTL to pull what amount was actually paid on a PO line for an agreement.

It depends on how you process price changes. I would say PURCHORDER and POLINE by vendor/item would be more accurate as if any changes are made directly to the POLINE that don't match the agreement, the agreement is then removed from the line, which I believe would them affect the amount shown on the agreement. I would run a report both ways and then see what's most accurate to your organization. You could also left join the agreement line to the po line and see what poline's may relate to the agreement but the agreement wasn't referenced on the poline. Hope this helps!

MAINVDTL is also a great suggestion!

I've attached a copy of my Contract/Noncontract spend report.  This shows total supply spend for a selected date range and separates it into spend attached to an agreement and spend not attached to an agreement. It may not be exactly what you're looking for but you can maybe modify it to suit your needs. Had to make it a .doc to fool the forum because it doesn't seem to accept .rpt files. Just change the file extension back to .rpt after you download it, should be fine.

Thank you both for your responses! I will try them and let you know the results.

Do you know of a screen or report in Lawson that shows the spend for an agreement (it does not have to be a 12 month total)?

Take a look at PO227. Not the easiest report to read but it might be what you're looking for.

Try out PO227 - Contract Agreement Compliance Report. After you enter the procurement group you can leave the other parameters open. I think the report Jon shared could be customized a bit more to fit your specific needs by relating the agreement reference if needed. Pulling from the invoice detail is more accurate.

Here's the form help from PO227 -
If run in detail, the report will list all items tied to a contract that had purchase orders created, list the quantities and amounts purchased against the contract, and the quantities and amounts purchased in total. A percentage is then listed for both quantities and amounts of what the compliance was. Purchase order number and line detail can also be listed for purchases that were not compliant with the contract. The report will summarize by order, contract, vendor, entity, and grand total including purchases made against the contract of items not listed on the contract.

Ha. Just a second behind you Jon. :-)

I am still having problems with retrieving the spend for the contracts. I am getting the list of contracts based on Povagrmthd.EXPIRE-DT, and trying to get the total spend (for 12 months) for each contract based on the following formula:

Poline.QUANTITY * Poline.ENT_UNIT_CST

The problem that I am running into is that I am trying to get the 12 month total spend based on Purchorder.PO-DATE ( for the date range).

Thanks! I will take a look at the screen. I will be out of town for the next few days, but will definitely review the screen and give you the results (of my report).

See if this is close to what you need. Again, I changed the file extension to allow the upload.

Thanks, Jon! I will take a look at it.

Yes, the report is exactly what I need! Thanks!

Glad to hear!