Production Ticket(ST) #11963
KYMMSENG - today header and detail amount no tally
turned off the rounding at organization setup for kymmseng
None
Description
History
#1 Updated by Rashdan Hussin 4 months ago
- Subject changed from Suntory- today header and detail amount no tally to KYMMSENG - today header and detail amount no tally
- Due date changed from 08/06/2024 to 11/06/2024
- Type set to Support Request
- SLA Delivery set to 11/06/2024
#2 Updated by Rashdan Hussin 4 months ago
- File Invoice Not Tally SY.sql Invoice Not Tally SY.sql added
- Status changed from Assigned To to Support In Progress
select * from txn_invoice_history_header where invoice_no = 'INKSMS001218-240607'
--850.50
select * from txn_invoice_history_detail where invoice_id = '11637E504768412C8A20FD53047FD397'
select web_product_total_disc, mobile_product_total_disc, * from txn_invoice_history_detail where invoice_id = '11637E504768412C8A20FD53047FD397'
select sum(line_total) from txn_invoice_history_detail where invoice_id = '11637E504768412C8A20FD53047FD397'
--850.48
select * from txn_sales_order_header where ord_hdr_id = 'a1a78f12-6936-4a6e-985d-678dad3e4d22'
select order_web_net_amount, order_mobile_net_amount, * from txn_sales_order_header where ord_hdr_id = 'a1a78f12-6936-4a6e-985d-678dad3e4d22'
--order_web_net_amount 850.5000000000
--order_mobile_net_amount 850.4800000000
select * from txn_sales_order_details where ord_hdr_id = 'a1a78f12-6936-4a6e-985d-678dad3e4d22'
select web_product_total_disc, mobile_product_total_disc, * from txn_sales_order_details where ord_hdr_id = 'a1a78f12-6936-4a6e-985d-678dad3e4d22'
#3 Updated by Rashdan Hussin 4 months ago
- Assignee changed from Rashdan Hussin to Muhammad Arif
#4 Updated by Muhammad Arif 4 months ago
- Status changed from Support In Progress to Pending Client Verification
select 850.50
+ 1540.85
+ 33.30
+ 350.75
+ 1030.55
+ 137.95
+ 850.50
SELECT * FROM
(
select h.invoice_id, h.invoice_no, h.invoice_balance AS header from txn_invoice_history_header h
inner join txn_invoice_history_detail d ON d.invoice_id = h.invoice_id
WHERE h.invoice_status like '%Approve%' AND CONVERT >= '2024-06-07' AND CONVERT <= '2024-06-07'
GROUP BY h.invoice_id, h.invoice_no, h.invoice_balance
) x
INNER JOIN
(
select d.invoice_id, SUM as line_total, cast(sum(ROUND) as decimal(18,2)) as line_total_before_discount, cast(sum(ROUND) as decimal(18,2)) as line_total_after_discount from txn_invoice_history_header h
inner join txn_invoice_history_detail d ON d.invoice_id = h.invoice_id
WHERE h.invoice_status like '%Approve%' AND CONVERT >= '2024-05-03' AND CONVERT <= '2024-06-07'
GROUP BY d.invoice_id
) y ON x.invoice_id = y.invoice_id
select * from txn_invoice_history_header where invoice_no='INKSMS001218-240607'
select * from txn_invoice_history_detail where invoice_id='11637E504768412C8A20FD53047FD397'
select * from product_item where item_id='70DD4BDDA0D5491DA4A88CDCABFC5B8C'
select * from customer where customer_id='50621d28-9fa1-4fa2-bb2f-07036c62e401'
#5 Updated by Muhammad Arif 4 months ago
- Assignee changed from Muhammad Arif to Rashdan Hussin
currently details is correct. Joe already requested user to follow details amount.
Plan: Joe will request datanory team to check on the header issue
#6 Updated by Rashdan Hussin 4 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 0 to 100
- Actual Initial Response set to 07/06/2024
- Resolution updated (diff)
[18:46, 10/06/2024] Rashdan Hussin: Hi team, boon already turned off the rounding at organization setup for kymmseng
[18:46, 10/06/2024] Rashdan Hussin: I check just now from our backend, no issue with header and detail amount for today. However, need to keep monitor this issue