Hand-on Manual(GST Features)

Hand-on Manual(GST Features)
Older  Version 1 (April 2015) : Download
Newer Version 2 (April 2015) : Download
Hand-on Manual (July 2015) : Download

Accounting (1.8.16.126) and POS (3.0.12.88) All in One --- Last Updated:18/09/2015

Warning!!! : Please backup before you install the new version. 

If you are not sure how to do it by yourself, please contact your software vendor. 

This action will change of your database structure & software version.

AutoCount Accounting, AutoCount Express, POS 3.0.012.87(1.8.016.126) --- Last Updated:18/09/2015

Version 1.8.015.126(All in One) : Download

AutoCount v1.8.15.124 --- Last Updated:12/08/2015

Introduction

This version of AutoCount Accounting is a maintenance release for version 1.8. Some of the improvements implemented in this version are:

1. Enhancement in the previous rounding method.
2. Addition of Inclusive field in Cash Book and Journal Entry detail.
3. 30 Days Advanced Payment Warning.

Improvements Introduced

Enhancement in the previous rounding method

In an effort to produce a more accurate and consistent figures, the rounding methods available in AutoCount Accounting has been updated. The update has upgraded the Whole Document Rounding Method to version 3 and the Line by Line Rounding Method to version 2. The reason for this enhancement is due to the fact that there is some inaccuracy and inconsistency in figures generated for inclusive tax documents. For example:
The following image is shows the inconsistency found between the document and the transaction detail screen when comparing the values generated by the Whole Document Rounding version 2.

There is a difference of 1 cent in the figures generated in the document when compared to the figures in the transaction details

In the following image, the previous inconsistency is no longer observed when using the Whole Document Rounding version 3. With the new update, both the figure in the document and the transaction detail screen is now consistent and is no longer inaccurate.

The difference is no longer observable after using the Whole Document Rounding Method version 3

Addition of Inclusive field in Cash Book and Journal Entry detail

A new field is added into both the Cash Book Detail and Journal Entry Detail entry. This field, Inclusive Tax, is added to allow users the capability to simultaneously enter multiple bills of exclusive and inclusive tax type together in one Cash Book or Journal Entry document. To access this field in the respective document entry, the user must drag out the Inclusive Tax column via the Column Chooser menu (accessible by doing a right click on the column header inside the document entry window).

The Inclusive Tax column in the Column Chooser

The Inclusive Tax column in action inside a Journal Entry document

This field is by default controlled by the Master document Inclusive Tax option. As such, if the user changes the master Inclusive Tax option, all detail Inclusive Tax will follow the changes done to the master option. This is also observable when a new detail is added as the new detail will also follow the master inclusive tax option when created. It must be noted that while the master inclusive tax option controls the detail options, the calculation is still based by the detail as if the user changes the detail inclusive tax to be different from that of the master option, the calculation will be change to reflect that change.

30 Days Advanced Payment Warning

A new feature has been added into this version of AutoCount Accounting. This feature, 30 Days Advanced Payment Warning, will cause a warning to be prompt when users try to save an A/R Receive Payment document that is used to knock-off an Invoice that has its document date or knock-off date greater than 30 days of the A/R Receive Payment document date. To access this option, just navigate to the Tools -> Options -> Goods and Services Tax.

The 30 Days Advanced Payment Warning option

The warning message that will be prompt when user try to save the document that violates the 30 days rule

Bugs Fixed and Minor Enhancement

Among the newer bugs fixed and minor enhancement introduced in AutoCount Accounting version 1.8 are:

1. Enhancement: Add GST Bank Recon reminder message.
2. Enhancement: Add Imported Goods record in Tax Transaction Audit Trail report.
3. Fix Bug: Fix wording issue in Confirm Change Tax Trans form.
4. Enhancement: Change Ctrl+Alt+G shortcut key for GST Instant Infor to Ctrl+Alt+5.
5. Enhancement: Add ToTaxCurrencyRate to all ARAP and GL Import from Excel template.
6. Fix Bug: Fix UDF memo type can’t display during view transaction.
7. Enhancement: Replace TaxableAmt to LocalTaxableAmt for Tax Transaction Audit Trail Report.
8. Enhancement: Add drill down control for Bank Reconciliation report.
9. Fix Bug: Fix Stock Detail Listing report Filter Option display error.
10. Enhancement: Add declaration date for GST Processor.
11. Fix Bug: Fix bug in write upgrade exception to error log.
12. Enhancement: Modify Tax Bill Date validation by comparing with Tax Date.
13. Enhancement: Add write error message to error log file when upgrade account book.
14. Enhancement: Add can change GST Date access right.
15. Fix Bug: Correct Median wording to Medium for Tax Transaction Changed Tracking Report.
16. Enhancement: Add drill down on Tax Transaction Listing Report.
17. Enhancement: Modify calculate local tax adjustment for APDN.
18. Enhancement: Extend command time out for upgrade DB.
19. Enhancement: Use Doc Date to increase next number instead of today’s date for import excel.
20. Enhancement: Add Self Billed Approval Number for debtor.
21. Enhancement: Extend Self Billed Approval Number length for PI, CP, Debtor and Creditor table.
22. Enhancement: Request to have Audit Trail for GST Processor.(ACC-2848)
23. Enhancement: Enable summary style in submitted Journal Entry when create new account book.
24. Enhancement: Add Tax Date filter to Tax Transaction Audit Trail report.
25. Enhancement: Allow Tax Transaction Change Tracking form to be closed by pressing the escape key.
26. Fix Bug: Fix unable to filter Stock Write Off when export data.
27. Enhancement: Display tax date info when it is different with the doc date in document entry form.
28. Enhancement: Prompt tax date form when create new document with tax code in GST Processor period.
29. Fix Bug: Fix date filtering issue in Tax Transaction Audit Trail form.
30. Enhancement: Support new Area Code size, from 12 to 50.
31. Fix Bug: Fix NullReferenceException in Stock Assembly Order entry form.
32. Enhancement: Add new whole document rounding method 3 and line by line rounding method 2.
33. Fix Bug: Fix total of taxable amount for line by line rounding method.
34. Fix Bug: Fix scan barcode with item batch no when merge.
35. Fix Bug: Fix in Copy from other cash book where Source Type is not null transactions should not appear in the search list.
36. Fix Bug: Fix sum tax transaction listing report amount grid view display.
37. Fix Bug: Fix extra discount amount does not calculate according to Indent Group Discount.
38. Fix Bug: Fix object is null in journal entry when processing currency rate control.
39. Fix Bug: Fix copy to new document exclude GST Journal Entry dockey.
40. Enhancement: Show Tax Permit No for Tax Transaction Audit Trail Report.
41. Fix Bug: Fix issue in GST Detail window where mru items does not work properly in Cash Book Entry and Journal Entry.
42. Enhancement: Add To / From column, this column maps to debtor / creditor name in A/R and A/P documents, or maps to Cash Book Entry’s Pay To / Receive From column, or maps to Journal Entry’s Description.
43. Enhancement: Add negative sign to A/R CN, A/P CN, and Supply record in Journal Entry’s detail.
44. Enhancement: Support Include Empty Tax Code option.
45. Enhancement: Add 5 cent rounding adjustment for Quotation and Purchase Order.
46. Enhancement: Modify C/N and D/N list finding invoice filter by Debtor or Creditor code in GST Processor.
47. Enhancement: Add Is Inclusive Tax field in CBDTL and JEDTL.
48. Enhancement: Add C/N Reason at A/R and A/P Payment discount.
49. Enhancement: Add Advanced Payment 30 days rule warning for A/R Payment.
50. Enhancement: Modify Item Package Inquiry interface to show Item Package Description.
51. Enhancement: Add amountextax and amountwithtax column in CBDTL.
52. Enhancement: Add Audit Trail on delete transaction for Stock Assembly Order and Stock Assembly.
53. Enhancement: Add Bad Debt Credit Sales AccNo for posting Journal Entry.
54. Fix Bug: Fix divide by zero exception when inquiry Item Profit Margin report.
55. Enhancement: Enhance return cheque by posting to Tax Trans table.
56. Enhancement: Support boolean in UDF in Import Stock.
57. Fix Bug: Fix chkedtAccChqNo control does not bind into database.

Warning!!! : Please backup before you install the new version. 

If you are not sure how to do it by yourself, please contact your software vendor. 

This action will change of your database structure & software version.

AutoCount Accounting, AutoCount Express, POS 3.0.012.87(1.8.016.124) --- Last Updated:12/08/2015

Version 1.8.015.124(All in One) : Download

AutoCount v1.8.15.124 --- Last Updated:12/08/2015

Warning!!! : Please backup before you install the new version. 

If you are not sure how to do it by yourself, please contact your software vendor. 

This action will change of your database structure & software version.

AutoCount Accounting, AutoCount Express, POS 3.0.012.87(1.8.016.124) --- Last Updated:12/08/2015

Version 1.8.015.124(All in One) : Download

Data-Entry for Imported Goods in AutoCount Accounting

How to run GST Processor Part 1 & Part 2

Part 01

Part 02

V1.8.15.123

Warning!!! : Please backup before you install the new version. 
If you are not sure how to do it by yourself, please contact your software vendor. 
This action will change of your database structure & software version.

AutoCount Account & Express Version 1.8.15.123 --- Last Updated:22/07/2015

AutoCount Accounting v1.8

(Last Updated:22/07/2015)

Version 1.8.15.123(32 Bit) : Download

Version 1.8.15.123(64 Bit) : Download

Express AutoCount v1.8(Last Updated:22/07/2015)

Version 1.8.15.123(32 Bit) : Download

Version 1.8.15.123(64 Bit) : Download

AutoCount POS(Last Updated:22/07/2015)

Version:3.0.011.86 (1.8.015.123): Download

AutoCount USB Server & Backup Server(Last Updated:22/07/2015)

AutoCount USB Key Server(version 1.5) : Download

AutoCount Backup Server(version 1.8.11.3) : Download

AutoCount Accounting Version 1.8.15.123 --- Last Updated:22/07/2015

Introduction

This version of AutoCount Accounting is a maintenance release for version 1.8. Some of the improvements implemented in this version are:

1. Tax Transaction Change Management.
2. Added Tax Code and Transaction ID fields in Ledger Report.
3. New fields in Sales, Purchase, ARAP and GL.
4. GST Detail in Cash Book and Journal Entry.
5. Lampiran 2 export to excel function.
6. Enhancement to Bank Reconciliation.
7. Enhancement on the GST Setting window.

Improvements Introduced

Tax Transaction Change Management

A major improvement is implemented in this version of AutoCount Accounting. Previously, when the GST Processor has processed the GST Return for a period, the period lock mechanism is employed to lock the related documents to prevent from accidental modification that may cause issues with the correctness of the document. As such if the user is required to modify some parts of a document that is locked, they are required to manage the period lock exception. While this in itself is easy to apply, an issue may arise in that with the period lock exception being open, any other modification could occur on other documents, and these changes might be accidental. To prevent such issue from ever occurring as well as giving users more flexibility, a new mechanism is now implemented to help with this situation.
This mechanism is known as the Tax Transaction Change Management. The Tax Transaction Change Management works as a safeguard mechanism to protect the tax transaction that has been processed by the GST Processor. This mechanism works by comparing the changes being done to the document containing the tax transaction with its original version and assigning a severity level on each of the changes done. The highest severity level of all the changes done will then be the severity level assigned to the changed document. If the user making the changes have the correct access right level to save the changes, he or she will be allowed to save the changes done to the document. If the user does not have the access right level to do so, the changes will not be saved and the document will revert to its original condition. The level of severity that is assigned to changes are as follows; Low, Medium and High.

The access right to allow user to save according to the severity of the changes

The following series of images shows how the system will prompt the user when the user has modified a document that contains a severity level. Note: if the user did not received any prompt when saving a modified document with tax transaction, this means that the modification done does not impact the tax transaction itself and is safe. As such the Tax Transaction Change Management mechanism will not trigger any prompts to the user and the save operation will continue without any other input from the user.

When saving a low severity change

When saving a medium severity change

When saving a high severity change

Trying to save a high severity change without access right

The following table illustrate the type of action as well as its severity level.

Action on document with tax transaction	Condition	Severity
		Low	Medium	High
Insert or Delete	Tax Code is ‘OP’ or ‘OS’.		True
	All other Tax Code			True
Modification	Change on the following fields: TaxDate (in the same GST Processed Period) DocNo DocDate ProjNo DeptNo TaxableAccNo TaxableName Seq TaxAccNo Business Register No Bill of No for GST Tax Permit No Tax Export Country Detail Description	True
	Change between tax code ‘OP’/’OS’ to empty tax code and vice versa.		True
	Change on the following fields: TaxDate (not in the same period or out of GST processed period) TaxCode Currency code Currency rate Taxable amount Local Taxable amount Tax Local Tax			True

With the addition of this mechanism, the previous period lock mechanism is no longer applied and as such when updating to this version of AutoCount Accounting, the period locks applied previously will be removed.
To help users manage and track the changes done under this mechanism, a new report is also introduced. This report is named as Tax Transaction Change Tracking Report and it will display the changes done, the severity of the changes as well as who did the change.

The Tax Transaction Change Tracking Report that shows the changes done the tax transaction document by which user

Added Tax Code and Transaction ID fields in Ledger Report.

Two new fields is added into the Ledger Report. The two fields added are Tax Code and Transaction ID.

The Tax Code column in the Ledger Report window

New Fields in Sales, Purchase, ARAP and GL.

A few new fields are added into the documents in the Sales, Purchase, ARAP and GL module. These columns are localtaxableamt, taxcurrencytax and taxcurrencytaxableamt which is used to store some of the previously calculated values into the database. The Local Taxable Amt field is also added into the Tax Transaction Audit Trail report.

GST Detail in Cash Book and Journal Entry

In an effort to make it easier for user to enter the GST information in both Cash Book and Journal Entry as well as reducing the number of columns for the information, a new button is introduced under the column GST Detail. The user can just click this button to enter the following GST information on a separate dialog;

1. Business Name
2. Business Registration Number
3. GST Registration Number
4. GST Permit Number
5. GST Export Country
6. GST Reference Number
7. Bill Date for GST

Click on the button under the GST Detail column, and the dialog window to fill the information will prompt up

Lampiran 2 export to excel function

A new function is added into the GST Return window. The function allows users to create the Lampiran 2 report which the Customs may request when the user is requesting tax refunds from them. To access this function, just open the GST Refund window and click the ‘Export Lampiran 2 in Excel’ button. The function will then generate the Lampiran 2 in excel format.

Click the button highlighted to generate the report

An example of the report generated

Enhancement to Bank Reconciliation

Two enhancement for Bank Reconciliation is introduced in this version of AutoCount Accounting. The first is that, when a user double-clicks on the Bank Reconciliation record, it will now open the record in View mode. The second enhancement is by using the keyboard shortcut Ctrl+F, the user will be able to access the Find panel, where they can search for the relevant Bank Reconciliation record.

The Find panel, accessible via Ctrl+F

Enhancement on the GST Setting window

In the previous version of AutoCount Accounting, the GST Setting menu is only accessible from the GST Processor menu. This is no longer the case as it is now placed under the GST menu as shown below.

The new GST Setting menu position

The GST Setting window has also been modified by separating all the options base on the GST functionality it falls into. The following series of images illustrates the changes done.

Bugs Fixed and Minor Enhancement

Among the newer bugs fixed and minor enhancement introduced in AutoCount Accounting version 1.8 are:

1. Fix Bug: Fix “Index was outside the bounds of an array” error when generate GST Return File.
2. Enhancement: Enhance GST03 Report to latest form design.
3. Enhancement: Extend GST Person Name to 50 characters long.
4. Enhancement: Add AccNo in Delivery Order document for generate GST on D/O 21 days.
5. Enhancement: Open the “Use Transaction Account Number for Posting” to those Non-Govt tax code in Malaysia only.
6. Enhancement: Allow modify date range for GST Instant Info.
7. Enhancement: Get default sales account for generate GST on Payment.
8. Fix Bug: Fix unable auto assign AccNo field for import document’s item package.
9. Enhancement: Modify rounding method for footer amount.
10. Enhancement: Modify ARAP, GL, Sales and Purchase document rounding method control at form level.
11. Enhancement: Add MRU to Cash Book Entry and Journal Entry’s Business Name edit, and also add logic to automatic bring out the previous entered Business Reg. No. when the Business Name was matched or use the RegisterNo from Debtor and Creditor if the Company Name was matched to Business Name entered.
12. Enhancement: Add TaxDate column to Tax Transaction Audit Trail report and remove those SourceType IS NOT NULL transactions from Cash Payment and Cash Receipt.
13. Enhancement: Add GST on Realized Gain Loss.
14. Enhancement: Add Recompress GL Transaction ID Trash Form to Studio.
15. Enhancement: Apply New SerializeGLTransIDTrashSourceData with compress to ARAP and GL.
16. Fix Bug: Fix unable posting journal from ARAP DN & CN when using inclusive tax.
17. Enhancement: Add TaxBRNo, TaxBName and TaxRefNo to Cash Book adn Journal Entry dataview.
18. Enhancement: Add rounding method audit log for ARAP, GL, Sales and Purchase document.
19. Fix Bug: Fix ExtraDiscountAmt will get negative value if the detail row without item code and sub total is zero.
20. Fix Bug: Fix knockoff label showing error.
21. Fix Bug: Fix load outstanding DO partial transfer issue for GST on DO.
22. Fix Bug: Export Stock Module did not consider Item Package in Purchase Document. (ACC-2830)
23. Enhancement: Modify update currency rate for CBIGDTL table.
24. Fix Bug: Fix bug in GetGLTrans where if there is any negative amount in detail row, and there is no more non-tax account row with positive amount to match, the system will enter into an endless loop.
25. Fix Bug: Fix incorrect comment in LookupEditBuilder.cs.
26. Enhancement: Support execute only selected text in SQL Query.
27. Fix Bug: Modify unable to update package master unit price and taxable amount when Import XML.
28. Enhancement: Change D/O Entry SubTotal(Ex) Summary Type from Average to Custom.
29. Enhancement: Add TaxBName, TaxBRNo and TaxRefNo to Cash Book in Import XML.
30. Fix Bug: Fix location not showing value when group by item location at SalesAnalysisByDocument report for POS.
31. Enhancement: Import Export POS Sales Transaction.
32. Fix Bug: Fix Zero Currency Rate issue in CBIGDTL table.
33. Enhancement: Add Group Footer to Ledger report and UCLedger.
34. Fix Bug: Fix bug in Login form where the previously saved skin does not restored back.
35. Enhancement: Add Cancelled Status Option for FocQuantityAnalysisByDocument Report.
36. Fix Bug: When create new account book, do not set UseTodayDateForDefaultKnockOffDate to true.
37. Fix Bug: Fix strange date like 31/00/2015, and it ask “Do you want to apply default GST logic?” issue.
38. Enhancement: Apply KeepLastModifiedInfo to some fix and repost functions and remove unused user id parameter.
39. Fix Bug: Fix bug in Year End Closing’s CheckNegativeBalanceQuantityStock() to check only item with stock control set to true.
40. Enhancement: Change the exception thrown in CheckSNQtyConsistency() from ContextException.AbortException() to YearEndClosingException and provide a meaningful exception message.
41. Fix Bug: Fix object reference on PostToStockCosting when ItemUOMTable is null.
42. Fix Bug: GST payment amount does not deduct purchase tax during perform CIMB online payment. (ACC-2843)
43. Fix Bug: Fix unable save bank recon issue.
44. Enhancement: Add tax trans control and audit function.
45. Fix Bug: Delete A/P Deposit did not delete record in TaxTrans table. (ACC-2838)
46. Enhancement: Added GST Lampiran 2.
47. Enhancement: Tax Transaction Changed Tracking report.
48. Fix Bug: Fix pivotgrid field list cost field not being controlled by view cost access right in Multi Dimensional Sales Analysis.
49. Fix Bug: Fix very slow when delete an item when the document contains about 600 items.
50. Fix Bug: Fix a minor bug in CheckTransactionCountValidity().
51. Enhancement: Add localtaxableamt, taxcurrencytax & taxcurrencytaxableamt field for Sales, Purchase, ARAP & GL document.
52. Enhancement: Add taxcode field for GLDTL table.
53. Enhancement: Rename to Tax Transaction Change Tracking report.
54. Fix Bug: Modify GST Lampiran 2 decimal place.
55. Fix Bug: Auto assign (OS or OP) tax code for rounding adjustment when must specify tax code.
56. Fix Bug: Fix post separate discount row for tax transaction.
57. Fix Bug: Fix post separate discount row and purchase document to imported goods document.
58. Enhancement: Change Gift Rule credit to Sale Account No.
59. Enhancement: Enhance Tax Transaction Audit Trail report.
60. Enhancement: Add Include Outstanding Invoice option at Bad Debt Wizard.
61. Enhancement: Add Refresh button to Account Maintenance.
62. Enhancement: Allow double click on Bank Recon record to open in view mode.
63. Enhancement: Support Ctrl-F to bring up the Find panel in Bank Recon.
64. Enhancement: Check default sales account and GST control account before process GST Processor.

AutoCount Accounting v1.8
(Last Updated:22/07/2015)
Version 1.8.15.123(32 Bit) : Download
Version 1.8.15.123(64 Bit) : Download

Express AutoCount v1.8(Last Updated:22/07/2015)
Version 1.8.15.123(32 Bit) : Download
Version 1.8.15.123(64 Bit) : Download

AutoCount POS(Last Updated:22/07/2015)
Version:3.0.011.86 (1.8.015.123): Download

AutoCount v1.8.014.117 --- Last Updated:03/06/2015

Warning!!! : Please backup before you install the new version. 

If you are not sure how to do it by yourself, please contact your software vendor. 

This action will change of your database structure & software version.

AutoCount Account & Express AutoCount --- Last Updated:03/06/2015

AutoCount Accounting v1.8(Last Updated: 03/06/2015)
Version 1.8.014.117(32 Bit) : Download
Version 1.8.014.117(64 Bit) : Download

Express AutoCount v1.8
(Last Updated: 03/06/2015)
Version 1.8.014.117(32 Bit): Download
Version 1.8.014.117(64 Bit) : Download

AutoCount POS
(Last Updated: 03/06/2015)
Version 3.0.010.81 (1.8.014.117) : Download

AutoCount USB Server & Backup Server
(Last Updated: 03/06/2015)
AutoCount USB Key Server(version 1.5) : Download
AutoCount Backup Server(version 1.8.11.3) : Download

AutoCount Accounting Version 1.8.014

Introduction

This version of AutoCount Accounting is a maintenance release for version 1.8. For users that have run the GST Processor in the previous version of AutoCount Accounting and has use one or both of the following function:

1. Imported Goods
2. GST on D/O
3. GST on Payment

please read the following special note. Some of the improvements implemented in this version are:

1. New Rounding Method functionality.
2. Allow to change the date for GST Instant Info.

Special Note

Changes for Imported Goods

Some new column is introduced in this version of AutoCount Accounting in the Payment Voucher for the Imported Goods function. One of the column, named as Custom Assessed Curr. Rate has been added to allow users to key in the currency rate the RMCD used for their assessment of the imported goods as the currency rate used by the RMCD sometimes is not the same as the one used by the user when purchasing the items being imported in. Another 2 columns introduced are the GST Adjustment as well as the Local GST Adjustment column. Due to the addition of the Custom Assessed Curr. Rate column, it is advised that the users that have been using the Imported Goods function to go and check their payment vouchers to ensure that the currency rate used is correct as well as to re-run the GST Processor if there is any changes done to the documents due to the changes done in the new column.

The 3 new columns in the Imported Goods function

Changes for GST on D/O and GST on Payment

Users that satisfies the following condition:

1. have previously run the GST Processor on the previous version and used the GST on D/O
2. or GST on Payment function during the run

is required to re-run the GST Processor as there is a major change in the journal document generated by the functions. If the GST Processor document that is being re-run has been committed, please use the Tools->Reset GST Processor function in the AutoCount Accounting Management Studio to reset and allow the re-run to occur.

The reason for the GST Processor re-run is because in the previous version of AutoCount Accounting, the journal entry document created for the GST on D/O and GST on Payment has been using the Output Tax Account for the credit figure. In this version of AutoCount Accounting, the credit account has been changed. For the journal entry created by the GST on Payment, the system will use the Default Sales Account stored in the Tools->Options->GL->Default Accounts. For the journal entry created by the GST on D/O, the system will first use the Account Number specified in the D/O and if the there is no Account Number specified, it will also revert to using the the Default Sales Account stored in the Tools->Options->GL->Default Accounts. As such users have to remember to set the default sales account before running the GST Processor as they might encounter errors if not default sales account is stored in the Default Accounts window.

Enter the default sales account before re-running the GST Processor

Improvements Introduced

New Rounding Method functionality.

In the previous version of AutoCount Accounting, 2 different rounding methods are available when doing calculations in the system. The first, known as Old ARAP Rounding Method and the second is known as Whole Document Rounding. This is now changed in this version of AutoCount Accounting.

2 newer rounding methods are introduced in version 1.8.14. The first is Whole Document Rounding version 2 and the second is known as Line by Line Rounding. Before we go into the second version of Whole Document Rounding, I would like to discuss the Line by Line Rounding method.

The Line by Line rounding method is a simple rounding method that applies the rounding in each line of detail before summing the rounded amount to the total of the document. This is different when compared to the Whole Document Rounding in which the rounding is applied only after the total of the document is calculated. The reason for the introduction of this rounding method is due to the fact that other accounting software uses line by line rounding method when generating their documents. This causes our own users who have to either enter or provide documents to the users of the other accounting software to have issues when entering/generating the documents as the rounding mechanism is different between Whole Document Rounding and Line by Line rounding. As such to solve the issues faced by our customers, we introduce the rounding adjustment method to better help with our clients needs. Because of this, if the creditor or debtor of the user is using the Line by Line rounding method in their documents, the AutoCount user can select to assign the rounding method to be applied to the creditor or debtor via the Creditor or Debtor Maintenance. Just navigate to the creditor or debtor of your choice, and navigate to the Others tab and set the Rounding Method option to Line by line rounding.

Set the Line by line rounding for Creditor or Debtor that uses the rounding method to generate their document

The newer Whole Document Rounding (version 2) is different when compared to the first version in the sense that, when applying the rounding method on transaction for foreign currency, the first version introduced some inaccuracy when doing the calculation using the standard algorithm used by AutoCount Accounting (for more on the algorithm used, click here) This is due to the fact that when the first version is used, when calculating the Local Amount as well as Local Tax using the algorithm, the sequence of calculation done is first line Local Amount , first line Local Tax, second line Local Amount, second line Local Tax and so on. This causes the carry forward rounding amount of the Local Amount to sometimes move to the Local Tax column causing the inaccuracy to grow as more and more carry forward rounding amount is added into the Local Tax column, which ultimately causes the total for Local Amount and Local Tax to be very different with the total Amount and Tax for the original currency. The image below illustrates this issue:

Old Whole Document Rounding issue

If you calculate the figures directly the total amount in local currency should have been 27321.67 and not the shown amount of 27321.66 where as the total amount of local tax should have been 1639.29 instead of the 1639.30 calculate by the Whole Document Rounding version 1. Again this is due because the carry forward rounding amount went into the Local Tax figures instead of staying in the Local Amount.

To fix this issue, the 2nd version is introduced in which the sequence of calculation is corrected so that it will calculate all the Local Amount first before moving to the Local Tax amount next. This sequence of calculation should in fact be more accurate when compared to the older Whole Document Rounding method. To change the rounding method use in your document, just go to the Tools->Options->Miscellaneous option and select the type of rounding method in the Default Document Rounding Method as shown below:

The Default Document Rounding method option

Allow to change the date for GST Instant Info.

A new feature is added into the GST Instant Info function that allows the user to change which date period is to be used to generate the GST Instant Info data with. The reason for this addition is to allow users to generate a new GAF when there is an amendment of transaction that affects the accounting side but not on any GST transaction especially for the Ledger part of the GAF file. Another reason for this addition is for the scenario that a Customs Officer request a full year (or any date period) of transaction in the GAF file, the user can just change the date range and generate it via the GST Instant Info window.

Change the Date Range in the GST Instant Info to show more info in the GST Instant Info and generate the GAF file for it

After changing the date range

Bugs Fixed and Minor Enhancement

Among the newer bugs fixed and minor enhancement introduced in AutoCount Accounting version 1.8 are:

1. Enhancement: Allow double click to edit account in Account Maintenance.
2. Fix Bug: Fix escape key does not close some dialog in Account Maintenance.
3. Enhancement: Allow to use escape key to close GST Instant Info window.
4. Enhancement: Add checking of company name, address 1 and phone 1 in Registration Wizard.
5. Enhancement: Support calculate unit price from SubTotal option.
6. Enhancement: Add Transaxtion ID to Tax Transaction Audit Trail report.
7. Enhancement: Add DocNo2, RefNo2, TaxPermitNo, TaxAdjustment, TaxDR, TaxCR, TaxExportCountry, TaxBRNo, TaxBName, TaxRefNo to Import Journal Entry from Excel.
8. Enhancement: Add ProjNo and DeptNo columns in Tax Transaction Audit Trail report.
9. Fix Bug: Fix amount from Journal Entry is empty bug.
10. Enhancement: Add catch OutOfMemoryException for generate GST Processor.
11. Enhancement: Add a helpful message in Remote USB Key Setting window to explain to user how to use this function.
12. Enhancement: Import Export XML for all POS Maintenance.
13. Enhancement: Add SupplierInvoiceNo, Reason, Tax, TaxPermitNo to Import APCN from Excel.
14. Enhancement: Add SupplierInvoiceNo, Reason, Tax, TaxPermitNo to Import APDN from Excel.
15. Enhancement: Filter By GST Period Date for Unapplied amount ARAP CN in GST Processor.
16. Enhancement: Add TaxPermitNo and Tax to Import AP Invoice from Excel.
17. Fix Bug: Fix unable to calculate GLDTL when doing imported goods in inclusive tax.
18. Enhancement: Add BankChargeTaxType and BankChargeTaxRefNo to Import APPayment from Excel.
19. Fix Bug: Fix unable to assign tax rate properly when copy to new document.
20. Enhancement: Import Export XML for POS Staff Attendance.
21. Fix Bug: Fix bug in detail listing where item package detail option is not correct.
22. Enhancement: Add OurInvoiceNo, Reason, Tax and TaxExportCountry to import ARCN from Excel.
23. Fix Bug: Fix bug in all sales detail listing where item package detail option is not correct.
24. Fix Bug: Fix bug in all purchase detail listing where item package detail option is not correct.
25. Enhancement: Add OurInvoiceNo, Reason, Tax and TaxExportCountry to Import ARDN from Excel.
26. Enhancement: Add TaxExportCountry and Tax to Import ARInvoice from Excel.
27. Enhancement: Add BankChargeTaxType and BankChargeTaxRefNo to Import ARPayment from Excel.
28. Enhancement: Add custom assess currency rate for imported goods field.
29. Enhancement: Add rounding method for Sales, Purchase, ARAP and GL document.
30. Enhancement: Add local tax adjustment for Sales, Purchase, ARAP and GL document.
31. Enhancement: Add option for Rounding Method function.
32. Enhancement: Add grid column export excel at GST Processor.
33. Enhancement: Modify Bank Charge Business Name and Registration Number maximum length.
34. Fix Bug: Fix the ‘capacity’ must be greater than zero error in the GST Processor
35. Fix Bug: Fix bank charge in PV appearing as double value in the Tax Transaction Listing.

AutoCount Accounting v1.8
(Last Updated: 03/06/2015)
Version 1.8.014.117(32 Bit) : Download
Version 1.8.014.117(64 Bit) : Download

Express AutoCount v1.8
(Last Updated: 03/06/2015)
Version 1.8.014.117(32 Bit): Download
Version 1.8.014.117(64 Bit) : Download

AutoCount POS
(Last Updated: 03/06/2015)
Version 3.0.010.81 (1.8.014.117) : Download

AutoCount USB Server & Backup Server
(Last Updated: 03/06/2015)
AutoCount USB Server(version 1.5) : Download
AutoCount Backup Server(version 1.8.11.3) : Download

Guide on PAYMENT OF GST

Guide on PAYMENT OF GST : Download

Security Deposit in A/R Deposit

Security Deposit in A/R Deposit

When using the GST Processor, the system will detect any unapplied A/R Payment and generate a journal entry to account for output tax of the payment in advance. However, deposit transaction taken as security is not consideration for a supply (taken from Royal Malaysian Customs Goods and Services Tax Guide on Supply document). As such, to take into account of this definition, AutoCount Accounting introduces the ‘Is Security Deposit?’ option in its A/R Deposit entry window. With this, users may enable this option to mark the transaction as a Security Deposit transaction and exclude it from the GST Processor GST on Payment function.

AutoCount Accounting Version 1.8.113 --- Last Updated:18/05/2015

Introduction

This version of AutoCount Accounting is a maintenance release for version 1.8. Some of the improvements implemented in this version are:

1. Self Billed Approval No. added in Creditor Maintenance, Cash Purchase & Purchase Invoice
2. Business Registration Number and Business Name field in Cash Book moved from Master to Detail
3. Changes to the IS_ATS tax document flow.
4. Use Transaction Account Number for Posting for the Tax Code BL

Improvements Introduced

Self Billed Approval No. added in Cash Purchase, Purchase Invoice & Creditor Maintenance

The Self Billed Approval No. field has been added into the Creditor Maintenance, Cash Purchase and Purchase Invoice document. This is to allow companies that has obtained the Self Billed Approval No for their suppliers to fill in the information for their suppliers in the system.

The Self Billed Approval No field in Creditor Maintenance

The Self Billed Approval No field in Purchase Invocie

The Self Billed Approval No field in Cash Purchase

Business Registration Number and Business Name field in Cash Book moved from Master to Detail

In this version of AutoCount Accounting, the Business Registration Number and Business Name has been moved from the Master section of the document to the Detail section of the document. This change is done based on feedback from users that wish to key in the 2 fields for each detail line.

The Business Registration Number and Business Name in the Receipt Voucher detail

The Business Registration Number and Business Name in the Payment Voucher detail

Changes to the IS_ATS tax document flow.

Previously, using the IS_ATS tax code in the Purchase document side will allow the user to select the document in the Find Imported Goods window at Payment Voucher document entry. This has been changed in this version as from feedback and review, the use of IS_ATS at the Purchase side has been determined to be incorrect. As such a correction is made so that for the scenario of purchasing items from an overseas supplier for both normal import or under the Approved Trader Scheme, the tax code to use is IM-GDS. Using the IS_ATS in Purchase document will no longer cause that document to show up in the Find Imported Goods function in Payment Voucher entry.
The question now would be where should the IS_ATS tax code be used? The user will now have to determine when using the Find Imported Goods function in Payment Voucher entry, to use either the IM tax code or to use the IS_ATS tax code as previously shown for the Customs duty.

Use Transaction Account Number for Posting for the Tax Code BL

A new boolean field has been added into the Tax Code Maintenance. This field “Use Transaction Account No. for Posting” is used specifically with the Government Tax Code BL. The reason for this addition on the specific tax code is to allow user a more easier time of maintaining their BL tax code since this tax code requires posting to the transaction account instead to a tax account. As such, users no longer have to maintain multiple version of the tax code for multiple accounts as enabling this option will automatically cause the posting to be to the transaction account instead of the assigned tax account.

The “Use Transaction Account Number for Posting” option in Tax Code Maintenance for tax code BL

Bugs Fixed and Minor Enhancement

Among the newer bugs fixed and minor enhancement introduced in AutoCount Accounting version 1.8 are:

1. Enhancement: Add footer local amount field for sales and purchase view
2. Fix Bug: Fix possible NullReferenceException error in Project Maintenance.
3. Fix Bug: Fix possible NullReferenceException error in BudgetPBalanceDataColumnChangeEventHandler, LastYearBalanceMaintenance’s PBalanceDataColumnChangeEventHandler, and YearToDateMaintenance’s PBalanceDataColumnChangeEventHandler.
4. Enhancement: Change default account localization “Rounding Adjustment Account” to “5 Cents Rounding Adjustment Account”.
5. Fix Bug: Error Log Viewer Bug: The DELETE statement conflicted with the REFERENCE constraint “FK_GLTrxIDTrash_UserID”. The conflict occurred in database “AED_WALTA ENGINE”, table “dbo.GLTrxIDTrash”, column ‘UserID’. (ID: 36177) (ACC-2819)
6. Enhancement: Add to code to double confirm from users whether they want to continue upgrade with the account book contained AutoCount POS database.
7. Fix Bug: Fix come out duplicate item when editing Item BOM.
8. Enhancement: Assign default tax rate from tax type when import ARAP & GL document
9. Enhancement: Extend tax ref no field to 30 characters.
10. Fix Bug: Fix copy sales document to purchase document, the tax type should not copy over or vice versa.
11. Fix Bug: Fix sometimes Item Search window disappear when press F9 in Stock Item Inquiry issue.
12. Fix Bug: Fix wording bug in FormManageARBadDebtWizard.
13. Fix Bug: Fix Copy Receipt Voucher to Payment Voucher, the tax type should not copy over issue or vice versa.
14. Fix Bug: Fix unable to copy taxable amount for item package detail to other document.
15. Enhancement: Add self bill approval no in Cash Purchase, Purchase Invoice & Creditor table
16. Enhancement: Move tax business name and regno from Cash Book Master to Detail table
17. Enhancement: Merge IS_ATS with IM by using IM-GDS
18. Fix Bug: Error Log Viewer Bug: Column ‘LocalTax’ does not belong to table AddInfoTaxSummary. (ID: 36537) (ACC-2822)
19. Enhancement: Change payment method field from bankchargetaxbrname to bankchargetaxbname
20. Fix Bug: Fix bug in Year To Date Maintenance and Last Year Balance Maintenance which was introduced in previous changeset.
21. Fix Bug: Fix tab order issue in Debtor Edit and Creditor Edit.
22. Fix Bug: Add Bank Charge Tax Code, Bank Charge Business Name, Bank Charge Business Reg. No. to Payment Method grid.
23. Fix Bug: Fix grid control does not fill properly in Negative Serial Number Inquiry.
24. Fix Bug: Add use transaction tax accno field for BL goverment tax code (apply in Malaysia)
25. Fix Bug: Change double entry matching algorithm in Cash Book Entry to exclude tax record.
26. Fix Bug: Fix wording issue in Tax Code Maintenance.
27. Fix Bug: Fix bug in Show Tax Summary form where it does not use the BCE.AutoCount.Common.CommonFunction.CalculateTaxSummary(), now we have standardize it to use the function so that the result in Show Tax Summary Form will be same as in Invoice report.
28. Enhancement: Change the default refresh to 15 minutes for GST Instant Info.
29. Enhancement: Change the way refreshing GST Instant Info into another thread.
30. Fix bug when create new Debtor Control / Creditor Control, the Input Tax Code and Output Tax Code already preset with value issue.
31. Fix bug: You still can enter inactive item from Scan Bar Code control.
32. Enhancement: Add TaxRegisterNo to Debtor and Creditor Statement report.
33. Fix bug: Exclude GST Amount during calculate commission on Commission By Collection report.
34. Fix bug: Change from LocalSubTotal to LocalSubTotalExTax at Stock Item Profit Margin report.
35. Fix bug: Change from SubTotal to SubTotalExTax at Stock Item Profit Margin report.
36. Fix bug: Change from NetTotal to TotalExTax for POS transaction at Sales Analysis report.

AutoCount Accounting v1.8
(Last Updated:15/05/2015)
Version 1.8.113(32 Bit) : Download
Version 1.8.113(64 Bit) : Download

Express AutoCount v1.8
(Last Updated:15/05/2015)
Version 1.8.113(32 Bit): Download
Version 1.8.113(64 Bit) : Download

AutoCount POS
(Last Updated:15/05/2015)
Version:3.0.009.77(1.8.013.113) : Download