Error message when invoice is not transferring to Sage
If you have an issue with an invoice not transferring to Sage, a transfer result pop up will display on screen or you can check the API logs to see if there is an error message listed there - You can access the API logs going to the main settings page > Under Settings > Select API Logs:
Listed below are common sage error messages and how to resolve them:
1 - Error Message - Couldn't find LedgerAccount
Cause: Sales account is missing
Solution: Go to Settings > Under Accounts > Select Company Details > Under Invoicing Defaults, check you have selected a valid Sales Account. The default Sales account in Sage is 'Sales - Products (4000)'.
2 - Error Message - You cannot add tax, your business is not registered for tax
Cause: This error is to do with the set up of your VAT in Sage.
Solution: You need to check your Sage account to resolve this.
3 - Error Message - Couldn't find TaxRate
Cause: Incorrect VAT rate & Zero Rated VAT setting.
Solution: Check you have selected the correct VAT rate & Zero rated tax rate in MagManager. Go to the main settings page > Under Accounts > select Company Details > Checked the VAT Rate & Zero Rated VAT fields.
4 - Error Message - Artefact number must be unique.
Cause: This indicates that the invoice number already exists in Sage.
Solution: You will need to cancel the invoice in MagManager. Check what your next invoice number is in Sage then contact MagManager Support to have your invoice number set to the correct number. You can then raise a new invoice in MagManager.
It may also be due to you having already transferred the invoice to sage. Go to the main settings page - Under Settings > Select API Logs. You will see two entries one showing the Invoice as being Transferred and a second showing that the Artefact number must be unique. No need to do anything here as the invoice will have already been transferred to your Sage account.
5 - Error Message - artefact_number must be between 1 and 2147483647
Cause: A prefix has been added to the Invoice Prefix field in the Company Details settings in MagManager and Sage does not support this.
Solution: To solve this go to the main settings page > Under Accounts > Select Company Details > Delete any text in the invoice prefix field > Save.
6 - Error Message - Invoice Address is required
Cause: The error message Invoice Address is required indicates that the address is missing from the client record in Sage.
Solution: To fix this open Sage > Select Contacts then Customers > Click on the customers name > Select Contacts and Addresses > Fill in the address details > Click Save.
details and the invoice transferred over successfully.
7 - Error Message - Is too long (Maximum is 25 characters)
Cause: This is an issue with the data in the purchase order number field being too long. Maximum length Sage's API will allow for the purchase order field is 25 characters.
Solution: Reduce the number of characters in the purchase order number. You may have to cancel the invoice first, then update the purchase order number to 25 characters or less on the booking and create a new invoice.
8 - Error Message - This field is required
Cause: A new client in MagManager with a Sage ID. (However, this Sage ID had been created when the account was connected to another Sage account, as this MagManager account had been taken over and connected to a new Sage account).
Solution: User had to manually add the client to Sage with the same Sage ID as in MagManager including full address details and the invoice transferred over successfully.
Note: When taking over a MagManager account and connecting it to another third party accounts app, contact support to have the Sage Ids cleared from the account.
