Transaction History

Sage ERP Accpac General Ledger 6.0

G/L Transaction History

This form:

  • Opens the Journal Entry Inquiry form.

  • Displays all transactions posted to an account in a particular year and fiscal period (unless they've been consolidated).

If you wish, you can restrict the list to transactions with a particular source code or source currency (if you have a multicurrency ledger).

Transaction information includes:

  • fiscal period

  • date

  • source code

  • reference and description

  • functional currency for posted amounts and source currency (if you have a multicurrency ledger)

  • reporting currency amount (this option is available only if the euro is your functional currency and you specified a reporting currency)

  • quantity

  • exchange rate, rate type and rate date (if you have a multicurrency ledger)

  • batch number, entry number and transaction number

  • optional fields

If you do not specify a source code or currency, the program lists the displayed transactions first by year and period, then in order by currency, source ledger, source type, posting sequence, and detail record number.

  • Displays rollup amounts. If Use Rolled Up Amounts is selected and the Go button clicked, all transactions posted to an account in a particular year and fiscal period as well as the rollup member transactions will be displayed. A new field, labeled "Members" appears in the grid to display the rollup member/rollup account the transaction was posted to.

If this is an Intercompany Transactions company:

The report will be called ICT G/L Transaction History Inquiry, and will have an extra field, labelled "Company." In all other respects, the report does not change.

To display transactions

  1. If this is an Intercompany Transactions company, select the company code in the Company field. (If this is not an ICT company, begin with step 2.)

  2. Enter an Account number or select one with the Finder.

  3. Select the Period Ending for which you want to view transactions.

  4. To view only one type of transaction, use the Finder to select a Source Code.

  5. Use the Finder in the Currency field to select the currency of the transactions you will view.

Results display automatically in the detail grid whenever you change the input fields.

  1. If you want to view transactions of rollup members, select the Use Rolled Up Amounts option, then click the Go button.

  2. Double-click a transaction detail to drilldown to the journal entry that created it.

Click here for hints on using forms.

See also