Annaik Boudin Microsoft SR SUPPORT ENG EMEA

In most European countries ECO participation is requested. This is a contribution to help recycling.

This is a trend all over European countries.

Eco participation is mostly based on unit and should be printed on invoice.

• Eco participation is based on unit
• the rate can be based on 3 digits even rounded to 2 digits on invoice
• VAT total will be calculated on total invoice lines included Eco participation.

There is no full solution in the system. But so far workaround will be to adapt Charge for sales order.

Some example.

• BEBAT (tax on battery)
• Plastic
• Carbon

Tax calculation service allows to have several tax registration numbers (VAT ID).

But each VAT number must be linked to an address in the country.

In some case, VAT number is not linked to a local address.

It is expected then to have same legal entity address with several VAT number from different countries.

feature managements are enable

• Add Vendor ID, Vendor name, Customer ID, and Customer name to the Voucher transaction list page.
• Awareness between ledger settlement and year-end close

When year end close is run with detailed opening transactions, customer and vendor information are not showing on opening transaction.

As per design, year end close is summary of accounting and then do not include customer/vendor detail as this information is not stocked on GeneralJournalAccountEntry. But it can help customer on settlement to have customer vendor information

As workaround, tag should be available in future version and can then stocked this information. But still some idea to get directly customer/vendor information on posting profile account at least.

when creating revenue recognition, sales invoice is created for full amount and revenue recognition (deferral) are posted via General journal.

As per consequence, link between initial sales order / sales invoice does not exist. There is no traceability to initial transaction from accounting.

Moreover posting types are not aligned with deferrals default setup for posting type.

It will be nice to track initial information (to Sales order / sales order / customer) from General ledger (voucher transaction) and have correct posting type to help better accounting understanding.

Audit trail is not possible.

When using tool such as Financial reporting, Power BI, there is no way to drill down to initial transaction.

So far on CODA bank statement import, 2 structured messages are supported S101 and S102 as per customer setup option.

But other options may be interesting as

• 111 for POS credit - globalisation.
• 114 for POS credit - individual transactions

Coded statement of account (CODA) - version 2.6 (febelfin.be)

Settlement or unsettlement should not be possible with fiscal period is closed / on hold.

When fiscal period is closed or on hold, if transactions are generated, settlement is not possible. BUT if settlement is does not generate transactions it is not blocked.

Either an option to block settlement / unsettlement on fiscal period should be added or settlement should not be possible when fiscal period is closed even if no transaction is generated.

Settlement / un-settlement impacts some reports used by auditors. Even if balance is not modified, list of open transactions will differ.

D365 via OCR process allows to digitalise vendor invoices. But these digital documents should also be archived and have some audit trails, timestamps, ....

In France some legal requirement

Article A102 B-2 - Livre des procédures fiscales - Légifrance (legifrance.gouv.fr)

This may be requested in different countries and solution should be global and not specific

Main points

• should be exact copy of original
• Archiving solution should be documented and subject to internal audit to ensure availability, readability, integrity during the period
• regarding integrity, document should be kept on format PDF or PDF A/3 (ISO 19005-3)to have interoperability of systems and sustainability

also should have either

• stamp from server on certificate with security reference on 1 star
• digital footprint
• electronic signature from certificate with security reference on 1 star
• or any similar security device with certificate from organization listed by French Authorities (Trust-service Status List-TSL).

each file should have a timestamp to have date on different operations done.

Some countries used conditional tax.

Tax reversal with sales tax code for payment is generated during settlement process.

BUT no link exist between invoice and tax transactions.

Customers request a report to reconcile the tax ledger account and be able to link tax to initial invoice.

No such report provide good information.

Subscription billing allows to defer Cost of goods sold. But only the COGS posted during sales invoice is deferred.

If customer has FIFO item model Group (or MWA...), when invoice is posted, COGS is based on averaged cost and adjusted during inventory closing adjustment. This inventory adjustment should also be deferred.

Consequence: financial reporting will show incorrect value. Decision maker could not used standard financial report.

If COGS value at invoice posting is not fully closed, then all COGS will be posted during closing adjustment at one specific date.

Deferral period 1/1/2022..12/31/2022

12/10/2021 Sales invoice revenue = 12000

Sale invoice COGS = 100

12/3/2021 Closing adjustment = 10000 (all purchases / production order / .. are closed)

in 2022, each month deferred revenue = 1000 / deferred consumption = 8.33 => Margin = 991.67

But Margin should have been deferred revenue 1000 - Deferred consumption (841.67) = 59.33

France FEC should be possible to be run cross legal entities part of the Group.

Then the consolidated FEC will included a column 19 named Code Etbt

https://bofip.impots.gouv.fr/bofip/9028-PGP.html/identifiant%3DBOI-CF-IOR-60-40-20-20170607#Fichier_des_ecritures_compt_21

Paragraph VII (cas particuliers) /B

This code Etbt (Code établissement) should also be a financial dimension inside same legal entity as some customers used financial dimension.

This FEC should have the option to add a column with a financial dimension.