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:
Chad Mac
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5185
People Online:
Visitors:
192
Members:
0
Total:
192
Online Now:
New Topics
Infor CloudSuite
Infor OS/Cloudsuite SCIM groups
10/4/2024 2:06 PM
We are in the process of moving to the Cloudsuite
Lawson Landmark
Spreadsheet Designer Error "Unknown state selection"
9/20/2024 3:19 PM
I am looking for assistance, I am trying to upload
Lawson S3 Procurement
Adding Std Comments to all PO's
9/17/2024 7:06 PM
Does anyone know of a way to get trailing comments
Lawson S3 Procurement
Missing po info
9/4/2024 3:34 PM
We are experiencing an issue where freight account
Lawson S3 Procurement
We need to charge multiple items to 1 dept no mattter who orders the items. Our POs are out of company 1000 and cost centers are set up in company 1300. Does anyone else have this issue and have a way around it?
8/16/2024 1:55 PM
We have 3 items that need to be charged to the lab
Infor CloudSuite
Dbimport - only importing 1st record of file
8/13/2024 3:51 PM
In FSM Cloudsuite, I've got a file containing
Lawson S3 Procurement
How does everyone charge an item to 1 dept no matter who orders the item?
8/12/2024 6:20 PM
We have 3 items that need to be charged to the lab
IPA/ProcessFlow
WFWORKUNIT table, WF-STATUS field value set
7/25/2024 8:51 PM
documentation I can find has values for this field
Lawson S3 HR/Payroll/Benefits
Benefit change/termination rules
7/23/2024 2:22 PM
Can old benefit change/termination rules be delete
IPA/ProcessFlow
this.bean is null
7/19/2024 5:42 PM
Getting this error when my IPA gets to the second
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3291
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1360
Roger French
1315
mark.cook
1244
Forums
Filtered Topics
Unanswered
Unresolved
Announcements
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Financial Management
Lawson S3 Financials
Accounts Payable Aging Report
Please
login
to post a reply.
13 Replies
2
Subscribed to this topic
149 Subscribed to this forum
Sort:
Oldest First
Most Recent First
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.
Please
login
to post a reply.