Great Plains

Note: Many clients file invoices by Batch using Cheque numbers. If you file via this method, including Cheque numbers is vital in these reports

The report we are looking for is named either the Transaction Reprint Journal OR GL Distribution Detail and can be accessed by going to Reports >> Purchasing >> Posting Journals (GL GL Distribution Detail).

In the report options change the range of the Posted Date so that only transactions for the last 4 years will be included in the report.

If file size is an issue, or reports take a long time to run, it may be necessary to use multiple time periods, for example one fiscal year at a time.


    To reprint the Transaction Journal:
        Purchasing>Reports>Posting Journals
        Reports: Choose  Transaction Journal from the drop down
            Year: Click on Open and choose the proper year from the drop down at the end of the Year field.
            Sort By: Choose Batch ID from the drop down
            Ranges: Choose Batch ID from the drop down
            Click on the looking glass at the end of the From field to open the Historical Purchasing Batch IDs window
            Click on the batch needed and Select
            Insert
            Destination: choose your preferred destination and format, and click OK.
            Print


    To reprint the General Ledger Distribution Journal:
        Purchasing>Reports>Posting Journals
        Reports: Choose GL Distribution Detail from the drop down
        Same Steps as above


Slightly different report, the Cross-Reference may also work:

    To reprint the General Posting Journal:
         Financial> Reports>Cross-Reference
         Reports: choose Audit Trail Code from the drop down
            Include: Check Posting Accounts, Unit Accounts, and Voided Transactions.
            Sort By: Audit Trail Code
            Year: Click on Open and choose the proper year from the drop down at the end of the Year field.
            Ranges: Click on the drop down and choose Date.
            From/To: choose the posting date range
            Destination: choose your preferred destination and format, and click OK.
            Print

Alternatively

If the above instructions do not work, the report Detailed GL Trial Balance will provide similar details. To generate this report go to Reports >> Financial >> Trial Balance (Detailed).

Either report can be saved a as text (.TXT) file and sent.

OLD INSTRUCTIONS which are not always working:

It may depend upon which version/configuration of Great Plains, but the report we're looking for is much like the GENERAL TRANSACTION EDIT LIST, which is printed out when an A/P Batch is entered. The report is sometimes titled TRANSACTION REPRINT JOURNAL.

For most versions of Great Plains the report is the following:

Go to Reports
Purchasing
Posting Journals
The report should be Transaction Journal
Select New or choose an existing report to modify
Ranges: Select posted Date and enter the start of a fiscal period and the end
Remove any restrictions
Click on Destination
Deselect screen and printer if they are selected. Select file
File Name: Click on the file icon to select a location and filename for the report
File format: Should be Text file
Click OK to the options
Click on the print icon to run the report

We will also need a vendor list since these A/P reports only contain vendor IDs.