RO | EN

New functionalities

Discounts and offers - a quick, on-document approach

A new configuration and application subsystem has been added for offers and discounts in documents. The main elements that differentiate the new subsystem from the rest of the discount customization features in EBS are the following:

• • The configuration of the promotions is done through a new and easy-to-operate environment, without complex configuration.

  • The way of registering documents has changed significantly, as promotions are now selected, configured and introduced instead of items, to which any active discounts will be applied. As a result, it is easier to apply discounts and guide the user in selecting the best available promotion.

  • Percentage and value discounts are supported.

  • Promotions relating to individual items or item combinations are supported.

  • In a simple and understandable way, promotion targets and rewards are defined.

  • With easy configuration, you can customize scales for the target and rewards.

PROMOTION CONFIGURATION

The promotion configuration screen is available from (Configuration and Tools menu) Configuration... > Invoicing policy > Discounts and offers.

• Validity period - Optionally, you can set the time period for which the user can choose to apply the promotion in the document.

• Comment - You can enter a text that describes the terms and benefits of the promotion. The text will appear when selecting the promotion, to make it easier for the user to configure it.

• Display - Select some images that could be used to enrich the display of the promotion.

• Target field - Select the field of the document’s item line involved in the calculation of the target achievement.
  For example, if the “Line quantity” field is selected, then, in order to calculate whether the target was reached, the content of the “Quantity” field of the item line (or item lines) is summed up and compared to the target.

• Target - Please enter a number that is the target of the promotion.
  For example, in a promotion that requires at least 3 items to be purchased, the target is 3.

• Reward field - In this field the user enters the discount percentage or value of the discount, when the target is reached.

• Reward - A number that indicates the percentage or discount value received after reaching the target.
  Instead of the above target and reward fields, a target and reward scale can be used. The scale can be common for all promotion items, so it will be filled-in at the top of the screen. It can also differ by item, so it can be filled-in below each promotion item, by choosing the next level.

• Discount type - Select the discount type to be entered in the “Discount analysis” table, in the document line.

  • When the target and reward fields are entered per item, then this means that the promotion is assessed separately for each item participating in the it, for the target completed in each item and also with a reward that has been entered in each item.

  • On the contrary, if the target and reward are entered in the upper area of the “Reward data” screen, then the promotion’s target is calculated for any combination of items that participate in the promotion.

DOCUMENT REGISTRATION

Using promotions when registering documents requires that the document registration screen be configured properly, so that you can display the application and processing actions of promotions, as well as the display and selection screens.

• When you enter an item in the document and select it, grid number 1 shows all available item promotions. This grid can be found in the available fields of the form called “Item - Available promotions”.

• With action A, you can display the selected grid 1 offer to edit and then insert it into the document. You will find the action in the available actions of the form as "Apply selected promotions - Item".

• Grid number 2 displays all available promotions for the selected customer of the document. This grid can be found in the available fields of the form called “Available promotions”.

• With action B, you can display the selected on the grid 2 promotion to edit and then insert it into the document. You will find the action in the available actions of the form as "Apply selected promotions".

The promotion processing screen displayed by the above actions is customized depending on whether the promotion has been configured with a target and reward related to each item separately or reward and target related to any item combination.

TARGET AND REWARD IN THE HEADER (ITEM COMBINATION)

For example, the promotion can states that at least 3 pieces of any promotional item must be purchased to apply 50% to all items.

At the top of the screen, you will see items for your target, reward and coverage during the fill in of the document. Additionally, there’s a field marked “Successful/failed”, regarding the promotion coverage up to that point based on the entries.

On this screen, the quantities must be entered on the left grid. The right-hand grid helps better control the promotion when a scale has been declared in these promotions. The scale can be displayed by selecting the "In total" tab, to view the scale limits.

TARGET AND RETURN BY ITEM

For this example, the target and reward differ by item. Here, the right grid displays, the target and reward by item. The quantity entries for items are also made here, on the left grid.

CONFIGURATION

In order to enable the use of such promotions in a document type, it is enough to select in the document type the new field "Enable promotion selection", which you will find on the "Behavior" page of the document type.

Additionally, the screens need to be configured by adding the actions and grids as mentioned above.

Alternative independence - on Warehouses inventory valuation

With the addition of the concept of Alternative independence concerning valuation, the user is given the opportunity to choose a different independence for as many warehouses as they wish. Up until now, the independent branch that the warehouse belonged to could only be identified with the branch to which it was declared to belong. Optionally, you can now set for each WH the independent branch to which it belongs by selecting the independent branch in the new Alternative independence, which has been added to the address details of the company.

• As an alternative independence, the user can select only a branch that has the Independent field selected.

• The Alternative independence can only be selected in addresses that are declared as WH.

• The monitoring of alternative independence  places requires the filling-in the Independent field in at least one branch.

• Branches selected as Alternative independence may in turn belong to another branch selected in the Branch field.
  These branches, to which the alternative independence belongs, play the role of Main independences.

PURPOSE

The result of activating the use of Alternative independences, is that the valuation will calculate results for each Alternative independence separately, by "charging" the movements of the involved warehouse, not to the "main independence” anymore, but in the alternative independence to which each warehouse belongs. 

In practice, with the appropriate configuration of Alternative independences, the user could even achieve the calculation of valuation results per warehouse.

IMPORTANT

• • Activating alternative independences deprives the installation of obtaining valuation results in what until recently was called “main independences”, as the movements are now perceived as movements of alternative independences and not of the Main independence.

  • The various points in the differentiation of the application mode using alternative independence will be activated only if the relevant customization for alternative independence has been applied.

  • When registering item lines in documents, when using warehouse with an alternative independence, then the line and therefore the movement branch will be populated with what has been selected in the Alternative independence field.

  • In trade documents, if an alternative independence is activated, the registration of a branch in the item line, which is different from that of the heading, is allowed.

RESULTS

The above configuration produces valuation results per (alternative) independence, which you can display in the balances and tabs, as usual. The official stock price is also calculated per alternative independence. Therefore, it is not possible to get a price in the "Main independence", as the movements are not registered in it but in alternative independences. However, the results can be obtained in the main independence (except for the official price), using the Branch type special parameter that has been added to all stock balances and accounting balances.

Results can be viewed based on:

• • Movement branch.

  • Reference branch, that is, the “main autonomy”.

Depending on the selection, the results are grouped and displayed at the appropriate concentration level.

A new SGR (Warranty-Return System for recyclable packaging) implementation procedure

Addressing the specific requirements for SGR (Warranty-Return System for recyclable packaging) implementation is possible through the EBS functionality regarding special accounts, having the following advantages:

• • They can be set as a surcharge, meaning they will be added to the value of the document.

  • They can be linked to specific articles/ documents. This means that for documents that include both warranty and non-warranty items, the warranty amount will only be added where applicable.

  • They do not appear in Sales/Turnover Analysis reports, nor do they affect the cost of products.

The implementation will be done on demand, in two steps:

1. Creating specific documents (by copying some already existing ones)

2. Adjusting custom features where applicable:

a. Printing invoices/tax receipts,

b. Interface for Retail,

c. Integration of external systems (EDI).

Requested enhancements

Implement a complete financial leasing flow

This newly added functionality allow to monitor the full flow of financial leasing process:

• Monitor each leasing contract;

• Monitor the monthly amounts to be paid;

• Register the monthly invoice for interest;

• Reevaluate the balance of each contract;

• Reports per leasing contracts.

The functionality offers:

1. A relation between a Generic Item and a trade account via Alternative code.

2. A new document type (with new attribute - LEASING) for the contract leasing - RO.FAM,
   with the following document parameters:

• First month,

• Number of installments,

• Value in EUR,

• Exchange rate,

• Generic Item.

3. A new automation for RO.FAM to generate the installment lines.
   The automation will add in the document as many lines as the number of installments parameter shows.

4. A new document type for updating the 167 account balance - RO.SND. 

5. A new document type for monthly invoice of installments/ interest/ advance - RO.FSC.

6. A new scroller to show all monthly installments.

7. A new automation to create installment invoices.

8. A new scroller to show all monthly installments invoices.

9. A new automation to update the creditor balance.

Will have a new menu entry:

•  (Main menu) Accounting > Fixed Assets > Leasing with the following sub-entries:

  • Contracts List,

  • Generate monthly installments invoices,

  • Update contracts balance.

Analytical Trial Balance with multiple equalities

This new trial balance can be found in (Main menu) Accounting > Accounting reports > Analytical Trial Balance with multiple equalities.

This trial balance allow to display the following equalities (column pairs for debitor respectively creditor values):

1. Beginning of the year balance

2. Previous turnover

3. Previous total sums (1+2 on D&C)

4. Beginning of the period balance (for 3)

5. Current turnover

6. Cumulative turnover (2+5 on D&C)

7. Total sums (1+6 on D&C)

8. Final balance (for 7).

The trial balance has a default group by class accounts with its subtotals. Also, in the default view of the scroller there are some hidden columns like International code, Alternative code, or Synthetic (summary) account that can be used if needed.

The first equality - Beginning of the year balance - it will no longer depend on the closing of the previous year. Please remember that the closing of the previous fiscal years remains a must for performance reasons.

Because this report is based on a scroller, the users have the option (by hiding columns) to create multiple layouts, so they will have a trial balance with their usual equalities.

By using the Preview functionality this layout of the trial balance can be exported and/or printed.

Add New Trade Nature for Intrastat statement

A new Nature of transaction code - 34 - was added, for transactions that imply property transfer without financial compensations. The xml generation procedure for the Intrastat statement was updated in accordance.

Automatically apply VAT type on documents

This feature allows the automatic fill of the Tabe5 field - a name assigned to codify several different possible VAT types that can occur for the sales and acquisition documents based on certain conditions.

Conditions that affect the VAT Type values are: 

• The nature of the transaction - goods or services (based on the articles categories: Services, Stock Items, Fixed assets).

• If the articles are with reverse taxation (Table10).

• The delivery address (based on Eurostat codes).

• The VAT Status of the document and of the trade partner. This VAT Status can be:

  • Normal - coded as 0,

  • Special - 1,

  • Intra-community (EU) - 2,

  • International (outside EU) - 3, 

  • Exempt - 4.

This field of the commercial documents is used to properly place documents in the VAT Sales and Acquisitions Journals, and of course are affecting the proper fill of the D394 and D300 fiscal statements.

After a first automatic fill of the Table5 field (VAT Type code) - based on this complex assignment logic,
the user has the possibility to manually adjust the VAT Code of the document if considered necessary.

Some typical cases for this automatic VAT Type code assignment:

• In case of Sales documents:

  • If the document has VAT Status = 3 (international, outside EU), the value of Table5 is 3.

  • If the document is with VAT Status  = 2 (intra-community, EU), and the items are services,
    Table5 = 7.

  • If the document is with VAT Status = 2 (intra-community, EU), and the items are goods,
    Table5 = 6.

  • If the document is with VAT Status = 0 or 4 (normal, or exempt), and the items are goods with value <= 22,500 lei, Table5 = NULL (cleared).

  • If the document is with VAT Status = 0 or 4 (normal, or exempt), and the items are goods with value > 22,500 lei, the Table5 = 9.

• In case of Acquisition documents:

  • If the document is with VAT Status = 2 (intra-community, EU), Tabe5 = 0 (reverse taxation);
    In the case of a service that was delivered in a country outside the EU, such a document will require that the user will manually set Table5 = 4.

  • If the document is with VAT Status = 3 (outside EU) and the items are goods delivered to an EU country (the delivery address has Eurostat code), Table5 = 1; but for services the Table5 will be manually filled. If there are exceptions from these conditions the Table5 will be cleared (null value).

  • For articles of reverse taxation (Table10 not null), if the trade partner has a VAT Status = 0 (Normal), the Table5 = 2 and the document’s VAT Status will automatically be changed to 4 (Exempt); otherwise, if the  trade partner has a VAT Status = 4 (Exempt) the Table5 = 3.
    
    

Create a log process for the API calls of the UPS courier integration

We now can generate a log entry for each API call regarding the UPS courier integration, similar to the log already created for TNT.
In the ESNoSync folder a new folder ESUPS  must be created, containing an empty text file named ESUPSRequest.trigger which if present will validate the logging process.

Secure API calls via https on GLS courier integration

Based on recent changes in the GLS courier API, the API calls must be done with a secure https protocol.

Non-deductible depreciation in the case of Fixed Assets with a rate value higher than 1,500 lei

A new functionality was added regarding the special case of depreciation for passenger cars which are not entirely deductible. For values of the monthly depreciation rate that exceed 1,500 lei, the rest of the rate is considered non-deductible. To meet this criteria two new parameters were introduced:

(Configuration and Tools menu) Configuration > General > Company parameters in the Fixed assets subsystem:

1. Non-deductibility limit value fixed assets - set to 1,500 (lei, editable)

2. Non-deductible depreciation expense account - set to the accounting code for non-deductible expenses - such as 6811.02.

Furthermore, a new report will list these fixed assets that meet this criteria:

(Main menu) Accounting > Fixed assets > Non-deductible Fixed Assets. 

Based on this report we can calculate the non-deductible depreciation.

Sameday courier integration

From this version the Sameday courier is also available for deliveries/shipments. This is found in the menu: (Configuration and Tools menu) Configuration... > Transaction parameters > Transporters. The additional data for this can be viewed and filled in from the (Main menu) Sales > Trade accounts > Transporters.
The account(s) opened with this courier will be entered to (Configuration and Tools menu) System integration > Sameday - Connection Settings..., where the accounts created with the credentials and API access data received when the contract with this courier is signed.

When creating a sales document (e.g., a delivery note -  AEV) in the second tab - Miscellaneous info - you will find the Transporter field. You can now select this courier as your transporter. After you save this document, in the Automations menu, find the Create shipment command. Fill in the shipping details for the courier and at the end you will have a voucher (AWB) attached to this courier delivery order. For a document with a delivery attached, in the Automations menu, you will find the following commands: Print shipment voucher, Update shipment status, Cancel shipment and View shipment. All of this can be applied to each of the deliveries listed in the scroller accessible in (Main menu) Sales | Order Routing/Invoicing | Courier shipment management.

Various smaller improvements

• • It is now possible to select a Service code immediately in documents, through the new SERVICE_ADD_REQUEST general action, in the action panel. In the action configuration the user selects the service code, which will be automatically entered in the document by pressing the button.
    
    

  • ESKiosk | It is now possible to display the keyboard in action "Edit Quantity” (GC_DOC_EDIT_QUANTITY).
    
    

  • ESRetail | Is is now possible to activate the keyboard on the key on save input screen.
    
    

  • The display time of the results for view "Not counted items (with and without dimensions)” has been improved.
    
    

  • In “Set ... Privileges”, of the Financial administration actions, the “Create new customer from document” privilege has been added.
    
    

  • In commercial agreements, at the Scale criteria of Group values, the total number of characters for selected values was increased from 2,000 to 4,000.
    
    

  • It is now possible, when the budget cash flow entries are created, to update the cash flow entry in the document line with the company dimensions that have been declared as dimensions in the sheet type, and have been entered in the budget entry.
    This should be done by selecting the user at the time the calculation runs.

    • In the calculation screen, the "Inventory Items - detailed presentation" the option "Detailed company dimensions analysis" was added. It becomes available for selection by using default value NO, when budget sheets that monitor company dimensions are.

    • If the YES value is selected, then budget entries are grouped, taking into account the company dimensions entered, and the company dimension information is transferred to the item line to be created. This option is activated in conjunction with the "Maintaining open amounts" field.

Fixes

Relevant cases: PS-77455, PS-81503, INT_SUP-141854, PS-92188, PS-92241, INT_SUP-155627, PS-86553, PS-91733, PS-88970, INT_SUP-153794, PS-92854, PS-93215, PS-92857, PS-71702 (#1080701)

Automations

• Fixed an error that would occur when running the "Update address coordinates" and "Update distance" automations, in view Sales > Activities > Calendar administration > Update business address distance.

Shortcuts

• The “Save group to file” option will no longer be active by right-clicking a simple shortcut and will only be active by right-clicking on a Group.

Login

• Upon login, it is now possible to sort servers by code or description (an option that also existed in the series 4).

Collaboration Chat

• Fixed a problem in chats, where sending a snapshot and excel file would display an error message. The message would only display if the recipient user had the dot symbol in their password.

General functions 

• Fixed the erroneous image in the list of backups, where next to the size of the base the symbol of the Euro would appear.

Configuration 

• Fixed a problem that would occur when deleting the last entry of a zoom table.

Menu 

• Addressed a problem that would occur when changing the user menu, where the changes would not save.

Olap 

• Applied corrections to make the previously selected folder into the default folder in OLAP data recall instead of folder ESCubes/ CSCubes.

Views 

• Fixed an error that would occur after creating a drill down level in a view.

•  Fixed an error that would occur when copying lines to a scroller level.

• Fixed an issue in the value selection from criterion to view. With the problem that existed, when the price came from a criterion investigated (e.g. customer code), if the investigation would repeat, the price would not be transferred as the criterion value.

Reminders

•  Fixed an issue where "expired" reminders set to tasks would not display in red.

• Addressed a problem in playing the audio set for reminders.

Miscellaneous (RO)

• Fix the missing simple print form report on the supplier's account register.