iDrive tip: Reprinting posting journals in Microsoft Dynamics – GP

Today’s tip reviews how to reprint the most common posting journals in Microsoft Dynamics – GP.

General Ledger
The easiest way to reprint is to know the TRX Source.  Create a SmartList under Account Transactions that includes the TRXSource and the Originating Source.  The Originating Source can be seen on your sub-ledger posting as the Audit Control Code in the upper left hand corner of the report.  In the SmartList, search for the Originating Source or Audit Control Code from the sub-ledger.  Note the related TRX Source field.   Go to Reports – Financial – Cross Reference.  Choose Journal Entry as the report.  Create a report option.  Check Posting Accounts and select your year.  If you are using Unit Accounts or have a Voided Transaction you will also need to select these options.   Set the range to Audit Trail Code and enter the TRX Source number you just looked up in SmartList.  Insert this

into your ranges.  Set your destinations and Print.

Accounts Payable
Go to Reports – Purchasing – Posting Journals.   Select the type of journal you want to reprint.  The options are Transaction Journal, Manual Payment Journal, Checks Journal, GL Distribution Detail, Apply Journal, Void Historical Trx and Void Open TRx.  (The other available options are Purchase Order related.)  Create a report option.  Range choices for selecting your information are Audit Trail Code, Batch ID, Posted Date and Batch Source.  Enter as many of the ranges as possible to eliminate getting the wrong journal.  Set your destination and print.  If you don’t know the Batch Number, Batch Source, or Batch Source, you can identify these by creating a SmartList under Payables Transactions.  Include Vendor ID, Voucher or Document Number, Batch Number, Batch Source, and TRX Source.  Search by using a known voucher or Document Number.

Accounts Receivable
Go to Reports – Sales – Posting Journals.   Select the type of journal you want to reprint.  The options are Sales Posting Journal, Receivables Posting Journal, Cash Receipts Posting Journal, Discounts/Write-offs Journal, Receivables Voided/Waived/NSF, Commissions Posting Journal, Invoicing Posting Journal, Sales Voided and Sales Deposits.   Create a report option. Range choices for selecting your information are Audit Trail Code, Batch ID, Posted Date and Origin.  Enter as many of the ranges as possible to eliminate getting the wrong journal.   Set your destination and print.  If you don’t know the Batch ID, Audit Trail Code, or Origin, you can identify these by creating a SmartList under Receivables Transactions.  Include Customer Number, Document Number, Batch Number, Batch Source, and TRX Source.  Search by using a known document number.

Please let us know if you have questions.

 

This covers most journal reprints that I see you guys needing.  Please let me know if you have any questions/issues.