Electronic Invoice For Italy - Receipt Setup

Quick Guide
1Fill in the inbound setup
2Specify the vendor setup by defining the Setup Groups
3Define the reconcile criteria
4Define the check parameters

Inbound Setup (FTE)


TabCampoDescrizione
TemplatePA XLS Template Saved / PA XLS Template File Name / B2B XLS Template Saved / B2B XLS Template File NameClick Restore Default Tmplates to upload style sheets from the cloud:
Vendor bank account Nos.If the field is filled in with a numerator, when creating a vendor with the “Create missing vendor” action in the “incoming document preview (FTE)”, if the electronic invoice file contains an IBAN code, the vendor bank account is created with the code set in the serial no
Purchase HeaderUse Receipt Date as Posting Dateby ticking this option, the system will use the receipt date of IX-FE as the posting date when it will create the purchase invoice. Otherwise the workdate will be used. NB If the user does not have the IX-FE module the system will use the workdate by default.
File SystemImport Folder Archive Folder Rejected FolderIndicate the massive import folder of the .xml files. we can indicate a storage folder in which to save the files already processed. Indicate a folder for the discarded .xml files (if a file is discarded, it is not deleted, but it will exit the list of documents to be processed and go to the discard folder)

Other setups:
Test File Pathsit is possible to verify that the network paths set to setup are reachable. NB - The user (person) must have modify permissions - The user running the BC service must have read / modify permissions
Navigate->Show Field Mappingwe can display the mapping of the fields between the input .xml file and BC. The list cannot be edited.
Setup Groupsit is the main setup of the B2B billing module. It allows you to save sets of options that can then be applied to all vendors or specific vendor through the association with the setup group code.
Vendor Setupit is possible to associate the setup group code to a specific vendor all vendors
Job Queues Entriesit is possible to schedule the import of .xml files. Indicate the codeunit or report to be executed, specify the start / end date and time and define the days if necessary.

Setup Groups


From Edit you can set the different options:


General
Codeassign a code to the setup
Validate on Creationdecide whether to have the system checked after the electronic document preview is created
Ignore Duplicate Filesdecide whether to have the system ignore the files (names) already imported
Reconcile Criteria
Link Rating Limitdefine a minimum rating value for a posted document to be automatically linked
Warning Rating Limitdefine a minimum rating value for a posted document to be automatically linked without warnings
Handle Document Headeronly the document header is imported and the system will not square the totals
Allow Document Linkallows you to manage only the document header and also prevents the generation of a new document within BC. It is only possible to link to existing documents
Payment Data
Payment Data Fromspecifies whether payment and setup information should be taken from the file or from the Vendor Card
Batch Processing
Batch Electr. Doc. Creation Batch Purch. Documeyou can decide which phase to perform automatically if there are no blocking errors

Unit of Measure

From the Unit of Measure, a cross reference can be defined so that the system recognizes the units of measure present in the .xml file.

Checks

You can see the checks that the system makes on the documents and the error codes. The list can be modified only in the Description and Check type column.


It is possible to choose whether for each check the system shows:

ERROR: in this case the user is blocked in the execution of the following steps

WARNING: it does not block the user, but warns that there is some anomaly in the document

NONE: the system does not perform the validation and no message / warning appears

SILENT: the system performs validation, but does not issue messages / warnings.

For the red line a further setup must be specified: Lines reconciliation ratings.

Lines reconciliation ratings

In Lines reconciliation ratings are set rules for automatic reconciliation of posted documents. This is done by assigning a score that indicates to the system whether the posted document has the necessary requirements to be matched:


Example:

For a specic electronic document line, If the system finds a DDT that has the correct Vendor DDT No. (25 points) and the exact item quantity (5 points), will assign to that line a total points: 25 + 5 = 30.

Based on the setup, the system will or will not match the document. In our example, if the setup is the following:


the document will be linked to the line because it has exceeded 20, but a warning will appear because the rating does not exceed 30.


Other Setups

For each vendor setup group it is possible to map the Cash Types with the desired destination account.


FieldDescription
Cash TypeEnter the code provided in the electronic invoice layout (e.g. TC01, …)
DescriptionDescription of the code
Description 2Additional description
VAT %% VAT applied to the amount
VAT Prod. Posting GroupVAT Prod. Posting Group to be applied to the line
Cash Line TypeLine type to apply to the line (G/L Account, Item)
Cash Line No.No. to be applied to the line to be filled in with the G/L Account code or the Item code (depends on the completion of the “Cash line type” field)
Professional Tax AmountIf the flag is YES the amount is reported in the “Professional Tax Amount " field, if it is NO added to the taxable amount. (e.g.: the value is No when it comes to INPS contribution, which is added to the recipient’s income)

EOS Labs -