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