Project

General

Profile

Production Ticket(ST) #9623

Nozoly Food Sdn Bhd - Sales Report By Customer & Item Grand Total Show Wrong Amount

Added by Muhammed Assyafiq Bin Ahmad Kamal about 1 year ago. Updated about 1 year ago.

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Muhammed Assyafiq Bin Ahmad Kamal
Start date:
28/07/2023
Due date:
31/07/2023
% Done:

100%

Estimated time:
Job Remark:
Ticket Logged Date:
28/07/2023
Ticket No.:
Related Ticket ID:
Type:
SLA Initial Response:
SLA Delivery:
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
Resolution:

Request fulfilled

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

None

Guidance or help by :
None

Description

Dear Chris,

We received another escalation from Nozoly Food Sdn Bhd regarding Sales Report by Customer/Item vs Sales Invoices Listing Report. We find out that in Sales Report By Customer/Item the grand total amount is SUM up all the sales regardless the currency. While in the Sales Invoices Listing it does convert the amount into MYR.

Hence, customer reported that the grand total in Sales Report by Customer & Item are wrong. The report should not sum up with a mix of currencies and has to convert based on user selection of currency or split the grand total by currencies.

Please help to further check and advise the solution. Further, attached is the sample report that having discrepancies due to this issue and below is the sample :

Nozoly_Sales Report By Customer.xls (164 KB) Nozoly_Sales Report By Customer.xls Muhammed Assyafiq Bin Ahmad Kamal, 28/07/2023 12:17 PM
Nozoly_List of Sales Invoices.xls (53 KB) Nozoly_List of Sales Invoices.xls Muhammed Assyafiq Bin Ahmad Kamal, 28/07/2023 12:17 PM

History

#1 Updated by Muhammed Assyafiq Bin Ahmad Kamal about 1 year ago

  • Status changed from Assigned To to Support In Progress

#2 Updated by Muhammed Assyafiq Bin Ahmad Kamal about 1 year ago

  • Status changed from Support In Progress to Escalated to 3rd Party
  • % Done changed from 50 to 70

#3 Updated by Muhammed Assyafiq Bin Ahmad Kamal about 1 year ago

  • Status changed from Escalated to 3rd Party to Ticket Resolved
  • % Done changed from 70 to 100
  • Resolution updated (diff)

Also available in: Atom PDF