EXP-RO01-4.4.6.3
Entersoft Expert®
New Features & Functionality
Περιεχόμενα
Summary
To begin with, a brief description of major extensions in this version is provided, and afterwards, new functionalities & improvements are thoroughly presented along with the necessary user guidelines and examples.
Entersoft ERP
- Hierarchical allocation profiles in Budget
- Loan accounts management
- Documents for inventory value impairment at the Fiscal Year end
- Combined Nomenclature (CN8) of 2018
Entersoft ERP
Inventory
Reports
The new feature of result grouping based on the Item accounting category has been added to the following trial balance reports (BIT):
- Inventory > Trial Balances > Inventory Costing Balance (simple format)
- Inventory > Trial Balances > Inventory Costing Balance (summary format)
- Inventory > Trial Balances > Inventory Costing Balance (detailed format)
- Inventory > Trial Balances > Opening Inventory Report
Lot management
New four calculated fields have been added to the lot data:
- Quantity in supplementary Ποσότητα σε συμπληρωματική ΜΜ
- Supplementary MU
- Quantity in EDU MU
- Excise Duty Unit
They are calculated based on the ΜΜ supplementary MU and the Excise Duty Unit that have been previously defined in the lot specific tariff and if these units are defined in the item. They display the quantity expressed in supplementary MU and in Exsice Duty Unit.
Intrastat codes
The Combined Nomenclature (CN8) of 2018 is available. From the menu option Update intrastat codes you may update the intrastat codes based on the current list of INS. The process will insert the new entries and update the existing codes, if need.
In addition, is highlighted that the process will create the missing measurement units which are associated to the Intrastat codes, using the proposed MU value as code, description & alternative code. It is suggested to visit the measurement units afterwards processing.
Budget
Hierarchical allocation profiles
The feature for budget amount modification based on % allocation has been added to the dimensions. Specifically, through the new tool Allocation to dimensions, budget allocation profile can be created and be applied to.
In the new allocation profile a type must be selected to make the corresponding budget dimensions available.
Each profile supports up to 5 levels, but in the budget sheet, as explained below, multiple profiles can be used to structure the entire hierarchy created for any level.
For each one of these 5 levels of a profile, the dimension that each level represents must be selected, as well as the available values of that dimension.
The total amount 100% should be filled out, in each level 
.
A profile can be used to allocate the amount of any budget entry (one or more), provided that the dimensions of the levels are NOT FILLED OUT.
![C:\Users\smp\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.IE5\VMTLPJOB\MCj04421410000[1].png](/wiki/%CE%91%CF%81%CF%87%CE%B5%CE%AF%CE%BF:EXP-RO01-4.4.6.3-image3.png){kind=small}
|
Examples |
|---|---|
| |
|
In the budget sheet, after selecting the lines towards allocation through the tool from the toolbar, select Allocation to dimensions (Alt-F6):
A dialog box with the following parameters is shown:
Allocation profile
Amount to be allocated (fiscal period amount, total amount)
Calendarization profile (if total amount is selected, the way that the allocation will be applied to periods can be selected -> a. initial line - profile – i.e. the line to be allocated b. dimension profile – in the case that calendarization profiles have been established for families, item category, business units, branches and so on and c. equal allocation)
Applying the profile causes replacement of the selected lines by new lines with the same total amount but with dimensions and the appropriate proportion of the amount defined by the profile.
In order to make clear how this replacement is performed, let us suppose that on a sheet with Item categories, Salesperson and Business unit, we fill out in one line, the item category A with the amount of 10.000 and we want to allocate it according to the following percentages and dimensions, which in hierarchical view would give the following amounts listed:
| Item category | Amount | Salesperson | Business unit | ||||
| Dimension - Value | % | Amount | Dimension - Value | % | Amount | ||
| Α | 10.000,00 | ||||||
| S1 | 30 | 3.000,00 | |||||
| BU1 | 60 | 1.800,00 | |||||
| BU2 | 40 | 1.200,00 | |||||
| S2 | 70 | 7.000,00 | |||||
| BU1 | 30 | 2.100,00 | |||||
| BU2 | 50 | 3.500,00 | |||||
| BU3 | 20 | 1.400,00 |
| Item category | Salesperson | Business unit | Amount |
| A | S1 | BU1 | 1.800,00 |
| A | S1 | BU2 | 1.200,00 |
| A | S2 | BU1 | 2.100,00 |
| A | S2 | BU2 | 3.500,00 |
| A | S2 | BU3 | 1.400,00 |
The one line to be allocated, will be replaced by the following lines:
The new lines are shown (temporarily, until the sheet is saved) with differentiated font, in order to be understood that they have been created from allocation.
In the example above, the lines with business unit = Services and empty activity could have been selected. So, the allocation could have been applied to activity.
It could also have a sales budget sheet and some additional dimensions, e.g., family, customer table 1, etc. and select all the above lines, applying allocation based on a single allocation to these additional dimensions.
In this way, with sequential allocations of an initial amount, a complete budget sheet could have been created, without typing.
The feature of grouping cube financial data based on the fields of business dimensions has been added to the budget sheet type in which a business dimension has set as dimension in the budget sheet.
Budget of expenses by salesperson
- The feature of selecting salesperson dimension has been added to Purchases budget sheets.
Documents
Improvements in documents
The columns Base and Alternative Measurement unit have been added to the dialog box shown when searching for items in the documents.
Apply price lists
When applying price lists, the due date that may have been added to the price list lines (with the same start date), is checked using the same methodology as in the start date, so the lines with the closest (date of document) due date are selected. This functionality facilitates the customization of the short period of sales, through these price lists.
User privilege profile
The official report check is ALSO ignored in restrictions exceeded, when the user privilege profile is applied. For instance, if the change of a document is forbidden to regular users due to the official report check, users who have the right to overcome restrictions (in a given category of data, in specific fields), hereafter, are allowed.
Financials
VAT Regime
In the VAT Regime field (trade account, documents etc.), the following terminology change of the available values has been done:
| Previous term | New term | |
|---|---|---|
|
|
Loan account management
The functionality of Available Liquidity accounts has been extended. Hence, those that represent loans can be bound to a (loan) Contract. Their entries can be merged based on the Contract (even when they do not concern the same register e.g. interest, expenses), for better balance overview and Cash flow forecasting.
- Related contract has been added to the Bank accounts
In the contract, Bank account entries bound to it are depicted through a dashboard with cumulative balance. Expected to be one, i.e. for each loan contract a separate bank account should be opened (52).
The Contract as a grouping field has been added to Trial Balances, Liquidity Account Registers and Cash flow.
|
|
|---|---|
| In terms of development, future withdrawals can be calculated to pay the loan and forecasts (to update the cash flow) and to calculate interest with an automation on the dashboard, using any rule and any field of the Contract for this purpose. Finally, any document related to the loan (e.g. Expense Invoice) may be completed by the Users in the Contract header so that the whole picture can be formed. |
Payments to customers
The feature of using liquidity accounts referring to credit card has been added to the DPC- Dispozitie de plata numerar catre client document type. This is the case of returning to the customer part or total value of a previous transaction made by credit card.
To use this feature, the DPC document type must be inserted from the product customization files.
Foreign currency
- The alternative document column has been added to Trade account registers by currency.
- The feature exchange rate BY ITEM LINE management has been added to Trade documents that are related to types WITH NO update profile. It could be used in Quotations, for example, if prices (pricelists) exist for some items in foreign currency (i.e. $), while prices (pricelists) for other items in another currency (i.e. €) and we wish to include all these items in the same Quotation. By displaying the Exchange rate column in the lines grid change of this column is allowed (by the user and by any system assignment mechanism), under the above condition (absence of update profile), else, the price of the column is always equated with the header Exchange rate. In this way, a consolidated quotation is created and its amount in base currency is calculated in the desired way.
If this feature is needed, then in development level the transition to the next step must be properly implemented and the exchange rate cannot differ. So, a special transition rule should be developed, which will copy the values in base currency or another method in order to avoid transfer to the produced document (which will, hence, update the various modules) prices/values in multiple currencies (because they will be converted into the base currency ate the one and only heard exchange rate !!!).
Accounts receivable – Balance justification
The Alternative document and Alternative document date columns have been added to Accounts payable – Balance justification reports (menu: Financials/Accounts receivable and context).
Closing period processes
Fiscal Year closing
The messages displayed during the fiscal year closing process have been improved. The warning and error messages display detailed information about the potential problems in order to find and solve them easier.
Sales rebate claim
In the following document types of discount credit notes forecast to customers (due to trade agreement)
- CSR - Sales Rebate Claim
- RRC - Reversal of Sales Rebate Claims
used for Actual rebates processes, hence, in addition to updating forecasts in trade account Periodics, the trial balance and the register of items will be updated by their values.
Calendar week management
Hereafter, the processes that manage the concept of week in Database queries (such as the selected date range, i.e. “current week”, “previous week”, etc.) use the statement First day of the week of the company’s season calendar (the season calendar in force is defined in company parameter) and only in case that it has not been defined, Monday is defined as first day of the week.
This extension allows managing the calendar week in multi-company / multi-lingual environments. For instance, a company located in Greece defines as week “Monday - Sunday”, while companies located in other countries define as week “Sunday - Saturday”.
More
In Data interchange functionality
The feature of setting EMI Run condition with values
Always
Never
If data exist. In this case, the files to be used by EMI must be added (; separated, if more than one). The EMI will run, if at least one of the files exist and contain data.
The new data type ES_LOG_LEVEL has been added. If its value is Error, then only errors will be stored. If its value is Warning, then errors and warnings will be stored, else, all messages will be stored.
- Hereinafter, the code of each entity that is copied, in a case that has format code and this does NOT include auto-counter, during new by copy.
- The criterion Customer country has been added to the following dashboards:
- Current sales insights (in Turnover analysis by Customer Category section)
- Analysis by customer category (as option of the Grouping criterion)
- Top performance (Turnover) / 2 year comparison (as an option of the two Grouping criteria)
- User menu management
The method of saving information about menu has changed. Hereafter, this type of information is saved in the new table User Menu (ESGOUserMenu) instead of the field MenuFile of the user data, as it used to happen. With this change, it is now possible to assign different user menus for each different Entersoft product.
The version upgrade will proceed with the necessary updates to the new table so that no further action is required for the smooth operation of the application.
