Production Ticket(ST) #11736
Goldcrest- Hi pls check, why didnt rounding up, unit price RM53.00
0%
None
Description
History
#1 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
SELECT
sod.base_uom_list_price,
pp.selling_price,
pt.item_name,
pt.item_code,
pp.selling_price,
sod.uom1_id,
ppt.*
FROM
txn_sales_order_details sod
INNER JOIN
mst_product_price pp ON sod.product_id = pp.item_id
INNER JOIN
product_item pt ON sod.product_id = pt.item_id
INNER JOIN
mst_product_price_at ppt ON sod.product_id = ppt.item_id
WHERE
sod.ord_hdr_id = 'beb93095-1edc-477b-b8d5-dd8bf832047b'
AND pp.price_code_id = '958C5158-80BB-4D60-A9AB-AB227182473E'
ORDER BY
pt.item_name DESC;
as I checked in the At_table the value is 53.00 for each SKU.
-------------------------------------
AUTOCOUNT
SELECT *FROM IV WHERE DocNo like '%INMCJ000276%'
select * from IVDTL where DocKey= '2534703'
-------------------------------------------------------------------------
HI arif as I checked, the value in the datanory is correct for the total wise I noticed that the total amount is SAME AS autocount but different in the we portal. the amount selling price different in the autocount. Need advise on this ticket to further check
Handover to arif , end shift
#2 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Assignee changed from Muhammed Azhar Mohamed Maideen to Muhammad Arif
#3 Updated by Muhammad Arif 4 months ago
- Status changed from Assigned To to Support In Progress
in progress verify logic with tech team.
as first, i noticed that we integrate the mentioned invoice with PCS price, but in autocount will show as CTN. may need to further check if have any calculation for UOM conversation.
#4 Updated by Muhammad Arif 4 months ago
- Status changed from Support In Progress to Pending Client Feedback
Hi
Pls understand our office operating hours
Monday-Friday-8.30am to 5.30pm
Saturday-8.30am to 12.30pm
Need to wait for their next operating hours. Support team need to remote goldcrest to further checking on the sku setup in autocount
#5 Updated by Muhammad Arif 4 months ago
- Status changed from Pending Client Feedback to Ticket Resolved
- SLA Delivery set to 21/05/2024
- Actual Initial Response set to 17/05/2024