Sage 50 & 50cloud Accounts

Adept Add-On Support

Sage 50 & 50cloud Accounts

How to Videos & Common FAQs for your Adept Tools & Sage 50

This page has a range of Videos & FAQs to help with Adept Add-On Support.

How to Install and insert the Trial Licence for your Adept Tool

This video shows you how to install an Adept Sage 50 Add-On Tool on your PC and how to enter the Trial Licence details we sent you via email.

Occasionally the Trial Licence email may go into your Junk/Spam Folder so please check there before requesting a resend.

Sometimes during the install you are told that a file you are copying is older than your current file, in this case always select “Yes” to keep your current file.

How to Insert Licence, Connect to Sage Data and Set up a User Name for your Adept Tool

This video shows you how to insert your Trial Licence, Connect to a set of Sage Data (Practice, Demo, Local or Live/Network) and setup a User Name for your Adept Tool in Sage.

Each Adept Add-On or installation of an Adept Add-On can use the same User Name Adept.

The software will automatically generate Adept01 Adept02 as each Tool or install connects to Sage (Adept Tools v23 and above).

How to setup Auto Importing on Adept CSV Add-On Tools

Here we show you how to setup the Automatic Import Loop on our Adept CSV Import Add-Ons.

You can choose when during the day you want to import, how often to check the folder for new files and select your own Folders for the Tool to use.

How to Export using the Adept CSV Add-On Tools

In this video we show you how to use the Export function on the Adept CSV Add-Ons (excluding Transaction CSV).

You decide what data you want to export from the Sage Module by creating a template with the Sage Field Names on Row 1.

After browsing to this File using the Tool, you then select Menu and the Export function becomes available to click.

How To Resolve Login Issues with Sage 50 User Accounts

Sage has a bad habit of locking users in. There are two ways of resolving this:

1. Login to Sage as Manager. Click on View>User List and remove the User Name that the Adept Tool is using from the list.
2. Make sure all users have closed Sage & Adept Tools down. Browse to your ACCDATA folder and the delete the file named QUEUE.DTA When the first person logs back in, Sage recreates this file.

Never EVER delete any other files from this folder and always make sure every install of Sage has been closed.

How To Setup a New User in Sage 50 for your Adept Add-Ons

Open Sage and Login as Manager
Click on Settings>Access Rights>New
Add the User Name Adept and give it a password (if required).
Then in the Adept Add-On Tool, Click on Menu>User Name and enter the details you created above then Click OK.

Each Adept Tool or installation of an Adept Tool can use the same User Name Adept. The software will automatically generate Adept01 Adept02 as each Tool or install connects to Sage (Adept Add-Ons v23 and above)

How to Purchase a Full Licence for your Adept Tool

This video shows you how to Purchase a Full Licence for any of our Adept Sage 50 Add-on Tools range.

Very occasionally our Payment page may not like your Debit/Credit Card details when not signing in with a PayPal account. If you experience this issue please call us and we can process your order over the telephone.

Paypal can sometimes remove the “Pay by Debit/Credit Card” option from the screen. This happens if you have turned down setting up a Paypal account several times as it keeps a record in your Internet Cache/Cookies, these would need to cleared to continue.

How to purchase an Annual Renewal for your Adept Add-Ons

Here we show you how to purchase and Annual Renewal Fee or Upgrade for your Adept Tool.

You will also see a Blue Light Bulb on your Tool when you reach Month 11 of your Licence.

You can renew the Licence at any point during Month 11 and it will not start until the full 12 months has expired.

Adept Add-On Support

Failing to connect to Sage, Not Responding or Crashing on Start Up?

If your Adept Add-On is failing to Connect to Sage, showing as Not Responding by Windows or Crashing & failing to Start Up?
This is usually an issue with your Sage 50/50cloud Accounts software and can be normally be resolved by:

Taking a Backup of your Sage Data Files (File>Backup)
Then click on File>Maintenance>Re-Index and select All Data Files
When the Re-Index has finished you should then Compress All Data Files
Once complete click on the Check Data button to confirm that the data files are Error Free
Your Adept Add-On Tool should now start up and connect to Sage

Run time Permission Errors & Data Service Cannot Connect to

There are some Registry entries that need to have the correct Sage Data Path in (including ACCDATA at the end):

HKEY_CURRENT_USER\Software\VB and VBA Program Settings\Adept Computer Support Ltd\AdeptAdd-OnToolName\DataPath
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Adept Computer Support Ltd\AdeptAdd-OnToolName\DataPath

Example Path: C:\ProgramData\Sage\Accounts\2017\Company.000\accdata\

Run-time Error – Could not open registry section or similar

Basic Fix
Download our Adept Sage 50 Health Check, Install and connect to your Sage 50 data, Select Disable/Off on the UAC Option in the Windows Info

Advanced Fix
Open up Windows RegEdit (Registry editor) and Browse to the following location:
Then Change EnableLUA to 0 and Restart your computer

Setting Permissions on the Application AdeptAdd-On.exe

Browse to the Adept Tool directory in Program Files (x86)
Right Click AdeptTool.***(e x e) and select Properties
Click on the Security Tab
You may see that the Users Group has disappeared from the list
Click on Advanced then Enable Inheritance then Apply
You will then see the Users Group back in the list and click OK and OK again.

Adept Add-On Support

How to correctly apply Net Value Discounts

This CSV File correctly applied a £10 Net Value Discount
The TAX_FLAG column is important and must be set to 0. This tells Sage to recalculate the VAT after applying the discount
CUST0003,1,PROD0001,2,30,Test Discount,10,0
CUST0003,1,PROD0002,1,40,Test Discount,10,0
CUST0003,1,PROD0003,1,50,Test Discount,10,0

Discount Issues when changing imported Invoices & Orders

There is a Sage bug with Discounts, even though it only happens when orders are imported using a 3rd Party. The 3 potential workarounds are:
1. Add the field TAX_FLAG and populate it with a 0 (zero) When this field is on the CSV the tool ignores TAX_AMOUNT and lets Sage calculate the VAT. The only issue with this is that there are occasionally small penny rounding errors.
2. Instead of putting the discount on the front entry screen, edit the line of that product and enter the discount there.
3. After changing the discount re-select the Tax Code

Discount Notes when Importing CSV Files of Invoices & Orders

Description of Discount Field Names:
Is The Customer Discount as in the Customer Record.
Is The Quantity Discount as in the Product Record Discount Tables.
Is A Manual Discount is a Percentage
Is The Total of the above 3 discounts. Despite the name it is a Percentage Rate % not an amount.

Adept are Sage Platinum Partners for Sage 50 and certified Sage Developers