QuickBooks Asia

Tax account does not exist

Some user who uses QuickBooks Asia version 2007/08 had this error ‘Tax account does not exist’. This error was caused by corruption in tax setting (G.S.T.). When you perform a Verify and Rebuild data, QuickBooks does not pick up this error; user has to manually edit the setting to correct this error.

Before you edit your QuickBooks setting, it is best to back up your QuickBooks data. 

Then, from the Edit menu | select Preferences function. In the Preferences Window, go to Tax Preferences; then, follow by Company Preferences tab. Next, check the ‘NO’ radio button selection for ‘Do you track tax?’. Save your setting and exit Preference setting.

Next, you go back to your Tax Preferences Window and select ‘YES’ radio button selection for ‘Do you track tax?’. This will re-active your QuickBooks tax account.

The above will resolve the error on ‘Tax account does not exist’; try it, if you have a similar problem.

 

 

Foreign Opening Balance amount in Custom Transaction Detail Report was not sum up

Some of the user did mention that when they creating a report using Custom Transaction Detail Report; the Foreign Open Balance field was not sum up at the bottom of the report. Comparing with the Open Balance column (Home Currency), the Open Balance field did sum up at the bottom but Foreign Open Balance was showing ‘0.00’.

 

Was it a bug? Any work around solution?

Am not sure was it considered as a bug to Reckon. However, I do have a work around solution for this. To display the Foreign Open Balance with a total of this column simple export it to Microsoft Excel. To export the report, click the ‘Export’ button at the top of the report. In Microsoft Excel, this report does show the total amount of Foreign Open Balance column.

 

In Microsoft Excel, the total field has a formula of [ =ROUND(SUM(Sheet1!P2:Sheet1!P5),5) ], am not sure why the original report in QuickBooks was not total up.

Hope this is helpful to you.

QuickBooks template crashed

Lately, my customer, Mr. Andy Wilkinson, had done some “R&D” on QuickBooks template – He crashed it! He found a limitation in QuickBooks template.

Thanks! Andy.

I do not think many of you will get this error, however it is good to know this limitation.

I did a test myself on the QuickBooks 2009/10 Asia edition and confirmed that the maximum number of characters for Template was only up to 41characters (41 characters is a lot, it is good enough for most of us). When I use 42 characters, it crashed when I click on the Layout Designer. 

Reckon (developer of QuickBooks Asia) should set a maximum character limit in the Template Name field to prevent user from accidentally entering a Template name that is more than 41 characters.

For user who likes to have a long template name, please take note of this limitation.

If you discover something new in QuickBooks, do drop me a message, so I can share it out here with all the QuickBooks user.

You must assign an account for this transaction

Lately, I have a few customers having the same error with QuickBooks (Version 2004, 2005/06 and 2007/08). When they try to enter an invoice or bill, QuickBooks prompted an error message ‘You must assign an account for this transaction’.

I have checked both Chart of Accounts and Item list; it does not seem to have any issue. Besides, no error found when I run a Verify Data and Rebuild Data. It just not allows me to save the transaction. What could be the problem?

I did a test, I removed the ‘Require accounts’ setting from the Preferences. I did an Invoice again, since I removed the Require Accounts setting; it allows me to save the transaction. From the transaction journals, I found that the Tax Payable account was missing. Instead of crediting the Tax Payable account it crediting Uncategorised Income account. Ha! I found the problem.

It seems that the Tax Code, Tax Preference or Tax Payable account was having a problem; it may be corrupted and cause the selected Tax Code not able to register with the associated Tax Account. I turn off the Tax Preferences, save it. Then, I turn on the Tax Preferences back again to allow the setting to refresh. Next, I set the ‘Require Account’ back to its original setting.

I entered an invoice again, this time I can save the transaction without an error message prompted. I view the transaction journal, it presented nicely with debiting of Accounts Receivable account and crediting both Sales and Tax Payable account.