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 [1348 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 admin@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