Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Financial Management
Lawson S3 Financials
Accounts Payable Aging Report
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Chris Radcliffe
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5187
People Online:
Visitors:
252
Members:
0
Total:
252
Online Now:
New Topics
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson S3 Financials
Accounts Payable Aging Report
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Katfra
Advanced Member
Posts: 30
6/14/2010 7:23 PM
Hello,
First of all, is there a report in Lawson that i could run that shows me an AP Aging? Currently I use AP136 to show me what my AP for the month is.
Secondly, I'm attempting to create an aging report in Crytal since i wasn't sure if Lawson had one but having trouble with what table to use to pull the amount that shows up in my AP136. I'm currently using APDISTRIB as well as APINVOICE. Can anyone assist me in this?
Thanks,
Frank
Tom Keller
Advanced Member
Posts: 42
6/14/2010 7:36 PM
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.
Tom Keller
Advanced Member
Posts: 42
6/14/2010 7:39 PM
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.
Katfra
Advanced Member
Posts: 30
6/14/2010 8:11 PM
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?
Tom Keller
Advanced Member
Posts: 42
6/14/2010 8:23 PM
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.
Tom Keller
Advanced Member
Posts: 42
6/14/2010 8:28 PM
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.
Ruma Malhotra
Veteran Member
Posts: 412
6/14/2010 8:41 PM
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.
Ruma Malhotra
Veteran Member
Posts: 412
6/15/2010 6:03 PM
As you requested attached is the doc for APINVOICE.
Katfra
Advanced Member
Posts: 30
6/16/2010 11:44 AM
Thank you both for all your help, i have appreciated it.
Katfra
Advanced Member
Posts: 30
6/24/2010 12:27 PM
The .txt file you attached, is there more documentation like this and where can i find it for other tables?
Shenny
New Member
Posts: 1
7/1/2010 7:27 PM
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.
TK
New Member
Posts: 3
8/9/2010 11:20 AM
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
Ruma Malhotra
Veteran Member
Posts: 412
8/9/2010 12:19 PM
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.
TK
New Member
Posts: 3
8/9/2010 5:02 PM
Thanks Ruma for the solution.I will replicate this tomorrow when access to the documentation is allowed and will provide feedback.
You are not authorized to post a reply.