Help with Monthly AP Reconciliation - GL Summarized Transactions

I was asked by my AP Manager to post this question to this community - we have tried requesting assistance from Lawson but they only sent us 2 KB articles, which really didn't help her much, and said anything further would require us to reach out to Client Services.

Here is her request:

Requesting an Adhoc report which will generate the detail level transactions for any g/l combination. Basically a GL290 report, but expanded even further to include the detail that makes up summarized transactions. She will be using the report to investigate variances in the monthly AP reconciliation.

Has anyone does something like this before?

Thanks in advance,

Laura

Find more posts tagged with

Infor Lawson Financials Group - Discussion

Accepted answers

All comments

amacknig

..there is a "canned" Lawson report for AP Detail of any General Ledger account...the AP275. but it you want AP Detail AND other types of transactions that go to any GL Account, then i would recommend a Lawson Add-In Query report. That is what we use when we want all detail for a General Ledger account that can include all of the detail in the summarized transactions

unknown

There isn't a lawson delivered report that will provide this information that I'm aware of. If you are familiar with Lawson add-ins, create a query using GLTRANS and select related tables to pick up APDISTRIB. make sure you have the OTM set high enough to pull all invoices.

laura-patenaude

That is what we are looking for - I've tried to put something together in SQL - but it seems like there is no clear cut way to final the detail for each summarized transaction for AP. Would you be willing to share your Addins query with us?

unknown

there is the AP275 report as noted above. sorry for the confusion.

amacknig

yes, i can send you an example - my email is: ggudgel@urmstores.com

send me your email address and i can send you a sample query

unknown

I use an AP Distribution detail report created via add-ins that gives the detail of the summarized transactions but only AP transactions. I haven't found a way to get all transactions as the detail is summarized once it's moved over to the GL. I can't seem to attach the query. Sorry.

laura-patenaude

Thanks - I believe that is what she is looking for are those summarized transactions specific to AP. My email is laura.jarvis@baystatehealth.org if you would like to share it with us. I'll take any help I can get! Thanks in advance.

unknown

will do!

Copyright © 2025 Infor. All rights reserved.