Periodic Ledger

Overview

This module is used to generate the Periodic Ledger transactions from the sub-ledger transactions. Periodic transactions can be created daily, weekly or monthly.

Note

The Transactions Types need to have the following Status:

• Pending - Does not update Accounting - Default = New

• Complete - Updates Accounting - Default = Complete

• Cancelled -

Settings

Role Settings > Accounting > Periodic Journals - Access Allowed - None, User, Administrator - Administrator rights allow you to access Settings and open a Completed Journal.

Inventory

This allows you to record Inventory Movement for a selected Period.

How to create a periodic Inventory Journal

• Navigate to the Periodic Ledger - the Menu location for this module depends on your setup.

• Click the New button and select Inventory

• Enter the Period start and end date and click Save (The Dates are inclusive.)

• The list of Inventory items that have moved in the selected period will be displayed and an error message will be displayed for:

  • Items that don't have a Unit Price

  • Items that have had a Unit Price change of more than 5%

  • Items that have a negative Opening or Closing Balance

• The value to be posted can be updated in the Ledger column. Click the Reset (button) to reset these values; Values will automatically be reset if the Period dates change.

• Set the Status to Complete to create/update the Ledger transaction.

Settings

• General Settings > Periodic Ledger > Account - Inventory - Select the account to be updated.

• Transactions > Periodic Ledger > Default: Transaction used to Increase Inventory (Dr. Inventory)

• Transactions > Periodic Ledger > Default: Transaction used to Decrease Inventory (Cr. Inventory)

Purchases Received not Invoiced

This allows you to record Purchases that were received but not Invoiced before the end of a period. This transaction can only be executed at the end of a financial period.

Note

Transaction links are checked on the Header Flow.

The following scenarios are supported

• PO > GR > SI - One PO, multiple GR's and each GR is copied to one SI

• PO > GR (multiple) followed by PO > SI - One PO, multiple GRs from the PO and PO copied to SI

How to create a Purchases Received not Invoiced transaction

• Navigate to the Periodic Ledger - the Menu location for this module depends on your setup.

• Click the New button and select Purchases Received not Invoiced

• Enter a Date - the Date will automatically change to the last day of the Period.

• The value to be posted can be updated in the Ledger column. Click the Reset (button) to reset these values; Values will automatically be reset if the Transaction date changes.

• Set the Status to Complete to create/update the Ledger transaction.

Settings

• General Settings > Periodic Ledger > Account - Purchases Received not Invoiced - Select the account to be updated.

• Transactions > Periodic Ledger > Default: Transaction used to Increase Purchases Received not Invoiced

• Transactions > Periodic Ledger > Default: Transaction used to Decrease Purchases Received not Invoiced

• Transactions > Periodic Ledger > Transaction used to Increase Purchases Received not Invoiced: Purchase Order

• Transactions > Periodic Ledger > Transaction used to Increase Purchases Received not Invoiced: Goods Received

• Transactions > Periodic Ledger > Transaction used to Increase Purchases Received not Invoiced: Supplier Invoice