Accounts Payable Aging Report

You can use the AP250 Cash Forcasting report to create an aging. Just use negative numbers in the aging buckets for the report. I don't know why there isn't a canned aging report but this works. Don't forget to put the negative sign behind the number otherwise it wont work. 999- to 91-; 90- to 61-; 60- to 31-; 30- to "Blank"; 1 to 999.

Don't bother with Crystal. It would be a head ache and the solution I provided gives you exactly what an aging should be. Ours doesn't tie out with the AP136 though because there are some orphan records that muck it up. I am still at a loss for how to clean it up but 99.5% of what you need will be in this report.

Great! I did as you mentioned and was able to generate a report but in total my AP136 and AP250 doesn't equal. I have some Vendors that matched as i spot checked. The fact that the AP136 uses the DISTRIB-DATE and the AP250 uses the AGE-DATE, would this cause a problem? OR is it possible i too have accounts that are causing some issues?

Yes that could be part of the problem. The best time to compare them is when you are closing a period and there is nothing left unposted or unreleased in AP. You also need to take into account any future dated payments. For example, our practice is to clear wires out even a couple days ahead of time so when you look at the aging it's as if they don't appear whereas in the AP136, they will appear provided you ran it with the current date. When I did the comparrison at the time if found a couple errors and was able to narrow the differences down to a couple records. One was some recurring payments that were partially paid. I don't know how that happened since the system doesn't allow it but the records are stuck in the aging even though most of the payment has been made. I would guess it's more of a timing issue in your case.

The AP250 works well as a cash forcasting tool too. I worked with Oracle before this and their solution was cumbersome and hard to set up. This one allows you the option to run it in detail or in summary which is nice. The Oracle solution was in Cash Management and not in AP which made it difficult for an end user to access. It did however take into account any open PO's that would eventually come due as well.

We run the aging report and the ap136 on the first of each month after AP175 and AP170 runs. These reports then are compared with each other to see which invoices are accrued and not paid.

I have written a report using crystal for the aging report. The table I used is APINVOICE. and the main criteria to look for is invoices not in a historical status.

There are functions in crystal that are Next30Days, Next31To60Days that can put these invoices in different buckets of aging.

The AP250 report is a great report used for aging that we have managed to use it as a source for crystal and also able to include comments on the crystal reprot as well.

As Tom stated you can use it both as a cash forecasting as well as aging with the negative sign in the different holders.

As you requested attached is the doc for APINVOICE.

Thank you both for all your help, i have appreciated it.

The .txt file you attached, is there more documentation like this and where can i find it for other tables?

You may create a Lawson query, thru Excel Lawson Add-Ins to include released and unreleased invoices, then create the buckets as necessary for your aging, it gives you and accurate report.

Hello colleagues,

I would like to find out whether a check issued in a closed period can be voided through CB80 in another period,and then reinstate the invoice in AP190 and then cancel it in AP30.4

Regards

TK

You can void a check from one period to the current period that is open and run AP190. But when you reinstate the invoice the invoice will be openned for the current period also and the cancellation of the invoices will happen in the most current period open on the system.

Thanks Ruma for the solution.I will replicate this tomorrow when access to the documentation is allowed and will provide feedback.