| Subject: | Redesign SQL API for EPICOR 7.4 General Ledger Journals |
| Summary: | Build SQL API for EPICOR 7.4 for General Ledger Journals |
| Audit Notes: | |
| 05 Feb 2018 | 04:58PM Comment 1 by Alvis (Link Technologies) Case 9096 added to project 8.3 |
| 06 Feb 2018 | 10:04AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 06-02-2018 10:04 AM Time Taken: 4.00 |
| Created EPICOR 74 API integration scripts according to requirements specified in case 9095 API packs need to be installed manually in EPICOR 74 database. This pack created the required procedures and functions to create transactions in EPICOR. Test the following for this integration: - Apply the EPICOR 74 integration API on an EPICOR 74 Database
- Enable linkSOFT integration in POS WEB to EPICOR 74
- Confirm transactions flow from LinkSOFT to EPICOR 74 according to the requirements in CASE 9095.
|
|
| 16 Feb 2018 | 03:50PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 16-02-2018 03:50 PM Time Taken: 1.00 |
| Please proceed with UAT. |
|
| 23 Feb 2018 | 02:55PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-02-2018 02:55 PM Time Taken: 2.00 |
| We have added "Company Code" and "Organisation ID" to GL Journal and AP Invoice integration. These codes are required for EPICOR integration. System tests completed on creating GL Journal and AP Invoice in EPICOR. |
|
| 26 Feb 2018 | 12:01PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 26-02-2018 12:01 PM Time Taken: 2.00 |
| QA Results Step 1 - Developer will perform test based on test cases provided Step 2 - Product expert to complete Product QA based on test cases.
Test cases are provided on the case header before the case is approved for development. Test Results Summary Table 1 - Summarised list of issues | No | Test Description | Pass/Fail | 1 | Users with access should be able to access the "Integration " modules
| Pass | 2 | For the "APInvoiceSQL" and "GlJournalSQl", set the below - Database Name - Epicor74
- CompanyCode - Dist
- OrganisationID - MAIN
This should be saved without errors. | Pass | 3 | Execute, processes "SYS009", this should run without errors. | Pass | 4 | Create and update pay for employees E013 and E019.Pay date 26/02/2018. Pay should be updated without errors
| Pass
| 5 | Generate the "GL Integration Report", the report should be generated without errors. | Pass | | 6 | GL Journal View and AP Invoice View should be created | Pass | | 7 | Change posting date to 31/12/2008. This should be successfully completed | Pass | | 8 | Edit the posting account and it should be successfully updated | Pass | | 9 | "Process Invalid Entries" for GL Journal View and AP Invoice VIew, and should this should be successfully completed | Pass | | 10 | Journals should be created for the below - ANHRS
- ANZ
- HGOVL
- AAL
- AAL15
- HSUPE
- FPAYE
- FSUPE
| Pass | | 11 | AP Invoice should be created for the below | Pass | | 12 | Users should be able to post the journals and invoices in Epicor | Pass |
QA Environment Details - OS version:Windows 7
- Application version:9.2.5
- Database (Demo/New/Client): Demo LINKSOFT - 9.2.5 and Epicor 74 on QA1
Steps to reproduce failed scenarios Case assigned for documentation.
|
|
| 28 Feb 2018 | 03:28PM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 01-03-2018 12:00 AM Time Taken: 1.00 |
| Hi Sanjay, The case has been tested as per comment 5. Documentation on the case has been completed. Documentation updated under ESS--> Integration --> Integration Setup. Thanks
Rashna |
|
| 28 Feb 2018 | 03:51PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 28-02-2018 03:51 PM |
| Thanks Rashna |
|
| 09 Oct 2019 | 08:14AM Comment 8 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019 |