EXP-RO01-4.0.6.1

Expert Version 4.0.6.1

Entersoft Expert^®

New Features & Functionality

New Features & Functionality (Outline)

This document aims to report the new features and extensions of Expert Version 4.0.6.1. First, the newly added functionality and features are briefly listed and, then, a detailed presentation follows. User guidelines and examples are provided where necessary.

Entersoft ERP

• New tool for allocating stock to orders
• Check posting to accounting: A new dashboard that constitutes a valuable tool for checking and ensuring reconciliation in Accounting.
• New rules that protect the users from creating erroneous entries.

Entersoft Framework

• Dashboard Designer and Form Designer: New impressive functionality is now available.

Entersoft ERP

Inventory

Stock Allocation to Orders

The aim of the “Stock Allocation to Orders” process (available at: Inventory / Distribution Processes) is to automatically locate stock, propose its allocation and, subsequently, reserve it for Sales Orders and Intra-warehouse Orders, based on their priorities.

The first list presents the pending Sales Orders and Intra-warehouse Orders, according to the defined filters. In case of Intra-warehouse Orders, the column “Customer” displays the Counterparty name; if this info is not available on the document, then the description of the destination warehouse is presented. In every line, the DEMAND quantity (the open quantity of the line) and the quantity to be DELIVERED (initially set to zero) are listed.

Image 1: Stock allocation to Orders

In the second (bottom) list, the process proposes the W/Hs from where stock is to be consumed, according to the selected Warehouses in the “from W/H” filter (filters’ panel) and based on the consumption feasibility.

Customization of Lists

The filters and the columns of the first list are customizable by modifying the View (scroller): Outstanding order lines (Area: Reserve available stock) (note that the “Name in filter” must not be modified). Any changes in the sorting (priority, issue date) affect the fulfillment prioritization.

Use the drop down field: “Stock calculation based on” in order to define whether the allocation proposal is to be based on:

• Actual Stock: The stock consumption will be based on the actual stock balance.
• Available Stock: The stock consumption will be based on the available stock (i.e. Actual - Reserved).
• Stock that is expected by <a date>: Once this option is selected, a date field becomes available. The stock consumption will be based on the stock that is expected to be delivered to the W/H by the defined date. The expected stock is calculated based on the open purchase orders and their delivery date. This option is principally a “what-if” scenario and, in this case, no reservations are expected to be issued since this might cause negative stock balances; nevertheless, this is permitted by the system in order to support cases where the inventory management configuration is based on future stock.
• A specific delivery: This option requires the selection of a specific Receipt Note (once selected, the button will become available) and its primary purpose is to allow us to examine whether the (recently) received stock is sufficient for the demanded quantities. This (recently) received stock is part of the actual stock unless it has already been used for other purposes.

The “Calculate proposal” action calculates the quantity that is to be DELIVERED for the selected lines of the first list. If not otherwise set, the default priority for the stock allocation is:

1. The “customer/branch priority”; i.e. the priority defined on the corresponding document field is defined according to:

   • In case of Sales Orders, the Customer.

   • In case of Intra-warehouse Orders, the “priority” field will be taken into account when it is not equal to zero; else the priority will be defined according the “Receipt priority” of the destination Warehouse.

2. The registration date of the order.

3. The delivery date of the order (FIFO).

If an Item has available stock in more than one W/Hs, then the systems proposes the use of the W/H that is defined on the Order line; if no stock is available in this W/H, then the stock will be consumed from other W/Hs by “delivery priority”. In order to exclude the use of some W/Hs, it is required to make the corresponding selections in the “from W/H” filter. In case of Intra-warehouse Orders, the “from W/H” is always considered to be the “Position W/H” defined on the document.

The detailed proposal per document line is displayed and can be manually adjusted on a list (Image 2) that can be accessed through the F12 key, when the cursor is placed on the “to be DELIVERED” column. Note that stock from more than one Warehouses can be used.

Image 2: Warehouses and Consumption Qty (F12)

The proposed quantity in the “to be DELIVERED” column can be manually modified as long as:

1. The Demand Qty is not exceeded
2. The quantity in the Consumption list (Image 2) must be equal to the quantity in the “to be delivered” column.

The field minimum fulfillment % is used for excluding orders that cannot be fully (or at least at a significant %) fulfilled, since this can be undesirable for a variety of reasons, e.g. to avoid multiple deliveries to customer. When a minimum fulfillment % is provided, then this used in the calculation of the proposal along with the open value of the order lines (that participate in the proposal calculation) and the total value of each order (which may include the value of items that are not part of the specific proposal calculation). In case of order lines with positive quantity and zero value, the process will use the ordered quantities to calculate the fulfillment percentage. However, when the calculation is based on quantities it may lead to inaccurate results due to the various, unrelated measurement units in use. Hence, a configuration for applying default prices and values in orders is strongly recommended.

The “Priority of repetitive Orders” check box is used in relation to the two new Company Parameters that are now available for defining the special document type for repetitive orders (2^nd, 3^rd, in the same season and by the same customer) and / or the special workflow step. If activated, the repetitive orders will be prioritized and served before all others. In order to define an order as repetitive (either this is placed by a customer or by a branch), the workflow step must be used and not a different document type.

Image 3: Stock Allocation parameters | Repetitive orders

If dimensions (color, size) are monitored for at least one of the Items that participate in the proposal, then the layout of the two lists will be adapted in order to accommodate the quantities per color (colors are listed as rows) and size (sizes are presented as columns). A special size chart that includes all of the sizes participating in the proposal is required (defined in Company parameter: Stock Allocation - Reference size chart).

If the “Calculate proposal” action (button ) is re-executed, the system will display a warning asking for the user’s confirmation in order to delete any quantities in the “to BE DELIVERED” column (either these were automatically generated or manually provided by the user) and re-calculate them.

The “Create documents” action (Button:) will generate reservation Documents (grouped by Customer and Warehouse) for all of the selected order lines. The available stock in these Warehouses will be reduced accordingly.

Image 4: Stock Allocation parameters | Transition Rules

This action executes Document Transitions based on the Transition Rules that have been defined in the related Company Parameters (Image 4). The new Document Type RCT (Rezervare de stoc din Comenzi de transfer intre magazii) and the Transition Rule 302. CTM =>RCT must be imported for Intra-warehouse Orders.

Stock transfer and distribution to Warehouses/Branches

• When stock is delivered by Suppliers and it is required to directly distribute it to warehouses and branches other than the one where stock was originally received, you may use the following new Transition Rules:
  • 130. FAC =>NTR - Aviz de transfer intre depozite proprii din Birourile centrale catre Alt depozit (din Factura - FAC)
  • 130. FRC =>NTR - Aviz de transfer intre depozite proprii din Birourile centrale catre Alt depozit
• In the Branch Replenishment Proposal, when defining the Stock limits per WH, the following Stock limits can also be defined now: “Minimum”, “Reorder Point” and “Maximum”.

Inventory Items and Warehouses

• Henceforth, it is not allowed to designate a Warehouse as “to Third parties” through the “W/H from/to 3rd parties” flag (available on Company Warehouses form), when this warehouse exists in transactions without Trade Accounts.

• Item transactions with no Trade Account. This new View (alternative scroller) can be used in order to find and revise Item Transactions without Trade Account (“to Third parties”).
• The Code Type filter has been added to the “3rd party Warehouse Stock Balances” report; this refers to the Item Code that is to be considered. The available, alternative options are: Standard, Alternative, Tax, and International.
• It is now possible to deactivate Item Measurement Units , in order to exclude any Measurement Units that are no longer in use for a specific Item, while preserving all the past data and transactions (Form: Inventory Item, Tab Page: Transactions, Section: Units of Measurement - Packaging, Column: Inactive; Image 5).

Image 5: Deactivate Item Measurement Units

• The Show Item Picture functionality has been improved in order to show pictures in actual size.
• The Retail Price is now available as a column in Inventory Item Investigation Lists.

Selection lists of not counted items in NVN

In the selection lists of not counted items in NVN, the effect of the parameter Period End Date has changed and, henceforth, it works as “until”. Therefore, the date inserted here represents the date until which the stock balance will be calculated for any not counted items; if the result is not equal to zero, then the item will be considered as not counted in the opening period. The change concerns the related selection list with dimension analysis.

New document types

• The new document type: NFT - Nota de intrare - receptie (fara taxe) is now available. It is used for receipts, demonstration; testing etc. that will NOT be invoiced. WARNING! These must be returned (ART) in the SAME COSTING PERIOD. It only accepts stock items and does not affect the cost of items.

• The new document type: ART - Aviz de retur (fara asteptarea notei de credit) is now available. It is used for Return of goods acquired for testing, demonstration, testing, etc., for which a credit note will NOT be issued. CAUTION! It must be returned at the SAME COSTING PERIOD (NFT). It only accepts stock items, it does not update the accounting subsystem, and it does not affect the item cost.
• New document type: NCA - Nota de credit. The new document type is used in order to make corrections to the values of Credit Notes issued by Suppliers. It affects the Acquisition Cost and it can be used for Inventory Items and Expenses.
• New document type: AFV - Aviz de expeditie (Fara valoare), used for sending merchandise to customers for demonstration, test etc that will NOT be invoiced. At the end of costing period, a transaction of definite cost is created by the COST VALUATION process for these that will not be returned. It exclusively accepts stock items; it does not cover payments and does not update Accounting.
• New document type: RFV - Nota de intrare si receptie (fara valoare) used for quantitative receipt from Sampling or testing that will NOT issue credit note. At the end of the period if a difference occurs from the related delivery quantities (AFV), stock valuation will create cost entries. If tasks are about to happen and a prepayment collection of service cost (cash) occur, Accounting is updated.
• New document type: ΑΤΜ - Aviz de transfer intre magazii used for dispatches between Branches or warehouses. It only updates quantities. If there is an earlier in-house transfer order, this must be done with "CTM" document.

eCommerce

• Measurement Units now include a new flag: “Activate decimals in eCommerce”, used by Entersoft E-Commerce^®. When activated (it is deactivated by default), quantities with decimals can be defined for the specific Measurement Unit.
• For the items that are available in Entersoft E-Commerce^®, it is now possible to influence their performance as search engine results. I.e. Search Engine Optimization is possible by entering appropriate content in the following new fields that are now available for: Catalogue Items, Families, Groups, Categories, and Sub-categories:
  • SEO - URL
  • SEO - URL (English)
  • SEO - Title
  • SEO - Title (English)
  • SEO - Description
  • SEO - Description (English)
  • SEO - Keyword
  • SEO - Keyword (English)

Persons & Trade Accounts

• In order to facilitate the data entry for the Organizational Chart, the Change Layout functionality, from card view to table view, is now supported for Company’s Contacts.
• The automatic update of Geographic coordinates based on the selected address (Address 1) has been improved in order to display a warning if Geographic coordinates already exist. The existing coordinates will be replaced only after the confirmation by the user.

Sales

New transition rules

• In case of Sales Order for items with no available stock in the current Branch when an Inter-Warehouse Transfer Order with reservation is issued using the RTM Document, and the actual Inter-Warehouse Transfer is registered by using the TMR Document, then one of the following new Transition Rules can be used: 162. TMR=>FAV, 163. TMR=>FRV, 164. TMR=>AEV for invoicing the Order. These should not be used if the initial Sales Order has been issued by using ΠΑΡ or ΠΑΔ Documents.
• In order to issue a Credit Note in case of a quantitative receipt after issuing the Invoice, the following new Transition Rule can be used: 178. RFV=>NCV.

New user protection rules

• It is now forbidden to assign negative quantities in document lines that concern Inventory Items, Fixed assets, Services, and Expenses; the rule has been activated for all active Document Types. It has been implemented through the new Field Property Profile CheckNegativeQTY. The version upgrade automatically activates it for all the related Document Types.
• Henceforth, it will not be allowed to modify documents that are linked to a closed Import Folder. A Business Rule has been implemented in order to ensure this. The version upgrade automatically activates the particular Business Rule.
• You can now deactivate special accounts in Document Types, though the new check box Selectable that is now available. This functionality allows you to deactivate Charges / Discounts from Document Types with transactions and protect the users from accidentally using them.

New invoicing functionality

• The customization of Special Accounts is now extended in order to optionally apply percentage on (Quantity * Gross price) which is calculated as the line quantity multiplied by the price (VAT incl.) before applying any discounts.

• Investigation list for Serial Numbers in Documents: the information about the current position of the Serial Number is now available.

• The Item Dimension analysis (F12) dialogue, used when the document lines refer to Items monitored by Color and Size, now includes an additional column that displays the sum of the quantities for a color for all sizes.

Current sales overview

A new drop down selector for Branches has been added to perform sales analysis for a selected company branch.

Sales of Item Sets

A new cube is now available that supports the effective monitoring of the sales of items that are either sold as standalone or in a set (e.g. for a promotion purposes). The report includes two distinctive column sets that present information about the sales of the item as a standalone product and as a part of a promotion (in set). The report is available at: Business Intelligence / Sales Statistics / Item sales statistics.

Image 6: Sales of Item Sets (Special Offers, Promotions)

Expenses & Services

Allocation Profiles in Documents

New fields for assigning an Allocation Profile to the Header of Trade and Adjustment Documents and Expense lines of documents are now available. Hence, when selecting an Allocation Profile at the Header, this is automatically copied to the Expense Lines. If the item has been linked to a different Allocation Profile, then this prevails (similarly to the Horizontal Dimensions). The allocations are calculated based on the profile of the expense line, if this is defined, and not exclusively according to the item’s allocation profile.

Special Account analysis in Documents

The functionality regarding the dimension analysis of special accounts and the functionality of the payment methods per dimension, now takes into account the allocation lines in order to calculate the proportion of amounts per dimension. If the related parameters contain a field (dimension) that exists for at least one of the allocation lines, then the allocation lines will be taken into account for the calculation of the amounts per dimension, instead of the item lines these refer to, for the particular dimensions (the others are educed from the ‘parent’ line), else only the dimension set of the item lines is considered.

Expense Report

LCH – Lista de cheltuieli. This Document Type is used for applying for reimbursement (to be approved) and for updating the Company Expenses. Only expenses can be inserted. If the request is approved (i.e. the ‘Approval’ check box is on), then through transitions, detailed Invoices (“FSC”) or Expense Receipts (“NSD”) may be created, depending on the “Invoice” attribute. The number and the date of the original voucher, and the supplier creditor are required. Moreover, since the registration of the expenses is usually exhaustive, it is recommended to create some standard, generic expenses (that correspond to groups of expenses) in order to facilitate non-expert users. Before the transition, a specialized user may replace these with the specific expenses.

For issuing new Documents of this type, go to the Purchases and Procurement / Expense Request / Preparation of Expense Requests, in order to check and process any expense requests. The “Select Requests” filter allows you to select the open requests or the closed one or both.

Transition rules:

• 194. LCH=>FSC - Factura de cheltuieli din Raport de cheltuieli
• 195. LCH=>NSD - Nota de debit din Raport de cheltuieli

Related supplier

You can now assign a Related Supplier for an Expense; the field is available at the first page of the Expense form.

Service sets

Service sets are supported in Expert Version 4.0.6.1. To identify a Service as a Set, it is required to activate the new field (flag): Service Set, which is available on the first page of the Service form. When activated, another new field becomes available, that of the BOM where we select the BOM for the set, similarly to selecting the main BOM for a Set of Inventory Items. The BOMs of type: set can be defined in Tools and Configuration / Service – Expenses / Set. When using a Service Set in a document and a BOM exists for it, then BOM explosion is automatic in the document and the service-components are included in the document.

Expense Type & Service Type

The Expense and Service Management functionality has been enriched by adding two new fields, Expense Type and Service Type correspondingly.

Image 7: Expense Type

Image 8: Service Type

These two new fields make possible the efficient and accurate classification of Expenses and Services by linking them to types that indicate their utilization in Accounting.

Available options for
…expenses	…services
Various Expenses Payroll Third Party payments Power supply Telecommunications Rents Water supply Insurance Transportation	Travel Marketing Subscriptions Stationery Taxes Interests Other Personnel Expenses Other Third Party Expenses	Service Provision Rents Grants Interests Associated Revenues Investment Income Various Sales Revenues

The new fields have been added to the Service and Expense lists as grouping elements and as filtering criteria. The Accounting Category filter is excluded. Moreover, the already existing filters: Family, Group, and Category have been defined as Advanced Filters. Moreover, the following columns are available and can be added: Cost element Type, Allocation Profile, Business Unit, Activity, Dimension 1 & 2.

Note that

After the upgrade the registered expenses will updated automatically as regards the new Expense Type field. It is strongly recommended to check whether the automatic upgrade did update the expenses according to your particular specifications and requirements.

Image 9: Expense List

New Document Types

• The new document AES - Aviz de expeditie - Prestare Servicii is a UNION of DELIVERY NOTE WITHOUT CHARGE (stock items) and SERVICE PROVISION INVOICE. Customer is debited only services, whereas items are quantitatively updated, without pending values. Quantity is entered by hand is not suggested by the system. Value/price is inserted only to services.
• New document type: NCD - Nota de credit cu decontare (Cash) used for various credit expenses documents with simultaneously cash refund (not Notes). The creditor is not debited/credited and in Accounting only updates EXPENSES (negative) and CASH. It must be paid at all, because it does not monitor forecast outflows.

“Include sets” filter

The filter “Include Sets” provides the options: All, Yes, No and it is now available at Service Trial Balance, Service Registers and Service Sales Statistics.

Fixed Assets

New document types

• New document type: MNC - Nota de credit Mijloace Fixe. The new document type is used in order to make corrections to the values of Credit Notes issued by Suppliers. It affects the Acquisition Cost of fixed assets.

• New document type: FSCM - Factura de achizitie (pentru Mijloace de transport) used for several expenses related to transportation means. It is similar to the rest expense document types apart from expense lines’ layout which displays AND the TRANSPORTATION MEANS related to the expense. You may add this layout into the existing document types in order to avoid using it. IF you complete the transportation mean into expense line you will able to use the report “Expense per Vehicle” in fixed asset sub-system.
• New document type: TCM - Transfer contabil mijloc fix used for 1) a fixed asset quantity transfer from one Branch/Warehouse to another and the attribution of proportional value, at the same time 2) for a fixed asset acquisitions (total or partial value) transfer to ANOTHER FIXED ASSET, 3) for a fixed asset acquisition value separation in TWO PART , 4) for the fixed asset value transfer to another COST CENTER (horizontal dimension). The fixed asset that reversed must be entered to NORMAL lines, whereas the fixed assets that added must be entered to OPPOSITE lines. This could be done automatically by choosing the action “Fixed asset transfer” (Ctrl+M). Already depreciated fixed assets are covered as well as S/N analysis.
• New document type: CAC - Capitalizare stoc active used for quantity and cost transfer from warehouse to fixed assets (Stock asset capitalization). In the 1st page you insert the item or items that are credited (the cost of which is considered as definite) and in 2nd page fixed assets that are debited. If a journal is given then transaction is posted LINE items account credit and debit of fixed assets account.
• A new Document Type is now available: TMF - Transfer mijloc fix in stoc. This is intended to be used for transferring Fixed Assets (Quantity and Cost) to Stock. In the Fixed Asset line the default value is the TOTAL (net) ACQUISITION VALUE that corresponds to the selected quantity. In the Item line, it is required to fill-in the RELATED UNDEPRECIATED VALUE and to check the line account (to be debited). If the undepreciated value is equal to zero or the filled-in value is not equal to the reversed depreciations that will be created for the fixed asset, the header account (extraordinary profit) will be used, for the Accounting Document to remain in balance.
• A new Document Type is now available: CCH – Capitalizare cheltuieli. This is intended to be used for transferring expenses to fixed assets for depreciation. The expense is credited and a new depreciable acquisition is created to the apposite fixed asset. The values in the expense grid must be equal to those in the fixed asset grid.

Weight MU & Alternative MUs

The functionality to monitor fixed assets per Weight MUs is now available. Moreover, you may assign additional, alternative MUs. (administration tab of the fixed asset form). This enhancement can be used for the resolution of issues related to Intrastat and fixed asset transactions.

Image 10: Alternative Measurement Units for Fixed Assets

Reports & other improvements

• In order to check the fixed asset quantitative date, the new report “Details by position” in now available at: Finances / Fixed assets / Trial Balance. The report support grouping per WH.
• The new report: Fixed Asset Inactivation (Finances / Fixed assets / Information) provides an overview of the inactivated fixed assets.
• The grouping of the depreciation documents generated by the depreciation process has been modified, for the cases when the company parameter “Multiple debits and credits allowed in the same Accounting Document” value is “NO”. In such cases, depreciation documents are created per fixed asset Accounting Category.

Financial management

• The revoking of Calculated Inflows/Outflows can be now done by FIFO matching, based on due date. This mode is activated by setting the value of the new Company Parameter Consumption method of calculated inflows / outflows (Document administration) to 1. When 1 the revoking is by FIFO, based on due date. When 0 (default) the revoking is done proportionally for all pending payables and receivables.
• The Cash flow update process now takes into account the budget sheets of accounting type that include at least one of the following measures: Credit balance, Debit balance.

The functionality of the action: “Update settlement data” (Image 11) is now enhanced. The action is available at the following reports: Outstanding Receivables, Outstanding Payables, and Collection planning. Monitor and schedule collections (Collection planning): UD Tables (1 to 5), of the liquidity account transactions, have been included among the available columns. You may choose to include in the layout any of these and, then, through the action: “Update settlement data” you can update the liabilities or the claims with the changes you made on the view (option: “based on the column of the view that has the same name”) or to update the selected transactions with the same value (option: “same content in all selected”).

Image 11: Update settlement data

• A new report (scroller) that supports the effective monitoring of the calculated inflows is now available; the “Process Order Collection forecasts” report is available at: Financials / Receipts – Payments. This report allows you to modify the settlement data through the corresponding action (i.e. “Update settlement data”).

Image 12: Process Order Collection forecasts

• The functionality to analyze settlements of receivables/payables by item lines’ UD Texts and UD Tables is now available, additionally to Business Dimensions, is now available. The customization is done through the following two Company Parameters (in Document Administration):
  • Analysis method for settlements of amounts receivable by item line Business Dimension (comma separated list)
  • Analysis method for settlements of amounts payable by item line Business Dimension (comma separated list)
• The available options as Grouping Types of a Payment Method now also include the five UD tables of the Item Line.
• In order to protect users from mistakes, henceforth it is not allowed to insert negative values in liquidity account lines, notes and cheque lines & trade account documents that affect Account Matchings. This new rule is implemented through the Field Property Profile CheckNegativeValue that is automatically activated after the version upgrade for the related Document Types.
• The default dates in the filters that define the issued in period and the due date, in the reports related to Pay-out indicators (Pay-out indicators for Customers and Suppliers, Pay-out indicators per Salesperson, and Credit Behavior assessment) have changed in order to ensure that the default values are common in all of these reports. Specifically:
  • Issued on: default value ‘previous and current year’
  • Due on: default value ‘Anything’
• The new document type: “OPT - Ordin de plata” is now available. This is intended for PLANNING payment and easy "transition" to a normal payment receipt. It does not update cash inflows forecasts because they are produced by all customer trade documents.
• The new document type NIC - Nota de intrare receptie de la client is used for receiving notes from a customer / debtor. Credits trade account and updates inflow forecasts.

==
Accounting ==

Post to accounting - Review

A new dashboard that allows you to examine and review the accounting postings is available at: Finances/End of period processes/Postings. This dashboard combines the necessary information and data for an effective and efficient review of the accounting postings; specifically, the dashboard allows us to:

• Check directly possible sources of errors and issues
• Perform in-depth review of specific accounts, days or documents
• Correct any discrepancies or errors

A prerequisite is to activate the Company Parameter: “Activate justification table during accounting post” (Accounting sub-system). If activated, the dashboard can be used after the next posting to accounting.

Accounting Documents - Origin

By selecting this option, a Trial Balance-like report becomes available; this includes all accounting document that where generated by documents of all types, per type. Some records emerged by fixed assets, others by liquidity accounts, cheques etc. This view allows us to identify errors directly, e.g. if an amount appears to be unjustifiable posted to an account; e.g. if an account that refers to customers is updated by an inventory Item.

Image 13: Post to accounting - Review

The link “Full list” forwards the user to a view that displays the specific data in the classic, scroller format. This scroller may be adapted to the requirements of a specific implementation and, evidently, it provides the functionality for extended sorting and filtering, for exporting e.g. to excel, or any other scroller functionality. The dashboard object on the lower left dashboard zone, presents the accounting entries that updated the origin table, for the current account are displayed. To its right, the related documents are listed. The full list can be also used in order to examine the accounts where e.g. a Trade Account’s transactions were posted to; to achieve this you are advised to use the Trade Account filter.

The search control (up right) allows us to search for the data available in memory e.g. a customer’s name or a reasoning etc. By activating the flag “Daily check”, a slider becomes available: this slider presents all the distinct days displayed; by selecting one of them the data below are filtered accordingly.

Documents that have not been posted to accounting and Posting errors

These two subpages must not return any data if no related errors exist. The corresponding views are available as standalone scrollers; however, these have been integrated in this particular dashboard as essential steps of the review process.

Original entries to be checked

This page presents the accounting entries that were manually created (and not generated through postings) and, at the same time, refer to accounts that have been updated through postings. The search involves the last 12 months. In such cases, inconsistencies between the Accounting Subsystem and the other subsystems are inevitable. The accounts that are not updated through postings - i.e. accounts updated exclusively by manually created entries - are excluded by this list (these data are not considered to be erroneous). An example of erroneous data that will be identified through this process is the monitoring of some extraordinary expenses. These should be either registered exclusively through the Expense administration module (and then post the amounts to accounting) or they should be registered exclusively through manually created Accounting documents.

Accounting document templates

Accounting document templates now support the creation of entries per journal, if the period type is ‘Closing Period’ i.e. the template contains lines for reading accounting balances and a balancing line. In this case, many accounting documents will be created: one per journal of each participating account. If different journals per Branch (or any other business dimension) exist, then in order to ensure the accurate update of the accounting document lines as regards the business dimensions, the “preserve dimensions” multi-selector must be defined accordingly. In order to activate the functionality, it is required to activate the flag “Processing based on Journals to be replaced” on the “Apply accounting document templates” dialogue. The journals will be listed; in order to select all of them, use the button .

Note that…

In order to serve clarity, it is strongly recommended to assign a special Accounting Document Type for templates of this type, other that these used for the enumeration of branch entries (since the enumeration in the document code field will be common for all the documents of the template. The information about the branch per se exists on accounting entries and there is no need for it to be also evident in the enumeration, as it is required for invoices etc.

Various improvements

• Default values that correspond to the Product Locale specifications have been assigned to Company Parameters. These default values do not overwrite the customized parameter values displayed in bold.

• The call centers integration (CTI) functionality has been enhanced; now, when searching for phone numbers, those of the contacts are also taken into account.

• The identification process of e-mail addresses is now improved; now the e-mail defined on the relation is first considered and if this is undefined the Person’s e-mail is considered.

• In order to improve the administration of the Additional properties, you may now configure the order of appearance when selecting them or when editing them. This is achieved by utilizing the “Order by” field that is now available at the
  

“Property Options” list, in Customization / Organization Parametres / Properties.

• In the Salespersons’ Commission Profiles, the option “Pre-tax value” is now available as an alternative in the drop-down field “Value: Calculation based on. If this new option is selected then the base value is calculated as the difference of the Net Value minus the Charge value of the Item Line. This way, it is now possible to exclude the charge value that is included in the line through a special account that has been allocated to the Item Lines.
• The size of the Project fields Name, Alternative Name and Description is now increased.
• It is now feasible to create a shortcut for the Bulk allocation (Accounting) process.
• Five UD tables have been added to the following:
  • Trade Account Lines
  • Liquidity Account Lines
  • Cheque / Note Lines
  • Special Account Lines

In these new UD Tables, the system applies by default the values selected in the corresponding UD Tables of the Document Headers.

Note that…

The UD Tables of the transactions that will be generated from the above lines will contain the same values too.

• In Adjustment Documents, you can now paste lines from clipboard.

Entersoft framework

Security

• The Login process is now improved; after the user enters his/her password, the Companies and Branches are restricted to those where the user actually has access rights.
• A new login control mechanism is now by default activated that checks the number of repeated failed login attempts; if the user makes more than three failed attempts to login, then the User Account is deactivated. The application administrator can activate the user account again, simply by unchecking the “Inactive” flag on the User Account form.

Note that…

The above described restriction is not applied to administrators.

Form Designer

Context Dashboards

You can now add context dashboards in any dynamic form container. The container can be placed on a tab page or in an expander. The configuration of the context dashboard parameters is similal to the configuration of the context view parameters. This means that the dashboard designer may define more than one context parameters that receive their values from the form. The auto execute property is also available.

Lot entity form

The form of the Lot entity is now customizable.

Multiple grid layouts

You can place the same detail table more than once in a form by specifying a custom layout name for each grid. Moreover, you can define different filter conditions for the information rows presented by each grid. You can define default values for each column in the grid; these values will be applied on the data row during insertion. Each different grid layout can support different investigate specifications (shift+F3) for the same column, if the same column is to be used by different layouts.

Note that…

The default behavior is to strip the defined as default values from the layout upon saving it using the “Save Layout” functionality available on the grid’s toolbar. In order to preserve these default values it is required to manually save the .egl file (i.e. the layout file) by selecting the “Save Layout” functionality available on the grid’s right click menu, under the “Debug” menu entry.

Dashboard Designer

• A new “group by” with cube function is provided by the dataset in memory functions.
  • You can use this function to calculate all the possible combinations of the group by dimensions and the calculated measures.
  • Moreover, you can define attributes per grouped dimension.
  • You can use these attributes to sort or to present data in a dashboard object.
  • The functions of conditional ranking and sharing has been enhanced to support the new group by cube mode
• A new function is provided for creating a new data table column with a value of the previous row.
  • Therefore by using this function you can easily perform in memory operations related with growth key figures or changing rate figures (moving figures) or figures that represent ratios.
  • The previous value can be created based on a single dimension value or a group of dimension values. It is important to ensure that the data table is sorted in order to add the in memory column based on a previous row value.
• A new copy function is provided for Entersoft queries and in memory data tables as well.
  • The copy function copies also the in memory calculated columns.
• A new filter selector is provided that can be used to filter data in an interactive page or navigate through different dashboard objects.
  • This selector supports two presentation controls: Drop down and Radio button.
  • The selector supports two different modes of operation. This operation is related with the list of values that are listed by the selector and the type of filtering that is executed by the selector.
    • List of values by an attached dashboard data table with one filter command expression.
    • A custom list of values with one filter expression or multiple filter expressions – one per custom value. This kind of selector can be placed in a dashboard horizontally or vertically.

The selector also provides a configurable parameter for the state of the selected value. This feature can be used when the selector is filtered by another selector.

• A new in memory Top n/ Bottom n function can be applied per dashboard item.
• A new in-memory Reverse function has been added for the attached table of a dashboard object. This feature allows you to reverse the data rows that will be presented by the object.
• A new in-memory sorting function can be applied to a dashboard object (grids, charts and geo maps). This feature is useful when the data table attached to the dashboard object is cubed. This way, when you combine Top n or Bottom n with sorting you can perform advanced in memory top / bottom in-memory analysis, filtered by different dashboard objects.

These advanced features are also available in the dashboard dataset designer for ranking and top n/bottom n actions on cube dimensions, attributes and measures as a post operation of the cubed data table.

• Dashboard commands: You can design and develop commands using as source objects the items of a dashboard page. Using the built in expression editor, you can define dashboard command invocations for the controls that you used on your canvas. A command invoke can be configured to be executed for the selected records or for all records displayed by the dashboard object.
• Top N function: Α new top N function is provided to perform top or bottom interactive analysis. This function can be used for in-memory or query filtering expression.
• Slider: A new slider control is provided that can be used to filter data in an interactive page. The slider supports three different modes of operation. The operation mode depends on the range of values and the type of filtering executed by the slider:
  • List of values provided by an attached data table with one filter command expression;
  • The minimum, maximum value and the step (ticks) of the slider provided by an attached table with one data row; alternatively min, max and tick values may be explicitely defined by the dashboard developer;
  • A custom list of values with one filter expression or multiple filter expressions – one per custom value.

The slider can be defined as a single value selector (<=,>=, =) or as range of values filter selector and Ιt can be placed on a dashboard horizontally or vertically.

Moreover, a play feature, that resembles a movie, has been added to the slider filter control. You can configure this feature through the ‘advanced’ tab (slider’s property dialogue). The reproduction speed can also be defined. The play feature applies the filter sequentially, based on the ticks calculated by the slider during runtime or the fixed ticks configured by the designer. During the runtime, the user may start/pause or move the slider to a previous or a subsequent tick value.

Image 14: A slider with the "play" feature

• Gauge component: You can connect a gauge object to a pre-defined key figure scale in order to calculate dynamically the performance limits (good, medium, bad). Hence, by changing the scale, the performance limits are redefined without editing the dashboard objects that use it.

The gauge object can display up to three values. E.g. a gauge can now display the Gross Profit (%) for the current year, of the previous year (for comparisons) and the projected Gross Profit (%) target value.

PDF Version