You are here: System Settings > System Settings

general ledger system configuration

Masking of the General Ledger for sales branches and inventory warehousing is setup in this tab.  The ability of the system to save errored sets (for posting at a later date) and change BAS codes on committed journals is maintained in this tab.

IDKey Default Description
NumberFormat #,##0.00; (#,##0.00) Number format for monetary values.
SaveZero
Transactions
No Create a journal set from an external form (e.g. purchase orders, stock transfers) where the dollar value of the journal is 0.00.
BranchSegNo   General ledger account number segment applicable to branching.  A ledger mask is applied over the Profit & Loss accounts in the journal(s) created by Sales Order Processing.  This setting works in conjunction with the setting BranchInvoicing in Invoicing.The Branch descriptions and ledger masking details are set up in System, Branch Config.

Example:
Branch Segment = 3 (i.e. the third segment of the account code)

Cost of Goods account  = 2500-100-00
Sales account              = 2014-100-00
Melbourne Branch        = 03

Debit        
Cost of Goods 2500-100-03
Credit              
Sales Account 2014-100-03

WarehouseSegNo   General ledger account number segment applicable to warehousing.  Warehouse masking is applied over the Balance Sheet accounts for purchase orders, receival slips, purchase invoicing, stock and warehouse transfers, stock takes and Sales Order Processing.  It is also applied over the Profit & Loss accounts during Sales Order Processing. Details are set up in Inventory, Control Maintenance, Warehouse Maintenance.  

Example: 
Warehouse Segment  = 2 (i.e. the second segment of the account code)
Inventory Account      = 6200-000-00
Melbourne Warehouse = 300

Stock Transfer into Melbourne Warehouse
Debit   
Inventory 6200-300-00
Credit              
Write On  (no masking)

Sales out of Melbourne Warehouse for the Melbourne Branch

Cost of Goods account  = 2500-100-00
Sales account               = 2014-100-00
Melbourne Branch         = 03


Debit   
Cost of Goods 2500-300-03
Credit              
Sales Account 2014-300-03
Credit              
Inventory 6200-300-00

TransCode1 Job No Transaction code descriptions for ledger allocation from a search window in the journal screen.  The title of this field is editable. Details are set up in General Ledger, Control Maintenance, Maintain Transaction Jobs.
TransCode2 Group No Transaction code descriptions for ledger allocation from a search window in the journal screen.  The title of this field is editable. Details are set up in General Ledger, Control Maintenance, Maintain Transaction Groups.
Staff Code Manager Allows selection of a Staff code from the Staff Table.
SaveErroredSets No Controls whether journals to be saved from external forms (e.g. purchase orders) are done so without checking for data validity.  This can result in errored journal sets.  Where the setting is unticked, a message displays detailing the error and will not activate until the error has been corrected. E.g. - Period Lock for Year 2005, Date 23/05/2006, Period 11 May 06.
WarnWhenErrored

SetsExist
Yes Display a message when loading General Journals where errored journal sets exist in the database.
AllowBasCode
Change
No Permit the BAS code ONLY to be changed on posted journals where the ledger period is NOT Globally locked.
AllowClearing
AcrossPeriod
No Where this setting is unticked, clearing General Ledger transactions is limited to only clearing transactions in the login month. Where this is yes, multiple clearing across different General Ledger periods is permitted.
SuppressCreation
OfParent

Accounts
No Do not allow creation of General Ledger Parent Accounts automatically.

Copyright © 2012 Jiwa Financials. All rights reserved.