infor.com
concierge
infor u
developer portal
Home
Groups
Lawson - Financials Product Customer Community [READ ONLY]
Query for AP150
unknown
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
0905290750040159.pdf
Find more posts tagged with
Infor Lawson Financials Group - Discussion
Comments
Jim Norbut
If you have the OLEDB Connector for Lawson, you can use crystal reports and use a persons print file as the source for a report. And then link things up back to the lawson db by company,vendor,invoice,suffix to get the invoice date if need be. If that is what you might be looking for.
Or maybe dump the report from print manager to a .csv and use that as a source and link back (not sure how pretty the .csv would look)
the trickiest part will be the fact in the print file or if you dump to a csv
that the vendor field won't be right justified anymore and you'll have to pre-pad with the right amount of spaces to make it link up correctly.
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Popular Tags
Infor Lawson Human Resources Group - Discussion
Infor Lawson Technology Group - Discussion
General Discussions
VISUAL - Enterprise General Discussions
Infor Lawson Supply Chain Management - Discussion
Process Automation (IPA) - General Discussions
Pegasus - Partner General Discussions
Infor Lawson Supply Chain Group - Discussion
Infor Lawson Financials Group - Discussion
Infor EPM Discussions