Subject: | Payroll Territory, Branch and "Cost Centre" Upload template |
Summary: | Requested Feature: "Branch" and "Cost Centre" Upload template
While doing the Project for Jacks Retail Pte Limited, we have identified that they have stores in almost all the towns and cities in Fiji. They are using the Multi-Company feature whereby they will have 8 companies. Therefore we need;- Template to Upload "Branch" in all 8 companies
- Template to Upload "Cost Centre" in all 8 companies
Regards Vineshwar Prasad |
Audit Notes: | Edited by sanjay on 12/05/22 16:03. Edited by sanjay on 12/05/22 09:18. |
11 May 2022 | 09:05AM Comment 1 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 12-05-2022 09:04 AM |
| Transferred to Development |
|
11 May 2022 | 01:11PM Comment 2 by Sanjay (Link Technologies) Case L12721 added to project 14.00 |
12 May 2022 | 09:18AM Comment 3 by Sanjay (Link Technologies) ETC was changed from 15/05/2022 to 15/05/2022 |
12 May 2022 | 04:06PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 13-05-2022 04:03 PM Time Taken: 21.00 |
| PART A - Development work for this case is in progress 1. The change will be available in version: 14.00 2. The following changes were made(Include Database object names, Program classes, and any other relevant information): - Created a CSV template for:
- Payroll Territory - Format: CompanyID,Code,Description,GLCode,Notes
- Payroll Branch - Format: CompanyID,Code,Description,GLCode,PhysicalAddress1,PhysicalAddress2,PhysicalAddress3,City,State,PostCode,Country,PostalAddress1,PostalAddress2,PostalAddress3,Phone,Fax,Notes
- Payroll Cost Centre - Format: CompanyID,Code,Description,GLCode,Notes
- Added dropdown List for the above three imports
- Added to Business Intelligence ~> File Import for Validation and POST
3. Affected Areas: - File Import
4. The issue was caused by: - Improvement
5. Other Relevant Notes: 6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): System Test |
|
13 May 2022 | 11:02AM Comment 5 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 17-05-2022 09:57 AM Time Taken: 18.00 Notes: Edited by sanjay on 13/05/22 11:03. |
|
The following tests were performed: Table 1 - Test Results
No | Test Case | Expected Result | Pass/Fail | Comments | 1 | Use the sample provided to upload the Territory. Make Company Code and Territory Code invalid. Correct Upload issues and VALIDATE followed by POST
| Validation should flag invalid values. Verify upload Territory
| Pass
|
| 2 | Use the sample provided to upload the Branch. Make Company Code, Territory Code, City, State, Country invalid. Correct Upload issues and VALIDATE followed by POST | Validation should flag invalid values. Verify upload Branch
| Pass
|
| 3 | Use the sample provided to upload the COst Centre. Make Company Code and Cost Centre Code invalid. Correct Upload issues and VALIDATE followed by POST
| Validation should flag invalid values. Verify upload Cost Centre
| Pass
|
| Environment Details - OS version: Win11
- Application version: 14.00
- Setup on:
- Server: LinkQA4
- Database: LinkSOFT
- LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
- Login Details: Standard username and password for user "admin"
Next Step: UAT
|
|
21 Jul 2022 | 02:45PM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 28-07-2022 02:33 PM Time Taken: 4.00 |
|
The following tests were performed: Table 1 - Test Results
No | Test Case | Expected Result | Pass/Fail | Comments | 1 | Import Territory/Branch/Cost Center with New Codes
|
| Pass
|
| 2 | Import Territory/Branch/Cost Center with New Existing Codes
| Validation should fail
| Pass
|
| 3 | Amend codes in 2. above and validate
| Validation should pass
| Pass
|
| 4 | Import and verify
|
| Pass
|
| 5 |
|
|
|
| Environment Details - OS version: Win11
- Application version: 14.00
- Setup on:
- Server: LinkQA4
- Database: LinkSOFT
- LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
- Login Details: Standard username and password for user "admin"
Next Step: Closure
|
|