Explorer

Using the desktop version of Explorer (versus the live/online version), we can work with the AP Journal Report

Instructions:

Switch to the G/L module, go to the Reports menu, choose the Journal Report, choose which company to pull for and the Transaction Date range, and then from the list of which journals to pull from choose all the ones prefaced by A/P (Consider including other transaction methods like Purchasing Cards if you use them), finally choose the format (Excel button in this case)

We reccomend splitting the Date Range up as the full 4 years can take up to an hour for Explorer to generate the spreadsheet

If you're unable to create a single report with the information we want, in the past weve had success in using the following three reports:

AP INVOICE JOURNAL

AP GL DETAIL

GST GL DETAIL

Explorer can export these reports to plain text format (TAB Delimited) and we can then join them together. These reports should be run for the same time period (likely a fiscal period)

Excel is also an option in terms of format to export to, but it has issues of row limitations so we prefer plain text.