Company: Link Technologies
Case No: L11937. Project: 12.10: LinkSOFT version 12.1
Logged By: Sanjay (Link Technologies) on behalf of Alvis (Link Technologies) on 06 Mar 2020 04:55PM
Priority: Medium
Product: Framework
Group: Enhancement
Time Taken: 22.00 (Weight: 22.00)
Version: 12.10.1020
Assigned To: Rashna (Edge Business Solutions)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Wednesday, 29 April 2020 03:28 PM [1508 days since logged date]
Status: Closed
Subject: Integration to external systems- Add Revenue Account in Invoice Line Items
Summary:    

Problem: In the Invoice Entry system in LinkWEB, the revenue account comes from the Item code.
There is a need to select the Revenue account on invoice entry for NON-AR Invoices and invoices where Item Code is not required.

Design:

  1. Add integration where GL Chart of accounts is imported from FMS Systems
  2. Add field to capture Revenue Account Drop Down in the Invoice Entry Line Items
  3. When passing the invoice to FMS, use the nominated Revenue account if one is available
  4. Make Part Number Optional
Audit Notes:Edited by alvis on 21/05/20 15:09. Edited by alvis on 28/04/20 16:53. Edited by alvis on 01/04/20 11:35. Edited by sanjay on 27/03/20 15:36. Edited by sanjay on 27/03/20 15:36. Edited by sanjay on 27/03/20 15:36. 
27 Mar 202003:36PM Comment 1 by Sanjay (Link Technologies) ETC was changed from 20/03/2020 to 03/04/2020
24 Apr 202010:12AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 28-04-2020 10:07 AM Time Taken: 16.00

Development work for this case has been completed.

The change will be available in version:11.5.0424

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

  1. Added Revenue account and Posting Account to Invoice line items
  2. When an item is selected, default values are loaded
  3. When selling Misc items, users need to create a MISC item code in LinkSOFT as Items are Mandatory, you can choose the Revenue account  to be different
  4. GL Integration has been enabled so Revenue Accounts from ERP will be available

2. Affected Areas:

  1. POS Customer Maintenance
  2. POS Invoice View 

3. The issue was caused by:

  1. Improvement

4. Notes: We could not make ITEM CODE optional - so the workaround is to create a MISC item and use this item code to sell non-inventory items.
5. Next Step
: UAT, Documentation


28 Apr 202003:29PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 29-04-2020 03:28 PM
Ready for UAT

28 Apr 202004:53PM Comment 4 by Alvis (Link Technologies) ETC was changed from 03/04/2020 to 29/04/2020
21 May 202009:21AM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 22-05-2020 09:03 AM Time Taken: 2.00
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
1

Create a MISC Item in Linkweb with below details:

  1. Posting Account - NONSALE
  2. Location - Main
Pass
2

Create a customer in Linkweb with code as "LinkPOS"

  1. Navigate to "Linkweb - Point of Sale - Customer Profile".
  2. Add a credit invoice for the customer.
  • The posting account should be updated to "NONSALE".
  • Edit the "Revenue GL Account" to "Sales Main Software 40000000SFWE"
  • Save and Process Invoice 
Pass
3

Validate that "AR Sales Order View" shows

Revenue GL -.40000000SFWE 

Pass
4Validate the invoice in Epicor reflects the posting accounts in 2 above. 

Fails.

The sale was processed with below settings from LinkPOS

  1. Posting Account - NONSALE
  2. Revenue Account - 40000000SFWE  

The "Invoice Entry" in Epicor was created as below:

  1. Posting Account - LAHDWE
  2. Revenue Account - 40000000HDWE 

  • Test URL - http://10.0.0.16/LinkWEB-EPICOR/Account/login.aspx
  • Control Number in Epicor - ARTRX0000224
  • POS Reference No - RC000010 

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 11.5.0505
  3. Setup: Demo
  4. Server : 10.0.0.16
  5. Database: LINKSOFT-XERO

Next Step

  1. Review

    21 May 202003:09PM Comment 6 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 22-05-2020 03:05 PM Time Taken: 2.00

    Development work for this case has been completed.

    The change will be available in version: 11.5.0521

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

    1. Added revenue GL account when Epicor AR invoice is created from Link WEB.

    2. Affected Areas:

    1. EPICOR AR Invoice integration
    2. JIWA 6/7 Sales order integration. Note that Jiwa does not support changing the revenue account.

    3. The issue was caused by:

    1. New feature/improvement. Request from Datec Fiji

    4. Notes: Posting account used in EPICOR is from the EPICOR customer defaults.
    5. Next Step
    : UAT


    22 May 202010:10AM Comment 7 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 26-05-2020 09:42 AM Time Taken: 1.00
    QA Results
    Tests carried out according to requirements specified on the case header

    Test Results Summary

    Table 1 - Summarised list of issues
    NoTest DescriptionPass/Fail
    1
    • Create a  posting account that should be updated to "NONSALE".
    • Edit the "Revenue GL Account" to "Sales Main Software 40000000SFWE"
    • Save and Process Invoice
    • Validate that the invoice  entry is created with code - 40000000SFWE 
    Pass

    Environment Details

    1. OS version: Windows Server 2012
    2. Application version: 11.5.0521
    3. Setup: Demo
    4. Server : 10.0.0.14
    5. Database: LINKSOFT-DEMO-11-RASHNA

    Next Step

    1. Documentation

      02 Jun 202001:40PM Comment 8 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 03-06-2020 01:14 PM Time Taken: 1.00 Notes: Edited by sanjay on 24/09/20 08:36. 

      Hi Sanjay, 

      Documentation has been updated at LinkSOFT\LinkWebApplicationsPortal\Point of Sale\Invoice_List.htm

      Thanks
      Rashna

      NOTE: 11.5 has been renumbered to 12.0


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

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