The problem with supply chain spend reporting

We’ve all gotten the request before…. What was our spend on item 11111 last year?

Where do you go to provide them the data behind the request? PO54, MM280, or maybe you get a little crazy and start pulling records directly from POLINE?

What if I told you that if you are looking for accurate spend, your best bet is invoice data, not purchase order and receipt data. At the very least, a review of both sets of data will provide you a better determination of spend as well as identifying potential issues. Or perhaps what-if-ithis is a “close enough” for the review you are pulling data for. The amounts showing on the PO line, PO receipt and Invoice could all be different, in the end, the invoice reflects what you actually paid.

I don’t believe Lawson provides an invoice detail report that has a parameter for a specific line item. That causes a problem with supply chain spend reporting. We’ve worked with many organizations to customize AP175 to include an item parameter. However, you could utilize other reports now and filter out the results you are not interested in. Pulling data directly via MS-Addin’s from MAINVDTL could be a better capture of information until you can explore the custom report route.

what-if-i-2MA278 is a helpful report to run and can provide you a cost variance analysis by item by date range. It is calculating the same totals as the MAINVDTL when queried directly.


Want More Content?

Sign up and get access to all our new Knowledge Base content, including new and upcoming Webinars, Virtual User Groups, Product Demos, White Papers, & Case Studies.