Production Ticket(ST) #12082
YAKULT - SFA Implementation for Yakult
1) Review and verify all the data in excel file provided.
2) Insert the data into database.
3) Do testing.
Root cause: Client master data update.
None
Description
Dear Rashdan,
Kindly import Yakult Customer and User Master Data attached into Datanory Trial. Then, please assist to setup the approval (either one) based on the Approval List attached.
Before import, please assist to backup database and clear all the Yakult warehouse and branch Master.
After the setup, please help to verify one round end to end process of Van Sales. Van Goods Request -> Van Goods Request Approval -> Van Goods Receive -> Sales Order, Exchange, Goods Return, Collection -> Check out -> Upload
Thanks.
Warm Regards,
Muhamad Kamal Arif Bin Muhamad
History
#1 Updated by Rashdan Hussin 3 months ago
- Status changed from Assigned To to Support In Progress
select * from #TempTable --151
select * from approval_flow where org_id = 'A000002' order by created_date desc --29
--insert into approval_flow (approval_flow_id, org_id, tenant_id, information_id, information_desc, activity, start_date, end_date, status, created_date, created_by, updated_date, updated_by)
--select newid(), 'A000002', 'A000002', information_id, information_desc, activity, '2024-01-01 00:00:00.000', '2099-12-31 00:00:00.000', 'Active', getdate(), 'Support', getdate(), 'Support'
--from #TempTable
INSERT into approval_flow_branch (id, org_id, tenant_id, approval_flow_id, branch_id, status, created_date, created_by, updated_date, updated_by)
SELECT NEWID, 'A000002', 'A000002', c.approval_flow_id, b.branch_id, 'Active', GETDATE, 'Support', GETDATE, 'Support'
FROM
(
select di.information_id, di.branch_code from #TempTable di
group by di.information_id, di.branch_code
) x
inner join mst_branch b on b.branch_code = x.branch_code and b.org_id = 'A000002'
inner join approval_flow c on c.information_id = x.information_id and c.org_id = 'A000002'
where NOT EXISTS
insert into approval_flow_approver
(id, org_id, tenant_id, approval_flow_id, member_id, level, status, created_date, created_by, updated_date, updated_by, approval_mode)
select newid(), 'A000002', 'A000002', b.approval_flow_id, c.member_id, '1', 'Active', GETDATE, 'Support', GETDATE, 'Support', 'Either One'
from #TempTable a
inner join approval_flow b on b.information_id = a.information_id and b.org_id = 'A000002'
inner join member c on c.member_cd = a.user_code and c.org_id = 'A000002'
where not exists(select 1 from approval_flow_approver r where r.org_id = 'A000002' and b.approval_flow_id= r.approval_flow_id and c.member_id = r.member_id)
#2 Updated by Rashdan Hussin 3 months ago
- Status changed from Support In Progress to Pending Client Verification
- % Done changed from 0 to 90
- Actual Initial Response set to 23/06/2024
- Resolution updated (diff)
#3 Updated by Rashdan Hussin 3 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100