Check before you connect
Here's a list of values to be provided in order to connect to Exact Globe:
Some parameters can be obtained directly from Exact Globe and some to be provided by the IT team, below are the details on how to get the required values.
Moss requires a user with Admin rights, it's recommended to create an additional user to be used by the integration.
DB Name and Server name can be retrieved from Exact Globe page with the Company view:
DB Name is "Company" in Exact (001 in the example below)
Server Name is "Server" in Exact (EXACT-GLOBE in the example below)
Network details should be available after the network configuration is completed (more details in section "3. Set up Exact Globe for the integration with Moss")
Server Address (address of the Exact Globe server), this should be a DNS (not IP) of the server where Exact Globe is running.
Port (8020 by default).
What data will be imported from Exact Globe to Moss
Attribute in Moss | Attribute in Exact Globe | Location in Exact Globe |
Chart of Accounts | General Ledgers | Finance → General Ledger → Chart of G/L’s |
Suppliers | Suppliers | Finance → Accounts payable → Cards |
VAT codes | Taxes | Finance -> VAT/Statistics -> VAT overview |
Cost Centers | Cost Centers | Finance → General Ledger → Cost Centers |
Cost Carriers | Cost Units | Finance → General Ledger → Cost Units |
Connecting Moss and Exact Globe
Click on “Accounting” and open “Accounting Integration”.
Click on “Connect to Exact Globe” and "Continue".
Enter necessary details (Username, Password, DB Name, Server Name, Server Address, Port). Please refer to the “Check before you connect” section above for details
Connected Successfully. Now you can sync your accounts from Exact Globe
Enter Bank Journal id
Enter Purchase Journal id
If you want to use the Memorial journal instead of the Purchase journal, you can change it at a later stage
Define Default Moss Supplier or enable supplier accounting for card transactions to book transactions on respective vendor accounts
Select “VAT Exempt” if your business is exempted from VAT
Make sure you connected the correct entity and all Journals are set correctly
Here you can switch between Purchase and Memorial journals byToggling “Exporting to memorial Journal” option
Entering Memorial journal code
Continue to set up the Chart of Accounts, Vendors, VAT codes, Cost Centers and Cost Carriers. All Accounts should be synchronized from Exact Globe already:
Check connected Suppliers
Check VAT rates (Tax Codes) synced from Exact Globe. You can set VAT codes inactive, which are not needed on the Moss platform (next step)
Click three dots, hover over “Status” and select “Inactive” to mark VAT codes inactive. These codes will not appear as options for pre-accounting for cards, invoices and reimbursements.
Check Cost Centers
And Cost Carriers
16. Exact Globe connection and integration setup are now completed