Intercompany Integration Solution for SAP Business One 9.1

1. Initial ConfigurationThe Intercompany Integration Solution for SAP Business One Version 2.0 for SAP Business One 9.1

2. Topic Objective At the end of this topic, you will be able to: • Follow the process of initializing the branch, head office and consolidation companies. • Plan the landscape of companies

3. Intercompany Integration Solution:Business Scenario • The intercompany solution is installed on all the branch companies. • Now we need to perform initial configuration for the branch, head office and consolidation companies.

4. Mandatory Configuration Steps • Immediately after installing the Intercompany Integration Solution you need to: • Go through the Intercompany Initialization Wizard. • Set up the Intercompany integration solution using the Intercompany Administration Console web application. • Go Through the Intercompany Setup Wizard in all branch companies and the head office. • (You have the Consolidation Setup Wizard for the consolidation company).

5. Mandatory Configuration StepsContinue • Immediately after installing the Intercompany Integration Solution you need to: • For each company in the Intercompany landscape, use the Authorization window to define, for each user, the windows he can access. • Then, as an administrator, use the Global Data Authorization option to set up authorizations for users to add, update, and remove global masters: • Business partners • Items • Bill of materials • Price lists. • Set master data as Global.

6. 1. The Intercompany Initialization Wizard 1. Intercompany Initialization Wizard • In all 3 company types (Consolidation, Head Office and Branches): • This 8 steps wizard will guide you through all the steps of initializing a company for the Intercompany solution. • The steps that are related to SAP Business One settings will open the relevant window and highlight the relevant fields in green. • AdministrationIntercompany Implementation WizardsIntercompany Initialization Wizard

7. 1. The Intercompany Initialization WizardStep 2 of 8 - Decimal Places • All steps include a brief description on the required setup. • Required settings are presented in green. • Ensure that all companies have identical decimal places setup in the General Settings window. • Tip: pay special attention to separators when working with different localizations.

8. 1. The Intercompany Initialization WizardStep 3 of 8 - Attachments and Pictures Folders • Set the paths for the Attachments and the Pictures folders. • This setting is used in the document exchange cycle when the user wants to send an email notification with an attached document.

9. 1. The Intercompany Initialization WizardStep 4 of 8 - Manage Freight • Check the Manage Freight in Documents option. • If necessary, define the Freight setup for the company. • This setting is used in the document exchange cycle. • If you work with Freight, then you need to ensure that the freight data is available in all companies in the landscape.

10. 1. The Intercompany Initialization WizardStep 5 of 8 - Currencies • Ensure that all companies (branches, head office and consolidation) have the same currencies definition.

11. 1. The Intercompany Initialization WizardStep 6 of 8 - Encryption Key • Define a 16 digit encryption key. • This key is used to encrypt the passwords saved in the Intercompany settings.

12. 1. The Intercompany Initialization WizardStep 7 of 8 - B1i Server Details • The details in the B1i Server Details window are used when generating Intercompany reports • B1i Server Address: server • B1i Port: • HTTPS is not selected (8080) • HTTPS is selected (1443) • User Name: active B1ip ipo user and related password

13. 2. Set up the Intercompany Administration Console 2. Intercompany Administration Console • Start → All Programs → The Intercompany Integration solution for SAP Business One → Intercompany Administration Console. • On the machine with the Intercompany Solution Scenarios installed: • Open the Administration Console application • The Administration Console web application is organized into setup steps which must be executed in a sequence.

14. 2. Set up the Intercompany Landscape using the Administration Console

15. 2. Set up the Intercompany Administration Console Step 1 - Company Registration on the SLD • SLD (system landscape directory): • Check that system landscape directory (SLD) entry exists in the B1iF for each SAP Business One company database • Register all branch and consolidation companies on the SLD page.

16. 2. Set up the Intercompany Administration Console Step 1 - Company Registration on the SLD • SLD (system landscape directory): • Check that system landscape directory (SLD) entry exists in the B1iF for each SAP Business One company database • Register all branch and consolidation companies on the SLD page.

17. Step 2 - Companies Registration in the Intercompany Landscape • Intercompany Landscape Registration

18. Step 2 - Companies Registration in the Intercompany Landscape • We recommend you start with the higher level of consolidation company.

19. Step 2 - Companies Registration in the Landscape Company Type Define the hierarchy between the companies: • In the Company Type field, choose whether the company is: Head Office, Branch or Consolidation. • This definition should be derived from the business structure. • Example1 • Single level of consolidation • Example2 • Multi-level consolidation

20. Step 2 - Companies Registration in the Landscape Company Type

21. Step 2 - Companies Registration in the Landscape Operation

22. Step 2 - Companies Registration in the Landscape – Consolidation Details – for Branch Companies

23. Step 2 - Companies Registration in the Landscape – Consolidation Details – for Branch Companies Branch Company

24. Step 2 - Companies Registration in the Intercompany Landscape • Head Office branch • Branch Company • Consolidation Company • Company Not registered in the Intercompany integration solution • The Consolidation Hierarchy Chart • The Company details have been modified; • The solution deployment is still pending

25. 2. Set up the Intercompany Administration Console Step 3 - Deploy

26. 2. Set up the Intercompany Administration Console Step 3 – Deployment Results Remember to deploy the Intercompany integration solution again whenever: • SLD registration or email connectivity details are updated, and • Whenever you assign a new company template to a branch company in the Company Details.

27. 2. Set up the Intercompany Administration Console Step 3 – Deployment Results • The Solution is Currently Deployed • The Consolidation Hierarchy Chart

28. 2. Set up the Intercompany Administration Console Step 4 – Key Mapping For some objects, SAP Business One maintains an internal primary key: • For example – Freight, Length and Width UOM, Weight UOM, Payment Terms, Item Group, etc. • To successfully replicate master data for these objects, the internal keys of all branch companies must be mapped to each other.

29. 2. Set up the Intercompany Administration Console Step 4 – Key Mapping Before initiating this step: • Ensure that all master data which are replicated by the Intercompany integration solution have an equal number of records in each branch company. • Example: Define equal number of Currencies records in all branches. • See Appendix I in the Intercompany Admin Guide for the list of masters replicated by the Intercompany integration solution and Appendix II for field level details.

30. 2. Set up the Intercompany Administration Console Step 4 – Key Mapping

31. 2. Set up the Intercompany Administration Console Step 4 – Key Mapping • Import the data to be mapped into the key mapping tool. 1 • Choose the object to be mapped and the base company. 2 • Business object’s internal keys 3 • The Base Company • Map to these Companies…

32. 2. Set up the Intercompany Administration Console Step 5 – Preferences • The Preferences menu allows you to perform the following tasks: • Set up replication of user defined fields (UDFs) • Set up replication of user defined tables (UDTs) • Set up the replication schedule for consolidating business partner balances • Set up the replication schedule for allocation accounts • Consolidation configuration maintenance • Configure sender´s e-mail address • Set up the frequency of automatic retries on errors • Language customization • Manage logs • Access audit logs

33. 3. Intercompany Setup Wizard Branches and Head office 3. Intercompany Setup Wizard • In all branch companies including the head office: • This wizard enables you to complete the settings required for the Intercompany Integration solution. • For the consolidation company you have the Consolidation Setup Wizard. • The steps related to SAP Business One settings will open the relevant window and highlight the relevant fields in green. • AdministrationIntercompany Implementation WizardsIntercompany Setup Wizard. • We will get into more details on some of the setup steps when discussing their context in the working process and the consolidation topics.

34. 3. Intercompany Setup Wizard Step 2 of 22 - General Settings 1 2 3

35. 3. Intercompany Setup Wizard Steps 3 and 4 of 22 - User Notifications Define which users are going to receive a notification once an intercompany transaction is received in the branch companies.

36. 3. Intercompany Setup Wizard Steps 5 and 6 of 22 – Control Accounts In each branch you define the control accounts to be set when the branch receives a replicated master data. * Note that we will get into the details of steps 7 until 17 when discussing their context in the Working Process Across Branch Companies topic.

37. 3. Intercompany Setup Wizard Step 18 of 22 – Messaging Setup • The details in this setup are used to send email notifications to the users of the receiving company based on the contact person setup. • These email notifications are supported for the following transactions: • G/L allocation • Intercompany trade, that is – marketing document exchange • Centralized payments

38. 3. Intercompany Setup Wizard Step 19 of 22 - Unique Serial Numbers By • This step is used for the Intercompany Service Management scenario. • The setup should be decided at the organizational level. • The Unique Serial Numbers By setup should be common to all companies in the solution.

39. 3. Intercompany Setup Wizard Step 20 of 22 - Consolidation Account Mapping • Specify accounts for consolidation. • For each active G/L account in each branch company, specify an active G/L account in the consolidation chart of accountsto which the balance is to be transferred on consolidation.

40. 3. Intercompany Setup Wizard Step 21 of 22 – Consolidation Translation Method • Relevant when consolidating between multiple currencies. • In this case, you must define the consolidation translation method (that is the exchange rate translation method) for each G/L account in the chart of accounts. • The value in the Consolidation Translation Method field is used for consolidation reporting.

41. 3. Consolidation Setup Wizard Consolidation Company • This wizard enables you to setup the consolidation process. • It is only available in the consolidation companies. • This wizard presents 7 steps

42. 3. Consolidation Setup Wizard Step 2 of 7 – Consolidation Chart of Accounts • This step reminds you to set up the chart of accounts for the consolidation company. • It is recommended to create a new chart of accounts (manually or with DTW import). • In this chart of accounts you should NOT have any accounts classified as a Control Account.

43. 3. Consolidation Setup Wizard Step 3 of 7 - Consolidation Accounts Setup • The consolidation accounts setup is relevant for cases where branch companies use different currencies in SAP Business One. • In this step you define the system accounts: • Exchange Rate Gains. • Exchange Rate Losses. • Residual.

44. 3. Consolidation Setup Wizard Step 4 of 7 – Chart of Accounts Distribution • Distribute the consolidation chart of accounts to the branch companies in order to map the branches accounts to the consolidation chart of accounts. • Follow these steps: • Export the consolidation chart of accounts from the consolidation company to the B1i server. • Import the consolidation chart of accounts to all branch companies.

45. 3. Consolidation Setup Wizard Steps 5 and 6 of 7 - User Notifications Step 5 and 6 in the Consolidation Setup Wizard are identical to steps 3 and 4 in the Intercompany Setup Wizard.

46. 4. Authorizations 4. Authorization Definition

47. 5. Global Data Authorization 5. Global Data Authorization

48. 6. Set Master Data as Global 6. Setting Master Data as Global • The intercompany integration solution supports the replication of essential master data between companies. • For the following masters selective replication of master data records is possible by checking the ‘Global’ field: • Item Master Data. • Business Partner Master Data. • Bill of Materials. • Price Lists.

49. 6. Set Master Data as Global • To synchronize master data records, you must mark the relevant master data. • You can set all items and business partners as Global simultaneously. • You can also choose the option: Automatically Mark Business Partner as Global on Add and Automatically Mark Item as Global on Add. • If a global price list is based on another price list then the base price list must also be marked as Global • To replicate the exchange rate across companies choose the Sync Button available on Exchange Rates and Indexes Window.

50. Intercompany Tools • Intercompany integration solution provides you with the following Microsoft Excel based tools: • Branch Accounts Setup Tool • Account Classification Setup Tool • Account Classification Mapping Tool • Consolidation Account Mapping Tool • Custom Language Tool