Company: Link Technologies
Case No: L12752. Project: 14.60: LinkSOFT Version 14.60 - April 2023
Logged By: Vineshwar Prasad (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 07 Jul 2022 07:07AM
Priority: Low
Product: Framework
Group: Enhancement
Time Taken: 24.50 (Weight: 16.00)
Assigned To: Development
Circulation: Development, Sanjay, Vineshwar Prasad
Resolve By: Friday, 31 March 2023 05:20 PM [651 days since logged date]
Status: Closed
Subject: MYOB AP Invoice Integration supports only 1 Tax Code greater than zero
Summary:    Fiji Government has introduced multiple VAT Labels (A, D, B, C, N). These VAT Labels have different percentage rates.

Purchase Orders are created in LinkSOFT with Tax Label (A) at 9% and Tax Label (D) 15%

Issue
  1. MYOB AP Invoice Integration supports only 1 Tax Code greater than zero
Audit Notes:Edited by sanjay on 25/03/23 13:50. Edited by sanjay on 22/03/23 14:04. Edited by sanjay on 09/03/23 17:31. Edited by sanjay on 09/03/23 15:51. Edited by sanjay on 07/03/23 08:02. Edited by sanjay on 02/03/23 16:14. Edited by sanjay on 01/03/23 15:57. Edited by sanjay on 01/03/23 15:29. Edited by sanjay on 01/03/23 10:18. Edited by sanjay on 28/02/23 14:03. Edited by sanjay on 28/02/23 14:02. Edited by sanjay on 02/02/23 16:11. Edited by sanjay on 26/01/23 09:40. Edited by sanjay on 13/10/22 10:47. Edited by sanjay on 07/10/22 14:51. Edited by sanjay on 07/10/22 14:49. Edited by sanjay on 29/07/22 17:34. Edited by sanjay on 29/07/22 17:33. Edited by sanjay on 13/07/22 08:51. Edited by sanjay on 13/07/22 08:51. 
06 Jul 202203:41PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 06-07-2022 03:37 PM Time Taken: 1.00

Discussion with Vineshwar

  1. We should be using the tax codes defined in LinkSOFT. Sanjay to see why we used a pre-defined label

Next Step:

  1. Transfer case to development and assign to Sanjay

07 Jul 202207:15AM Comment 2 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 08-07-2022 07:13 AM Time Taken: 1.00 Notes: ETC extended from: 07/07/2022 to 08/07/2022
Case transferred to Development

13 Jul 202208:51AM Comment 3 by Sanjay (Link Technologies) Case L12752 added to project 14.10
11 Oct 202211:16AM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 31-01-2023 11:16 AM Time Taken: 0.50 Notes: ETC extended from: 08/07/2022 to 31/01/2023
Allocated to project

13 Oct 202210:47AM Comment 5 by Sanjay (Link Technologies) Case L12752 added to project Review
26 Jan 202309:40AM Comment 6 by Sanjay (Link Technologies) Case L12752 added to project 14.50
02 Feb 202304:11PM Comment 7 by Sanjay (Link Technologies) ETC was changed from 31/01/2023 to 08/02/2023
17 Feb 202305:16PM Comment 8 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-02-2023 05:13 PM Time Taken: 2.00 Notes: ETC extended from: 08/02/2023 to 23/02/2023
*** Skype Message ***
Hi Guys, Case L12752 - There is very little information to complete development. Can someone set this up (or show me on a client's environment) and show me how they want multiple Tax Codes handled so I can design and complete this?

Please arrange for this Monday next week as there are only a few cases left before 4.5 is released. thanks


28 Feb 202311:32AM Comment 9 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 03-03-2023 08:14 AM Time Taken: 1.00 Notes: ETC extended from: 23/02/2023 to 03/03/2023
Hey guys, can you respond to this case - organise a time to look into this as soon as possible? I will need to move this to the next release if I do not have enough details. thanks.

28 Feb 202302:02PM Comment 10 by Sanjay (Link Technologies) Case L12752 added to project 14.60
28 Feb 202302:03PM Comment 11 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 31-03-2023 02:02 PM Time Taken: 2.00 Notes: ETC extended from: 03/03/2023 to 31/03/2023

Hi Guys, I am moving this to Version 14.60 as I have not received environment details for MYOB.

Please prepare an environment so this can be tested and signed off as COMPLETED.

If we don't have a test environment, this can hold up the final release.


02 Mar 202304:14PM Comment 12 by Sanjay (Link Technologies) Case L12752 added to project 14.50
02 Mar 202304:45PM Comment 13 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 10-03-2023 04:43 PM Time Taken: 4.00 Notes: ETC extended from: 31/03/2023 to 10/03/2023

Setup MYOB Integration in QA1 to Premier 2023 AU Company using local file integration.

Found the following issues that need to be corrected:

1. Tax Master Import - Allow Import of Grouped Tax Code which is currently failing
2. Supplier Masterfile is importing Additional Fields Twice. Delete the second Additional field
3. When creating AP Invoice in Integration, do not consolidate the AP Invoice
   Use Tax Code from Purchase Order where the tax code exists in the Tax Integration. If it does not exist, use the Override specified in the Integration setup

02 Mar 202308:47PM Comment 14 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 10-03-2023 06:40 PM Time Taken: 8.00 Notes: Edited by sanjay on 02/03/23 20:48. 

Work done today:

  1. Tax Master issues were caused by previous data in the DEMO system. Once I cleared existing Tax, Supplier and Customer Records, the API pulled records without errors. I had to remove Additional Fields and let the API recreate them.
  2. Changed POS PO Receive function to send multiple lines for each PO Receipt (instead of summarising the PO Receipt)
  3. Tax Codes are still coming from the Integration setup.

Next step:

  1. Change the Tax Code to use Integration Tax Code
  2. Test AP Invoice Integration.



07 Mar 202308:02AM Comment 15 by Sanjay (Link Technologies) Case L12752 added to project 14.60
07 Mar 202305:22PM Comment 16 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 17-03-2023 05:20 PM Notes: ETC extended from: 10/03/2023 to 17/03/2023
PART A - Development work for this case has been completed.

1. The change will be available in version:14.60

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

  1. Changed the MYOB Integration to use the Tax Code from the Purchase Order unless an override is specified in the flags: "BillMiscellaneous.TaxCode" and "BillMiscellaneous.TaxCodeExempt" 

3. Affected Areas:

  1. MYOB Integration

4. The issue was caused by:

  1. Bug fix and Improvement

5. Other Relevant Notes
6. Next Step
(Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT


09 Mar 202303:51PM Comment 17 by Sanjay (Link Technologies) ETC was changed from 17/03/2023 to 31/03/2023
22 Mar 202302:07PM Comment 18 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 31-03-2023 02:04 PM Time Taken: 5.00
The following tests were performed:

Test Setup Instructions:
  1. Setup MYOB Integration using FILE API and Online
  2. Setup Tax Codes to use with LinkSOFT
  3. Enable TAX API and pull all MYOB Tax Codes
  4. Set the Override Tax code in the integration to BLANK
Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Receive PO with multiple lines using 3 different VALID tax codes
PO Receive should send the three lines with the three separate tax codes to MYOB Misc Bills
Pass

2Receive a PO with 1 invalid Tax code
Integration should mark the item as INVALID identifying the Tax Code
Pass

3Edit the line in 2. above and correct the tax code and resubmit for processing
PO should create in MYOB 
Pass

Environment Details

  1. OS version: Win11
  2. Application version: 14.60
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


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

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