Ledger

Overview 

The Ledger module allows you to view all your Accounting transactions on one screen. Multiple Views are available including a Transaction View and a Detailed Ledger View.

A Recent button is used to enable easy navigation back to any of the last 20 Items that you have accessed. Visible in the List View and the Edit View. 

The list of Transactions that pops up under the New button is grouped by Customer, Supplier and other Transactions to prevent scrolling the popup menu. 

Note: Ledger transactions are created in the Ledger and do not replicate to modules.

Editing View

The following Warnings are displayed in a red bar at the top of the Editing View:

• The Bank Currency does not match the Transaction Currency 

• Bank is not linked to the same Entity as the Transaction 

• The Customer Currency does not match the Transaction Currency - Foreign Gain/Loss transactions are excluded. 

• The Supplier Currency does not match the Transaction Currency - Foreign Gain/Loss transactions are excluded. 

Menu (button)

• Open Transaction in Module - Used to open transactions in the standard Transactions module.

• Enable Debit & Credit - Enables the ability to override the Debit and Credit defaults in the Transaction for custom selections.

Actions

• Update the 'From' transaction

• Update the Transaction Type

• Update the Supplier Payment 

• Create/Update a Service Ticket - This can be used to create an internal Service Ticket to manage an accounting query on a Transaction.

Transaction View 

Fields

• OTE - Override Trial Errors - this field can be used to filter Transactions where an override has been applied to a Transaction with a Trial Balance Error.

• VAT ID - The ID of the VAT Reconciliation that contains the transaction

Note: Items in the Ledger can be multi-selected. The Footer Summary reflects the multi-selected items. 

Customer/Supplier Account

This view allows you to view all the Transactions for a selected Customer in the local Currency and in the Customer/Supplier's Currency. When you view the account in a Foreign Currency, only the transactions that were created in the Foreign Currency will be displayed. All the Transactions will be displayed when you view the account in the Local Currency, including the Forex Gain and Loss Transactions.

Data Filter

• Filter - Select Customer Account or Supplier Account

• Account - Select a Customer or a Supplier

• Entity 

• Currency - The Currency will default to the Customer/Supplier Currency. You can change it to the local currency to view the Forex Gain/Loss transactions.

Fields

• Outstanding - The outstanding amount on the transaction in the selected currency.

Ledger Allocations

When a Transaction is read-only from being linked to a VAT Reconciliation, you can allocate it (similar to how it works when a Transaction is read-only from being Allocated) 

The Outstanding Transactions to allocate are filtered to match the Transaction Entity.

The Clear (button) clears all Allocations at once. 

Context Menu

Right-click on Allocation for the following actions:

• Delete Allocation - Clears one allocation at a time 

• Open Transaction - Opens the transaction in the Ledger.

Output

The available Data Pipelines include:

• Lgr_Rec/Lgr_All - Transaction View / Detailed Ledger View - Depends on the selected View.

• Lgr_Items - Transaction Items

• Lgr_Allocation - The Allocated Transactions

• Lgr_Filters - The Filter parameters

Settings

General Settings

• General Settings > Service Manager > Category used for Accounting queries: Select from a lookup list of Service Categories. When a Service Ticket is created from a Ledger transaction, the selected Category will be assigned.

• General Setting > Password: Edit read-only transactions in the Ledger. This password allows you to temporarily make a read-only transaction editable. See Ledger > Edit Form > Actions > Edit Transaction. An Audit is created when a read-only transaction is edited. 

Transaction Settings

• Enable 'Clear Overpayment' function in Ledger

• Enable 'Discount Outstanding' function in Ledger

• Enable 'Record Foreign Exchange Gain' function in Ledger

• Enable 'Record Foreign Exchange Loss' function in Ledger