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