| Subject: | Restrict data flowing into FMIS systems by Customer Category and Location |
| Summary: | With reference to case L12727, the below test cases are failing: Our Client has 20 Service Stations to accommodate the fuel needs of its customers. For the convenience of its Customers, the client has also made arrangements with third-party sites (Merchant Sites) where customers can fuel up at any of these Merchant Sites. Since all transactions are processed on the same database, we need a way to prevent "Merchant Site" transactions done for Non-Client customers from flowing into their FMIS system Below change was performed in version 14.1. We need a change so that when both conditions are met (2.1 below), then we send data to FMIS PART A - Development work for this case has been completed. 1. The change will be available in version:14.10 2. The following changes were made(Include Database object names, Program classes, and any other relevant information): - Added to filters to Sales Order Processing in FMISSQLAPI
- ExcludeCustomerCategory
- ExcludeShiftLocation
- Configuration is CSV list, users can specify multiple categories and locations using CSV format
3. Affected Areas: - Sales Order Integration - Filtered by Customer Category AND/OR Shift Location
4. The issue was caused by: - Change Request
5. Other Relevant Notes: Section B - Below is a test plan using examples
Task | Business Scenario | Merchant Site | Customer Category | Location | Record Sales in FMIS | Test Status
|
1 | Energy Fiji Limited fills $100 Unleaded at Grace Road Navua | Merchant Site | MOBIL | GRNAVUA | No | Pass
|
2 | Energy Fiji Limited fills $120 Unleaded at On The Go Sigatoka Site | OTGL Site | MOBIL | SIG01 | Yes | FAIL
|
3 | Energy Fiji Limited fills $100 Unleaded at Bridge Town Service Station | Merchant Site | MOBIL | BTB01 | No | PASS
|
4 | Link Business Solutions fills $100 Diesel at OTGL Regent | OTGL Site | OTGL | SUV02 | Yes | PASS
|
5 | Link Business Solutions fills $130 Unleaded at Grace Road Navua | Merchant Site | OTGL | GRNAVUA | Yes | FAIL
|
6 | Link Business Solutions fills $90 Unleaded at Bridge Town Service Station | Mer chant Site | OTGL | BTB01 | Yes | FAIL |
|
| Audit Notes: | Edited by sanjay on 19/04/23 15:43. Edited by sanjay on 18/04/23 11:38. Edited by sanjay on 30/03/23 16:17. Edited by sanjay on 30/03/23 16:13. Edited by sanjay on 30/03/23 16:03. Edited by sanjay on 30/03/23 09:47. Edited by sanjay on 20/03/23 16:39. Edited by sanjay on 20/03/23 16:38. Edited by sanjay on 15/03/23 13:45. Edited by sanjay on 10/03/23 08:36. |
| 06 Mar 2023 | 02:52PM Comment 1 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 06-03-2023 08:44 PM Time Taken: 1.00 |
| Development Meeting Sanjay and Vineet 06/03/2023 Test cases 2,4 and 5 are failing because we need both category and location to pass for the transaction to be excluded from FMIS. |
|
| 10 Mar 2023 | 08:36AM Comment 2 by Sanjay (Link Technologies) Case L12845 added to project 14.60 |
| 20 Mar 2023 | 04:38PM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 22-03-2023 06:38 PM |
| Moved to 14.70 due to urgent release with bug fixes in 14.50 |
|
| 20 Mar 2023 | 04:38PM Comment 4 by Sanjay (Link Technologies) Case L12845 added to project 14.70 |
| 30 Mar 2023 | 04:03PM Comment 5 by Sanjay (Link Technologies) ETC was changed from 24/02/2023 to 07/04/2023 |
| 30 Mar 2023 | 04:17PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 07-04-2023 06:17 PM Time Taken: 1.00 |
| Hi Vineet, can you update he case with the environment where this is setup? |
|
| 03 Apr 2023 | 12:55PM Comment 7 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 06-04-2023 10:54 AM Time Taken: 3.00 |
| Hi Sanjay Setup details below: Server: LINKQA4\CP1
DB: CLIENT-OTGL-LinkSOFT-HQ
User: Admin
PW: Standard Admin Pw
URL: http://10.0.0.18/OTGL-HQ I have performed the below transactions using the fleet card details as listed.
Task | Business Scenario | Merchant Site | Customer Category | Location | Record Sales in FMIS | CardNo | Pin | ReferenceNumber | Test Status |
1 | Energy Fiji Limited fills $100 Diesel at Grace Road Veisari | Merchant Site | MOBIL | GRV01 | No | /%40209%/. | 12342102 | HQRC0000040506 | Pass |
2 | Energy Fiji Limited fills $120 Diesel at On The Go Sigatoka Site | OTGL Site | MOBIL | SIG01 | Yes | /%40209%/. | 12342102 | HQRC0000040507 | FAIL |
3 | Energy Fiji Limited fills $100 Diesel at Kundan Service Station | Merchant Site | MOBIL | KUN01 | No | /%40209%/. | 12342102 | HQRC0000040508 | PASS |
4 | Link Business Solutions fills $100 Diesel at OTGL Sigatoka Site | OTGL Site | OTGL | SIG01 | Yes | /%35971%/. | 1234 | HQRC0000040509 | PASS |
5 | Link Business Solutions fills $130 Unleaded at Grace Road Veisari | Merchant Site | OTGL | GRV01 | Yes | /%35971%/. | 1234 | HQRC0000040510 | FAIL |
6 | Link Business Solutions fills $90 Unleaded at Kundan Service Station | Mer | OTGL | KUN01 | Yes | /%35971%/. | 1234 | HQRC0000040511 | FAIL |
| | chant Site | | | | | | | |
Thanks
Vineet Ram |
|
| 04 Apr 2023 | 01:38PM Comment 8 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-04-2023 02:29 PM Time Taken: 12.00 |
| PART A - Development work for this case has been completed. 1. The change will be available in version: 14.70 2. The following changes were made(Include Database object names, Program classes, and any other relevant information): - Added an "ExcludeMethod" rule that allows the user to choose if the "ExcludeCustomerCategory" and "ExcludeShiftLocation" rules are used together or separately.
- When Enabled, both conditions must be met for the transaction to be excluded.
3. Affected Areas: - FMISSQLAPI Integration for Sales Orders
4. The issue was caused by: - Enhancement requested by users
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT
|
|
| 05 Apr 2023 | 09:45AM Comment 9 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 07-04-2023 11:17 AM Time Taken: 2.00 |
| Bula Sanjay 2 scenarios are still failing. Below is the test results:
Task | Business Scenario | Merchant Site | Customer Category | Location | Record Sales in FMIS | CardNo | Pin | ReferenceNumber | Test Status |
1 | Energy Fiji Limited fills $100 Diesel at Grace Road Veisari | Merchant Site | MOBIL | GRV01 | No | /%40209%/. | 12342102 | HQRC0000040512 | FAILED |
2 | Energy Fiji Limited fills $120 Diesel at On The Go Sigatoka Site | OTGL Site | MOBIL | SIG01 | Yes | /%40209%/. | 12342102 | HQRC0000040513 | PASS |
3 | Energy Fiji Limited fills $100 Diesel at Kundan Service Station | Merchant Site | MOBIL | KUN01 | No | /%40209%/. | 12342102 | HQRC0000040514 | FAILED |
4 | Link Business Solutions fills $100 Diesel at OTGL Sigatoka Site | OTGL Site | OTGL | SIG01 | Yes | /%35971%/. | 1234 | HQRC0000040515 | PASS |
5 | Link Business Solutions fills $130 Unleaded at Grace Road Veisari | Merchant Site | OTGL | GRV01 | Yes | /%35971%/. | 1234 | HQRC0000040516 | PASS |
6 | Link Business Solutions fills $90 Unleaded at Kundan Service Station | Mer | OTGL | KUN01 | Yes | /%35971%/. | 1234 | HQRC0000040517 | PASS |
Thanks
Vineet Ram |
|
| 05 Apr 2023 | 04:34PM Comment 10 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 07-04-2023 05:31 PM Time Taken: 1.00 |
| *** Skype message ***
Vineet, 9:45 AM For case L12845, there are 2 failed cases still. I have updated the case with the results
4:06 PM Bosso, I did the tests and I don't get the same result as your's in comment 9. Can you check again? or maybe we can check together?
Vineet, 4:07 PM Tomorrow at 9 am AEST?
Ok?
I am testing the environment I gave. The results can review under AR Sales Order. I have given the Link Reference Number
2 that should not have gone in Jiwa is sitting in Jiwa
I see the problem. You are using Shift location for exclusion. I am using the POS Order Detail line location doing all sales in 1 shift. I'll test tomorrow on different locations' shift
I guess that's why mine failed
4:11 PM :) ok. Yes the rule says Shift Location as an order can have multiple locations I tested it again and mine is following the rules in comment 8
Vineet, 4:12 PM Yap. Acha will test tomorrow first thing and let you know
4:13 PM Let me know, I can do Midday or 2 PM.
Im not sure if you are 2 hours ahead or 1 hour. Its 4:12 PM here
Vineet, 4:13 PM 2 hours
its 6.15 pm here
Off to do some running now. Let's catch up tomorrow
4:14 PM ooi, ok let me know how you go in the morning and we can work something out
Vineet, 4:14 PM set boss
4:14 PM
Off to do some running now. Lets catch up tomorrow Vineet, Today at 4:14 PM awesome :)
|
|
| 06 Apr 2023 | 10:57AM Comment 11 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 12-04-2023 12:18 PM Time Taken: 2.00 |
| Hi Sanjay I have tested this on the QA4 setup using the below test plan. This is functioning as per the required design.
Task | Business Scenario | Merchant Site | Customer Category | Location | Record Sales in FMIS | CardNo | Pin | ReferenceNumber | Test Status |
1 | Energy Fiji Limited fills $100 Diesel at Grace Road Veisari | Merchant Site | MOBIL | GRV01 | No | /%40209%/. | 12342102 | HQRC0000040523 | PASS |
2 | Energy Fiji Limited fills $120 Diesel at On The Go Sigatoka Site | OTGL Site | MOBIL | SIG01 | Yes | /%40209%/. | 12342102 | HQRC0000040518 | PASS |
3 | Energy Fiji Limited fills $100 Diesel at Kundan Service Station | Merchant Site | MOBIL | KUN01 | No | /%40209%/. | 12342102 | HQRC0000040521 | PASS |
4 | Link Business Solutions fills $100 Diesel at OTGL Sigatoka Site | OTGL Site | OTGL | SIG01 | Yes | /%35971%/. | 1234 | HQRC0000040520 | PASS |
5 | Link Business Solutions fills $130 Unleaded at Grace Road Veisari | Merchant Site | OTGL | GRV01 | Yes | /%35971%/. | 1234 | HQRC0000040524 | PASS |
6 | Link Business Solutions fills $90 Unleaded at Kundan Service Station | Mer | OTGL | KUN01 | Yes | /%35971%/. | 1234 | HQRC0000040522 | PASS |
Thanks
Vineet Ram
222 0085 |
|
| 13 Apr 2023 | 12:35PM Comment 12 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 19-04-2023 02:35 PM Time Taken: 2.00 |
| Thank's Vineet. I will mark this case as closed. |
|