Project

General

Profile

Production Ticket(ST) #11046

Gold Crest - may i ask why salesman got fill in which inv the collection pay but autocount didnt knock off?

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

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Muhammed Azhar Mohamed Maideen
Start date:
26/02/2024
Due date:
28/02/2024
% Done:

0%

Estimated time:
Spent time:
2.00 h
Job Remark:
Ticket Logged Date:
26/02/2024
Ticket No.:
Related Ticket ID:
Type:
User Enquiry & Clarification
SLA Initial Response:
26/08/2024
SLA Delivery:
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
11/03/2024
Resolution:

We found out that the outstanding is Rm0.00.
Root cause- User enquiry and verification.
this is may occur simce the integration takes anput 30 minutes in autocount. user may checked earlier , therefore the data is not updated Case closed

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

None

Description


WhatsApp Image 2024-02-26 at 10.38.30_b57af6c6.jpg (309 KB) WhatsApp Image 2024-02-26 at 10.38.30_b57af6c6.jpg Muhammed Azhar Mohamed Maideen, 26/02/2024 02:26 PM
WhatsApp Image 2024-02-26 at 10.38.30_897bfd25.jpg (309 KB) WhatsApp Image 2024-02-26 at 10.38.30_897bfd25.jpg Muhammed Azhar Mohamed Maideen, 26/02/2024 02:27 PM
WhatsApp Image 2024-02-26 at 10.38.37_4bda58c0.jpg (132 KB) WhatsApp Image 2024-02-26 at 10.38.37_4bda58c0.jpg Muhammed Azhar Mohamed Maideen, 26/02/2024 02:27 PM
WhatsApp Image 2024-02-27 at 17.34.49_87b18a7d.jpg (195 KB) WhatsApp Image 2024-02-27 at 17.34.49_87b18a7d.jpg Muhammed Azhar Mohamed Maideen, 27/02/2024 05:39 PM

History

#2 Updated by Muhammed Azhar Mohamed Maideen 7 months ago

  • Status changed from Assigned To to Support In Progress

#3 Updated by Muhammed Azhar Mohamed Maideen 7 months ago 

SELECT i.DocNo, CONVERT(VARCHAR, i.DocDate, 25) DocDate, i.DebtorCode, i.SalesAgent, i.SalesLocation, i.Cancelled, i.NetTotal, a.Outstanding 
                FROM IV i 
                INNER JOIN ARInvoice a ON a.DocNo = i.DocNo 
                WHERE i.SalesAgent is not null
        and exists (select 1 from IVDTL d where i.DocKey=d.DocKey and isnull(d.ItemCode,'') <> '')
        and i.docno ='INJNL000994-240224'

#4 Updated by Muhammed Azhar Mohamed Maideen 7 months ago

  • Status changed from Pending Client Verification to Ticket Resolved
  • Actual Initial Response set to 11/03/2024
  • Resolution updated (diff)

Also available in: Atom PDF