QuickBooks Asia

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.

Account is not in Account List

[I use account code for my accounts in the Chart of Accounts list. While creating an item in the item list, I try to select the account in the associated account field but it prompts me, either "account is not in Account list" or "account cannot be added. QuickBooks cannot add more than one level to the Account list at a time". ]

What is the problem? 

The account was already created in the Chart of Accounts list, why can’t I simply select it for my new item?

This is a common issue that the Asian user had when using QuickBooks with East Asian languages.

QuickBooks is not design to use with East Asian Fonts such as Chinese, Japanese or Thai. When user installed QuickBooks in a Computer that has an East Asian Language installed such as Chinese, Japanese or Thai languages. User will not be able to use the account number in QuickBooks. 

Why is it so?

When QuickBooks account number is turned on, from the Chart of Accounts list, you will see a “?”, “#” or a “@” symbol between the Account Number and the Account Name. This is due to the Uni-code in the East Asian language has replace the hidden code between the Account Number and the Account Name into a East Asian Language Symbol.

To resolve it, you have to turn off the Account Number from your Preferences window. Once you have turned off the Account Number, you will be able to use your QuickBooks as usual; “Accounts is not in Account list” error message will stop prompting you.

What if account number is very important to you, how should you continue using account number with East Asian Language running side by side with QuickBooks?

The workaround solution you can consider will be:

• Turn off the Account Number feature in QuickBooks.
• Enter your account number in the Account Name field. Example: if your Bank account’s account number is 100-101, then, you may record the Account Name for your Bank account as “100-101 – Bank Account”. 

Note: The maximum number of characters for Account Number is 7 Characters.

Hope this is useful to you, you may consider to sign up my QuickBooks training to understand fully how QuickBooks can work for you.

Maximum number of list items and transactions in QuickBooks Asia 2009/10

Few days ago, while I was browsing the Reckon’s FAQ’s, I discovered this useful information and I think QuickBooks user will benefit from it.

Under Reckon’s FAQ ID: Q11873, it stated the Limitations in QuickBooks QBi 2008/09 (that is Asia’s version 2009/10).

Maximum number of transactions:

QuickBooks can handle a maximum of 2 billion transactions. The maximum number of transactions is limited more by your computer’s disk space and memory than by QuickBooks.

Maximum number of items in each individual list:

QuickBooks Accounting to QuickBooks Premier Version:

    Account List: 10 000

    Name List *: 14 500

    Item List: 14 500

    Class List: 10 000

    Terms List: 10 000

    Customer Type List: 10 000

    Shipping Method List: 10 000

    Customer Message List: 10 000

    Payment Method List: 10 000

    Memorised Transaction List: 14 500

    Memorised Report List: 14 500

    Template List: 10 000

    Payroll Item List: 10 000

    To Do Note List: 10 000

    Job Type List: 10 000

    Sales Rep List: 14 500

    Price Level List: 100

    Tax Code List: 10 000

    Currency List: 10 000

    Attribute Definitions List: 10 000

    Vehicle List: 10 000

    Workers Comp Code List: 10 000

    Billing Rate Level List: 100

    Payment Template List: 10 000

    U/M Set List: 100 000

    Payroll Schedule List: 200 

Note:  * Employees, Customers, Suppliers and Other Names added together cannot exceed the 14 500 combined.