SUP202 – Inventory Revaluation
Overview
We have added the ability for users to revalue their Inventory On Hand Values without needing to adjust quantities in any way. This function is available in the Palladium Enterprise and Premium Editions only.
Processing
From a processing point of view, you simply select the Inventory Adjustment function and change the type from Adjustment to Revaluation as seen below.
SUP105 – Segmented General Ledger
The General Ledger Segmentation function was designed to allow business to have extended General Ledger reporting capabilities in organisations with Multiple Branches and/ or departments, with the ability to filter and report on one or more of the segments. This facility has also been designed to complement the account set by warehouse function, allowing us to have a segment integration by item or item category by warehouse, allowing profitability to even be reported on a product line basis. Another market for this is in the issuance and control of Grants or Fund Management whereby we can report on the individual projects managed within the specific fund(s).
Another limitation that has been overcome is that of departments with departmental allocations previously being done at a document level basis. With the segmented General Ledger you can now process integrations document line item.
Setting Up General Ledger Segmentations
The first thing you need to do is to create the segments. It is important to note that creating segments is merely creating parameters and does not create the accounts themselves. Creating segments will be explained in 2 separate sections, ie clients converting an existing (non-segmented) company, and clients creating a new company. Note that the ability to add segments is available to both scenarios at can be done at any time. You can also Manage segments either by accessing the General Ledger / Maintenance / Accounts function and selecting the Add New Account Segment as seen below.
You can also access the account segment maintenance by accessing the Control Panel / Company Options / Company tab as seen below:
Upgrading an Existing Company
Existing Segments
When you upgrade from a pre-General Ledger Segmentation company, on conversion the current Sub-Accounts will automatically become the second segment, and will allow you to report by the values in this segment. You can see from the screen that we had 2 sub-account settings in the Original Company Data namely 0000 and 0500. All we need do now is to name the segments and report accordingly.
Adding Segments
You can then redefine the General Ledger Segments as required with the ability to add new segments as seen below.
Remapping Accounts
The Manual Setup option as seen here, allows you to define your own segment lengths while the other options below will install the 4-4 account segment structure with the sample data, but allow you to adjust at a later stage. The first segment is reserved for the account number and can have a minimum quantity of 3 digits, that are numerical only, while the other segments are limited to 10 segments 50 characters in total, and can be set as Alpha, Numeric or, Alphanumeric as defined above.
Creating a New Company
When creating a new company there are a number of options afforded to you.
The Manual Setup option as seen here, allows you to define your own segment lengths while the other options below will install the 4-4 account segment structure with the sample data, but allow you to adjust at a later stage. The first segment is reserved for the account number and can have a minimum quantity of 3 digits, that are numerical only, while the other segments are limited to 10 segments 50 characters in total, and can be set as Alpha, Numeric or, Alphanumeric as defined above.
Building or Creating Accounts
Once you have created your segments (or building blocks) you then need to create your accounts. You do this by selecting the primary account segment then select the second segment. In doing this you ensure that only the accounts relevant to that segment (branch or department for example) are created.
Using the Account Builder
The account builder function allows you to build your required accounts with the Segment definitions being added as they are selected as seem here.
Account Import
We also provide the ability to import your General Ledger accounts. You can find this in the Control Panel / Import & Export / Ledger Accounts.
General Ledger Reporting
The general ledger reporting function caters for up to 3 combinations of segment filters in most of the ledger Reports. In addition, you can select one of more of the segments to give you unsurpassed multi-dimensional financial view of your business.
SUP085 – GL Open Item Allocations
The purpose of this function is twofold. Firstly it allows you to “allocate” or suppress from view, transactions that offset each other, allowing you to only see the relevant “outstanding” entries. Secondly, the system is used to auto-allocate transactions during the adjusting process, allowing you to suppress the original and reversal entries on the fly, leaving only the original entry as unallocated.
Manual Reconciliation
Objective
You would generally use this facility to reconcile accounts such as cash clearing accounts or general provisions and accrual accounts where you would like to offset amounts or entries against each other.
Processing
To process open-account allocations, first, select the icon in the General Ledger processing screen and select the account to allocate against. The system will list all transactions in the account whether allocated or not. This will allow you to reallocate previously allocated transactions should you require.
In the screen below you will see that we have offset a loan of R2000 against 2 of the repayments (in red) where the system has automatically applied an adjusted entry in Orange.
Reports
You can now run the General Ledger Transaction report showing All transactions or only the Unallocated Transactions.
Showing ALL transactions
Or showing UNALLOCATED Transactions Only
Automated Reconciliation
Objective
One of the main control features in Palladium is that we write a reversing Journal Entry for all adjusted transactions. This is good accounting practice and corporate governance, but can result in an extensive number of transactions in your General Ledger accounts.
Processing
To overcome this, Palladium automatically reconciles the original transaction with its General Ledger reversal on the fly, allowing users the ability to show all transactions or only the “unaffected’ or unreconciled entries.
Prevention
To prevent excessive transactions we would like to remind you of the Document Info feature that allows you to amend non-financial information, such as a sales representative as on sales documents as will not create any General Ledger Entries unlike the Adjust feature found on the same document.
