1 / 36

Managing Trade Statistics in version 12

Managing Trade Statistics in version 12. A Process Overview. Bruno Cabaret Product Management bruno.cabaret@fr.lawson.com. Trade Statistic. Version 12 - Solution. General configuration - per Division. Goods transactions not yet invoiced. MUC transactions management. Report declaration.

emily-aguilar
Download Presentation

Managing Trade Statistics in version 12

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Managing Trade Statistics in version 12 A Process Overview Bruno Cabaret Product Management bruno.cabaret@fr.lawson.com

  2. Trade Statistic Version 12 - Solution General configuration - per Division Goods transactions not yet invoiced MUC transactions management Report declaration Trade Statistic Reconciliation Electronic Output management

  3. New Settings (1 of 2) CRS726 Trade statistic Settings • Based on goods transactions • This permitted to handled trade statistic from stock transactions. • Business type and Labor code for Distribution Orders • This permitted to allocate value code for DO and Internal transactions. • Customs exchange rate • For transfer into local currency for reporting. • Electronic forms - for Declarations • Using E-Collaborator runtime maps.

  4. New Settings (2 of 2) CRS726 Trade statistic Settings • Triangular and MUC operations • It is possible to allocate transactions on invoice transaction (sales division), • Or on the goods transaction (warehouse division) • Or on the Movex internal invoice (exchange between divisions and external invoice). • Triangular operations are identified from: • Country code on warehouse (delivery / receipt) • Country code on address (customer) • Country code on master file (customer / supplier) • Country code on warehouse • Intrastat and Extrastat • Same handling.

  5. New Process (1 of 2) Goods transactions not yet invoiced • Goods transactions not yet invoiced can be created from two functions. • TXS330 for customer orders • TXS340 for purchase orders • Selections available to control: • Order Number - from/to • Warehouse - from/to • Transaction date - from/to • These functions should be run at end of month (before Report Declaration) • This permitted to create trade statistic transaction from inventory transactions that are not yet invoiced to the customer.

  6. New Process (2 of 2) Goods transactions not yet invoiced • These new functions also permitted to recreate transactions • Update database and recreate transactions (item, warehouse, customer, supplier…). • Update additional information (invoice number, invoice year, voucher number and voucher series) • It is not possible to recreate transaction already reported (status 90) • Change in general setup CRS726 is not handled to delete previous transactions (this previous delete should be done manually). • Update Intrastat transactions on invoice • Transactions created on goods not invoiced are updated when invoice is handled • A new transaction without amount is created if goods transaction is already reported (status 90).

  7. MUC transactions (1 of 9) Where are generated transactions? • Four cases of triangular operations identified: • Sales division in the same country as warehouse division • Sales division in the same country as customer/supplier • Sales division, warehouse division and customer/supplier in three different countries • Warehouse division in the same country as customer/supplier. • Three possibilities: • Follow the goods • Follow customer/supplier invoice • Follow internal invoice • Intrastat / Extrastat • Automatic handling between Intrastat and Extrastat with the same setup.

  8. MUC transactions (2 of 9) VAT registration number • External • From Customer/Supplier in case of export with customer/supplier • From division/warehouse for internal transactions • Internal • From warehouse • From country code if not registered on warehouse

  9. A standard process rule for simple case MUC transactions (3 of 9) • Export to customer from warehouse • EU Sales to customer Order Customer EU 2 External Internal / MUC Goods Invoice No differences between warehouse and sales division country Sales division EU 1 Warehouse EU 1

  10. A standard process rule for more complex case MUC transactions (4 of 9) • Four cases corresponding to country legal rule about triangulation • EU1 = EU3 <> EU2 • EU1 = EU2 <> EU3 • EU1 <> EU2 <> EU3 • EU1 <> EU2 = EU3 • Three options • 1 = Follow goods • 2 = Follow invoice • 3 = Follow internal invoice Order Customer EU 2 External Internal / MUC Goods Invoice Internal Invoice Sales division EU 1 Delivering division EU 3

  11. Case 1 – EU1 = EU3 <> EU2 Country of Sales division = country of delivering division <> country of customer delivery address EU 2 EU 1 EU 3 1 = Follow goods 2 = Follow invoice 3 = Follow internal invoice MUC transactions (5 of 9) • Follow goods transactions • Export (info type 2 or 5) to EU2 in EU3 division based on customer delivery/invoice • Follow External Invoice • Export (info type 2 or 5) to EU2 in EU1 division based on customer delivery/invoice • Follow internal invoice • Option 3 not available because it is not an EU transaction • Quarterly report • Quarterly report (info type 3) in EU1 division for customer invoice

  12. Case 2 – EU1 = EU2 <> EU3 Country of Sales division = country of customer delivery address <> country of delivering division EU 2 EU 1 EU 3 1 = Follow goods 2 = Follow invoice 3 = Follow internal invoice MUC transactions (6 of 9) • Follow goods transactions • Export (info type 2 or 5) to EU2 in EU3 division based on customer delivery/invoice • Follow External Invoice • No transaction because it is not an EU operation • Follow internal invoice • Export (info type 2 or 5) to EU1 in EU3 division based on internal invoice • Import (info type 1 or 4) from EU3 in EU1 division based on internal invoice • Quarterly report • No transaction because it is not an EU operation

  13. Case 3 – EU1 <> EU2 <> EU3 Country of Sales division <> country of customer delivery address <> country of delivering division EU 2 EU 1 EU 3 1 = Follow goods 2 = Follow invoice 3 = Follow internal invoice MUC transactions (7 of 9) • Follow goods transactions • Export (info type 2 or 5) to EU2 in EU3 division based on customer delivery/invoice • Follow External Invoice • Export (info type 2 or 5) to EU2 in EU1 division based on customer delivery/invoice • Follow internal invoice • Export (info type 2 or 5) to EU1 in EU3 division based on internal invoice • Import (info type 1 or 4) from EU3 in EU1 division based on internal invoice • Export (info type 2 or 5) to EU2 in EU1 division based on external invoice • Quarterly report • Quarterly report (info type 3) in EU1 division for customer invoice • Quarterly report (info type 3) in EU3 division for internal invoice

  14. Case 4 – EU1 <> EU2 = EU3 Country of Sales division <> country of customer delivery address = country of delivering division EU 2 EU 1 EU 3 1 = Follow goods 2 = Follow invoice 3 = Follow internal invoice MUC transactions (8 of 9) • Follow goods transactions • No transaction because it is not an EU operation • Follow External Invoice • Export (info type 2 or 5) to EU2 in EU1 division based on customer delivery/invoice • Follow internal invoice • Export (info type 2 or 5) to EU1 in EU3 division based on internal invoice • Import (info type 1 or 4) from EU3 in EU1 division based on internal invoice • Export (info type 2 or 5) to EU2 in EU1 division based on external invoice • Quarterly report • Quarterly report (info type 3) in EU1 division for customer invoice • Quarterly report (info type 3) in EU3 division for internal invoice

  15. A standard process rule for all countries legal requirement EU 2 EU 1 EU 3 1 = Follow goods 2 = Follow invoice 3 = Follow internal invoice Triangular and MUC transactions (9 of 9) • Case 1 • EU 1 = EU3 <> EU2 • Goods • Export to EU2 in EU3 division • Invoice • Export to EU2 in EU1 division • Case 4 • EU 1 <> EU2 = EU3 • Goods • Nothing • Invoice • Export to EU2 in EU1 division • Internal invoice • Export to EU1 in EU3 division, • Import from EU3 in EU1 division • Export to EU2 in EU1 division Customer Country code Sales division Delivering division • Case 3 • EU 1 <> EU2 <> EU3 • Goods • Export to EU2 in EU3 division • Invoice • Export to EU2 in EU1 division • Internal invoice • Export to EU1 in EU3 division, • Import from EU3 in EU1 division • Export to EU2 in EU1 division • Case 2 • EU 1 = EU2 <> EU3 • Goods • Export to EU2 in EU3 division • Invoice • Nothing • Internal invoice • Export to EU1 in EU3 division • Import from EU3 in EU1 division

  16. Report Declaration (1 of 1) Added handling • New report layouts in CRS600 • Report layouts 22 and 23 are added with sort and accumulation • Report layouts 32 and 33 are added for report of standard printout for accumulation. • Report declaration Reconciliation • Report declaration number, line number and report period are stored in Trade Statistic transactions when transaction status is set to 90. • Trade Statistic display • View 7 permitted to access on report line declaration.

  17. Trade Statistic Reconciliation (1 of 3) With Stock transactions • Intrastat transactions are created with link to one stock transaction • Source file (CO, PO or DO), Order number, Order line, Delivery number and warehouse is stored on records • Trade Statistic display • Jump to Stock transaction MWS070 is available by option 12 from Trade statistic to control origin.

  18. Trade Statistic Reconciliation (2 of 3) With Accounting entries • At invoice process OIS100 / APS100 the Intrastat transaction are updated • Accounting date, voucher number, voucher series, invoice year and invoice number are stored on Intrastat transactions • Trade Statistic display • Jump to Voucher display GLS200 is available with option 13 from Trade statistic to control information • View 6 is also available. • Recreate transactions from TXS330 for Customer Orders or TXS340 for Purchase Orders • Accounting information are get

  19. Trade Statistic Reconciliation (3 of 3) With Internal Invoice • At invoice process MFS100 the Intrastat transaction are updated • Transactions based on Internal invoice process (setup 3) are updated with information from MUC (internal price, transfer currency code, customer code and supplier code) • For others setup (1 and 2) no information is stored in Intrastat transactions • Trade Statistic display • If an order is included in MUC jump to Internal invoice display MFS200 is available with option 14 from Trade statistic to control information. • Recreate Intrastat transactions for Distribution Orders • New function TXS350 • Internal information are get from MUC

  20. Electronic Output Management (1 of 1) Electronic form • Setting • Electronic form is defined per division in CRS726. • Automatic management • When running CRS600 with report layout 22, 23, 32 or 33 two files are created • These two files (header and detail) are get by e-collaborator and send to customs.

  21. Summarize change in v12 • In Previous Versions • Transactions are created from invoice. • Goods not invoiced are not included. • Transactions are not always created in the good company. • No easy link with sources • In V12 • Transactions are created from invoice process like previous version. • Goods not invoices can be included. • Setup in CRS726 permitted to define where transactions should be created. • Internal invoice transaction can be included • Standard EDI file • Link with Stock transactions • Link with Internal invoices • Link with accounting voucher • Link with Tax Declaration Report line.

  22. Table of Contents Managing Trade Statistics Use Workflow Before Starting Results Use Use Before Starting Gives you the starting condition for the process. Workflow Describes the different activities in the process. Results Tells you what you get at the end. Uses Indicates what the results can be used for.

  23. Before Starting Managing Trade Statistics Your Company Must Have • Well-defined routines and policies for Configuring and Reporting Intrastat • Configured its system • See supporting process: Configuring for Trade Statistics (TST)

  24. The Intrastat Process in Movex Intrastat

  25. ERM for Configuring for Trade Statistics Configuring Trade Statistics Intrastat

  26. ERM for Reporting Imports Reporting Imports Intrastat

  27. ERM for Reporting Exports and EU Sales Reporting Exports and EU Sales Intrastat

  28. Identify Scenario and MUC structure Customer Delivery address Triangular cases 10 S = W <> C 20 S = C <> W 30 S <> C <> W 40 S <> C = W Customer C Fiscal Representative of selling Division W Delivering warehouse S Int.Invoice EU sales EU sales Goods Import Division Owner of delivering warehouse Invoice Selling division Export Order

  29. MUC=0 Customer Delivery address Customer Triangular cases 10 S = W <> C 20 S = C <> W 30 S <> C <> W 40 S <> C = W UK FR GG1 FA6 006 (FR) Delivering warehouse Int.Invoice EU sales EU sales GG1 FA6 (FR) Goods Import Invoice Selling division Export Order

  30. MUC=0 with fiscal representative Customer Delivery address Customer UK FR Fiscal Representative of selling division GG1 FA6 006 (FR) Delivering warehouse UK Int.Invoice EU sales EU sales GG1 FA6 (FR) Goods Import Invoice Selling division Export Order

  31. MUC=1 Customer Delivery address Customer Triangular cases 10 S = W <> C 20 S = C <> W 30 S <> C <> W 40 S <> C = W SE FR 2 1 3 Option : GG1 FAE 107 (GB) Delivering warehouse Int.Invoice EU sales EU sales GG1 FA6 (FR) Goods Import Invoice Selling division Export Order

  32. MUC=1 with fiscal representative Customer Delivery address Customer SE FR Fiscal Representative of selling division GG1 FAE 107 (GB) Delivering warehouse SE Int.Invoice EU sales EU sales GG1 FA6 (FR) Goods Import Invoice Selling division Export Order

  33. MUC=2 Customer Delivery address Customer Triangular cases 10 S = W <> C 20 S = C <> W 30 S <> C <> W 40 S <> C = W UK FR 2 1 3 Option : AAA FA1 106 (FR) Delivering warehouse Int.Invoice EU sales AAA A01 (SE) EU sales EEE FA6 (FR) Goods Import Owner division of delivering warehouse Invoice Selling division Export Order

  34. Results Results Things Look Better Now, • Trade Statistic records automatically created by Movex • Records reviewed • Legal Reports generated and sent to the authorities • Detailed back-up available in Movex

  35. Uses What Do You Do Next? • Time previously spent producing reports can now be spent adding value to the business

  36. www.lawson.com

More Related