¶ SageOne accounting
- Overview
- Connecting the two platforms
- Inventory synchronization
- Cron settings
- Define the payment methods to push to SageOne from Splynx
- Define items within SageOne with the correct VAT
- Push customers from Splynx to SageOne and merge the customers between two platforms
- Push customer invoices from Splynx to SageOne
- Push payments from Splynx to SageOne
- Sync payments from SageOne to Splynx
- SageOne accounting integration logs
- SageOne tweaks
- Troubleshoot
¶ Overview
The SageOne add-on in Splynx was designed to improve efficiency and the ability to perform all activities on one platform. We have integrated all SageOne features into Splynx for your convenience. Syncing customer data, invoices, and payments can now be done effortlessly by your powerful Splynx server.
¶ Important:
SageOne integration is available only for SageOne South Africa
Please, contact our support team (support@splynx.com) to enable this accounting integration.
¶ Connecting the two platforms
- To install the SageOne add-on in Splynx - Navigate to
Config → Integrations → Add-ons, search forsplynx-sageoneand click on the install
icon:
- Configure add-on settings - navigate to
Config → Integrations → Modules list, search forsplynx_addon_sageone_accountingand click on the edit
icon:
Enter SageOne credentials into the Login and Password fields provided under the SageOne API settings section:
The company ID will be fetched from SageOne upon saving the login and password. Once the ID appears in Splynx it is an indicator that the platforms have connected successfully.
¶ Synchronization settings
The general configuration of the SageOne integration module can be viewed and edited here. Double check if Entry points status for portal option is enabled and API domain (with last slash) value is set correctly.
- Payment method ID - select the payment method for imported payments. Payments with selected method id will not be pushed to SageOne;
- Payment statement grouping - group payment statements by "month" or "day";
- Partners ignore list - select the partners which will be ignored in the sync process. Customers, invoices and payments of the partners selected here, WILL NOT be synced with SageOne;
- Ignore inactive customers - toggle this option to exclude inactive customers and their financial documents during sync. However, if a customer was synced before deactivation or manually paired, their financial documents will still be included;
- Import payments from date - specify the date in 'Y-m-d'(2021-03-31) format, which will be used as the start date for importing all payments;
- Payments synchronization direction - define the direction of syncing payments:
SageOne → Splynx,Splynx → SageOneorBidirectional. If SageOne to Splynx direction is selected - all payments that were created in Splynx will not be synced to SageOne; - Payments push to SageOne - select the payment methods to sync to SageOne, this selection only applies if the selected method to sync payments is set to
Splynx → SageOne; - Create payments without invoices/credit notes - a toggle allows to enable creating payment in Splynx when customer doesn't have invoice/credit note (e.g. for the partial payments in SageOne) or, in disabled status - only bank statement (-s) will be created in Splynx. Used on payments import. Attention: in some cases can lead to duplicate payments. Use this option with caution;
- Customer name pattern - used as SageOne customer 'Contact Name'. The following variables can be used:
{id},{login},{name},{email}. Customer name max length: 100;
If you change the pattern, the add-on will update customers in SageOne individually whenever there is a change in the customer’s profile in Splynx.
- Active - the option to activate (deactivate) the customer profile on SageOne side. The toggle allows to configure the same relevant state of customer profile (checkmark's status) during sync between Splynx and SageOne (e.g. in case of customers manual pairing);
- Accepts Electronic Invoices - enable/disable to accept electronic invoices, the option is located in customer profile in SageOne. The toggle allows to configure the same relevant option state in customer profile (checkmark's status) during sync between Splynx and SageOne;
- Auto Allocate Receipts to Oldest Invoice - use this option if you want Accounting to automatically allocate receipts to the oldest invoice. If you do not use this option, when you receive money from customer, you will need to go to the Customer Allocations option to allocate each receipt to the correct invoice. The toggle allows to configure the same relevant state of customer profile (checkmark's status) during sync between Splynx and SageOne;
- Allow this customer to view invoices online - enable/disable for customer to view the invoices online, this option is located in customer profile in SageOne. The toggle allows to configure the same relevant option state in customer profile (checkmark's status) during sync between Splynx and SageOne;
- Use Inclusive Amounts - toggle allows to enable/disable the usage of the inclusive amounts for invoices. Inclusive amounts may provide more accurate roundings. In disabled status Splynx pushes all invoices to SageOne with VAT exclusive, this however make some rounding in SageOne and most of the time the account is out by 1 or 2 cent. In enabled status - Splynx pushes the invoices to SageOne with VAT inclusives that the total amount will always be the same in Splynx and Sage One;
- Invoice/credit note fix Item id - in the field the id of SageOne item can be specified to fix (the SageOne item will be added to invoice) mismatched totals due to rounding differences. Using the empty value - the totals will not be fixed. Items' ids can be found in
Config → Finance → Accounting categoriesof Splynx; - Export finance documents from date - all finance documents (invoices, credit notes, payments) before this date will be ignored on synchronization;
- Use system document number - toggle allows to enable/disable the usage of the Splynx invoice number format for new Sageone invoices during export.
¶ Inventory synchronization
Inventory synchronization keeps stock quantities in SageOne in line with your Splynx inventory. Each SageOne item is paired with one Splynx product. After the first import or export, you manage stock in Splynx: when the In stock quantity of a paired product changes, Splynx updates the Quantity On Hand of the matching SageOne item.
In Splynx, every physical unit is a separate inventory item with its own serial number, barcode and stock location, while SageOne stores a single quantity per item. That is why the pairing is done at product level: the SageOne quantity equals the number of the product's items with the In stock status.
To enable it, turn on the corresponding toggle in the Inventory synchronization settings section:
Once the toggle is on:
- The Inventory toggle appears in the Cron settings section. Enable it to push changed stock quantities to SageOne automatically.
- The Products manual pairing and Inventory logs pages appear in the add-on menu under Finance → SageOne Accounting.
- The Inventory actions appear on the Finance → SageOne Accounting → Tools page.
While the toggle is off, all inventory pages and actions of the add-on are hidden and blocked.
¶ Pair SageOne items with Splynx products
Before you import or export inventory, pair the products that already exist on both sides. Any product or SageOne item left unpaired is created on the other side during the import or export.
- Navigate to Finance → SageOne Accounting → Tools and click
Load SageOne itemsin the Inventory section to load the list of SageOne items into Splynx. - Navigate to Finance → SageOne Accounting → Products manual pairing.
- Click
Auto map by nameto pair every Splynx product with the SageOne item of the same name. - For each product that is still Not paired, select the matching SageOne item in the Pair column. The dropdown lists SageOne items by name and SageOne ID. To unpair a product, click the
×icon next to the selected item.
The table shows the Id and Splynx product name of each product, its pairing Status and the paired SageOne item in the Pair column. Use the Status filter to show Paired, Not paired or All products.
¶ Import and export inventory
The Inventory section of the Finance → SageOne Accounting → Tools page holds the actions that bring the two catalogs together:
Load SageOne items- loads SageOne items into Splynx for products pairing;Import inventory- imports SageOne items as Splynx products;Export inventory- exports Splynx products as SageOne items;Push quantities- sends changed stock quantities to SageOne immediately, without waiting for the cron.
Import and export change data on both platforms. The import creates products and inventory items in Splynx, and the export creates items in SageOne and sets their Quantity On Hand. Pair existing products first, and check both catalogs before you run either action.
Import inventory from SageOne
Use the import when SageOne holds your stock list and Splynx does not have these products yet.
- On the Tools page, click
Import inventory. - In the Import inventory window, select the Stock location where Splynx places the items created by the import.
- Click
Import.
For every SageOne item without a pair, Splynx creates a product, pairs it with the SageOne item, and creates as many inventory items as the SageOne Quantity On Hand. All items go to the selected stock location. You can move them to other stock locations in Splynx afterwards.
Export inventory to SageOne
Use the export when Splynx holds your stock list. On the Tools page, click Export inventory. For every Splynx product without a pair, the add-on creates an item in SageOne, pairs it with the product, and sets its Quantity On Hand to the product's In stock value.
¶ Stock quantity updates
After the initial import or export, manage stock in Splynx. When the In stock quantity of a paired product changes — for example, when you add items, sell or rent them, or return them to stock — the add-on adjusts the Quantity On Hand of the matching SageOne item and records the reason for the change on the SageOne side.
Changed quantities are sent to SageOne:
- automatically by cron, when the Inventory toggle is enabled in the Cron settings;
- manually, when you click
Push quantitieson the Finance → SageOne Accounting → Tools page.
¶ Inventory synchronization logs
To track quantity updates for each paired product, navigate to Finance → SageOne Accounting → Inventory logs.
The table shows the following columns:
- Product - the Splynx product and its ID;
- Modified - whether the product has quantity changes that are not yet sent to SageOne;
- Accounting Id - the ID of the paired SageOne item;
- Accounting Status - the result of the last synchronization: New, Pending, Unknown, Error or Ok;
- Additional 1, Additional 2, Additional 3 - extra details about the last synchronization, for example No quantity changes;
- Created date and Last updated - when the record was created and last changed.
Filter the records by Product, Period, Modified, Status and Show records (All, Deleted or Not deleted).
¶ Cron settings
These are the global settings to automatically sync items between the two platforms, in any selected direction of syncing.
- Customers - enables/disables automatic syncing of customers;
- Invoices - enables/disables automatic syncing of invoices;
- Credit notes - enables/disables automatic syncing of credit notes;
- Payments - enables/disables automatic syncing of payments;
- Inventory - enables/disables automatic pushing of changed stock quantities to SageOne. The toggle appears only when Enable inventory synchronization is turned on — see Inventory synchronization;
- Payments synchronization dates - enables/disables payments sync by cron on selected dates in drop-down list. The toggle Payments should be enabled.
If any of the above items are not enabled to sync automatically, we can manually sync items via the Web UI under Finance → Sageone Accounting, with the export and import functions.
It is recommended that all settings in the "Cron settings" section of the page are disabled for the initial set up of the add-on to avoid syncing all these elements automatically via cron jobs, the first import and export should be done manually
¶ Define the payment methods to push to SageOne from Splynx
- Payments are processed within Splynx and sent to SageOne. Credit cards, cash, debit orders, Paypal payments, etc. - Navigate to the
Synchronization settingssection, select SageOne as thePayment method IDand whichPayments push to SageOnefrom Splynx:
NOTE:
- Exclude payments processed in SageOne from the payments to push to SageOne from Splynx (if SageOne will be used as a payment gateway) because it will grab payments from SageOne.
How to create and link a Bank account in Splynx and SageOne:
Click here to expands
On SageOne side
On Splynx side
Navigate to Config → Finance → Accounting bank accounts, scroll to the Accounting bank accounts section and click the Load button. The Bank account created in SageOne will appear in the table:
Once the bank account has been loaded, scroll to the top of the page and select the necessary account as the default one to which all payments processed in Splynx will be transferred. The default bank account should be selected for each payment method listed in Bank Accounts Map.
In case the bank account list is not loaded
On the sidebar, click on the Finance → Sageone Accounting and press the Import mapping settings into Splynx button, then try again.
¶ Define items within SageOne with the correct VAT
Understanding transaction categories: all types of tariff plans within Splynx create its own transaction and each transaction for tariff plans are by default set to a service type of transaction. This behavior can be modified and it is necessary to do when using the SageOne addon in order to successfully pair items with transaction categories.
Define accounting categories items in SageOne and sync it to Splynx (Items / Add an Item) - these items you will use to pair/sync with transaction categories in Splynx.
The first step is to create the items within SageOne.
Items created in SageOne should have relativity to services within Splynx.
For instance, if you have prepaid and recurring Fibre tariff plans in Splynx, you should have/create these items in SageOne.
In essence, for each different type of service in Splynx, there should be a corresponding item in SageOne. Think of items in SageOne as the grouping mechanism for types of costs from Splynx.
Then we will create transaction categories within Splynx that correspond to the items created within SageOne.
Navigate to Config → Finance → Transaction categories, here you can edit the default transaction categories or simply add new categories for each item created in SageOne.
After creating all the relevant categories, then it's necessary to assign these categories to the different types of services (accounting categories in SageOne). You can assign one category to a full type of services, e.g. one category for all Internet services and one for all voice services, etc, or you can assign the separate category to each of the different tariffs plans, e.g., one category for a wifi tariff and another for a fiber tariff.
To assign transaction categories by tariff plans, it is necessary to enable the transaction category fields within the tariff plans. To do this, simply scroll down to the bottom of the Transaction categories page and enable this option for the desired types of tariffs.
Once you have enabled these fields for the desired types of tariffs, you can simply navigate to the tariffs and assign categories to individual plans.
Navigate to Tariff plans → Internet, find in the list the desired Internet plan and click on Edit icon, scroll down to the bottom of the page, in the field Transaction category change the default category to the corresponding category you have created.
Once all your transaction categories have been created and assigned to the different plans, we can now start to link the categories in Splynx to the (accounting categories) items in SageOne.
Navigate to Config → Finance → Accounting Categories:
Once here, the first step is to load the categories/items from SageOne. To do so, scroll to the bottom of the page and click on the Load categories button in the Accounting categories sections:
In case the accounting categories list is not loaded
On the sidebar, click on the Finance / Sageone Accounting and press the Import mapping settings into Splynx button, then try again.
Once the categories have been loaded we can now proceed to map them to the relevant transaction categories, simply select the relevant SageOne accounting category for each corresponding transaction category in Splynx :
NOTE: In case the monthly invoices are generated in Splynx, its transactions won't be related to the newly created transaction categories. This setting will be applied only for new created transactions.
Click here to see how to cancel the last charge and perform the new service re-charge
- To delete the created invoices and its transactions: open
Finance → History & Previewin the History table find the necessary item of charged invoices, click on the Cancel icon and confirm the action;
- To remove finance history records: a new Delete icon will then appear in place of the Cancel icon. Click on the Delete icon and confirm the action to remove batch files;
- To generate new invoices: select the correct date in the filed Date, click
Previewbutton and choose the Invoice date. After that press Confirm button;
- Double check the generated invoices and its transactions with new categories: the invoices can be checked for specific period in
Finance → Invoicessection, the transaction, accordingly, inFinance → Transactions.
¶ Push customers from Splynx to SageOne and merge the customers between two platforms
In order to sync all customers between two platforms, click on Finance item on the sidebar of Splynx and in the drop-down menu click on SageOne Accounting.
This step is only required for the initial set up of the SageOne add-on, as we have disabled the Cron settings in the second step of the configuration of the add-on. Once the step Export customers to SageOne has been completed for the first time, all cron functions can be enabled to allow the system to sync data automatically.
To export customers from Splynx to SageOne, simply click on Export customers to SageOne button:
Check exported customers in SageOne to confirm the export was successful:
¶ Push customer invoices from Splynx to SageOne
After we have successfully exported customers to SageOne, the next step is to export all customer invoices. To do so, on the sidebar, navigate to Finance → SageOne Accounting.
This step is only required for the initial set up of the SageOne add-on, as we have disabled the Cron settings in the second step of the configuration of the add-on. Once the step Export invoices to SageOne has been completed for the first time, all cron functions can be enabled to allow the system to sync data automatically.
The invoices without transactions or marked as Deleted in Splynx will not be synced to SageOne.
Click on Export invoices to SageOne button:
Check exported invoices in SageOne to confirm the export was successful:
As shown below, customer balances have already changed due to invoice.
Check the customer in SageOne to verify the invoices:
¶ Push payments from Splynx to SageOne
The next step is to export the payments from Splynx to SageOne.
To do so, on the sidebar, navigate to Finance → SageOne Accounting, click on Export new payments to SageOne button:
This step is only required for the initial set up of the SageOne add-on, as we have disabled the Cron settings in the second step of the configuration of the add-on. Once the step Export new payments to SageOne has been completed for the first time, all cron functions can be enabled to allow the system to sync data automatically.
Check the exported payments and the customer balance as well as the bank account status (Banking / Lists / List of Banks and Credit Cards / Activity tab) in SageOne to confirm the export was successful:
The payments can then be allocated and processed within SageOne:
When a gateway payment is voided in Splynx, it is treated like a removed payment during synchronization — the matching payment record is deleted from SageOne on the next payment sync, so your accounting records stay consistent. This requires the reversal feature to be enabled for your instance — see Refunding and voiding gateway payments.
¶ Sync payments from SageOne to Splynx
Using SageOne as a payment gateway in Splynx is possible, but it is very important to be careful to avoid making any duplicated payments.
Navigate to Customers / Lists / List of Customers find in the list the required customer and click to the name to edit (or Actions / Edit). Click on Invoices tab, an unpaid invoices will be listed here (the option to Include Paid Invoices is present as well). Click on detail of the selected invoice to process. Then, click on Options, in drop down menu choose Create Receipt option.
Check the balance of the bank account in Banking / Lists / List of Banks and Credit Cards .
Now we can synchronize this payment that is present in SageOne to Splynx.
The Payments synchronization direction option should be set to SageOne to Splynx in Config → Integrations → Modules list → Sageone Accounting.
On the sidebar, navigate to Finance → SageOne Accounting, click on Import all payments into Splynx button.
After the payments import is completed, double check the invoice and its transaction in customer's profile (Billing → Finance documents and Billing → Transactions tabs). The status of the invoice should be Paid and the description of the payment transaction - SageOne.
If the customer receipt has been created and processed on SageOne side without being linked to the Unpaid invoice and the step Import new payments into Splynx has been performed - the invoice will remain unpaid (the balance will not top up as well) in Splynx. To fix this it's necessary to do the manual pair of the new bank statement with Unpaid invoice in Splynx. Navigate to Finance → Payment statements → History → SageOne (some date) find the related statement and click on Manual pair icon. In new window specify the invoice number to pair with and click on Manual pair icon again. In next window specify the Payment type and press Pair button (pay attention what types of payments are ignored in Payments push to SageOne drop down list in add-on config. This option is used for Splynx to SageOne sync).
To verify that everything is correct, check the list of transactions. Go to the customer transactions tab and ensure that the transactions have been added correctly.
You might also be interested in the video tutorials about the SageOne integration
Click here to expand
(based on Splynx v3.0 and SageOne add-on v1.0.90.20200417)
In Splynx, when credit notes are deleted and synced with SageOne, they will remain in the accounting system, and you will need to manually delete them from there. For more information, please read this: Deletion of credit notes synced to accounting.
¶ SageOne accounting integration logs
All actions of the SageOne add-on can be monitored regularly to ensure that the add-on is working as expected. To check the list of add-on activities, navigate to Administration → Logs → Accounting Integrations:
¶ SageOne tweaks
The Finance → SageOne Accounting page holds all manual synchronization actions of the add-on. Use the gear icon in the top-right corner of the page to open the other add-on pages.
¶ Manual synchronization actions
Click a button in the SageOne manual accounting synchronization section to run the action right away, without waiting for the cron. The progress and the result of each action, including errors returned by SageOne, appear in the output panel on the right.
Export customers to SageOne- exports new customers and updates modified customers in SageOne;Export invoices to SageOne- exports new invoices and updates modified invoices in SageOne;Export credit notes to SageOne- exports new credit notes and updates modified credit notes in SageOne;Export new payments to SageOne- exports Splynx payments to SageOne. If a synchronized payment is deleted in Splynx, the add-on also deletes it in SageOne;Import new payments into Splynx- imports new SageOne payments into Splynx;Import all payments into Splynx- goes through all SageOne payments, imports the new ones and skips the payments that already exist in Splynx;Import mapping settings into Splynx- imports the SageOne data required for mapping, such as accounting categories and bank accounts. Run it after you enter the SageOne login and password in the add-on configuration, then configure the mapping as described above;Load SageOne customers for manual pairing- loads the SageOne customer list into Splynx. Use it before you pair customers on the Customers manual pairing page;Pair SageOne same number invoices- pairs the invoices that fail to export with the 400 Document Number already exists error. The add-on requests the SageOne IDs of these invoices and saves them in Splynx, for example, when invoices were exported but their IDs were not received;Pair SageOne same number credit notes- does the same for credit notes that fail to export with the 400 Document Number already exists error.
¶ Add-on menu
Click the gear icon in the top-right corner of the page to open one of the add-on pages:
- Manual Syncronization - the page with the manual synchronization actions described above;
- Customers manual pairing - pairs customers that already exist in both Splynx and SageOne, so you don't have to create them again on either platform. Click
Load SageOne customers for manual pairingfirst to load the SageOne customer list; - Products manual pairing - pairs Splynx products with SageOne items. Available only when inventory synchronization is enabled — see Pair SageOne items with Splynx products;
- Accounting categories mapping - opens the Categories map page, where you pair Splynx transaction categories with SageOne accounting categories. Categories with the same name are matched automatically. All categories must be paired before you click
Save— see Define items within SageOne with the correct VAT; - Module Config - opens the add-on configuration page (Config → Integrations → Modules list → SageOne Accounting);
- Synchronization logs - opens Administration → Logs → Accounting Integrations — see SageOne accounting integration logs;
- Inventory logs - shows quantity updates of paired products. Available only when inventory synchronization is enabled — see Inventory synchronization logs;
- Tools - opens the page with the Reset action and the Inventory actions.
¶ Tools
The Tools page has two sections:
- Reset - clears the accounting data of the add-on in Splynx. Click
Resetto:- clear the accounting IDs and additional information in Administration → Logs → Accounting Integrations;
- delete the data in Config → Finance → Accounting bank accounts;
- delete the data in Config → Finance → Accounting tax rates;
- delete the data in Config → Finance → Accounting categories.
- Inventory - the inventory import, export and quantity actions — see Import and export inventory.
After a reset, Splynx no longer knows which customers, documents and payments are already synced to SageOne, and the mapping of bank accounts, tax rates and categories is lost. Use
Resetonly when you connect Splynx to a different SageOne company or start the integration from scratch, then runImport mapping settings into Splynxand configure the mapping again.
The result of each action appears in the output panel below the buttons.
¶ Troubleshoot
You can learn more about common SageOne issues and their solutions in this article: Troubleshooting accounting add-on issues.