Query for AP150

Legacy Contributor

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

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.