| 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: - Add integration where GL Chart of accounts is imported from FMS Systems
- Add field to capture Revenue Account Drop Down in the Invoice Entry Line Items
- When passing the invoice to FMS, use the nominated Revenue account if one is available
- 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 2020 | 03:36PM Comment 1 by Sanjay (Link Technologies) ETC was changed from 20/03/2020 to 03/04/2020 |
| 24 Apr 2020 | 10: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): - Added Revenue account and Posting Account to Invoice line items
- When an item is selected, default values are loaded
- 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
- GL Integration has been enabled so Revenue Accounts from ERP will be available
2. Affected Areas: - POS Customer Maintenance
- POS Invoice View
3. The issue was caused by: - 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 2020 | 03: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 2020 | 04:53PM Comment 4 by Alvis (Link Technologies) ETC was changed from 03/04/2020 to 29/04/2020 |
| 21 May 2020 | 09: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 | No | Test Description | Pass/Fail | | 1 | Create a MISC Item in Linkweb with below details: - Posting Account - NONSALE
- Location - Main
| Pass | | 2 | Create a customer in Linkweb with code as "LinkPOS" - Navigate to "Linkweb - Point of Sale - Customer Profile".
- 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 | | 4 | Validate the invoice in Epicor reflects the posting accounts in 2 above. | Fails. The sale was processed with below settings from LinkPOS - Posting Account - NONSALE
- Revenue Account - 40000000SFWE
The "Invoice Entry" in Epicor was created as below: - Posting Account - LAHDWE
- 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 - OS version: Windows Server 2012
- Application version: 11.5.0505
- Setup: Demo
- Server : 10.0.0.16
- Database: LINKSOFT-XERO
Next Step: - Review
|
|
| 21 May 2020 | 03: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): - Added revenue GL account when Epicor AR invoice is created from Link WEB.
2. Affected Areas: - EPICOR AR Invoice integration
- JIWA 6/7 Sales order integration. Note that Jiwa does not support changing the revenue account.
3. The issue was caused by: - 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 2020 | 10: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 | No | Test Description | Pass/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 - OS version: Windows Server 2012
- Application version: 11.5.0521
- Setup: Demo
- Server : 10.0.0.14
- Database: LINKSOFT-DEMO-11-RASHNA
Next Step: - Documentation
|
|
| 02 Jun 2020 | 01: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 |
|