-
European triangulation business is not fully considered for EU sales list, intrastat, sales tax
Triangular transactions between European countries is a common process. There are lot of transactions requesting direct delivery inside European countries. System is not taking into account local requirement • Sales tax report should be different From Example in UK, UK VAT report should not include sales payable on box 8 if transactions is triangular. • EU sales list should tag transactions as Triangular/EU • Intrastat should tag transactions as Triangular/EU Setup can be done manually but it is difficult for user to know when to change setup, but also not possible due to volumetry. Suggestion Automation of triangulation business has to be considered as all information are available • Legal entity country = EU • Customer country = EU • Warehouse Country = EU • Sales order is marked as direct delivery In this case Foreign Trade parameters on sales order header and line should be Triangular/EU trade When foreign Trade shows Triangular/EU trade, option to change sales tax Group should be possible as Reverse charge rules setup for specific item. This reverse charge rules may be enhanced and take into account triangular transactions. Another possibility will be to have Term of delivery with option warehouse that will impact sales order to pick sales tax group from warehouse. So far it is only possible for Purchase order. Completed with this Idea https://experience.dynamics.com/ideas/idea/?ideaid=898e41d7-4375-e811-9cca-0003ff68c381 -
Consolidation - Elimination journal should post exchange rate difference automatically
Consolidation is done for several companies with different currency. During the process, all intercompany accounts must be eliminated. But the actual elimination rules process is not optimal. Elimination transactions are retrieved with original company currency. Elimination journal is balanced in different currency but not on consolidation company currency. Then journal cannot be posted. Workaround Run Elimination rules to identify exchange rate adjustment Workaround A * After each elimination, modify Elimination rules and add line for elimination rules for fixed amount with exchange rate adjustment * Run new elimination rules * Journal should then be balanced Workaround B you can also add in General ledger parameters penny differences for the exchange rate difference value (to be changed after each elimination) -
Withholding tax cannot be calculated in case of prepayment
Prepayment is posted (without settlement). The vendor invoice is subject to withholding tax. When invoice is settled with prepayment, withholding tax cannot be generated. on settlement screen/withholding tax, withholding tax cannot be added. System should have a way to calculate withholding tax with prepayment process. -
Broker claim should be reported on same currency as vendor currency
Broker claim is showing on accounting currency whatever vendor currency. it is expected to have broker claim in same currency as vendor currency -
Posting on Sales - packing slip revenue offset is not in sales order currency
Posting on Sales - packing slip revenue offset is not in sales order currency in General ledger. Posting type Sales - packing slip revenue offset reports customer accruals that will be reversed for customer balance. Customer accruals may require revaluation at accounting period end. But in General ledger the packing slip is in accounting currency then no revaluation can be run neither can customer knows which currency has been applied on sales order. There is NO report that linked sales order / packing slip / currency / amount. 1. Sales - packing slip revenue offset should be in transaction currency as for Purchase, accruals in Account payable. 2. report should exist to link packing slip to sales order and currency. -
Batch job print archive not efficient for user / customer account statement / customer invoices
Some reports are taking time to be printed. To ease process, batch job can be used with print archive option. But if process ends in acceptable time, print archive will not ease end user. * all files must be exported one by one (print one by one) * all files have the same name. (no able to know witch file to print first) Expectation * all files should be on zip to be exported once and all printed at the same time. * file name should be setup with some criteria (customer number / name / invoice / date.... this request run for all financial reports * customer account statement * Customer invoices .... -
Default delivery term and transport for transfer order as mandatory on intrastat
with tax service, transfer orders will increase between different country warehouses. These transfer orders will be included in Intrastat report. Then delivery term and transport (on mode of delivery) are mandatory fields for intrastat. These information should be default on transfer order -
Specific inventory posting for credit note different from revenue posting
requirement to have specific ledger posting type and account for sales credit note. In several countries, auditors request specific account for credit note to be able to read directly this part of activity. This feature has been implemented for Italy (Feature management: (Italy) Separate accounts for credit notes) can this feature be extended to all countries? -
France DAS2 report should be format EDI to be uploaded on Government portal
D365 FO provides assistance for DAS2 report with Excel report and form. But EDI process will help all customers in there yearly declaration. Can Microsoft define txt file to be uploaded on government portal? https://www.impots.gouv.fr/portail/les-cahiers-des-charges-tdbilateral https://www.impots.gouv.fr/portail/files/media/1_metier/3_partenaire/tiers_declarants/cdc_td_bilateral/cdc_salaires_honoraires_actionnariat_2022_revenus_2021.pdf -
France Intrastat - statistics procedure automatization
Intrastat France request Statistical procedure code (régime). This code is defined by the transaction type
Example
11 Arrivals from EU countries that have VAT in France (intracommunautaire)
21 dispatch to EU countries exempt of VAT in France
this code can be automized as rules are clear.