The Advanced Sales Reporting includes a collection of reports that report and present sales statistics in various formats. These reports have been designed to assist in the analysis and interpretation of sales data within Tencia.

Sales analysis report feature includes:

•  Sales Code by Debtor Code: This report includes Month to Date (MTD) and Year to Date (YTD) sales quantity and value by Sales Code, by Stock Category and can be printed categorised by sales code.
•  Sales Code by Stock Category: This report includes MTD and YTD sales quantity and value by Sales Code by Stock Category. This report can be printed by sales code.
•  Sales Code by Debtor Code by Stock Code: This report can be printed in summary or detail format, and includes MTD quantity and values, including a margin value and percentage. This report can be printed by sales code, customer code or stock category.
•  Debtor Code by Sales Code: This report includes MTD and YTD sales quantity and value by Debtor Code by Stock Code. This report can be printed by debtor code.
•  Debtor Code by Stock Code Monthly Detail: This report includes 12 individual months sales details by Debtor Code by Stock Code optionally printing quantity, value or both. This report can be printed by debtor code.
•  Sales Code by Debtor by Stock Code: This report can be printed in detail or summary format, this report includes MTD and YTD sales quantity and value, including a margin value and percentage. This report can be printed by sales code.
•  Sales by Stock Category by Stock Code: This report includes MTD and YTD sales quantity, sales value and cost including margin value and percentage by stock category or stock code. This report can be printed by stock code or stock category in stock code or alpha sequence, including supplier code.
•  12 Month Sales By Debtor Code: This report includes 1 2 individual months sales value for each Debtor Code, and calculates the sales value percentage that each debtor represents of the total sales value. This report can be printed by debtor code, in alpha or debtor code sequence.
•  12 Month Sales By Sales Code: This report includes 12 individual months sales value for each Sales Code by Debtor Code, and calculates the sales value percentage that each represents of the total sales value. This report can be printed by sales code, in alpha or value sequence.
•  Sales History Report: This report can be printed in summary or detail format, when selecting in detail format individual transaction details listed, including date, invoice number and transaction type. This report can be printed by Sales Code by Date range in either stock or debtor sequence.
•  Maintain budgets by stock code, stock category and customer type.

• Back to Module Overview

For organisations that have more than one company operating, the Multi-Company feature in Tencia has been developed to assist and streamline the creation and optional consolidation of these companies.

Tencia Multi-Company features:

•  When creating new companies it is possible to copy the Chart of Accounts and Financial Reports from an existing company.
•  This Multi-Company option allows you to optionally consolidate general ledger balances from nominated companies. This can be done for all companies created or by selecting specific companies for the consolidation process.
• Back to Module Overview

Tencia’s Serial Tracking feature provides the mechanism to easily and immediately identify, monitor and track the movement of stock items by a unique characteristic such as a Serial, Batch or Roll number.

This feature is very valuable in manufacturing environments, when Bill of Materials is implemented, both raw materials and/or finished goods can be tracked by Serial, Batch or Roll Numbers.

Serial batch tracking feature includes:

•  The ability to assess and track warranty claim conditions.
•  To allocate Serial/Batch numbers to raw materials and finished goods.
•  Optionally able to enter expiry dates and production batch details.
•  Optionally allocate Serial, Batch or Roll Numbers during sales order entry.
•  Optionally allocated Serial, Batch or Roll Numbers during production order entry.
•  Monitor actual cost of individual items, and this cost can optionally be the basis for cost of sales calculation.
•  Automatically allocate serial numbers.
•  Ability to use oldest stock first according to expiry date.
•  Bar code scanning features.
•  Have Multiple Bin Locations per item.
•  Perform global stock searches by Serial, Batch or Roll Numbers.
•  Provision to record adjustments against, Serial, Batch or Roll Numbers.
•  Serial, Batch or Roll number reports can be based on the status of individual numbers, including expiry date range, production batch range or quantity selections.

• Back to Module Overview

With Tencia you can enter purchase orders, creditor’s invoices, sales orders, debtor invoices, General Ledger payments and journals and credit notes in a foreign currency.Tencia allows for centralised cash related transactions, for currencies in addition to the local currency.

•  Nominate a default foreign currency code for individual debtors and creditors.
•  The foreign currency rate can be maintained daily or at a frequency that suits your individual requirements.
•  Override the default foreign currency rate, during a transaction by entering a transaction “currency rate”.
•  Reports such as the debtors and creditors trial balance reports can be printed using either the “default rate” or “transaction rate”.
•  Optionally when printing debtors statements or creditors remittance a currency code can be selected.
•  Inquiries can be performed to display local currency values and foreign currency values.
•  Foreign Currency transactions are entered in the nominated currency of the bank account e.g. US dollars.
•  Automatic calculation of local currency amount based upon conversion rates entered during data entry.
•  Ability to revalue transactions allowing for unrealised and realised foreign exchange losses/gains to be generated.
•  Automatically generate the necessary journals for revaluation of transactions.
•  Print Cash Book reports such as the transaction list, in either local and/or the foreign currencies.
• Back to Module Overview

A transparent layered security model provides the foundation for the Tencia user experience. It aims to deliver a user experience which helps both employees and systems administrators become more efficient and productive

Tencia’s security features include:

•  Security based on roles. Tencia groups individual users that have similar characteristics into ‘roles’. A role could be based on job function, e.g. customer order entry and processing or on position e.g. senior management.
•  Tencia incorporates code level permissions, which is a facility to assign a permission level on predefined system codes such as debtor, creditor or stock codes. This limits the type of data that can be accessed by users and ensures sensitive details are not easily accessible.
•  User defaults can also be set which means that some fields in a data entry screen can be by-passed based on the user default that has been applied to these fields. Information is therefore pre-populated into these fields which means they can be by-passed so that data entry is streamlined which also minimises errors during data entry.
•  Security levels can be applied to individual menu programs. A security level of 1-9 with 9 representing the highest level can be applied which will determine which programs are displayed in the users menu.
• Back to Module Overview

Tencia’s Purchase Order features allow you to effectively manage orders that are placed with suppliers.This feature is fully integrated with job costing, Bill of Materials and the Sales Order system so that automatic stock allocation to customer backorders occurs.

Purchase order features include:

•  Easily change or delete orders.
•  View stock balances when creating orders.
•  Maintain foreign currencies so that orders can be placed with overseas suppliers.
•  View costs that were charged in the past by a particular supplier for an individual item while placing an order.
•  Enter non-stock lines on purchase orders.
•  Automatically allocate stock received to sales backorders.
•  Enter multiple purchase orders against one supplier’s invoice or delivery docket.
•  Purchase order text facility by line or block.
•  Calculate total weight on purchase order.
•  View purchase history for creditors and stock code combinations, to better negotiate purchase prices with creditors.
•  Print bar code labels for stock received.
•  Receipt stock into a transit location.
•  Optionally allocate additional costs to a purchase order based on value, quantity, import duty percentage, or weight. (Landed cost.)
•  Variances between actual and estimated costs will be highlighted when supplier invoices are entered.
•  Purchase orders received into stock before the supplier invoice is received.
•  You can create a purchase requisitions.
•  Can allocate a minimum authorisations value.
•  Allocate authorisation security levels.
•  Create return authorities.
•  Automatically generate purchase orders for sales orders, stock, production orders and jobs.

Purchase order reports include:

•  Orders.
•  Cash commitments.
•  Costs by order.
•  Costs by stock.
•  Quantities by supplier.
•  Values by order.
•  Values by stock.
•  Values by supplier.
•  Order status report.
•  Quantities by stock.

 Back to Module Overview