Some Microsoft Windows 10 users have recently been reporting that their Microsoft Excel either crashes or hangs regularly, particularly after the Windows 10 Anniversary Update to version 1607 in August 2016. In turn, this causes problems for Onion which needs a stable Excel to function correctly.
The issue can often be traced to printer driver incompatibilities with Windows 10 which affect the correct operation of Excel. Correct operation of Excel can usually be restored by temporarily setting your "Default" printer driver to either "Microsoft Print to PDF" or "Microsoft XPS Document Writer" until you can obtain a Windows 10 compatible printer driver from your printer manufacturer.
HP Laserjet users can find the "Recommended Solution" for their printer model at http://h20564.www2.hp.com/hpsc/doc/public/display?docId=emr_na-c04675396. Ignore the first entry in the table (Color LaserJet Family Driver (printer-specific)), it didn’t work for us!
Please don't hesitate to call us if you experience any problems with using our software with Excel on a Windows 10 platform.
First, you must download and install the 30 day free trial. That way you're sure the software will be worth the licence fee before you part with your money!
During the initial evaluation period (and coming to the end of your licence period) you will be provided with a countdown of the number of days to the end of your licence period. If there are any days left, there will be a [Continue] button (see below) which will bypass the licensing process and take you to the Onion software.
When you decide to buy a licence you will be asked to supply the Installation Code from your machine. An example is shown in the dialog box below. It is a simple process that is repeated for each machine:
Go to www.onionrs.co.uk and go to the Onion for Sage Licence details where you will see these details:
Following confirmed receipt of payment we shall email an Unlock Code to the registered email address. The Unlock Code should be copied to your clipboard using Ctrl+c (be careful not to include any additional characters before or after the code) and then pasted into the Onion Product Licence dialog using the paste clipboard icon to the right of the Unlock Code box. Clicking Register will activate the 365 day licence for the software.
We understand that, sometimes, time just gets away from you. Or, maybe, you had reviewed an older verson of the software and want to have a look at the most recent developments. Just call our helpline (+44 (0)28 9581 9815) and they'll be happy to provide a temporary licence.
We keep the versions in your downloads area up to date with the most recent minor version number. For example, if you order the v4.0.0.x download at a time when the most recent version is v188.8.131.52, and we subsequently release v184.108.40.206, the new version 220.127.116.11 is immediately available via your v3.0.0.x order in your downloads area. The complementary templates downloads are also kept up to date with later releases.
Additionally, the Onion version downloadable from the home page without logging in will always be the most recent version.
Onion doesn't require functioning Sage software on the same machine. All you need is ODBC access to your Sage data from the machine on which Onion is installed. Your Sage software installation disk contains an ODBC Install folder containing the software necessary to install the appropriate ODBC driver on any number of additional machines. There is also an ODBC driver installer in any Sage installation at a location such as C:\Program Files\Sage\Accounts\ODBC32. Open this and select "Setup" which will open a Wizard to install the "Sage Accounts ODBC". Even a single user Sage licence will allow ODBC access from any number of additional machines.
If you install Onion on a machine with only the Sage ODBC driver, but not the Sage program, you will need to follow the instructions in the next section "Onion hasn't been able to automatically detect my company data, what do I do?" to tell Onion where to find your company data.
If you have difficulties or questions please call our helpline on +44 (0)28 9581 9815.
There is an < Add / Remove a company > option when selecting a company.
To find out where a company's data file is located: in Sage, select Help | About and note the location.
If you continue to have difficulties please call our helpline on +44 (0)28 9581 9815.
So long as you've configured your chart of accounts to display an overdrawn bank position as a liability, Onion will do the same.
Yes, it is transaction based and not limited by the balances maintained by Sage.
Yes. Use the Change reporting year tickbox when running Onion.
Onion uses transaction based reporting. The bigger the company, the more transactions. Consequently, whilst it may still be possible to create an Onion workbook for a very large company, it may not be practicable because of the size of the Excel file generated or because the processing time becomes too long. Small companies (e.g. the Sage demo company) should process in 40 seconds or so. Obviously bigger companies take longer. We're aware of customers running Onion on quite large data sets. In the event that you encounter an Out Of Memory error message using Onion (only likely with very large data sets), please download Onion Extra which has the same functionality as Onion but is known to work with data sets as big as 1,300,000 transactions.
We'd appreciate feedback on running times / file sizes for your companies via our Contact Us page.
Secuity is the user's responsibility. Be careful how you use and store Onion outputs. Use Excel's document encryption options by all means, but be aware that Excel passwords are notoriously easy to crack. Another option is to zip the Onion workbook using a password protection capable zip program (e.g. 7-Zip) . Do your own investigations and testing and decide what is best for you.
Yes. You can filter data by Department and Onion produces departmental TBs to interface with a free template for enhanced departmental presentations. Contact Us if you'd like to know more.
No. Depending on demand, we might add it to our "to do" list. Let us know if you'd like this facility via our Contact Us page.
Yes, the Onion workbook incorporates standard budget reporting at present. Additionally, we have a free Budgeting template designed to work with the exportable Onion TBs to provide extremely flexible off-system department level budget maintenance and reporting capabilities. Contact Us if you'd like to know more.
Yes, we have a free template that provides a user customisable approach to consolidation incorporating consolidation adjustments. Contact Us if you'd like to know more.
If you find that copy and paste between workbooks refuses to ignore hidden rows it might be that the two workbooks are in different instances of Excel. Try opening the two workbooks from the same Excel screen.