Subject: | OTGL Fleet Enhancement Mobil Sales Delivery Docket and Customer Statement Report - Multiple Changes |
Summary: | A. Business Process - OTG facilitates Mobil Customers to fuel up at the OTG outlets.
- Since VMS is not enabled at OTG sites, The Mobil Customer will not work out with a Tax Invoice but rather a delivery docket. Figure 1.1 and Figure 1.2 below shows the sample of the delivery docket. However, when VMS is enabled, we will print VMS Tax Invoice followed by Sales Delivery. OTG will give the relevant docket to the Customer.
- This sale will need to be transmitted to FRCS using the customer name Mobil as a B2B sale instead of B2C. To achieve this, we will need to identify ‘Parent Customer’ in the customer profile.
- At the end of the Month, the SAP export file will be generated for Mobil customers and sent to Mobil.
- Mobil will then send the invoices to these customers from their system at a discounted price. (We don't need to handle discounts in the Link System)
- OTG will send the tax invoices together with a statement to Mobil for all Transactions that have been processed for Mobil Customers at the OTG outlets.
- Mobil will make the payment to OTG for these customers. Payment will be received for Parent Customer and allocated to the individual child customer invoices
B. Change Required: - Sales Delivery docket to be printed and issued to customer tagged under Category Mobil. Sample in Figure 1.1 and Figure 1.2 below.
- Actual Invoice to be completed under customer Mobil (Parent Customer)
- Mobil SAP file to incorporate the fleet customer name and details. Attached sample MobilMassUploadFileCustomerA&B.xlsx
- Customer Statement for Mobil to contain the customer name and vehicle number in the Reference Field as shown in Figure 3.1 below
C. Business Scenario Customer A has been registered with OTG as a Mobil Customer. Customer A buys 40 Litres of Unleaded Fuel from OTG Nabua Outlet. Customer A will be given a delivery docket similar to figure 1.1 below Figure 1.1 Sales Delivery Docket Customer A
Customer B has been registered with OTG as a Mobil Customer. Customer B buys 35 Litres of Diesel Fuel from OTG Nabua Outlet. Customer B will be given a delivery docket similar to figure 1.2 below Figure 1.2 Sales Delivery Docket Customer B
2. SAP Output File Attached is the SAP output file (MobilMassUploadFileCustomerA&B.xlsx) that will be sent to Mobile at the end of the Month. The Customer in this file will be the actual customer who has refuelled from OTG. 3. Customer Statement Statement to Mobile shown as Figure 31. below. Note the reference of the statement contains the names of the Mobil Customers together with their Vehicle Numbers. The Fleet Statement and Fleet Transaction Listing report will be generated for Mobil Customers only and Mobil should be able to log in and generate these reports from the portal on their own at the end of the month. Figure 3.1 Customer Statement for Mobil
Attached is the Signed Copy of the Signoff of the above. |
Audit Notes: | Edited by sanjay on 09/04/21 16:32. Edited by sanjay on 24/03/21 11:23. Edited by sanjay on 10/03/21 14:17. Edited by vineet on 09/03/21 14:36. Edited by vineet on 09/03/21 14:35. Edited by vineet on 03/03/21 08:23. Edited by vineet on 03/03/21 08:17. |
16 Feb 2021 | 11:01AM Comment 1 by Sanjay (Link Technologies) Assigned To: Vineet (Link Business Solutions) Followup Date: 16-02-2021 10:53 AM Time Taken: 1.00 |
| Thanks, Vineet. In our previous discussion, we agreed that we will print the standard docket and mark the changes required so that there is no confusion on what is delivered. My comments below: - The numbering of the requirements does not allow me to reference the figures and the changes required, Can you label the Table and add numbers to the changes?
- There is NO QR code on the receipt. You need FRCS approval to remove QR code.
- You need FRCS approval to change the document title from "TAX INVOICE" to "Sales Delivery Docket"
- I have attached a sample INVOICE that FRCS required for compliance. See attachments named "NormalSale" and "NormalRefund". Can you make amendments to this and get FRCS to approve the change? Then attach this as "ApprovedNormalSaleForMobil" and ApprovedNormalRefndForMobil"
I know this is a lot of work, however, it is better to get clarification before we make the change so that we do not double up the development effort. |
|
16 Feb 2021 | 12:34PM Comment 2 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 18-02-2020 10:00 AM Time Taken: 0.50 |
| Hi Sanjay The images have been labeled and referenced in the detail for clarity. Also, find attached approval from FRCS on confirmation to Mobil to issue Fiscal receipt and OTG to issue delivery docket for signoff for Mobil Customer Regards Vineet Ram |
|
19 Feb 2021 | 05:28PM Comment 3 by Sanjay (Link Technologies) Assigned To: Vineet (Link Business Solutions) Followup Date: 19-02-2021 05:04 PM Time Taken: 2.00 |
| Hi Vineet, Apologies for the delay in getting back, this is a tricky one and I needed some time to think through this. Effectively, this SOP requires us to treat Mobil as the "Parent Customer" of all customers under its umbrella, however, you have chosen to use the "Customer Category" to flag this dependency. This causes some issues in standardization as "category" does not imply "Parent Customer" Here is the best way and "least-cost means" that I can accommodate this change: - Add the following custom fields to the customer maintenance:
- Receipt Print - Yes/No. For Mobil Customers, this will be "No"
- Delivery Docket Print - Yes/No. For Mobil Customers, this will be "Yes"
- Delivery Docket Customer Name - Text Field. For Mobil Customers, this will be "On the Go Limited on Behalf of Mobil"
- Modify the Receipt to take into account the above custom fields
- Create the Delivery Docket and modify the report to take into account the above custom fields
- Write an OTG specific trigger to set the values in 1. above whenever the CATEGORY = "Mobil", and remove the values when the CATEGORY != "Mobil"
Change Cost: 20 hrs Delivery: 2 weeks from confirmation Questions: - Item 2 says something about the SAP Output file. Where is Item 1?. I see Sections A and B and then number 2 for the SAP Output file. I am assuming there is a change required to this file? If so, can you let me know what the change is?. I am assuming you want the custom field added to this file which contains a Mobil Customer code??
- Item 3 "3. Customer Statement" seems like a simple change. We can do this in 6 hours of work. This will have to be a custom report as the Logo and Addresses are in different places compared to our standard reports.
|
|
26 Feb 2021 | 04:08PM Comment 4 by Vineet (Link Business Solutions) Assigned To: Vineet (Link Business Solutions) Followup Date: 11-03-2021 12:00 AM Time Taken: 2.00 |
| In addition to comment 3, the following changes are required: - Integration SAP output file (Attached file name MobilMassUploadFileCustomerA&B.xlsx)- Change the following data
- Column K - Additional field of Customer. The additional field name is MobilCustomerNumber.
- Column L: Customer name.
- Column M: Customer name.
- VMS signing for customers under the Mobil Banner will need to be signed under Under Mobil. To achieve this we have to add a parent customer. If a parent customer is available the financial ownership need to be applied to the parent customer i.e VMS will be signed against the parent customer.
- On the customer statement, change the reference column to show the customer and vehicle details.
|
|
03 Mar 2021 | 08:16AM Comment 5 by Sanjay (Link Technologies) Case L12183 added to project 12.3 |
03 Mar 2021 | 08:17AM Comment 6 by Vineet (Link Business Solutions) ETC was changed from 19/02/2021 to 19/02/2021 |
05 Mar 2021 | 04:07PM Comment 7 by Sanjay (Link Technologies) Assigned To: Vineet (Link Business Solutions) Followup Date: 09-03-2021 04:07 PM |
| Hi Vineet, can we discuss this case first thing on Monday please? there are some clarifications needed before we can make this change. |
|
09 Mar 2021 | 11:10AM Comment 8 by Sanjay (Link Technologies) Assigned To: Vineet (Link Business Solutions) Followup Date: 10-03-2021 11:05 AM Time Taken: 2.00 |
| Hi Vineet, As discussed this morning, here is what needs to be done: - To SIgn invoices Against MOBIL, the customer Name and Tax ID needs to be Mobil
- All the other details can be the Customer details. W can add "Address 1,2,3" in the Customer Profile
- We can add a functionality to Receipt one account and allocate it to Multiple accounts on an "Oldest Invoice first" basis. Users can then maintain the allocations seperately
- Figure 3.1 cannot be done as a Customer Statement must be individualized. We agreed to remove this as Mobil will get a file for all its customers.
Since this case has a lot of incomplete items, can you create a fresh case with the requirements so we can start this build? |
|
10 Mar 2021 | 02:17PM Comment 9 by Sanjay (Link Technologies) Assigned To: Vineet (Link Business Solutions) Followup Date: 11-03-2021 02:17 PM Time Taken: 1.00 |
| Refer to changed requirements - case L12196 |
|
09 Apr 2021 | 04:32PM Comment 10 by Sanjay (Link Technologies) Case L12183 removed from project 12.3 |