Sage v27 & the T18 Tax Code – 17/05/21

A Bug in the Sage SDO Engine

We have discovered a bug in the Sage v27.1 SDO Engine when using the new T18 Tax Code. Our Transaction CSV Tool is correctly dealing with the Liabilities in Box 5, but due to the bug in Sage it has not been increasing Boxes 1 & 4. DON’T PANIC! The amount you have paid or been refunded by HMRC for VAT is correct.

Solution : Download the new v27 (we are expecting this to become v27.2) standalone SDO installer from here. This ZIP File contains a folder with 4 files. After unzipping, you must run the file called Sage50Accounts_SDO.msi and follow the instructions on screen.

The Adept Team

Sage Update

Transaction CSV – 05/05/21

List Mode with Specific Allocation Amounts

A new additional feature of List mode for Transaction CSV v27.0.73 is that you can specify the amount to be allocated to each invoice by including it in a NET_AMOUNT column.

For example, suppose you have 5 invoices for £100 each and you receive a payment for £200 that you want to allocate equally to all 5 invoices. A suitable CSV file is shown in the blog image.

If you had not included the NET_AMOUNT column the importer would have allocated £100 of the payment to invoices 30001 and 30002 and nothing to the remaining three invoices.

When the NET_AMOUNT column is left blank for a reference, the importer will allocate as much as it can to that transaction. If the NET_AMOUNT column contains 0 or 0.00 the importer will not allocate anything to the transaction with that reference.

List Mode with Amounts works ok with foreign currency accounts in Sage 50 versions 26 and higher. However, a bug in Sage 50 versions 23, 24 and 25 prevents it from working with foreign currency accounts in these versions.

The Adept Tools Team

New Nominal Code & Name – 20/04/21

Option to create a Nominal Code record if it does not exist

Another great new feature for the Transaction CSV Add-On Tool with v27.0.72. When using the NOMINAL_CODE field you can now set the Option to “Allow new Nominal Codes to be created” during the import.

A New field NOMINAL_NAME sets the name of newly created Nominal Codes in your Sage 50 or 50cloud Accounts package.

The Adept Tools Team

Postponed VAT Transactions – 02/03/21

New Sage import tax codes from 1 January 2021 – UK only

Sage 50cloud Accounts v27.1 introduces some new tax codes to make it easy to record EU and non-EU imports, but their in-built importer cannot yet deal with this! Adept have once again stepped up to the mark and made sure that our Transaction CSV Tool does import these new transactions correctly.

Here’s a simple CSV file:
PI,SEUR1,5000,1,15/02/2021,R04,D1,300.00,T18,60.00
PI,SEUR1,5001,2,15/02/2021,R04,D2,600.00,T18,120.00
PI,SEUR1,5002,3,15/02/2021,R04,D3,900.00,T18,180.00

If you try to load this CSV file Using Sage’s standard file import:

The same file successfully loaded by the Adept Sage 50 Transaction CSV add-on:

The Adept Tools Team

The results in Sage 50 after the Adept Import

Sales & Purchase Order CSV Add-Ons – 26/01/21

New STATUS column default options.

The STATUS column can now be used to instruct the Sales Order Add-On to set the STATUS of new sales orders to ALLOCATED by default and the Purchase Order Add-On to set the STATUS of new purchase orders to ON-ORDER by default.

  • Sales Order CSV v27.0.69 STATUS Column
  • Set Status to Allocated by default.
  • If you tick this box the program will automatically attempt to set the STATUS of newly imported orders to ALLOCATED.
  • If there is not enough free stock available to allocate to the order the STATUS will be set to either ORDERED or PART-ALLOCATED as appropriate.
  • Note that if you include a STATUS column in your CSV file then the contents of that column will override this setting.
  • Purchase Order CSV v27.0.64 STATUS Column
  • Set Status to Ordered by default.
  • If you tick this box the program will automatically set the STATUS of newly imported orders to ON-ORDER.
  • Note that if you include a STATUS column in your CSV file then the contents of that column will override this setting.

These great new features are available by selecting Menu>About>Check for Updates or by selecting Download Again from our Support Menu above.

The Adept Tools Team

Custom Alerts in Sage v27.1 – 21/01/21

If you are using Sage 50 v27.1 or higher you can now import Custom Alerts.

You can use these 3 Adept Add-On Tools to import into the New Sage Custom Alerts section. The Product & BOM CSV Tool, Customer CSV & Supplier CSV Tools can now import these alerts via a CSV File, this feature was the Top Rated Sage customer request!

In Sage 50cloud Accounts v27.1 you can add custom alerts on customer, supplier and product records. When you or a colleague selects the record during invoice or order processing, the message appears. It’s a simple and effective way to share important information and timely reminders.

When you create a new invoice, quote, sales order or purchase order, a customised alert can be set up to appear when you select specific customer, supplier or product. For example, a message can pop up as a reminder that this customer only orders a specific product.

NOTE: This is feature is available in Sage 50cloud Accounts v27.1 and above. Alerts for sales and purchase orders are only available in Sage 50cloud Accounts Professional.

Thank You for our CSV Add-OnsAdept Sage 50 Product & BOM CSV v27.0.65

  • ALERT_ADD Column – Enter the text of an alert that you want to add to the current product.
  • ALERT_REPLACE Column – Enter the text of an alert that you want to add to the current product. Before the Alert is added all existing Alerts for the current product will be deleted.
  • ALERT_DELETE Column – If you enter Y in this column all existing Alerts for the current product will be deleted. The default is N.
  • ALERT_POPUP Column – Y = Alert is a Pop Up. N = Alert is Embedded. Default is Y.
  • ALERT_ACTIVE Column – Y = Alert is Active. N = Alert is Inactive. Default is Y.
  • ALERT_ON_SO Column – Alert appears on Sales Orders Y/N. Default is Y.
  • ALERT_ON_QUOTE Column – Alert appears on Quotes Y/N. Default is Y.
  • ALERT_ON_INVOICE Column – Alert appears on Invoices Y/N. Default is Y.
  • ALERT_ON_PO Column – Alert appears on Purchase Orders Y/N. Default is Y.

Thank You for our CSV Add-OnsAdept Sage 50 Customer CSV v27.0.38

  • ALERT_ADD Column – Enter the text of an alert that you want to add to the current product.
  • ALERT_REPLACE Column – Enter the text of an alert that you want to add to the current product. Before the Alert is added all existing Alerts for the current product will be deleted.
  • ALERT_DELETE Column – If you enter Y in this column all existing Alerts for the current product will be deleted. The default is N.
  • ALERT_POPUP Column – Y = Alert is a Pop Up. N = Alert is Embedded. Default is Y.
  • ALERT_ACTIVE Column – Y = Alert is Active. N = Alert is Inactive. Default is Y.
  • ALERT_ON_SO Column – Alert appears on Sales Orders Y/N. Default is Y.
  • ALERT_ON_QUOTE Column – Alert appears on Quotes Y/N. Default is Y.
  • ALERT_ON_INVOICE Column – Alert appears on Invoices Y/N. Default is Y.

Thank You for our CSV Add-OnsAdept Sage 50 Supplier CSV v27.0.38

  • ALERT_ADD Column – Enter the text of an alert that you want to add to the current product.
  • ALERT_REPLACE Column – Enter the text of an alert that you want to add to the current product. Before the Alert is added all existing Alerts for the current product will be deleted.
  • ALERT_DELETE Column – If you enter Y in this column all existing Alerts for the current product will be deleted. The default is N.
  • ALERT_POPUP Column – Y = Alert is a Pop Up. N = Alert is Embedded. Default is Y.
  • ALERT_ACTIVE Column – Y = Alert is Active. N = Alert is Inactive. Default is Y.

These new features are available by selecting Menu>About>Check for Updates or by selecting Download Again from our Support Menu above.

The Adept Tools Team

Brexit! Love it or Loathe it! – 12/01/21

New import tax codes for use after 1 January 2021 – UK only

Sage 50cloud Accounts v27.1 introduces some new tax codes in the range T15 to T19, to make it easy to record EU and non-EU imports.

The UK’s withdrawal from the EU means that all imports and exports must now be treated the same for VAT purposes, regardless of their destination or origin. This affects the way you record EU and non-EU imports and exports within Sage 50cloud Accounts.

There is a new update for Sage 50cloud Accounts v27 which has some new tax codes to help process EU and non-EU imports and exports. Once the new update is installed, the first time you open your company, the five new tax codes will be created.

By default, these are in the range T15 to T19 but may differ depending on the tax codes you already use.

Sage have a Tax Code Finder Guide available here, which can be used to help determine the relevant tax code to use when posting sales or purchase transactions in Sage 50 & 50cloud Accounts.

The Adept Tools Team

Sales Order CSV Add-On – 07/01/21

Great new features keep on coming!

This new feature for Sales Order CSV has been requested plenty of times and we are now pleased to announce it’s release. It’s always been possible to set the Status Flags on SO’s but it’s never actually done the job in the background, well now it can with this great new feature!

The STATUS column can be used to instruct the importer to allocate available stock to the new Sales Order:

  • STATUS Column
  • ENTERED – (Default) The initial Status of a Sales Order after it has just been entered. 0 is the Numeric Value for this
  • ALLOCATED – The the importer will attempt to fully allocate stock to the Sales Order. 2 is the Numeric Value for this.
  • CANCELLED – Sets the Sales Order status to Cancelled. 3 is the Numeric Value for this.
  • HELD – Sets the Sales Order status to Held. 10 is the Numeric Value for this.
  • PART-ALLOCATED – Quantities to allocate should be set in a QTY_ALLOCATED column. 1 is the Numeric Value for this.

If there is insufficient free stock to fully allocate or part allocate stock to the order then the importer will allocate as much as it can and set the Staus of the order accordingly.

Additional statuses such as 8 = COMPLETED will be implemented in a future release of this program. For the moment status values 4 to 9 will not create an error however they will not update stock.

These great new features are available by selecting Menu>About>Check for Updates or by selecting Download Again from our Support Menu above.

The Adept Tools Team

Purchase Order Header CSV Add-On – 12/11/20

Another great new feature based on customer feedback.

This POP Header CSV Tool has always been able to set the Status Flags on PO’s but it’s never actually done the job in the background, well now it can with this great new feature! Setting the Status of an order to ON-ORDER will now update the product on order counts and Setting the Status of an order to COMPLETED can optionally update the product stock levels and create a GDN.

You can change the Status of a purchase order by including a column headed STATUS. Valid statuses are as follows (The numeric values for STATUS work as well):

  • STATUS Column
  • ENTERED – The initial Status of a PO after it has just been entered. 0 is the Numeric Value for this.
  • ON-ORDER – The PO has been sent to the supplier. Changing to or from this status will set the On Order quantity in any Stock Item Products accordingly. 2 is the Numeric Value for this.
  • CANCELLED – The PO has been cancelled. 3 is the Numeric Value for this.
  • COMPLETED – The Order has been fully delivered. 8 is the Numeric Value for this.

SUPPLIER_GRN Column
This column is used to set the Supplier GRN reference to be used on the Goods Received Note that is created when the STATUS is set to COMPLETED.

These great new features are available by selecting Menu>About>Check for Updates or by selecting Download Again from our Support Menu above.

The Adept Tools Team

POP Header in Action
POP Header CSV Import

Product & BOM CSV Add-On – 10/11/20

Another great new feature!

The Adept Sage 50 Product & BOM CSV Import & Export Tool is an extremely popular Add-On for Sage 50 and it’s got better again! We’ve added the option to be able to import a CSV File of Stock Category codes, see our Example CSV to the right >

This feature is available in Product & BOM CSV v27.0.64 which you can get by Checking for Updates or by selecting Download Again from our Support Menu above.

The Adept Tools Team

Product & BOM CSV Import Category

Adept Tools & Sage v27 (2021) – 05/10/20

And just like Magic, the entire Adept Add-On Tools range for Sage 50 & 50cloud have been upgrade to be be compatible with Sage 50 v27 (2021).

If your Adept Add-On is mission critical, before doing the next major version upgrade of Sage from “v26 or below to v27” you should check our website first.  There’s two places you can check to see your Add-Ons Sage version compatibility.

On our Category pages for the Add-Ons it can be seen in the top right hand corner of a Tools tile

On the Add-Ons Tool page in the Add-On Compatibility and Pricing Section

So that was pretty quick this year, especially as we got the Beta Version 3 weeks later then the rest! Here’s a link to help you upgrade your Adept Add-On to the latest version: Upgrading Adept Add-On Tools

The Adept Tools Team

Adept Computer Support Limited

Adept Add-Ons

How to check if your Adept Add-On is compatible with a version of Sage.

  • Currently this is showing that the Add-On works with Sage 50 & 50cloud v27
  • Unless otherwise stated, the Add-On will also work with any minor version number updates such as v27.1 or v26.2
  • Our Adept Add-On Tools are backwards compatible when it comes to Sage versions and most go back to v8, but you should check in the page for the Add-On you have before proceeding.

Upgrading to Sage v27 (2021) – 22/09/20

Sage have made a big mistake this year as they failed to provide us with the Beta Version of Sage v27 until today! We are now working hard to upgrade all of our Add-Ons for this new release of Sage 50cloud Accounts.

If your Adept Add-On is mission critical, before doing the next major version upgrade of Sage from “v26 or below to v27” you should check our website first.  There’s two places you can check to see your Add-Ons Sage version compatibility.

On our Category pages for the Add-Ons it can be seen in the top right hand corner of a Tools tile

On the Add-Ons Tool page in the Add-On Compatibility and Pricing Section

We’ve started work on the upgrades and last year we had the v26 release of our CSV Import & Export Add-Ons out before Sage was! However, don’t take this for granted (especially as we’ve only just got the Beta, 3 weeks late!) and please check as we’ve said above. Most of our Adept Add-Ons will be upgraded within 2/4 weeks of Sage v27 being released, with the exception of the Code Changers & Viewer Tools as these take a little longer to do.

The Adept Tools Team

Adept Computer Support Limited

Adept Add-Ons

How to check if your Adept Add-On is compatible with a version of Sage.

  • Currently this is showing that the Add-On works with Sage 50 & 50cloud v26
  • Unless otherwise stated, the Add-On will also work with any minor version number updates such as v26.1 or v26.2
  • Our Adept Add-On Tools are backwards compatible when it comes to Sage versions and most go back to v8, but you should check in the page for the Add-On you have before proceeding.

Add-On Compatibility and Pricing

  • Compatible with Sage 50 & 50cloud versions 8 to 26.

Sales Invoice, SO & PO CSV Add-Ons – 08/04/20

We’ve extended the Command Line features!

The recently added Command Line feature is already proving to be extremely popular and now we’ve added a few more options to the Export side of it. These new options apply to our Sales Invoice CSV, Sales Order CSV & Purchaser Order CSV Add-On Tools.

  • -B – Will Export a range of Invoices starting at invoicenumber. Change this text to for the Sales or Purchase ordernumber
  • -T – Will Export a range of Invoices ending at invoicenumber. Change this text to for the Sales or Purchase ordernumber
  • -O – Will Export a single Invoice number invoicenumber. Change this text to for the Sales or Purchase ordernumber
  • -R – Will Restrict the Export to Invoices or Orders with Customer or Supplier Code accountref

These great new features are available by selecting Menu>About>Check for Updates or by selecting Download Again from our Support Menu above.

The Adept Tools Team

Import Products & BOM into Sage 50

Product & BOM CSV Add-On – 20/03/20

Some great new features!

The Adept Sage 50 Product & BOM CSV Import & Export Tool is an extremely popular Add-On for Sage 50 and it’s just got better! We’ve added several great new features as described below.

There’s 4 new fields available to use:

  • BOM_TRANSFER Column – This column will allow you to trigger a BOM Transfer from a CSV file. You should put the quantity that you want to transfer in this column. Use zero or blank on rows that you don’t want to trigger a transfer for.
  • BOM_OUT Column – Similar to the BOM_TRANSFER column except that it creates the MO transactions for the components but does not create an MI transaction for the assembly itself.
  • ADJUST_OUT Column – Enter a quantity to Adjust Out in this column. If the quantity is non zero the program will create an AO stock transaction and set the Quantity in Stock accordingly. If Allow Negative Stock is turned off in Sage the program will report an error if the Adjustment Out quantity is greater than the current Free Stock level.
  • ADJUST_IN Column – Enter a quantity to Adjust In in this column. If the quantity is non zero the program will create an AI stock transaction and set the Quantity in Stock accordingly.

Another new option which has already been added to other CSV Add-Ons is the ability to run the program from the command line.

  • -F Specifies the CSV file to Import
  • -E Specifies the CSV file template to load for an Export
  • -P Specifies the Sage company to be used
  • -I Will exclude Inactive Products
  • -B Will Export a range of Products starting at
  • -T Will Export a range of Products starting at
  • -O Will Export a single Product

These great new features are available in Product & BOM CSV v26.0.60 which you can get by Checking for Updates or by selecting Download Again from our Support Menu above.

The Adept Tools Team

Sage 50 & 50cloud Accounts Authorised Product
Import Products & BOM into Sage 50
Import Products & BOM into Sage 50
Import Products & BOM into Sage 50

Allocating Customer & Supplier Payments – 13/02/20

A great new feature!

The Adept Sage 50 Allocate Payments Tool is already fantastic Add-On for Sage, allowing you to match outstanding invoices and payments together that are already entered on the Sage 50 & 50cloud Accounts Sales & Purchase Ledgers.

We’ve added a Configurable option to match transactions by reference which can also be Case Sensitive. There’s New Field Boxes for each transaction type that you want to match, use the drop down box to select the field that contains the reference to be matched.

With the New Word Boxes, for each transaction type you can select which word in the selected Field should be used as the reference to be matched. Examples are also provided for Sage Sales Order SA’s & OrderWise Matching.

Another new feature once again based on customer feedback, you talk and we listen! 😉

The Adept Tools Team

Sage 50 & 50cloud Accounts Authorised Product
Allocate Supplier Payments in Sage 50

Sage Accounts Date Criteria – 06/01/2020

Still defaulting to 31/12/2019?

If your currently using Sage 50 or 50cloud Accounts v25 or below you’ll notice that every time you go to run a Report or Layout that includes a date Criteria, the “To” Date or “and” (as the screen shot shows) is stuck on 31/12/2019.

This date criteria default has now been updated by Sage to 31/12/2050 but this change is only available in the latest release of Sage 50 & 50cloud Accounts v26.

Some users may still be experiencing this issue even though they are on v26, in this case the v26.2 Update will resolve it, with the exception of some of your Customised Reports. Click here to see how you can resolve this issue with your customised Reports & Layouts that the date is not changing on.

Sage v26 has also had a couple of Service Packs released, most of us are on v26.1.99.0 but v26.2.139.0 has been deployed to some users and is available to download from the public Sage Updates page.

Danny
Sage 50cloud Accounts Specialist

Sage 50 v26 Report Criteria
Sage 50 v26 Report Criteria

Festive Opening Hours at Adept – 02/12/19

Our phone lines will be closing.

The Adept phone lines will be closing at 5pm on Friday 20th December 2019 and will re-open at 9am on Friday 3rd January 2020. During this time we’ll be offering limited Email Support & Data Repair Services.

During this time when the Telephone lines are closed our Email Support will continue, though response times will be slower than usual I’m afraid. You can still get Trial, Full & Annual Renewal Licences as our systems for this are Automated.

Don’t Panic! This great new website of ours has plenty of Help material and Videos available from the Support Menu & YouTube link above, including the most popular Add-On FAQs, Installation, Upgrades, Annual Licence Renewals, Downloading Again and much more. You’ve also got your Help documentation for the Adept Add-On which you view by selecting Menu>Help.

If you do experience any issues with an Annual Renewal on our preferred Payment Providers website, please email us and we’ll send over a payment link from our secondary provider, please note that there may be a delay of 24/48 hours before you receive this request.

The Adept Team

Salisbury Cathedral
Xmas at Adept

Sales Invoice & Sales Order CSV Add-Ons – 07/11/19

A great new feature!

These are already fantastic Add-Ons for Sage and Sales Invoice CSV has been our most popular Tool over the last 3 Years with Sales Order CSV not that far behind.

We’ve added a field called DELIVERY_DESCRIPTION. To select a delivery address from the customer’s list of delivery addresses enter its description in this column.

As long as it exists, the importer will automatically populate the following fields in the invoice with the data from the selected customer delivery address: DELIVERY_NAME, DEL_ADDRESS_1 through to DEL_ADDRESS_5 and DEF_TAX_CODE.

This feature was again based on customer feedback, you talk, we listen! 😉

The Adept Tools Team

Sales Invoice CSV in Action
Sales Order CSV in Action

Transaction CSV Add-On – 27/09/19

We’ve added some great new features!

This was already a fantastic Add-On for Sage with all it’s features including the import and auto allocation of Sales Receipts & Purchase Payments, but it’s now got even better! These new features were based on customer feedback, so if you talk, we listen!

Adept Sage 50 Transaction CSV Add-On for Sage 50 & 50cloud

The column headings in the first line of the CSV file can now be used to define the fields that the data should be imported into.

This is what we refer to as Field Choosing and it was the only Adept CSV Add-On that didn’t have the feature. The Legacy CSV Format is still available and working if your happy with how your current file looks.

A new Export option will load your CSV template with transactions from your current Audit Trail. Once again, most of our other CSV Add-Ons could do it already so it was about time this Tool did too.

Part of the new Exporting options is a New export only field called TRAN_NUMBER which can be used in a template to include Transaction Numbers in an exported CSV file.

You can now define a default value for any column by adding =Content to the heading row field name, for example TYPE=SI as the heading for a blank column means that all the transactions in the CSV file will be SI transactions.

The final new feature is another New field called HEADER_DETAILS which will allow you to import or export the Header Details field separately from the Split Details field.

We hope you like these new upgrades to the Transaction CSV Add-On!


The Adept Tools Team

Transaction CSV New Advanced Field List
Transaction CSV Legacy File Format

Add-Ons & Sage v26 (2020) – 16/09/19

Adept Add-On compatibilty with Sage v26

All of our Adept Add-On Tools have now been upgraded to v26 so are now compatible with the new release of Sage 50 & 50cloud Accounts v26 (2020). The Adept range of Add-On Tools are also compatible with minor Sage version numbers, including v26.1 which is currently available on Sage’s download page. There’s two places you can check to see your Add-Ons Sage version compatibility.

On our Category pages for the Add-Ons it can be seen in the top right hand corner of a Tools tile

On the Add-Ons Tool page in the Add-On Compatibility and Pricing Section

The new Sage 50 & 50cloud v26 (2020) was deployed to a small number of customers via auto-update on 11th September 2019 and is phasing to the remaining customer base over the course of the next few weeks, who are likely to get v26.1 when they upgrade.

The Adept Tools Team

Adept Computer Support Limited

Adept Add-Ons

How to check if your Adept Add-On is compatible with a version of Sage.

  • Currently this is showing that the Add-On works with Sage 50 & 50cloud v26
  • Unless otherwise stated, the Add-On will also work with any minor version number updates such as v25.2 or v26.1
  • Our Adept Add-On Tools are backwards compatible when it comes to Sage versions and most go back to v8, but you should check in the page for the Add-On you have before proceeding.

Add-On Compatibility and Pricing

  • Compatible with Sage 50 & 50cloud versions 8 to 26.

Upgrading to Sage v26 (2020) – 16/08/19

Is my Adept Add-On compatible with Sage v26?

If your Adept Add-On is mission critical, before doing the next major version upgrade of Sage from “v25 or below to v26” you should check our website first.  There’s two places you can check to see your Add-Ons Sage version compatibility.

On our Category pages for the Add-Ons it can be seen in the top right hand corner of a Tools tile

On the Add-Ons Tool page in the Add-On Compatibility and Pricing Section

We’ve already started work on the upgrades and last year we had the v26 release of our CSV Import & Export Add-Ons out before Sage was! However, don’t take this for granted and please check as we’ve said above. Most of our Adept Add-Ons will be upgraded within 2/4 weeks of Sage v26 being released, with the exception of the Code Changers & Viewer Tools as these take a little longer to do.

The Adept Tools Team

Adept Computer Support Limited

Adept Add-Ons

How to check if your Adept Add-On is compatible with a version of Sage.

  • Currently this is showing that the Add-On works with Sage 50 & 50cloud v25
  • Unless otherwise stated, the Add-On will also work with any minor version number updates such as v25.1 or v25.2
  • Our Adept Add-On Tools are backwards compatible when it comes to Sage versions and most go back to v8, but you should check in the page for the Add-On you have before proceeding.

Add-On Compatibility and Pricing

  • Compatible with Sage 50 & 50cloud versions 8 to 25.

Summer Break at the Adept Office – 29/05/19

We’ll be closed for a rare Summer Break

The Adept offices will be closed on Thursday 30th May for a long overdue and very well deserved break! Once our power packs are fully recharged and we’ve updated some of our systems, we’ll re-open the office doors on Thursday 20th June 2019.

During this time our Telephone lines will closed but our Email Support will continue, though response times will be slower than usual I’m afraid. You can still get Trial, Full & Annual Renewal Licences as our systems for this are Automated.

Don’t Panic! This great new website of ours has plenty of Help material and Videos available from the Support Menu & YouTube link above, including the most popular Add-On FAQs, Installation, Upgrades, Annual Licence Renewals, Downloading Again and much more. You’ve also got your Help documentation for the Adept Add-On which you view by selecting Menu>Help.

If you do experience any issues with an Annual Renewal on our preferred Payment Providers website, please email us and we’ll send over a payment link from our secondary provider, please note that there may be a delay of 24/48 hours before you receive this request.

The Adept Team

Keep Calm
Taking a Break

Making Tax Digital for VAT – 23/05/19

Are you under the threshold for VAT?

Making Tax Digital for VAT (MTDfV), the new regime for VAT record keeping and VAT return submission is now live. All businesses with a taxable turnover over the £85,000 VAT registration limit come within the new rules with a few exceptions.

What if my business is a voluntary VAT Registration and is under the VAT registration limit?

If your turnover is below the VAT registration limit, you don’t have to enter MTD for VAT. You can carry on filing as you do at present which sounds to me like the HMRC VAT submission portal will still allow us to submit our return directly on the HMRC website. But if you prefer, you can join MTD for VAT voluntarily.

Danny

MTD for Sage 50cloud
Making Tax Digital

Adept Add-Ons QualiTest Update – 07/05/19

23 Adept Tools were tested in the 5 Days

I say 23, it was actually 20 Add-Ons tested but our Adept Viewer comes in 3 versions, Lite, Mid & Pro so this effectively counts as 3 in my book 😉

The other addition to the total was our Adept Tools Menu which was used by QualiTest to run any of our Add-Ons who’s Icons were not showing on the Sage toolbar due to Sage’s limit of 10.

Here’s the full list of the Sage Approved Certified Solution Add-Ons from our Adept Tools range:

Address CSV | Back to Back Orders | BOM Tools | Company Viewer Lite | Customer CSV | Health Check | INV Header CSV | Multi Location Stock Tool | Order Viewer Pro | Own Part Numbers | POP Header CSV | Price CSV | Product & Account Code Changer | Product CSV | Product Viewer Mid | Purchase Order CSV | Sales Invoice CSV | Sales Order & Invoice Entry | Sales Order CSV | SOP Header CSV | Supplier CSV | Tools Menu | Transaction CSV

Don’t be put off if your looking at one our Add-Ons without the Sage Certified logo, we only had 5 days for Testing and at £2500 a go it’s not a cheap process! Please rest assured that the remaining Adept Tools not tested all have the same quality of code for a simple and effective end user experience.

Danny

Adept 25 Years
Sage 50 & 50cloud Accounts Authorised Product
QualiTest
Adept Gold Sage Developer

Adept Sage 50 Transaction CSV – 29/04/19

Transaction CSV v25.0.53 New Features

By popular demand our Adept Sage 50 Transaction CSV now allows you to map the columns of your CSV file by using Sage’s field names in the first row of the CSV file. This new feature brings the Transaction CSV Importer in line with all our other importer products which already have this ability.

Historically this importer was first sold in 2007 to a charity who needed to import the Charity Fund Number. The initial design used the same fixed format CSV layout as Sage’s standard file import with an additional column for the Fund Number. Since then a plethora of new features have been added to the program which has taken the column count to a rather unwieldy 34.

The new feature will make it easier to import CSV files whose columns don’t follow the standard Sage layout. It will also allow you to eliminate columns that are not required.

An additional new feature will allow you to declare a default value for a column by adding =Content to the heading row field name. For example TYPE=SI as the heading for a blank column means that all the transactions in the CSV file will be SI transactions.

Please note that in order to maintain backwards compatibility for existing users these new features have to be turned on by ticking the “Heading row is column field name map” box in the program’s options.

Valid field names can be seen on the image to right. You can see this list within the program by clicking the Menu button and selecting the menu option Fields.

Martin

Sage 50 & 50cloud Accounts Authorised Product
Transaction CSV New Feature

Easter Opening Hours at the Adept offices – 16/04/19

We’ll be closed over the Easter weekend

The Adept offices will be closed this Easter weekend on Friday 19th to Monday 22nd April and will re-open at 9am on Tuesday 23rd April. Enjoy your time off and don’t eat too much chocolate! 😉

Danny

Easter Opening

5 Days QualiTesting completed with a 100% pass rate! – 02/04/19

We expected nothing less for 20 of our most popular Add-Ons

We’ve spent the last 5 days working with QualiTest who are Sage’s official testing partners. We are proud to announce that every Adept Add-On Tool tested passed and a rate of 100% was achieved.

Danny

Sage 50 & 50cloud Accounts Authorised Product
QualiTest

It’s back, 3rd time lucky for the v25.1 Update – 15/03/19

Minor issue with update v25.1.114.0 that Sage pulled this week.

Sage have released another update (3rd Time Lucky!) to resolve the minor issues identified with v25.1.110.0 and v25.1.114.0 . This means the latest build for Sage 50cloud Accounts is now v25.1.121.0

This 3rd new v25.1 Update is available to download now from Sage’s Update page which you can get to by clicking here.

Danny

Sage v25 Update
Sage 50cloud

Here we go again! Another update pulled! – 14/03/19

Another day and another update that’s no longer available to download

Have your Sage 50 Accounts v25 Add-Ons stopped working with an error message: “Data files are wrong minor version” ❓ The reason for this is that you server has just auto updated its data services to version 25.1 without telling you.

Sage have pulled this second update from their website which was 25.1.114.0

Our Solution : Download the v25.1 standalone SDO installer from here This ZIP File contains a folder with 4 files. After unzipping, you must run the file called Sage50Accounts_SDO.msi and follow the instructions on screen.

Danny

Sage Update
Failed to Connect to Sage Data

Beating Overzealous Spam Filters – 13/03/19

Adept Add-On emails for Trial Licences going into the spam?

We have recently noticed that some customers have only been receiving 1 of the 2 emails that are sent when they use our online systems to apply for a trial licence. It turns out that the first and most important email is being rejected because it contains a link to the Add-Ons installation .exe file.

To get round this we have changed the first email to point to a modified version of our “Download Again” web page. All you need to do now is just click on the link in the email, a web browser will open and the download will begin.

Martin

Spam
Sage 50 & 50cloud Accounts

Sage 50cloud Accounts v25.1 Update – 05/03/19

Minor issue with update v25.1.110.0 that Sage pulled last week

Sage have now released an update to resolve a minor issue that was identified with v25.1.110.0 (see our blog post below from 28/02/19). The latest build for Sage 50cloud Accounts will install v25.1.114.0

The new v25.1 Update will be deployed to a small number of customers via auto-update from today, then phased to Sage’s remaining customer base over the course of the next few weeks. This update is also available now from Sage’s Update page which you can get to by clicking here.

Danny

Sage v25 Update
Sage 50cloud

Data files are wrong minor version – 28/02/19

Have you had the message “Failed to connect to Sage Data – (26) Data files are wrong minor version”

Have your Sage 50 Accounts v25 Add-Ons stopped working with an error message: “Data files are wrong minor version” ❓

The reason for this is that you server has just auto updated its data services to version 25.1 without telling you. It appears that the Sage 50 Client UI v25.0 is happy to connect to to a server running the 25.1 data services. However the v25.0 SDO (used by Sage Add-Ons) fails to connect with the above error message. 🙁

Sage have now pulled this update from their website with a new release date of week commencing Monday 4th March.

Solution : Download the v25.1 standalone SDO installer from here This ZIP File contains a folder with 4 files. After unzipping, you must run the file called Sage50Accounts_SDO.msi and follow the instructions on screen.

Martin

Sage Update
Failed to Connect to Sage Data

Missing Transactions on VAT Returns – 18/02/19

If you are using Sage v23 or v24 you may have an issue with your VAT Return

Sage have identified a small issue in Sage 50 Accounts, but don’t worry they’ve got it covered! If you run your VAT Return up to the period ending March 2019, the transactions for 31 March 2019 are not appearing.

To make sure your calculations are correct when submitting your VAT Return, you’ll shortly receive an automatic update, which Sage recommend you install. Alternatively, you can download and install the update now or follow a manual workaround.

To find out how to do this, click here for v23 and click here for v24

Please note: You need to take action before submitting your return to HMRC if you have transactions dated 31st March 2019.

Danny

Sage 50cloud Accounts
Sage 50cloud
Don't Panic
Adept are Sage Platinum Partners for Sage 50 and certified Sage Developers