Experience
It brings years of experience on your Business Central
- Finance
- Arrange Customer/Vendor Entries
- Company Bank Account
- Original Due Date
- Repayments
- Edit Document Posting No.
- Enhanced Fiscal Reports
- Calculate balance in entries pages
- G/L Adjustment Entries
- Improved Accruals
- Warehouse
- Common
- Document Exchange
- Remote Functions
- Ledger deletion
- Partner Group
- Order types
- Partner Area
- Document Status
- Job
- IT Localization
- Activity Code
- Electronic Invoicing (IT)
- Enhanced "Fattura Stamp" Management
- VAT Shareout "Ventilazione"
- For Developers
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.
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.
Company Information
The "Preferred Bank Account" field is added to "Company Information" to automatically complete payment information from Bank Account Master Table.
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.
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".
Edit Document Posting No.
The function allows you to change the document posting no. before posting, for example to restore a previous deleted document.
Enhanced Fiscal Reports
New enhanced fiscal reports are added:
-
Customer Detailed Aging 2
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
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.
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.
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.
Common
Document Exchange
Document Exchange functions accelerate recurring task in EDI operations.
Exchange Profiles
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).
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.
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
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.
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.
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.
Document Status
"Document Status" is a simple table related in several document list to easy group and filter the records.
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"
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).
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.
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.
VAT Shareout "Ventilazione"
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.
For Developers
Experience contains a lot of functions and libraries to accelerate Business Central development.
If you want to explore these functions, clone the repository from GitHub and search the docfx documentation inside the source files.
Many functions are marked with a preprocessor symbol. The other ones are considered as general purpose and always available.
List of functions
Symbol | Description |
---|---|
W1XX001A | Generic API Page for incoming requests with dynamic JSON body implemented by interfaces |
W1XX003A | Bulk importer to populate database with structured JSON objects |
W1XX004A | Skeleton for recurring document exchange (EDI) tasks implemented by interfaces |
W1XX006A
|
Added several fields (normally hidden) to list pages |
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 |
W1FN016A
|
Allow earlier posting for vendor entries |
ITXX004A
|
Recalculate payment % from amount
|
ITXX005A
|
Check external document no by year during posting
|