Adding AP/PO Fields To GL Report

Hi. I am attempting to create a LBI report in Crystal reports for GL charges with AP (invoice number, vendor, etc.) and PO fields (PO line number, PO item id, etc.). I started by pulling charges from the GLTRANS table and joining to AP through the APDISTRIB table (GLTRANS.OBJ_ID = APDISTRIB.GLT_OBJ_ID) to get to the APINVOICE and APVENMAST tables. But the query seems to be unacceptable due to latency. Is there a better solution to doing this?

Paul Andres

dEPM-676_Series_Part 10_Shift Differential.mp4

Find more posts tagged with

Infor Lawson Business Intelligence Group - Discussion

Comments

unknown

Start at the APDISTRIB table. Attaching our version of the report (assuming I figure it out correctly).

Notes:

We are single company (company = 1000).

This report provide AP Detail only. We have a separate report for inventory issues.

Report includes a drill-around link as well as a link to our OnBase system to bring up document images.

[View:/cfs-file/__key/communityserver-discussions-components-files/61/490Accounts-Payable-Invoices.doc:320:240]

PS - change the file extension to .rpt

hrcasem_2022.x_cmag__en-us.pdf

unknown

Marybeth,

Thanks for the information. I went down the road of reporting out of AP since the accounting unit, account, and sub account charged are in the APDISTRIB table. And I do use the DISTRIB_DATE for my Purchasing reports. But the report I am working on is for Finance. They want the accounting in the correct period with the AP/PO fields added. Isn't there issues with your report where the accounting in GL reflects a different period than the invoice dates?

Paul

unknown

The distrib-date is the GL date. The report I attached is selected/grouped by distrib-date, but includes both the invoice date and the distrib-date in the output. This is especially useful to point out lags in invoice posting; sometimes an AP issue and sometimes a sat-on-the-manager's-desk issue. The report I attached should agree to the AP275 report.

unknown

I will try that again. I may be able to work around the obscure issues. I know there is a situation where if an invoice date is fat fingered, for example October 2016, and the period is closed GL will post into the first period which has not been closed.

Paul

0911060553270289.pdf

Copyright © 2025 Infor. All rights reserved.