AutoCount Accounting 2.1.12 Tax Updates

TaxType to TaxCode

All previous "TaxType" is renamed to "TaxCode".

Tax Entity

• Tax Entity is a new class that is required for Tax related entities and transactions.
• Tax Entity can be assigned to debtor and creditor.
• In some cases document cannot be saved, if Tax Entity is not pre-defined in debtor/creditor.
• Each debtor/creditor can be assigned with one Tax Entity.
• Each debtor/creditor is allowed to have more than one Tax Entity under Branches.
• Branches of a debtor/creditor

When create branches with Tax Entity, TaxBranchID has to be different, when Tax ID/TIN is the same.

So the keys for a Tax Entity are TIN and TaxBranchID.

• Tax Entity can be assigned to branches of debtor and creditor.

Fieldname	Data Type	Max Size	Compulsory	Remark
Name	string	100	Yes	Tax registered name for this Tax Entity
IdentityNo	string	30		Optional field for reference ID
FullTIN	string	30	Yes	Readonly. System auto combine TIN and TaxBranchID
TIN	string	20	Yes	TaxID or TIN of the Tax Registered ID
TaxBranchID	string	10	Yes	If not applicable, assign zeroes as head office, eg. "0000".
Address	string	200		Full address
PostCode	string	10		Postcode / Zip Code
Phone	string	25
EmailAddress	string	200
TaxCategory	int		Yes	0 = Individual, 1 = NonIndividual
TaxClassification	int		Yes	0 = Private, 1 = Government

Code sample to create new Tax Entity

/// <summary></summary>
/// <returns>TaxEntityID</returns>
public int? CreateNewTaxEntity()
{
    AutoCount.Tax.TaxEntityMaintenance.TaxEntityCommand cmd =
        AutoCount.Tax.TaxEntityMaintenance.TaxEntityCommand.Create(myUserSession);
    AutoCount.Tax.TaxEntityMaintenance.TaxEntity te = cmd.New();

    te.Name = "TFC Company";
    te.IdentityNo = null;
    te.TIN = "111-222-333";
    te.TaxBranchID = "3200";
    te.Address = "20, Street 1/2, Loney Road, 23000 (full address)";
    te.PostCode = "23000";
    te.Phone = null;
    te.EmailAddress = null;
    te.TaxCategory = Tax.TaxCategory.Private;
    te.TaxClassification = Tax.TaxClassification.NonIndividual;
    te.Save();

    return te.TaxEntityID;
}

Create new Debtor with Tax Entity

/// <summary></summary>
/// <returns>Debtor Code</returns>
public string CreateNewDebtor(string debtorControlAcc)
{
    string companyName = "ABC Company";
    string accNo = GetNewDebtorCode(myUserSession, debtorControlAcc, companyName);
    AutoCount.ARAP.Debtor.DebtorDataAccess cmd =
        AutoCount.ARAP.Debtor.DebtorDataAccess.Create(myUserSession, myUserSession.DBSetting);
    AutoCount.ARAP.Debtor.DebtorEntity debtor = cmd.NewDebtor();

    //Code Snippet
    debtor.ControlAccount = detborControlAcc;
    debtor.CompanyName = companyName;
    debtor.AccNo = accNo;
    //Create new or Assign existing Debtor's TaxEntity
    debtor.TaxEntityID = CreateNewTaxEntity();
    //...Add more fields to complete debtor creation

    cmd.SaveDebtor(debtor, myUserSession.LoginUserID);
    return debtor.AccNo;
}

Tax Entity application

Tax Entity is applied as in following:-

Master Data

• Branch
• Debtor
• Creditor
• Payment method

GL/AR/AP

• Cash Book Master
• Cash Book Detail
• Journal Entry
• ARInvoice
• ARCN
• ARDN
• APInvoice
• APDN
• APCN

Sales

• Advance Quotation
• Quotation
• Sales Order
• Delivery Order
• Sales Invoice
• Cash Sales
• Sales Credit Note
• Sales Debit Note
• Delivery Return
• Cancel Sales Order
• Consignment
• Consignment Return

Purchases

• Request Quotation
• Purchase Order
• Goods Received
• Purchase Invoice
• Cash Purchase
• Purchase Return
• Goods Return
• Cancel Purchase Order
• Purchase Consignment
• Purchase Consignment Return

Withholding Tax

Technical

• Withholding Tax Amount must be greater than zero.
• The total of Withholding Tax Amount must be equal or smaller than the net amount (that excludes tax amount of GST or VAT).
• Withholding Tax requires Tax Entity.

Document that has Withholding Tax cannot be saved without Tax Entity specified.

• Avoid changing the debtor/creditor Tax Entity at document of sales and purchases.

It is to prevent unexpected result in some government report.

However, it is advised to assign Branch Code in document which the Branch Code is pre-defined with Tax Entity.

Go to menu

Go to top

Resources For AutoCount Software Developers