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 name.
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 SQL server.
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 Windows Firewall.
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 registration.
To install AutoCount Accounting in Server PC,
- Go to the Server PC, put in the A2006 CDROM
- To install AutoCount Accounting in Server PC, choose Network Installation, Server Installation, then click Next button and follow the on screen instruction to complete the installation.
- Create any empty folder in Server PC, share this folder to allow other network users to have read, or read/write permission. For instance, we shared C:\A2006 as \\Server\A2006.
To install AutoCount Accounting in client PC,
- Go to the Client PC, put in the A2006 CDROM.
- Choose Network Installation, Client Installation, then click Next button and follow the on screen instruction to complete the installation.
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 Manufacturing documents.
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 Apply button.
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 functions.
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 Entry.
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 column.
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 information.
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 the entry.
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 documents only.
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 Temporary Account.
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 AP Invoice.