Experience

Several pages are improved with a new action "Document Exchange" that prompt to the user the available exchange choice for the selected rows. For example "Document Exchange" in Posted Sales Invoice can allow you to send the documents as electronic invoices.

Choices are defined by enabled "Exchange Profile". A profile is an entity with a code, description, formatting specifications and transport. For example "Italy E-Invoice" is a format implementation that converts posted invoices in an XML readble from the Government. As another example "Download/Upload" is a transport implementation that allow you to download the above XML from the browser, but other implementations could send the document directly via web service.

Document mapping (cross reference)

During data exchange process is often necessary to map incoming data (for example a code) to others one and vice versa.

Search for "Document Exchange References" and create a new mapping profile. Each profile has a unique code and a description.

With the action "Tables" you can map a local table (for example 18 for the Customer table) with its primary key to a custom value. For example internal code "C0001" can be mapped to "K453" for external operations.

Vice versa with action "Values" you can map a custom value to one or more local table. A typical example is an external combined code for payment method and terms that should be mapped to two internal tables (for example the code "B030" that becomes "BANK" for bank transfer method and "30D" for 30 days terms).

Common

Remote Functions

Several "low level" functions are not available in Business Central because they need a physical (virtual) server to be executed. For example: database access (ODBC), local file system, FTP, SFTP...

"Remote Functions" are a convenient way to use these functions via Web Services through a remote server.

The server must be well configured and secured, later you can setup multiple function profiles through the "Remote Functions" page:

Code and description of the server (to identify it)
API URL endpoint
Access Token

The preferred server is used when a specific server is not chosen.

Common

Ledger deletion

If allowed by your organization, sometimes is ncessary to delete ledgers, for example in case of a massive mistake.

Deleting legers is often prohibited and can make your accouting inconsistent. You must know what you are doing.

User Setup

To allow the function enable "Allow Ledger Deletion" flag in "User Setup" page.

Deletion

Select the action "Delete Document" from these pages:

General Ledger Entries
Posted Sales Invoice
Posted Sales Credit Memo
Posted Purchase Invoice
Posted Purchase Credit Memo

Common

Partner Group

To ease filtering of Customer and Vendors, a new field "Partner Group" is added to Master Tables.

Some example groups:

V-SER: Service Supplier
V-LEA: Leasing Supplier
IC: Intercompany Partner
C-TOP: Top Customer

"Partner Group" table is common to Customer and Vendors.

Common

Order types

Order types allow to group orders by several categories and easily find them.

"Order Type" can be assigned to:

Sales
Purchase
Orders or return orders
Invoices or credit memo

Order types extends invoice posting policy per document basis.

Common

Partner Area

To ease filtering of Customer and Vendors, a new field "Partner Area" is added to Master Tables.

Some example groups:

C-EU: Central Europe
I-NORTH: Italy North
I-SUD: Italy South
NY: New York

"Partner Area" table is common to Customer and Vendors.

Common

Document Status

"Document Status" is a simple table related in several document list to easy group and filter the records.

Common

Certified E-Mail "PEC" scenario

This E-Mail scenario allows to use specific server for Certified E-Mail sending (for example "PEC" in Italy).

Common

Misc Common functions

List of miscellaneous functions added to Common area.

W1XX001A	Generic API Page for incoming requests with dynamic JSON body implemented by interfaces
W1XX003A	Bulk importer to populate database with structured JSON objects
W1XX005A	Allows to handle files (stored in the database) in the same way of a common File System
W1XX006A	Added several fields (normally hidden) to list pages
W1XX018A	Skeleton (interface based) to batch several task with a single Job Queue
W1XX019A	"Barcode" field in various table for DMS integration
W1XX021A	Job Queue improvements ("Start Now" action, interrupt...)

Finance

Arrange Customer/Vendor Entries

With this function you can arrange existing Customer or Vendor Ledger Entries, adding, removing or grouping the installments.

From the Customer Ledger Entries page, select the document to arrange (all installments will be searched by Customer No., Document Type, Document No., Posting Date and Currency Code) and select the action "Arrange Entries".

Arrange the entries as you want in the details page and select the action "Apply".

If controls have succeed, the new installments are written in the ledger.

In case of rounding amounts, the difference will be placed on the last installment.

The original Transaction No. is retained, in case of new installment a "dummy" G/L Entry will be added at the end of the table to preserve Transaction No. sequence.

Finance

Company Bank Account

Company Bank Account is copied from documents (Sales Header, Purchase Header, Finance Charge Memo Header) to related entries.

The field is editable.

Original Due Date

Original Due Date (that one of the posting phase) is added to Customer and Vendor Ledger Entries.

The field is not editable for statistical purposes.

Finance

Repayments

Repayments is the function that allow to select multiple Customer or Vendor Ledger Entries and arrange them in new installments with new due dates.

Setup

Search for Repayment Setup and setup:

No. series for draft repayments document
No. series for issued repayments document
General product posting group and VAT for possibile interest of the repayment

Creating a new plan

Search for Repayments list and create a new document.

Select the customer and the dates of the document. You can edit the description, the default General product posting group and VAT, the Company Bank Account and the Payment Method.

If you specify a Finance Charge Term, the interests will be applied to the principal amount of the Repayment. The interests are calculated in "progressive depreciation" (first interests, next principal amount).

Select the action "Get Entries" to add the open Customer or Vendor ledger entries to the repayment.

With the action "Suggest Installments" you can calculate automatically the installments or the repayment with the following constraints:

Starting date of the first installment
Date formula for the next installments
Maximum amount of the installment

If you want to add charges (for example bank transfer costs) select the action "Charges":

G/L account for the charge
Description and the entire amount of the plan
Application method of the charge (add it to the first or last installment, divide it to all installments)

You can adjust the installments as you want (changing description, due date, amount and payment method).

Calculating the plan

Before issuing the plan, select the action "Calculate" to adjust the interests for each installments.

Possible roundings are added or subtracted from the last installment.

The report "Repayment Summary" allows you to share calculation with the Customer or Vendor.

Issuing

When the repayment is complete you can issue it:

Customer or Vendor Ledger Entries are arranged with the new due dates
Possible interests or charges are posted with a new Finance Charge Memo

Issued repayments are archived in the "Issued Repayments List".

Finance

Edit Document Posting No.

The function allows you to change the document posting no. before posting, for example to restore a previous deleted document.

Finance

Enhanced Fiscal Reports

New enhanced fiscal reports are added:

Customer Detailed Aging 2

Finance

Calculate balance in entries pages

The new action "Calculate Balance" allows you to view the progressive balance of the entries as shown on the page (with the same sorting and filters).

The data is temporary but very useful to check amounts.

Available in:

Customer Ledger Entries
Vendor Ledger Entries
General Ledger Entries

Finance

G/L Adjustment Entries

During the closing of fiscal periods, it's often necessary to integrate the general ledger with adjustment entries. These entries are considered as draft or temporary, so them are not ready to be posted.

The "G/L Adjustment Entry" is a specific table to register these entries and view the amounts in the Chart of Account and Financial Reports. The Adjustment Entries does not take part to fiscal ledgers and can be canceled in any time.

Post as Adjustment

Simply fill a new batch and select the action "Post as Adjustment".

The entries will be transferred in the special ledger and can be viewed through Chart of Accounts in the column "Adjustment Balance".

Cancel the transactions

Adjustment Entries can be canceled in any time, modified and then posted again or deleted.

To cancel the transactions, identify the entries in the G/L Adjustment Entries page and select the action "Cancel transactions".

The entries will be transferred to the source journal.

Financial Reports

To sum normal entries plus adjustment entries you can use Financial Reports.

In the Column Definition you can select Adjustment Entries as ledger entry type.

Finance

Improved Accruals

"Improved Accruals" boost the standard deferral posting with new and useful functions.

In sales and purchases document lines it's possible to directly insert accrual starting and ending date. In general journals too.

Accrual dates are transferred to general ledger entries. Calculation is made per day basis.

Accrual recognition

Accruals are recognized after posting and are transferred to general journal. Accrual recognition is incremental for the maximum speed also in huge environments.

It's sufficent to insert "Ending Date" as recognition date to start the calculation.

Finance

Totals in receipt or shipments

Posted receipts or shipments, in the standard version, are missing of total amounts.

This functions adds total amounts to easy evaluate the documents and identify them in the invoice process ("get receipts..." and "get shipments...").

Finance

Invoice without G/L

Sometimes orders are received or shipped but the transaction does not end with an invoice.

In these cases orders and inventory entries remain open, waiting for the invoice.

This function allows to close orders generating a "dummy" invoice, with a different number, and without any G/L entry.

Define the "dummy" number series in "Sales & Receivables Setup" and "Purchases & Payables Setup":

Fill the "Quantity to Invoice" in the orders and click the action "Post without G/L"

Finance

Misc Finance functions

List of miscellaneous functions added to Finance area.

W1FN010A	Better posting description: "Document Type" and "Partner Name" in Sales and Purchases
W1FN011A	Skip error if negative / positive amount mismatch in Gen. Journal Line; skip error if invoice already exists
W1FN013A	Average payment days (integer value) calculation
W1FN014A	Average finance charge terms grace period days (integer value) calculation
W1FN015A	Global e-invoicing support
W1FN016A	Allow earlier posting for vendor entries
W1FN021A	Allow to modify customer reminder level in ledger entries
W1FN023A	Allow to increase and depreciate the same fixed asset several times (first depreciation date as first cost document)
W1FN024A	Additional field to correlate imported entries with legacy system
W1FN028A	Check used/unused accounts in schedule
W1FN029A	Allow invoicing to same bill-to and different sell-to, different categories
W1FN030A	Disable deletion of master data with entries
W1FN031A	Allow posting no per batch
W1FN032A	Batch posting journal per document (useful in large batches, it posts every balanced document, leaving errors in batch)
W1FN033A	Posting categories on finance charge

Apply per document

Function W1FN025A allows to "explode" applied documents in batch before posting, avoiding selecting them one by one.

Allocation in G/L

Function W1FN027A adds a report to execute "Cost Allocations" directly in General Ledger to avoid usage of Cost Entries.

Finance

Notes in document

Simple "note" field added in all documents (sales and purchases) and transferred to all involved ledger entries.

Finance

Apply G/L Entries

The function allows to apply positive and negative General Ledger Entries, of the same account, to mark them as "closed".

This is very useful to analyze the balance of one account and view only the "open" entries.

G/L Account

Enable "Detailed Entries" in the G/L Account Card.

Apply and unapply entries

Apply G/L entries in the same way of customers or vendors entries.

Finance

Easy batch import from Excel

The function allow to import lines in General Journal from Excel. The process is easy:

No RapidStart
No Document Exchange (that requires mapping)
No Edit in Excel (that requires authentication)

Only a simple Excel File with the field caption in the first row.

Validations are made in column order.

Sales

Store Documents

This function add several processes and utilities to handle documents coming from stores.

Stores are very often managed by specific softwares and (more or less standard) interfaces integrates the stores with the headquarter.

This function propose a standard way to manage store documents in Business Central.

Store Setup

In the Store Setup you can set default accounts or categories and document numbering.

Store Documents

Each transaction made by store is transmitted to BC with a row level detail:

Sales (receipts or invoices)
Sales Return
Purchase
Purchase Return
Transfer between stores
Inventory adjustments
Physical inventories

Store Closings

The function adds the daily "Store Closing" process. Each sale is summarized in a document; totals are matched with payments.

It's possible to integrate physical devices and read data from them electronically (for example EFT-POS, intelligent printers...).

The posting of "Store Closing" makes entries in the ledgers (general, customers, vendors, item...).

Sales

Misc Sales functions

List of miscellaneous functions added to Sales area.

W1SA001A	Standard Sales Code for all customers
W1SA002A	Automatic lines (source) to add system-generated lines to documents and recalculate them several times
W1SA008A	Apply credit memo to invoice
W1SA009A	User creation information in document
W1SA013A	Ship-to address mandatory
W1SA016A	Do not delete invoiced orders
W1SA021A	Hide shipment date warning to workdate
W1SA028A	Payment method in credit memos
W1SA029A	Better item blocking (after item validation but before quantity or posting, to allow import of "zero" sales of blocked items)

Trade

Misc Trade functions

List of miscellaneous functions added to Trade area (Sales and Purchases).

W1TR004A	Unavailability reason codes (track missing quantities with a reason code)
W1TR005A	Do not recalculate unit price/cost for shipment/receipt (while changing the invoiced quantity)
W1TR007A	Do not ship/receive zero quantity
W1TR009A	Allow negative discount
W1TR010A	Vendor Item No. in prices
W1TR012A	"Line description" in Posting Group
W1TR013A	Location code in Copy Document

Payment balance per customer/vendor o category

Function W1TR006A allows to set balancing account in payment methods for specific customers, vendors or group within "Payment Setup" page.

Allowed dates for sales & purchases

The functions W1TR008A allows to specify allowed dates for sales or purchases.

Trade

Multiple discounts

Sales and Purchases document are enhanced with:

4 additional discount values
1 additional charge value

Discounts and charges are summarized in the standard "Line Discount %" field, but can be extracted for reporting or statistics.

Inventory

Misc Inventory functions

List of miscellaneous functions added to Inventory area.

W1IN003A	No series per location
W1IN005A	Default in transit code
W1IN006A	Negative transfer
W1IN013A	Exclude location from cost calculation
W1IN015A	Skip validation errors on Item Journal
W1IN017A	Disable "Post Value Entry to G/L"

Enhanced Cost Adjustment

Function W1IN016A expoeses through Codeunit "YNS Inventory Batch" an enhanced cost adjustment task:

Commit per Item
Sum and deletion of Adjustment Entries in Value Entry (useful for large tables)

Inventory

Item additional information

Enhanced Search Description

Function W1IN001A enhance Search Description with character replacing.

Inventory

Requested quantity

Sales Orders and Purchase Orders are enriched with "Requested Quantity" field.

The field is set for the first time by user validation. After, if the quantity is increased or decreased by warehouse activities, it's possible to compare "Requested" with "Actual".

Inventory

Item Taxes

This function allows to track or charge specific taxes per item (for example "Accisa" in Italy for some kind of goods).

Taxes can be applied to specific customers/vendors or group of them.

Taxes can be calculated per unit of measure or by a conversion rate. Tracked entries can be exported to various Government Agency.

Warehouse

Negative Bins

In some scenario is necessary that warehouse bins can have negative inventory.

This is possible through the flag "Allow Negative Quantity" in the "Bins" page.

Be careful: this option can have unpredictable consequences.

Job

Automatic creation of Planning Line from Sales Invoice

Sometimes you need to create and post a new Sales Invoice linked to a Job / Job Task.

Usually the fields "Job No." and "Job Task No." are read only in Sales Invoice Page because you need to create first the related Job Planning Line.

With this function the fields are now editable and the Planning Line is created automatically with type "Billable"

Integrations

Italy E-Invoice via Aruba®

This Document Exchange Transport add supports for Aruba® Business provider for Italian E-Invoicing.

The setup is very easy:

Integrations

Italy E-Invoice via Zucchetti Digital Hub®

This Document Exchange Transport add supports for Zucchetti® Digital Hub provider for Italian E-Invoicing.

The setup is very easy:

Integrations

Treasury via DocFinance®

This Document Exchange Format allow integration with the popular treasury software DocFinance®:

Export of Chart of Accounts
Export of Customers
Export of Vendors
Export of General Ledger Entries (for "batch" handling)
Import of Bank Account journal lines

Format setup is very easy:

Document Exchange is made via traditional file system, accessed via Remote Functions.

Integrations

Italy E-Invoice via ArXivar IX®

This Document Exchange Transport adds supports for ArXivar IX® provider for Italian E-Invoicing.

The setup is very easy:

IT Localization

Activity Code

If indicated in Company Information page, the Activity Code field is defaulted on the documents that request it (Sales Header, Purchase Header, Finance Charge Memo Header).

IT Localization

Electronic Invoicing (IT)

Italian Electronic Invocing (also known as FatturaPA) is defined by government rules through the "Agenzia delle Entrate".

Fatturazione elettronica PA - FatturaPA

Most sales invoices must be sent to customers and most purchase invoices are received from vendors. Only few exceptions are allowed.

Electronic Invoices can be exchanged manually (via certified e-mail PEC or via authorized provider) or automatically (Business Central can contact the provider via Web Services).

Company Information Setup

In the "Company Information" page the following data are mandatory:

"Company Type" (for example "01" for normal tax system)
"VAT Registration No." (in ITxxxxx format)
"Fiscal Code"
Complete name and address with country code and county
"Liquidation Status"
"REA No." and "Registry Office Province"

Payment Methods

Each payment method must be related with the government one.

Fill the "Fattura PA Payment Method" in the "Payment Methods" page.

Customers

For each customer the following data are mandatory:

"VAT Registration No." (in ITxxxxx format)
"Fiscal Code"
Complete name and address with country code and county
"PA Code" or "Send E-Invoice via PEC"

"PA Code" is the code of the provider of the customer, similarly to the domain name after @ in the e-mail addresses. For private company "PA Code" is 7 character length, for governative agencies is 6 character length. Use "XXXXXXX" for foreign customers, use "0000000" to use the default provider that customer has defined in the public registry.

E-Invoice Setup

The "Italy E-Invoice Setup" contains all specific parameters of the function. "Working Path" is the virtual file system path to store sent and received e-invoices and their attachments.

It's possible to strip unwanted characters from document numbers and to define a custom Exchange Reference to map internal code with external ones (for example change Unit of Measure Code).

It's possible to upload an XML/XSL to pretty format the e-invoices for printing. This is one of the mostly used stylesheet in Italy: https://for.assosoftware.it/assoinvoice

Exchange Profile

You can define several e-invoice exchange profile, one for each provider that you use. If you don't have a provider but exchange the invoices manually, select "Download/Upload" transport.

In the "Document Exchange Profiles" page select "Italy E-Invoice" as format and enable it.

Prepare an invoice for sending

In the "Posted Sales Invoices" page (or "Posted Sales Credit Memo") select the action "Document Exchange" and select the export option. For each selected document an E-Invoice is created.

Sales and Purchases E-Invoices

The pages "Italy Sales E-Invoices" and "Italy Purchases E-Invoices" allows you to view and filter all e-invoices created or received. It's possible to:

Delete and recreate the wrong E-Invoices
Export the E-Invoices as original XML o formatted HTML
Massive send or receive the E-Invoices
Automatically create new vendors
Automatically create purchase invoices or credit memo by predefined rules

These pages are very important to assert that all sales and purchases invoices have been posted.

IT Localization

Enhanced "Fattura Stamp" Management

"Fattura Stamp" is a special and mandatory tax if the sales document has no VAT. The "Stamp" can be only declared and paid by company or declared and charged to customer.

To better automate this process, new fields are added to "Sales & Receivables Setup" page:

Default Fattura Stamp Amount
Fattura Stamp Threshold (value over which the Stamp is applied)
Fattura Stamp G/L Account (G/L Account to charge the customer)
Fattura Stamp Description (description of charge invoice line)

To use the function press the Assist Edit on "Fattura Stamp" on "Sales Invoice" Page.

IT Localization

VAT Shareout "Ventilazione"

VAT Shareout ("Ventilazione" in Italy) is a specific VAT calculation tipycal of small business that handles multiple VAT rates.

These business can declare to government that:

Purchases are well divided per VAT rate
Sales are made in aggregated form, without applying any VAT rate

To pay the right taxes, these business need to calculate "Ventilazione" that is VAT rate to apply to sales proportionally to purchases.

The calculation is made starting from the 1° january of each years to the end of each VAT period.

Example

Month	VAT rate	Purchase amount	Shareout %
January	4 %	10.000	16,53 %
January	10 %	33.000	54,55 %
January	22 %	17.500	28,92 %
Total		60.500	100 %

The aggreate sales of January are 97.000 so the VAT to pay is:

VAT rate	Shareout %	Sales amount (incl. VAT)	VAT amount
4 %	16,53 %	16.034	641
10 %	54,55 %	52.914	5.291
22 %	28,92 %	28.052	6.171
Total	100 %	97.000	12.103

New purchases of February increase previous totals and generate a new shareout for February sales:

Month	VAT rate	Purchase amount	Shareout %
January + February	4 %	22.000	18,72 %
January+ February	10 %	59.500	50,64 %
January + February	22 %	36.000	30,64 %
Total		117.500	100 %

And so on...

Setup

In "VAT Posting Setup" table mark interested purchase lines for "base" in the shareout calculation.

Also mark the sales lines:

That ones aggregated "to be sharedout"
That one after calculation "sharedout"

For lines to be sharedout is necessary also to specify the G/L account for reversing the calculated VAT (sales are posted "included VAT" and need to be reducted for the amount of VAT).

Before VAT settlement, run and post VAT shareout calculation.

IT Localization

Mandatory Split Payment

This function adds a warning before post of Sales Invoices if the "split payment lines" have not be added in the document.

"Split Payment" is an Italian regulation that allows to reverse VAT amounts in invoices for the Public Administration. Reverse is done adding negative "full VAT" lines in the invoice. These lines are added manually in the standard version.

This function is useful in batch posting process to avoid to forget "split payment lines".

IT Localization

Enhanced Fiscal Report

A complete set of fiscal report with mandatory Italian regulatory informations:

Fixed Asset Book
G/L Book
VAT Register
Sales Shipment
Transfer Shipment
Purchase Order
Sales Credit Memo
Sales Invoice
Sales Draft Invoice
Sales Order
Issued Reminder

IT Localization

Electronic VAT Settlement

This Document Exchange Format allows to export the electronic declaration of VAT settlement (LIPE).

Export parameteres are defined in VAT Posting Setup, after simply run the Document Exchange action in Periodic VAT Settlement List.

IT Localization

Interest on Arrears Fin. Charge

This function allows to create Finance Charge Memos starting from Interest on Arrears as defined by Italian law.

Finance Charge Memos has been adapted and integrated with e-invoicing.

Simply run the report "Create Finance Charge on Arrears"

IT Localization

"Prorata" management

Italian regulation determines that some business, that has more purchase than sales, must always apply undeductible VAT.

Undeductible rate is arranged every year.

Simply run the action "VAT Prorata" from VAT Posting Setup.

IT Localization

Shipping information in Sales & Purchases

Italian regulation requires mandatory shipping information in sales / purchase return shipment ("DDT" "Documento di Trasporto").

These information has been added in various documents, for example:

IT Localization

Withholding Tax improvement and declaration

Every year in Italy is mandatory to export electronically the payed withholding taxes.

Tax records must be enriched with additional information.

A new Document Exchange format has been added.

IT Localization

INPS at posting (ENASARCO)

Some salespersons in Italy are subject to "ENASARCO" tax.

These salespersons are handled as vendors. This function adapts the standard "INPS" management to accomplish "ENASARCO" management.

IT Localization

VAT exemption

Italy regulations determines to not apply VAT on some sales transaction. These sales are made in "VAT exemption".

Each exemption is numbered and can be used:

Once
Until the maximum amount

Used VAT exemption must be exported in e-invoiced and related to each document line.

IT Localization

Misc IT localization functions

List of miscellaneous functions added to IT localization.

ITXX004A	Recalculate payment % from amount
ITXX005A	Check external document no. by year
ITXX007A	Enhanced RIBA/RID (dishonored import, RID+ management...)
ITXX009A	Fiscal code on salesperson
ITXX010A	Fattura PA improvement (default "CIG", "CUP", "CommessaConvenzione"...)
ITXX012A	Default operation type for credit memos, customer and vendor
ITXX015A	Italy VAT and e-invoicing also in Finance Charge Memos
ITXX017A	PEC E-Mail on company info
ITXX018A	"Forgotten" purchase invoices (utilities for invoices electronically received in a year and posted in the next one)
ITXX020A	Massive bill recall
ITXX022A	Close bank receipts at due date
ITXX025A	Copy setup VAT Identifier in Split Payment Lines