Journal Entry

Sage ERP Accpac General Ledger 6.0

image\field_bt.gifJournal Entry

This form lets you:

  • Create new batches.

  • Add journal entries to existing batches.

  • Change and delete journal entries.

  • View and reverse posted entries.

  • Add intercompany transactions if this is an ICT (Intercompany Transactions) database.

  • Drill down on posted and unposted entries that originated in other Sage ERP Accpac ledgers to view the source transactions.

A General Ledger batch is a group of journal entries, each of which contains at least two transaction details, one for the debit amount and one for the credit amount.

Journal entries do not affect G/L account balances until you post the batches.

To add an entry

To drill down to a source transaction

  1. Open General Ledger > G/L transactions > Batch List.

  2. Select an existing posted or unposted batch containing transactions created in another Sage ERP Accpac ledger (such as Accounts Receivable or Purchase Orders).

  3. Select the entry of interest to you.

  4. Click the Drilldown button next to the Entry Number field to display the original transaction in the source ledger's data entry form.

To drilldown from a report generated by G/L Statement Designer in Excel, see FR Drilldown.

 

To reverse a posted transaction

  1. Open General Ledger > G/L transactions > Batch List.

  2. Double-click the existing posted batch containing the transaction that you want to reverse. (This opens the G/L Journal Entry form.)

  3. In the transaction grid, highlight the transaction that you want to reverse, and click the Reverse button (at the bottom of the form).

The Create Reverse Entry dialog box appears.

  1. Use the Finder, or the navigation arrows to specify the batch where you want to add the reversing entry.

  2. Add an Entry Description.

If you create a new batch, the default description is REVERSE BATCH.

  1. Click the Process button to create the reversing entry.

Customizing the Journal Entry form

  • Change the order of columns in the transaction list to suit the type of information you enter with each transaction. Click on the column heading you want to move, and drag it to a new position.

  • Select a default source code for journal entries.

  • Use the Customize command on the File menu to hide fields.

  • Use Zoom (F9) to replace the detail list with a data entry form.

  • Use the Settings menu to streamline data entry. (Note that the Settings menu on other forms has two different options: Save Settings as Defaults and Clear Saved Settings.

Editing batches

  • You cannot edit entries in batches that are set Ready to Post (see the Status indicator on the upper right side of the Journal Entry form). You can change the Ready to Post status in the Batch List form.

  • You cannot edit entries in batches that have been deleted or posted; however, you can automatically create a reversing entry in a new batch.

  • You can edit batches that have been provisionally posted, then post the revised batches.

  • You can edit imported batches only to the degree you specify for the Edit Imported Entries option on the Posting tab of the G/L Options form.

You can allow editing of all fields, the fiscal period only, or prevent any editing.

 

Before posting

Before you can post an entry:

  • It must balance in the functional (home) currency.

  • It must contain valid account numbers and source codes.

  • The batch must be set to Ready to Post in the Batch List form.

  • The batch must be printed if you use the Force Listing of Batches option.

  • The accounts must have Active statuses.

  • The fiscal period it is posted to must be open. (Periods are opened and closed with the Fiscal Calendar in Company Services.)

When General Ledger posts a batch, all entries that cannot be posted are added to a new batch. Print the posting journal for a list of all posted transactions and all errors that the program encountered.

Importing and exporting transactions

To import a batch that was created in another program, choose Import from the File menu.

To export a copy of an unposted batch, choose Export from the File menu.

Click here for hints on using forms.

See also