If you've been using Commusoft and Sage 50cloud Accounts independently then you will have the same customers/suppliers in both systems. The problem with this is that there is no link between these customer/supplier records and therefore when importing data from Commusoft to Sage Line 50/Instant, Commusoft will create a new customer/supplier record in Sage 50cloud Accounts. This duplication isn't ideal.
To avoid this, you can use the steps below:
Getting the customer/supplier ID
- To link existing customers/suppliers from Sage 50cloud Accounts to customers in Commusoft, you will first need the ID of the customer/supplier in Sage 50cloud Accounts.
- Click on the customer/supplier from your customer/supplier list.
- The customer/supplier ID is displayed in a box labelled A/C. Copy this, as this number will be used to link the customer/supplier between Commusoft and Sage 50cloud Accounts.
Linking customers/suppliers
- Open your system settings, Then click 'Accounting interfaces':
- On your accounting integration dashboard go to Quick links > Link customers and suppliers.
- You will see a page with all of your customers/suppliers on. Paste the code into the Accounting reference column.
- Repeat for all customers/suppliers.
It is worth noting that for this to work, the following information must be correct (and copied exactly) in both instances: Customer name, Accounting reference (third party accounting reference in Commusoft), and the Customer's email address.
Go back to: Sage 50cloud Accounts Overview