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
AP150
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Jessica
Past 24 Hours:
2
Prev. 24 Hours:
0
Overall:
5164
People Online:
Visitors:
288
Members:
0
Total:
288
Online Now:
New Topics
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
AP150
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
maharuchi
Advanced Member
Posts: 28
5/14/2015 3:02 PM
Hi , I 'm looking for query to pull out data from AP150 Report. I want to create Custom report for AP150 to include Invoice Date.
Thanks
Mark F. Hardy
Veteran Member
Posts: 44
5/14/2015 3:21 PM
I was just viewing a Lawson Smart Reports webinar yesterday which is within the ICYHH series; it stands for “In Case You Haven’t Heard”. LSR is useful when you want to modify a report, as you do. You can always hardcode it in AP150, and it's printer file, but LSR is better as it makes patches and upgrades easier. It is also a deliverable for v9.01.11 and higher, or v10.0.0.6 and higher. You just have to enable it. It doesn't have a component cost. We have modified AP155 report a long time ago, so we have it hardcode. More cumberson now that the code is in the IFS. One of my posts details how we handle this. Hopefully you are on a version high enough to simply enable LSR.
maharuchi
Advanced Member
Posts: 28
2/8/2016 2:21 PM
Thanks Mark. I reached out to Infor for LSR. Per infor, Lawson Smart Report is only to edit a report's layout. It can not add or remove a parameter/field from an existing report. Is there any way I can pull out the query used in AP150? I could not find your post like you mentioned in your reply.
Mark F. Hardy
Veteran Member
Posts: 44
2/8/2016 4:22 PM
Thanks for the update; now I know LSR can only reposition fields within a report, not add or remove fields from a report. Below is the link where I posted regarding how we handled v9.0 to v9.01 migration. As the code is now on the IFS we devised a technique to not only edit the source using native Iseries source files as well as use it as an archival method for change versions. Hope it helps.
https://www.lawsonguru.co...g-from-9004-options/
You are not authorized to post a reply.