Project

General

Profile

Tasks #11287

Unable to void the charge invoice Document

Added by Rijas P over 1 year ago. Updated 8 months ago.

Status:
Closed
Priority:
Urgent
Assignee:
Rijas P
Start date:
08/04/2023
Due date:
% Done:

100%

Estimated time:
Spent time:
0.25 h

Description

Dear Suhail,

We can't able to void this charge invoice document due to an error. Kindly resolve this issue.

Files

WhatsApp Image 2023-08-02 at 9.40.07 AM.jpeg (91.3 KB) WhatsApp Image 2023-08-02 at 9.40.07 AM.jpeg Rijas P, 08/04/2023 09:56 AM

History

#1

Updated by Mohamed Suhail over 1 year ago

  • Status changed from New to Resolved
  • Assignee changed from Mohamed Suhail to Rijas P
  • % Done changed from 0 to 100

Rijas P wrote:

Dear Suhail,

We can't able to void this charge invoice document due to an error. Kindly resolve this issue.

Rijas,
Please try now

euro=# select c_invoice_id,c_order_id,c_payment_id,isreconciled,payamt,dateacct from c_payment where c_order_id=1071019;
c_invoice_id | c_order_id | c_payment_id | isreconciled | payamt | dateacct
--------------+------------+--------------+--------------+-----------+---------------------
1066579 | 1071019 | 1073332 | Y | 20000.000 | 2023-06-01 00:00:00
(1 row)

euro=# update c_payment set c_order_id=NULL,c_invoice_id=NULL where c_payment_id=1073332;
UPDATE 1
euro=# select c_invoice_id,c_order_id,c_payment_id,isreconciled,payamt,dateacct from c_payment where c_payment_id=1073332;
c_invoice_id | c_order_id | c_payment_id | isreconciled | payamt | dateacct
--------------+------------+--------------+--------------+-----------+--------------------- | | 1073332 | Y | 20000.000 | 2023-06-01 00:00:00
(1 row)

#2

Updated by Rijas P over 1 year ago

  • Status changed from Resolved to Closed

Done

#3

Updated by SHAIJAL EDAVANA 8 months ago

  • Tracker changed from Bug to Tasks
  • Project changed from Euro Novelties to Temp Projects
  • Category deleted (Others)

Also available in: Atom PDF