Project

General

Profile

Production Ticket(ST) #11473

GRADINO - SKU and UOM Setup Issues in Gradino Trial Environment

Added by Rashdan Hussin 5 months ago. Updated 5 months ago.

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Rashdan Hussin
Start date:
17/04/2024
Due date:
24/04/2024
% Done:

100%

Estimated time:
Spent time:
3.00 h
Job Remark:
Ticket Logged Date:
17/04/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
17/04/2024
SLA Delivery:
24/04/2024
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
17/04/2024
Resolution:

1) Delete unrelated item from product item table.
2) Import the missing item.
3) Patch the Conv Fact Oth Uom to be the same as Conv Fact Alt Uom for SKUs with only 2 UOM.

Root cause: Wrong data in product item table.

Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:

None

Description

Dear Afiq,

Currently I’m using Gradino Trial Environment for Power BI testing purposes. However, based on image attached below, SKU001 until SKU050 does not belong to Gradino, and Gradino’s actual SKU001 until SKU050 is missing. Please assist to re-import the SKU into Gradino Trial Environment.

Even though the SKU issue is not occurring in Gradino Production Environment, but I’ve found that there’s a UOM Setup incorrectly for certain SKU in both Production and Trial environment. You may refer to below attachment as reference. Some SKU have 3 UOM while others only have 2 UOM. From my understanding, for 2 UOM, the conversion rate for “Conv Fact Alt Uom” should the same as “Conv Fact Oth Uom”

Thanks.

Warm Regards,

Muhamad Kamal Arif Bin Muhamad




download4.png (150 KB) download4.png Rashdan Hussin, 17/04/2024 10:12 AM
download3.png (240 KB) download3.png Rashdan Hussin, 17/04/2024 10:12 AM
download1.png (386 KB) download1.png Rashdan Hussin, 17/04/2024 10:12 AM
download2.png (240 KB) download2.png Rashdan Hussin, 17/04/2024 10:12 AM
SKU Import (GRADINO).xlsx (48.2 KB) SKU Import (GRADINO).xlsx Rashdan Hussin, 17/04/2024 10:13 AM

History

#1 Updated by Rashdan Hussin 5 months ago

  • File deleted (download.png)

#2 Updated by Rashdan Hussin 5 months ago

  • File deleted (download3.png)

#3 Updated by Rashdan Hussin 5 months ago

  • File deleted (download2.png)

#4 Updated by Rashdan Hussin 5 months ago

  • File deleted (download1.png)

#5 Updated by Rashdan Hussin 5 months ago




#7 Updated by Rashdan Hussin 5 months ago

  • Status changed from Support In Progress to Pending Client Verification
  • % Done changed from 0 to 90
  • Actual Initial Response set to 17/04/2024
  • Resolution updated (diff)

--select * into _product_item_20240421 from product_item

--select * from product_item where org_id = 'gradino' and updated_by = 'DATANORYTRIAL-admin' order by item_code

--delete from product_item where org_id = 'gradino' and updated_by = 'DATANORYTRIAL-admin'

--select * from product_item where org_id = 'gradino'
--and item_id not in (select item_id from mst_product_price where org_id = 'gradino')
--order by item_code

--delete from product_item where org_id = 'gradino'
--and item_id not in (select item_id from mst_product_price where org_id = 'gradino')

--select * from product_item where org_id = 'gradino' and cf_oth_uom = '1'

--update product_item set cf_oth_uom = cf_alt_uom
--where org_id = 'gradino' and cf_oth_uom = '1'

--select * into _mst_product_price_20240421 from mst_product_price

--select * from mst_product_price where org_id = 'gradino'
--and item_id not in (select item_id from product_item where org_id = 'gradino')

--delete from mst_product_price where org_id = 'gradino'
--and item_id not in (select item_id from product_item where org_id = 'gradino')

--select * from di_product_item_import_Price where org_id = 'gradino' order by created_date desc

--INSERT into mst_product_price(
-- price_id,
-- price_code_id,
-- item_id,
-- selling_price,
-- price_basis,
-- status,
-- created_date,
-- created_by,
-- updated_date,updated_by,org_id,tenant_id)
-- SELECT
-- IsNull(temp.price_id, ''),
-- IsNull(mpc.price_id, ''),
-- IsNull(cc.item_id, ''),
-- IsNull(temp.selling_price, ''),
-- IsNull(temp.price_basis, ''),
-- IsNull(temp.status, ''),
-- IsNull(temp.created_date, ''),
-- IsNull(temp.created_by, ''),
-- IsNull(temp.updated_date, ''),
-- IsNull(temp.updated_by, ''),
-- IsNull(temp.org_id, ''),
-- IsNull(temp.tenant_id, '')
-- FROM di_product_item_import_Price temp
-- inner join product_item cc on temp.item_code=cc.item_code and temp.org_id = cc.org_id
-- inner join mst_price_code mpc on temp.price_code=mpc.price_code and temp.org_id = mpc.org_id
-- WHERE NOT EXISTS
-- and isNull(error_message, '') = ''
-- AND temp.org_id = 'gradino'
-- AND process_id = '8f81c9f5-149a-4faf-8ebe-edad7fd2014c'
-- order by cc.item_code

#8 Updated by Rashdan Hussin 5 months ago

  • Status changed from Pending Client Verification to Ticket Resolved

#9 Updated by Rashdan Hussin 5 months ago

  • % Done changed from 90 to 100

Also available in: Atom PDF