Production Ticket(ST) #11511
OROMEO - May Route Plan Import
1) Verify the route plan data excel file provided by client.
2) Validate the file through website.
3) Exec route plan import from backend.
Root cause: Client request.
None
Description
Hi Kamal,
Sorry for late reply.
Seek for your assistant to import May route into Datanory (refer to the attached file), then I will kick start first text run by this week, if there have any issue & challenge will refer to you.
Btw, master user template will send you later once RSM reply me.
History
#1 Updated by Rashdan Hussin 5 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Rashdan Hussin 5 months ago
- Status changed from Support In Progress to Pending Client Feedback
- % Done changed from 0 to 50
Dear Carmen,
I’ve received your route plan import for May. However, there’s 379 customers don’t have salesman code information. You may refer to below attachment for reference. We unable to proceed to import these 379 customers due to your customer could be serviced by more than 1 merchandiser. We’ll proceed to import for the rest 1552 customer first.
Please advise action to be taken for 379 customers without salesman code information.
#3 Updated by Rashdan Hussin 5 months ago
- Status changed from Pending Client Feedback to Support In Progress
#4 Updated by Rashdan Hussin 5 months ago
- File Route Plan Import Template - May Route Plan.xlsx Route Plan Import Template - May Route Plan.xlsx added
- Status changed from Support In Progress to Pending Client Verification
- % Done changed from 50 to 90
- Actual Initial Response set to 22/04/2024
- Resolution updated (diff)
select * from di_RoutePlan_import where org_id = 'oromeo' and process_id = '501c9dc7-4f57-48b9-8ef3-9784a234582d' and error_message = ''
exec sp_DataLoad_di_RoutePlan_import '501c9dc7-4f57-48b9-8ef3-9784a234582d', 'oromeo'
select * from mst_route where org_id = 'oromeo' and created_date = '2024-04-24 15:32:02.603' order by created_date desc
#5 Updated by Rashdan Hussin 5 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100