Project

General

Profile

Tasks #9831

Need to Change the Charge for mentioned Docs

Added by Rijas P almost 2 years ago. Updated 8 months ago.

Status:
Closed
Priority:
Immediate
Assignee:
Rijas P
Start date:
03/08/2023
Due date:
% Done:

100%

Estimated time:
Spent time:
0.50 h

Description

Dear Suhail,

Could you please change the Charge account for the documents 1017451,1017452,1017453. The required Charge is "Aziz Maleki Salary".

Files

Required Charge Aziz Maleki Salary.JPG (33.3 KB) Required Charge Aziz Maleki Salary.JPG Rijas P, 03/08/2023 01:45 PM
Previous Charge.JPG (95.1 KB) Previous Charge.JPG Rijas P, 03/10/2023 12:48 PM

History

#1

Updated by Mohamed Suhail almost 2 years 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,

Could you please change the Charge account for the documents 1017451,1017452,1017453. The required Charge is "Aziz Maleki Salary".

Modified in Invoice documents and reposted

c_invoiceline_id | c_bpartner_id | documentno |      dateacct       | c_charge_id | priceactual | qtyinvoiced | linenetamt | taxamt | linetotalamt | grandtotal 
------------------+---------------+------------+---------------------+-------------+-------------+-------------+------------+--------+--------------+------------
          2316059 |       1000149 | 1017451    | 2022-12-01 00:00:00 |     1010501 |         0.0 |           1 |        0.0 |      0 |          0.0 |  40000.000
          2316060 |       1000149 | 1017452    | 2023-01-01 00:00:00 |     1010501 |         0.0 |           1 |        0.0 |      0 |          0.0 |  40000.000
          2316061 |       1000149 | 1017453    | 2023-02-01 00:00:00 |     1000011 |   40000.000 |           1 |  40000.000 |      0 |    40000.000 |  40000.000
(3 rows)

euro=# update c_invoiceline set c_charge_id =1010501,priceactual=40000.000,linenetamt=40000.000,linetotalamt=40000.000 where c_invoiceline_id in (2316059,2316060,2316061);
UPDATE 3

c_invoiceline_id | c_bpartner_id | documentno |      dateacct       | c_charge_id | priceactual | qtyinvoiced | linenetamt | taxamt | linetotalamt | grandtotal 
------------------+---------------+------------+---------------------+-------------+-------------+-------------+------------+--------+--------------+------------
          2316059 |       1000149 | 1017451    | 2022-12-01 00:00:00 |     1010501 |   40000.000 |           1 |  40000.000 |      0 |    40000.000 |  40000.000
          2316060 |       1000149 | 1017452    | 2023-01-01 00:00:00 |     1010501 |   40000.000 |           1 |  40000.000 |      0 |    40000.000 |  40000.000
          2316061 |       1000149 | 1017453    | 2023-02-01 00:00:00 |     1010501 |   40000.000 |           1 |  40000.000 |      0 |    40000.000 |  40000.000
(3 rows)

eurobackup=# update c_invoiceline set c_charge_id =1010501,priceactual=40000.000,linenetamt=40000.000,linetotalamt=40000.000 where c_invoiceline_id in (2316059,2316060,2316061);
UPDATE 3

posiboltdb=# update c_invoiceline set c_charge_id =1010501,priceactual=40000.000,linenetamt=40000.000,linetotalamt=40000.000 where c_invoiceline_id in (2316059,2316060,2316061);
UPDATE 3

#2

Updated by Rijas P almost 2 years ago

Dear Suhail,

Thanks for changing the Charge.

Please note still previous charge is showing in Vendor Ledger.

#3

Updated by Mohamed Suhail almost 2 years ago

Rijas P wrote:

Dear Suhail,

Thanks for changing the Charge.

Please note still previous charge is showing in Vendor Ledger.

Please check now

euro=# update c_invoice set c_charge_id=1010501 where c_invoice_id in (1060058,1060059,1060060);
UPDATE 3

posiboltdb=# update c_invoice set c_charge_id=1010501 where c_invoice_id in (1060058,1060059,1060060);
UPDATE 3

eurobackup=# update c_invoice set c_charge_id=1010501 where c_invoice_id in (1060058,1060059,1060060);
UPDATE 3

#4

Updated by Rijas P almost 2 years ago

  • Status changed from Resolved to Closed

Found updated.

#5

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