Production Ticket(ST) #11723: Goldcrest- Hi pls check, when the salesman checked the invoice history details, he found that the bill amount did not match the bill quantity. - Datanory - GOLDCREST - Redmine

Production Ticket(ST) #11723

Goldcrest- Hi pls check, when the salesman checked the invoice history details, he found that the bill amount did not match the bill quantity.

Added by Muhammed Azhar Mohamed Maideen 4 months ago. Updated 4 months ago.

Status:

Ticket Resolved

Priority:

P3 - Medium

Assignee:

Muhammed Azhar Mohamed Maideen

Start date:

15/05/2024

Due date:

23/05/2024

% Done:

Estimated time:

Job Remark:

Ticket Logged Date:

15/05/2024

Ticket No.:

Related Ticket ID:

Type:

Support Request

SLA Initial Response:

15/05/2024

SLA Delivery:

Esclation Time:

Issue Reoccurance#:

Actual Initial Response:

29/05/2024

Resolution:

1) checked the database

2) checked the portal
3) checked the mobile database
4) escaalted to technical team for further checking

5) already fixed and customer verified
root cause- Bug

Requester ExpectedDeliveryDate:

Delay Justification:

Priority Seq:

Effort (Hour):

External Ticket #:

None

Description

Stocks qty

WhatsApp Image 2024-05-15 at 13.36.52_f0ab5e80.jpg (36.2 KB) WhatsApp Image 2024-05-15 at 13.36.52_f0ab5e80.jpg		Muhammed Azhar Mohamed Maideen, 15/05/2024 02:16 PM
WhatsApp Image 2024-05-15 at 13.37.23_78ea9128.jpg (31.4 KB) WhatsApp Image 2024-05-15 at 13.37.23_78ea9128.jpg		Muhammed Azhar Mohamed Maideen, 15/05/2024 02:16 PM
SalesOrderInvoice_28-05-2024.pdf (40.9 KB) SalesOrderInvoice_28-05-2024.pdf		Muhammed Azhar Mohamed Maideen, 28/05/2024 04:23 PM
WhatsApp Image 2024-05-28 at 16.24.41_f8cd4e7b.jpg (132 KB) WhatsApp Image 2024-05-28 at 16.24.41_f8cd4e7b.jpg		Muhammed Azhar Mohamed Maideen, 28/05/2024 04:23 PM

History

#1 Updated by Muhammed Azhar Mohamed Maideen 4 months ago

Based on my finding, I suspect there is reciept issue ( it did not show complete SKUs in the list)
SELECT ptem.item_name,ptem.item_code,dtl.web_uom2_qty,dtl.web_uom1_qty,*
FROM txn_invoice_history_header ihh
INNER JOIN txn_sales_order_header soh ON ihh.sales_order_id = soh.ord_hdr_id
INNER JOIN txn_sales_order_details dtl on soh.ord_hdr_id= dtl.ord_hdr_id
INNER JOIN product_item ptem on dtl.product_id= ptem.item_id
--INNER JOIN txn_invoice_history_detail invd on ihh.invoice_id= invd.invoice_id

WHERE ihh.invoice_no = 'INWWQ000311-240417';
the details and the total amount of invoice are correct

Steps need to do
Have to replicate this in the trail environment
but Have to do setup on the SKUs,
need advise from rashdan on setup the SKus to the particular customer.

#2 Updated by Muhammad Arif 4 months ago

Status changed from Assigned To to Support In Progress
Assignee changed from Muhammed Azhar Mohamed Maideen to Muhammad Arif

#3 Updated by Muhammad Arif 4 months ago

Status changed from Support In Progress to Pending Client Feedback

Hi @~Suzanne , kindly help to request user WWQ to upload database for further checking.

#4 Updated by Muhammed Azhar Mohamed Maideen 4 months ago

select * from txn_invoice_history_header where invoice_no= 'INWWQ000311-240417'
select * from txn_invoice_history_detail where invoice_id= '9450527a-87a1-479b-8cfb-c0816db3f947'
select * from txn_sales_order_header where ord_hdr_id= '173a07ba-06be-43c8-99a1-de4daab8db0e'
select * from txn_sales_order_details where ord_hdr_id = '173a07ba-06be-43c8-99a1-de4daab8db0e'
select *from product_item where item_code= '250-BC01'

as I checked in the DB there is 250ml Boboi Boy Blackcurrant SKU

#5 Updated by Muhammed Azhar Mohamed Maideen 4 months ago

select * from txn_invoice_history_header where invoice_no= 'INWWQ000613-240515'
select * from txn_invoice_history_detail where invoice_id= 'aae2700e-3e1e-471c-bd04-1a4b44d16fa1'
select * from txn_sales_order_header where ord_hdr_id= '18e7e28a-2811-4a51-a32f-40ce95112870'
select * from txn_sales_order_details where ord_hdr_id = '18e7e28a-2811-4a51-a32f-40ce95112870'
select *from product_item where item_code= '250-BC01'

select *from product_item where item_code= '250-BC01'

select * from txn_invoice_history_header where invoice_no= 'INWWQ000614-240515'
select * from txn_invoice_history_detail where invoice_id= '8ad28c5d-bd8b-49c1-95c9-7baf083d957e'
select * from txn_sales_order_header where ord_hdr_id= 'c3af5dc4-2d1d-4523-b2ff-4e48118740ae'
select * from txn_sales_order_details where ord_hdr_id = 'c3af5dc4-2d1d-4523-b2ff-4e48118740ae'
select *from product_item where item_code= '250-BC01'

select * from txn_invoice_history_header where invoice_no= 'INWWQ000615-240515'
select * from txn_invoice_history_detail where invoice_id= '3ff48434-4013-4d70-a4d3-fdfe448aee1f'
select * from txn_sales_order_header where ord_hdr_id= 'd079ccb9-2dd5-4090-8edf-e899048839f6'
select * from txn_sales_order_details where ord_hdr_id = 'd079ccb9-2dd5-4090-8edf-e899048839f6'
select *from product_item where item_code= '250-BC01'

select *from product_item where item_code= '250-BC01'

select * from txn_invoice_history_header where invoice_no= 'INWWQ000616-240515'
select * from txn_invoice_history_detail where invoice_id= '1db573b5-2c1d-496b-b4d5-ab7dfc6a4db2'
select * from txn_sales_order_header where ord_hdr_id= '2894c387-9a5e-4b95-aec6-b13d0b0346a4'
select * from txn_sales_order_details where ord_hdr_id = '2894c387-9a5e-4b95-aec6-b13d0b0346a4'
select *from product_item where item_code= '250-BC01'

select *from product_item where item_code= '250-BC01'

select * from txn_invoice_history_header where invoice_no= 'INWWQ000617-240515'
select * from txn_invoice_history_detail where invoice_id= '257519ef-aefd-4305-8015-9819f303f66d'
select * from txn_sales_order_header where ord_hdr_id= 'c104d9b9-4dab-49ae-9541-e6a58eef9952'
select * from txn_sales_order_details where ord_hdr_id = 'c104d9b9-4dab-49ae-9541-e6a58eef9952'
select *from product_item where item_code= '250-BC01'