Forcing selected journal lines to balance

You can extend the journal balancing rules by ensuring all of the journal lines that reference a selected field balance.

This is done by selecting one of the following reference fields in the Balance By option on Ledger Setup (LES) or Ledger Import (LIM):

Transaction Reference
Ledger Analysis Dimensions 1 to 10
Transaction Date (Ledger Import only)

For example, if Transaction Date is chosen for the Balance By option, the system checks that all of the journal lines that reference the same transaction date balance.

You can set the Balance By Override option in Ledger Setup (LES) to allow the user to override this check, if required. For example, you may only want the user to be made aware that the journal does not balance by Transaction Date rather than force the journal to balance in this way.

Note: This option causes the Ledger Import file to be sorted prior to processing and may therefore have a detrimental effect on the processing time of a ledger import.