Company: Link Technologies
Case No: L12021. Project: 12.10: LinkSOFT version 12.1
Logged By: Rashna (Edge Business Solutions) on 11 Aug 2020 09:17AM
Priority: Medium
Product: Framework
Group: Software Defect
Time Taken: 9.00 (Weight: 9.00)
Version: 12.10.1020
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay
Resolve By: Wednesday, 12 August 2020 11:59 PM [2265 days since logged date]
Status: Closed
Subject: Incorrect tax reflection in LINKSOFT when the "Tax Inclusive" flag is disabled in MYOB
Summary:    

Steps to Replicate

  1. Create an invoice in MYOB with a value of $1.15. User tax code as A.
  2. Untick the "Tax Inclusive"  option for the invoice.
  3. MYOB calculates value as $1 and tax as $.15.
  4. When the sale is integrated to LINK SOFT the tax is calculated as $0.13
  5. This gives an incorrect total on the sales receipt
Setup in QA6
URL - http://10.0.0.16/LinkWEB-MYOB-Online
Document Number - 00002310
Audit Notes:Edited by sanjay on 08/12/20 09:11. Edited by rashna on 14/09/20 08:17. Edited by rashna on 26/08/20 15:59. Edited by rashna on 11/08/20 09:17. 
11 Aug 202009:17AM Comment 1 by Rashna (Edge Business Solutions) Case L12021 added to project 12.0
11 Aug 202002:35PM Comment 2 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 12-08-2020 04:23 PM Time Taken: 8.00

Development work for this case has been completed.

The change will be available in version:12.0.0811

1. The following changes were made(Include Database object names, Program classes and any other relevant information):

  1. Corrected issue with Tax exclusive price invoices.
  2. Added "Tax Rounding Variance" flag to "Integration Setup -> MYOBAccountRightV2.API -> AccountsReceivableTransaction -> Tax Rounding Variance". The default value is 5 cents.
  3. Tax Rounding variance is added to the line with the highest tax amount.
  4. Added the ability to set up multiple tax rates for a tax code. For example, VAT + STT + ECAL can be configured. Refer to notes below.

2. Affected Areas:

  1. MYOB API integration for TaxCore.

3. The issue was caused by:

  1. MYOB API does not have tax amounts at each line. Due to this, the taxes need to be recalculated when invoices are imported. 
  2. Some invoices can have a rounding variance in the tax where the total tax amount does not match with calculated line tax.

4. Notes: 

  1. To set up multiple tax rates in MYOB, follow these steps:
    1. Create the individual tax codes: A, E, F in MYOB
    2. Create the combined tax code by adding tax code prefixes. for example. A + E + F will have a tax code as AEF. 



5. Next Step
: UAT and Documentation

----------------------

Development Reference:


26 Aug 202003:59PM Comment 3 by Rashna (Edge Business Solutions) ETC was changed from 12/08/2020 to 12/08/2020
17 Sep 202008:41AM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 18-09-2020 10:41 AM Time Taken: 1.00
Case assigned to Alvis for Documentation 

23 Sep 202002:29PM Comment 5 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 24-09-2020 04:27 PM
Documentation updated

If you have any queries regarding this support incident, please email Support@LinkTechnologies.com.au and include the Case No: L12021 in the subject line of all emails regarding this issue.

Document size: 59.9 KB
For call complaints, please contact the Managing Director of the company using this form.