Temp Projects

Rijas P wrote:

Dear Suhail,

Can u please check the above case. Showing many over payments in negative. Please correct it.

Rijas,

We had made a fix in code where it was not showing the payment as overpayment in reports when the unallocated amount BETWEEN -0.00999 AND 0.00999
These payments started showing up in reports due to this fix

Please see attached CSV file for the list of payments affected with this change
Please check and revert back with the way forward

Dear Suhail,

As we discussed, tried to enter each charge invoice entry to adjust the over payments. But the -ve overpayment couldn't able to allocate with charge invoice entry. It will be great if you can clear all the over payments to the ledger account "Payment Discount Expense". Because there is more than 400 transactions, So if we do manually we have to enter 400 charge invoice transactions.

Rijas P wrote:

Dear Suhail,

As we discussed, tried to enter each charge invoice entry to adjust the over payments. But the -ve overpayment couldn't able to allocate with charge invoice entry. It will be great if you can clear all the over payments to the ledger account "Payment Discount Expense". Because there is more than 400 transactions, So if we do manually we have to enter 400 charge invoice transactions.

Have corrected for the payments where it is showing -ve open amount balance

euro=# update c_payment set discountamt=discountamt-paymentavailable(c_payment_id),updated=now(),updatedby=100 where docstatus in ('CO','CL') and paymentavailable(c_payment_id) < 0 and payamt > 0 and ad_client_id=1000000 and isreceipt='Y' and c_cashbook_id is null;
UPDATE 211
euro=# update c_allocationline cal set amount=amount+paymentavailable(aa.c_payment_id),discountamt=discountamt-paymentavailable(aa.c_payment_id),updated=now(),updatedby=100 from (select max(c_allocationline_id) caid,c_payment_id from c_allocationline where c_payment_id in (select c_payment_id from c_payment where docstatus in ('CO','CL') and paymentavailable(c_payment_id) < 0 and payamt > 0 and ad_client_id=1000000 and isreceipt='Y' and c_cashbook_id is null) group by 2) as aa where aa.caid=cal.c_allocationline_id;
UPDATE 211
euro=# delete from fact_acct where ad_table_id=735 and record_id in (select c_allocationhdr_id from c_allocationline where updated::date=current_date and updatedby=100);
DELETE 942
euro=# update c_allocationhdr set posted='N' where c_allocationhdr_id in (select distinct c_allocationhdr_id from c_allocationline where updated::date=current_date and updatedby=100);
UPDATE 208

Mohamed Suhail wrote:

Rijas P wrote:

Dear Suhail,

As we discussed, tried to enter each charge invoice entry to adjust the over payments. But the -ve overpayment couldn't able to allocate with charge invoice entry. It will be great if you can clear all the over payments to the ledger account "Payment Discount Expense". Because there is more than 400 transactions, So if we do manually we have to enter 400 charge invoice transactions.

Have corrected for the payments where it is showing -ve open amount balance

euro=# update c_payment set discountamt=discountamt-paymentavailable(c_payment_id),updated=now(),updatedby=100 where docstatus in ('CO','CL') and paymentavailable(c_payment_id) < 0 and payamt > 0 and ad_client_id=1000000 and isreceipt='Y' and c_cashbook_id is null;
UPDATE 211
euro=# update c_allocationline cal set amount=amount+paymentavailable(aa.c_payment_id),discountamt=discountamt-paymentavailable(aa.c_payment_id),updated=now(),updatedby=100 from (select max(c_allocationline_id) caid,c_payment_id from c_allocationline where c_payment_id in (select c_payment_id from c_payment where docstatus in ('CO','CL') and paymentavailable(c_payment_id) < 0 and payamt > 0 and ad_client_id=1000000 and isreceipt='Y' and c_cashbook_id is null) group by 2) as aa where aa.caid=cal.c_allocationline_id;
UPDATE 211
euro=# delete from fact_acct where ad_table_id=735 and record_id in (select c_allocationhdr_id from c_allocationline where updated::date=current_date and updatedby=100);
DELETE 942
euro=# update c_allocationhdr set posted='N' where c_allocationhdr_id in (select distinct c_allocationhdr_id from c_allocationline where updated::date=current_date and updatedby=100);
UPDATE 208

Rijas P please check and confirm

Found fixed.