The best way to install Microsoft SQL Express is to install
from AutoCount Accounting CD.
This is because if you installed SQL Server from AutoCount
Accounting CD, we will always install it as A2006 instance
This problem is because there are some delay during Get Available
Server which makes you cannot find it in the list, if you are sure
your server name, you can type your server name and follows by \A2006
to specify the A2006 instance.
This is because you have not created any database in the
The most likely reason is the SQL Server is blocked by
firewall. The firewall might be Windows XP Service Pack
2 firewall or Windows Vista firewall, or other third-party
firewall which comes with anti-virus software or anti-spam
software. You should add an exception to the firewall or
turn off the firewall in order to make it work.
By default, if you install SQL Express using AutoCount
Accounting CD, the setup program will automatically add
exceptions to your Windows Firewall, so you don't have
to do anything in order to allow other PC to connect to
the server. However, if you found it not working, you can
run a program called SQLUtility which is available in the
AutoCount Accounting CD to help you add exceptions to
Please refer to the documentation or online help of the
software for how to do it.
You can go to File and select Manage Account Book, select
Attach Account Book then click on Get Available Server and
select server. After that, click on Get Available Database
and select AED file to attach.
You can save AutoCount Accounting Data folder at drive C
before format your PC. Once you had formatted your PC and
reinstall AutoCount Accounting, you can go to File, select
Manage Account Book and click on Attach Database File. Click
on Get Available Server to select your PC server which is in
this format, your computer name/A2006. Then, browse at Physical
Data File column and select file from AutoCount Accounting
folder. Click OK once you had selected the file.
Yes, you can do it in AutoCount Accounting Management
Studio. To transfer data from UBS, you can go to Data
Upgrade tab and select either UBS Accounting 9.1 or
UBS Stock 9.1. To complete data transfer, you can click
on Browse to specify your UBS data folder, select Import
Option (Import Items, Import Debtors, Import Creditors or
Import Past Year Price History Record) and click Import.
Product ID is product serial number which registered items
sold. It displayed at the side of CD cover.You are required
to register your product with Account Book Registration Code
to indicate modules, features and other setting purchased.
You will receive Account Book Registration Code from us either
by email or fax.
Without this, you will not be able to create new entry once
it exceeds 500 entry limits.
To register your product, you can go to Tools and select Account
Book Registration. Here, you can enter your Product ID, edit
company profile and enter Registration Code to complete
To install AutoCount Accounting in Server PC,
To install AutoCount Accounting in client PC,
This is because the PC has not installed Microsoft .Net Framework 2.0.
A document in AutoCount Accounting means a transaction
used for recording data which occurred at a specific
date. The standard documents in AutoCount Accounting
consists of G/L documents, A/R documents, A/P documents,
Sales documents, Purchase documents, Stock documents, and
First, open the document to view, then click the Cancel
Document to cancel it.
Right click any column, go to Column Chooser to customize
grid layout. You can add / remove by drag-drop the column.
Then, right click any column and select Save Grid Layout.
Right click again any column and select Layout Manager. Here,
you can assign different layout for different users at Assign
Layout to Users tab.
This means you are not allowed to use the function. If you
really want to use the function, you should consult your AutoCount
administrator to give you the access right.
If you have administrator right, you can go to General
Maintenance and select User Maintenance. To change
access right setting, select Access Rights button.
On the Access Rights tree list, find your access right,
then tick the users you would like to add to, then click
You can go to General Maintenance and select Document
Numbering Format Maintenance. Here, you can set numbering
for different categories of document, e.g. GL,
Manufacturing, Purchase, Sales and Stock.
After edit document numbering, you can go to General
Maintenance and select Payment Method Maintenance.
Select bank under Payment Method column to edit it.
You can then set document numbering at Payment Document
Numbering Format and Receive Document Numbering Format.
To lock accounting period, you can go to Tools and select
Manage Fiscal Year. Then, select fiscal year and click on
Manage Period Lock. Manage Exceptions is to exclude
certain user groups / individuals from locked by certain
You can go to Tools and select Options. Then you can
select General folder and tick on Decimals.
You can create new fiscal year. To do that, you can go to
Tools and select Manage Fiscal Year. Then, highlight
Fiscal Year 2007 and click on New Next Fiscal Year to
create Fiscal year 2008.
First, you need to create fiscal year for year before. To
do that, you can go to Tools and Manage Fiscal Year. Then,
highlight Fiscal Year 2007 and click on New Previous Fiscal
Year to create Fiscal year 2006.
Transaction (Invoice, Debit Note, etc) which the date is
earlier than fiscal year 2007 will be automatically
classified as Opening Balance for Debtor.
To do depreciation, you can go to GL and select Journal
You only need to enter total lam sum in the nearest month
column from your Actual Date Start Date. For example, your
Actual Date Start Date is on 1/9/07. To edit year to date
balance, you only need to enter total lam sum in August
To check your Actual Date Start Date, you can go to Tools
and select Manage Fiscal Year.
To create new bank account, you can go to GL and select
Account Maintenance. Click on Bank, Cash, Deposit under
New Special Account. Your new bank account will not
appear if you create with New Normal Account.
To create new deposit account, you can go to GL and select
Account Maintenance. Click on Bank, Cash, Deposit under New
Special Account. Your new deposit account will not appear if
you created with New Normal Account.
First, you should make sure your Opening Balance is balance.
And you must make sure the amount in Balance Stock Account in
Opening Balance must be same as the amount of the previous month
of fiscal year start date of Stock Value Maintenance.
Go to GL and select financial report (Balance Sheet,
Profit & Lost or Trial Balance). Before preview, tick
on Show Zero Balance option at the right.
You can go to GL and select financial report (Balance Sheet
Statement, Profit and Lost Statement or Trial Balance Report).
Here, you can select project under report format.
To do deposit, go to AR and select AR Deposit Entry. Click
on Create a new AR Deposit, select Deposit Account and
Debtor Code, select Payment Method and enter other relevant
To refund or forfeit deposit received, you can go to AR and
Select AR Deposit Entry. Select deposit transaction in
listing screen and click on View. Then, click on Forfeit &
Refund. Here, you can perform both forfeit and refund
function at the same click. Click Save once you had completed
To transfer deposit into received payment, you can go to
AR, select AR Received Payment and click on Create a new
AR Payment. Once debtor code selected, select Deposit
Received under Payment method. Tick to indicate which
Invoice / Debit Note to be knock off. Click Save to
complete the entry.
Forfeit / Refund function at AR Deposit Payment is to
refund deposit while AR Refund is to refund advanced
payment back to customer. For example, Debtor A had
paid RM 100 deposit to purchase an item. For some
reasons, Debtor A canceled the purchase. So we refund
RM100 back to Debtor A with Forfeit / Refund function
at AR Deposit Payment.
If Debtor A had advanced payment of RM 100, we will
refund the RM 100 back to Debtor A in AR Refund Payment.
Yes, you can do it. But first you need to know how to
use report designer.
The calculation is based on Invoice and Received Payment.
You can go to General Maintenance, select Sales Agent
Maintenance and click on Commission to set commission
percentage of your sales agent.
You can click on More Option after open Debtor Statement
Report / Debtor Aging Report. Tick Show in Local Currency
and select currency that you want to display in the report.
You can go to AR and select Debtor Maintenance. Click on
Credit Control and a dialog box will appear. Here, you
can set Credit Limit, Credit Term�s Overdue Limit, action
to be taken when credit exceeds limits or credit terms
overdue (disabled, controlled by credit terms or suspend)
and whether it is applicable to all documents or individuals
You need to set a temporary account to save contra
transaction. To do that, you can go to Tools, select
Options and click on GL folder. Here, you can set
temporary account by selecting account at AR/AP Contra
You should use Change Branch Code function in Tools | Change Code to change your branch code.
You can go to Tools and select Manage Fiscal Year. Click
on New Previous Fiscal Year to create fiscal year for
the year 2007.
Next, go to GL and select Stock Value Fiscal Year 2007 and
enter opening balance figure at December 2006 column.
This is because the way you insert stock transactions is out
of order. To make your stock costing correct, you should go
to Tools and select Recalculate Stock Costing.
Stock Group is used to define the account code used for Sales
and Purchase document to post to GL.
It began with smallest unit of measurement. For example, 1
box of soya bean drink contains 12 bottles of soya bean drinks.
UOM will be maintained in such sequences at the left hand side
of Stock Item Maintenance.
Yes, you can create new UOM under User UOM column in Invoice.
However, your stock card will only record UOM that you created
in Stock Item Maintenance.
You can open Cash Sales, select Tools and select Cash Sale
Option. You can then select Preview in After Save Option column.
You can do this in Cancel S/O. Create a new Cancel S/O, then
transfer from the Sales Order you like to cancel the quantity.
In AutoCount Accounting, Goods Received Note is no longer
posting to AP Invoice. You should transfer your Goods
Received Note to Purchase Invoice in order to post it to