ERP-RO01-5.3.0.0

Από

Entersoft Business Suite®

New features and extensions

Contents

[[#contents|Contents 2]]

[[#brief-description-of-contents|Brief description of contents 3]]

[[#invoicing-and-financial-administration|Invoicing and Financial administration 3]]

[[#horizontal-functionality|Horizontal functionality 3]]

[[#invoicing-and-financial-administration-1|1. Invoicing and Financial administration 4]]

[[#ro-e-transport|1.1 RO e-Transport 4]]

[[#one-stop-shop---oss|1.2 One stop shop - OSS 5]]

[[#integration-with-courier-gls|1.3 Integration with Courier GLS 8]]

[[#miscellaneous|1.4 Miscellaneous 10]]

[[#retail-club-cards|Retail – Club cards 10]]

[[#item-dimensions|Item dimensions 10]]

[[#horizontal-functionality-1|2. Horizontal functionality 12]]

[[#login-screen|2.1 Login screen 12]]

[[#about-the-application-screen|2.2 “About the application" screen 13]]

[[#olap-changes-improvements|2.3 OLAP | Changes & Improvements 15]]

[[#mass-showhide-dimensions|Mass show/hide dimensions 15]]

[[#negative-amounts-in-red-when-exporting-to-excel|Negative amounts in red when exporting to Excel 16]]

[[#display-layout-title-when-exporting-to-excel|Display Layout title when exporting to Excel 16]]

[[#emphasize-on-data-when-exporting-to-excel|Emphasize on data when exporting to Excel 16]]


Brief description of contents

Invoicing and Financial administration

  • E-transport support
  • Support for cross-border e-commerce sales integrated into the OSS system

Horizontal functionality

  • Rebuilt "About the application" screen

  • Olap Changes & Improvements

Next up, the new functionalities & improvements catalog is broken down per category, along with use instructions & examples.

Invoicing and Financial administration

RO e-Transport

This version supported the integration with ANAF's new e-transport service, which will be activated from October 2022. According to the provisions of the decision, for all road freight transport, which is transported in vehicles transporting high-tax risk goods, ANAF must be informed electronically of all the details of the transport.

The e-transport must be informed with the shipment details before the start of the transport of the goods and accompany the goods throughout their course in the Romanian transport network. The above obligation is also applicable on purchases from abroad, for which the buyer in Romania is responsible for informing e-Transport.

e-Transport Management

In EBS, the information to e-transport is not sent automatically, but users decide for which accompanying documents of the shipment they will inform ANAF.

All the «candidate» documents are reported in a new list named “e-Transport system management” (menu: Inventory). It shows all the documents that are configured to participate in the e-Transport system, in order to select them and obtain a new unique transport ID (UIT) from the e-Transport system.

ERP-RO01-5.3.0.0-image2.png

After selecting the documents for which you want to create shipments, select the “Create e-Transport” action to receive a unique shipping number for each selected document separately. After successfully update e-Transport, the new (document) field «Unique Transport ID» will be updated with the UIT returned from e-Transport for the document and the transmission status will turn to «Success».

For those documents where the e-Transport update fails, it is possible to display only these documents in the list by selecting the failure option in the "Transmission status" parameter. Then you can see the errors in detail by selecting the fields with the relevant marking that are activated next to each document with a shipping problem.

Configuration

  • For those document types that you want to participate in e-Transport, you must select the attribute ACTIVATE_ETRANSPORT.

  • Keep in mind that as long as the e-Transport system is about shipments an road transports, there is some information that is necessary to be completed in every shipment document, no matter the kind of transport. These are:

    • All the address fields of the Company sites

    • All the address fields of the customers and suppliers sites

    • All transporters address fields

    • All conveyance means and driver data

    • Tariff codes for the items.

  • In addition to the above fields the next more important field in the document, is the Shipping purpose. All e-transport document should have this selected according to the Shipping purposes zoom table, which we have updated with all necessary values needed for e-Transport. In the same table a new field “Value” has been added and contains the actual value that will be sent to ANAF. After the upgrade, value and code fields contain the same value. If you already use Shipping purposes table in your documents, you must  update your existing table records with the appropriate official content in the “value” field.

  • A new zoom table “Accompanying document type” has been added in order to select the proper value for the corresponding information required from e-Transport. The table contains the following values and can be found under Configuration/Documents and Series/ Shipment accompanying item - Type: CMR, Factura, Aviz de însoțire a mărfii , Altele

  • In document type select the appropriate type, selecting a value from the above table in the new filed field Shipment accompanying items type shown below:

    ERP-RO01-5.3.0.0-image3.png

  • In the four new company params shown below, select document header’s udf fields that will be used to enter the information described. Especially for the latter two parameters, the configuration step is only necessary if you are importing or exporting goods from outside the EU.

ERP-RO01-5.3.0.0-image4.png

One stop shop - OSS

The OSS of intra-community B2C distance sales was monitored. It concerns the taxable persons (salespersons) based on an member state and carrying out intra-community distance sales of goods and/or services to non-taxable persons in other member states. When the total amount of such transactions exceeds EUR 10.000 per year, these taxable persons must apply the VAT of the member state of consumption and register themselves in the OSS special VAT scheme.

OSS transaction status

In order to monitor and control OSS transactions, and to receive the data required to submit the relevant status on the OSS platform, OSS transactions - Summary statement was created (menu: Accounting / Period completion processes / Intrastat &Vies).

ERP-RO01-5.3.0.0-image5.png

The printout displays cumulatively by EU country the total net values and VAT values of sale of goods and services, broken down by VAT rate, normal and reduced and includes all the information required to complete the relevant platform for the OSS of MyData.

It should be noted that up to two categories of VAT per country are supported, one for a standard rate and one for a reduced rate, as provided for in the relevant submission instructions. If the incorrect configuration produces results corresponding to more than 2 VAT categories, this is marked on the printout with a special comment on the country record for which the problem occ

ERP-RO01-5.3.0.0-image6.png

VAT calculation - Configuration

The VAT value should be calculated on the basis of the VAT rates in force in the Member State of the goods purchaser or a customer recipient. It is therefore necessary to do the following, in terms of the application’s configuration:

  • VAT Categories. The various VAT rates per Country (EU) of the Recipient will be introduced by creating NEW VAT categories, so that their posting is also parametric. In the VAT categories table, the “Implementation country” must be entered.

ERP-RO01-5.3.0.0-image7.png

  • Types- Services. No change is required in the items: All items (and possible autonomous special accounts) involved in Invoicing have a specific VAT category and this will continue to be the case. It is the same as for domestic transactions and all other transactions not covered by this instruction.

    The relationship between these categories of VAT and the new ones to be created (to describe the VAT rates applicable per country in the European Union) should be declared in the new VAT Categories Mappings table.

    ERP-RO01-5.3.0.0-image8.png

    Document types. Finally, the document types used for these transactions should be appropriately classified, in order to activate the new functionality. This classification is made in the Transaction types table.

    ERP-RO01-5.3.0.0-image9.png

    There, the fields must be appropriately filled-in to calculate the VAT correctly:

  1. Calculate VAT per country If enabled, then the system will replace, in the document lines, the VAT category in the lines of items and special accounts (that gets its value from the default one in the “VAT Category” tab), by referring to the VAT Categories Mappings for the specific country of the Invoicing Address (concerns the LOCATION of the recipient, according to the directive). So, for example:

Goods-Services VAT categories:

  • C (Standard 24%)
  • C-FR (France 20%)
  • C-SP (Spain 21%)

VAT categories mappings:

  • C (Standard 24%) for FR or C-FR (France 20%)
  • C (Standard 24%) for SP or C-SP (Spain 21%)

Document with transaction type with ERP-RO01-5.3.0.0-image10.png in “Calculate VAT per trade account Country”

ERP-RO01-5.3.0.0-image11.png

The transaction type can be found on the “Miscellaneous info” page of the header:

ERP-RO01-5.3.0.0-image12.png

Sale of item with VAT category -> C (24%) to a local customer

ERP-RO01-5.3.0.0-image13.png

Sale of the same item to a customer from France, VAT category = C-FR (20%)

ERP-RO01-5.3.0.0-image14.png

More specifically:

The Country of the Customer’s Address automatically changes the VAT category of the lines, based on the VAT categories mapping.

  1. Affects the VAT regime If enabled, then regardless of how the “VAT regime” field receives a default price, in the document header (on Sales by the trader and their Address, on Purchases by the company branch, except for exempted creditors) the system will replace the default value with the one specified in the existing transaction type (in the next “VAT Regime” field).

  2. VAT Regime Used if the previous field has been enabled.

This functionality is necessary when the sale is digital e.g. from the Internet and the VAT is NOT differentiated, as are the retail prices therefore, it depends on the Address specified by the customer. It is therefore possible to define an appropriate “transaction type” and always apply the desired “VAT Regime”.

The transaction type in the header of the document is by default filled-in by the transaction type entered in the document series, otherwise (if not specified) by the document type.

  • Company parameters. On the following new company parameter:

    ERP-RO01-5.3.0.0-image15.pngSelect the transaction type you have configured appropriately, and use in case of intra-community distance sales, based on the instructions in the previous paragraph

Integration with Courier GLS

It is now possible to use the online services ofGLS to manage shipments. Implementation has been carried out using the relevant GLS API services.

More specifically, it is possible to:

  • Create a new “shipment (voucher)”, through which GLS updates its content in real time. These shipments are considered “pending” until they are finalized.
  • Promptly receive and print the shipment voucher as issued by Courier GLS
  • Create the daily list of shipments. The Shipment list finalizes the shipments (vouchers) created in the previous step.

Create shipments (vouchers)

When the trade document is being issued (e.g. Delivery Note - SLN), it is possible to create the shipment (voucher) entry using the Create shipment automation. ERP-RO01-5.3.0.0-image16.png

  • This creates a new shipment record and updates GLS content in real time.
  • At the same time, a pdf is sent by GLS when the shipment is printed, which is automatically attached to the relevant document’s attachments.

https://www.iconexperience.com/_img/o_collection_png/blue_dark_grey/32x32/plain/gearwheels.png Configuration

The creation of shipments concerns specific types of documents (usually those that act as a Delivery note) to which the SHIPMENT_TRACKING attribute should be added

The process is enabled only for documents filled-in by a carrier that has been marked as a GLS courier provider. This attribute can be assigned in the data administration screen for Transporters (Configuration and Tools/Transaction parameters), using the Courier provider field, where the user must select the GLS Romania value.
The Courier GLS login information must be entered by selecting GLS - Connection Settings from the application menu(menu: Configuration and Tools/ Systems integration). The "Terminal" area of the screen is intended to support the future alternative forms of printing provided through a special application.

Actions on shipments (vouchers)

ERP-RO01-5.3.0.0-image18.pngOnce the shipments/vouchers have been created, the relevant actions (automations) are activated. You can use them to contact GLS and prepare the shipment for the specific document.

The following actions are available on the document screen:

  1. Print shipment. This action prints the shipment pdf that was embedded to it when it was created.

  2. Update shipment status. Relates to already finalized shipments. The user can be informed of the current shipment status of the by the Courier GLS service

  3. View shipment information. Displays a window with the shipment information associated with the current document. The screen displays all important information related to the shipment, such as the Code, its status etc.

  • The Print action of the shipment is also available on the same screen.
  • This action prints the relevant pdf on a physical printer.

Shipments can also be batch managed in scroller Courier shipment management Sales /Order Routing/Invoicing. This view can display the documents involved in the GLS shipment sub-system, by selecting the appropriate value in the "Provider code" parameter. Displays documents that have either created a shipment or not. Use the “Document status” criterion to choose to display documents with shipment or without.

With this scroller, you can batch perform the above actions, for all selected entries.

Miscellaneous

Retail – Club cards

New company parameter added: Enable person change based on club card number in the Contact administration category, when activated, then when entering the club card number in the customer info, and if another trade account with the same club card number is found, the default is to replace the person in the trade account with the person of the trade account found with the same card number.

Item dimensions

In all item dimensions, color, size, dimension 1 and 2, an ascending numbering “SEQ.NO” field has been added, where a dimension priority number can be entered, that’s general and independent of the dimension charts in which the dimension participates. It can be used to sort on prints, and where it is necessary to make the selection of dimensions easier. Buttons have also been added to the dimension management screens, in order to make it easier to define the SEQ.NO field.

ERP-RO01-5.3.0.0-image19.png

Horizontal functionality

Login screen

A rainy day in the city as a login screen.

ERP-RO01-5.3.0.0-image20.png

Photo by Raimond Klavins on Unsplash

“About the application" screen

The “About the application” screen was rebuilt with a more functional and complete appearance. The information and procedures included were kept and grouped together into three separate pages: Version, System, and Communication.

Depending on the Login language the screen appears translated, in order to be more usable for all Entersoft products.

ERP-RO01-5.3.0.0-image21.png

. Version Page

ERP-RO01-5.3.0.0-image22.png

. System Page

Entersoft branches are presented on the new page: Contact, where map display is available.ERP-RO01-5.3.0.0-image23.png

. Contact Page

OLAP | Changes & Improvements

Mass show/hide dimensions

It is now possible to mass show and hide dimensions in OLAPs, either in the Data area, or in the Line, Column, or Filter area. The new feature can be enabled by right-clicking anywhere on the OLAP, on the selection Field\Mass show-hide fields by area.

ERP-RO01-5.3.0.0-image24.png

ERP-RO01-5.3.0.0-image25.pngThen, the user can choose to show or hide the desired dimensions by area.

Negative amounts in red when exporting to Excel

In Print preview and export to Excel and PDF, the negative amounts shall be displayed in red.

ERP-RO01-5.3.0.0-image26.pngERP-RO01-5.3.0.0-image27.pngexport to excel

ERP-RO01-5.3.0.0-image28.png

Display Layout title when exporting to Excel

When exporting an OLAP to Excel, and if a Layout has been selected, the Layout title is displayed, otherwise the OLAP title.

Emphasize on data when exporting to Excel

A new feature was added for when an OLAP is being exported to excel to emphasize data. The new feature is only available for exporting in xls and xlsx and only if the OLAP contains a pivot grid.

In this mode, more emphasis is placed on the data, not on the layout and the pivot grid colors. This allows export without cell merging at a higher speed and less memory consumption. At the same time, the user can expand / collapse the fields from within excel.

ERP-RO01-5.3.0.0-image29.png

The criteria, title, date and Company all appear in the left side of Excel, while no field titles appear in the row and column area, instead they appear grouped together in the left side of Excel with the "Fields in rows" and "Fields in columns” indications.


PDF Version