Project

General

Profile

Tasks #10882

Cash Bank transfer error

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

Status:
Closed
Priority:
High
Assignee:
Rijas P
Start date:
06/20/2023
Due date:
% Done:

100%

Estimated time:
Spent time:
0.50 h

Description

Dear Thaneesh,

Please see the attached cash bank transfer has 2 times effected to cash book but not effected in bank account.

Also the transfer from ivestor card to cash book has also wrongly effected.

Regards,

Lukman

Files

Screenshot 2023-06-20 092359.png (24.8 KB) Screenshot 2023-06-20 092359.png Rijas P, 06/20/2023 11:00 AM
WhatsApp Image 2023-06-20 at 9.06.36 AM.jpeg (32.1 KB) WhatsApp Image 2023-06-20 at 9.06.36 AM.jpeg Rijas P, 06/20/2023 11:00 AM

History

#1

Updated by Peer Thanesh over 1 year ago

  • Assignee changed from Peer Thanesh to Savad Ibrahim

Duplicate entries on cash bank transfer.
Please check this is happening now also.

#2

Updated by Savad Ibrahim over 1 year ago

  • Assignee changed from Savad Ibrahim to Mohamed Suhail

As per screen shot ,this is issue before fixing bank transfer issue http://bugzilla.posibolt.com/show_bug.cgi?id=9695 . Checked here but issue seemed to be solved now in test instances .

@suhailka plz advise if we can fix previous entries

#3

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

Savad Ibrahim wrote:

As per screen shot ,this is issue before fixing bank transfer issue http://bugzilla.posibolt.com/show_bug.cgi?id=9695 . Checked here but issue seemed to be solved now in test instances .

@suhailka plz advise if we can fix previous entries

Please check now

euro=# select cbl.c_bankstatement_id,cbl.c_bankstatementline_id,cp.c_payment_id,cp.documentno,cp.dateacct,cp.payamt,cp.docstatus,cp.c_bankaccount_id,cb.c_bankaccount_id,cb.statementdate,cp.isreconciled from c_bankstatementline cbl join c_bankstatement cb on cbl.c_bankstatement_id=cb.c_bankstatement_id join c_payment cp on cp.c_payment_id=cbl.c_payment_id where cp.c_bankaccount_id <> cb.c_bankaccount_id ;
c_bankstatement_id | c_bankstatementline_id | c_payment_id | documentno | dateacct | payamt | docstatus | c_bankaccount_id | c_bankaccount_id | statementdate | isreconciled
--------------------+------------------------+--------------+------------+---------------------+------------+-----------+------------------+------------------+---------------------+--------------
1049700 | 1071235 | 1072812 | 1047633 | 2023-05-12 00:00:00 | -10000.000 | CL | 1000031 | 1000001 | 2023-05-12 00:00:00 | N
1049896 | 1071774 | 1073138 | 1047853 | 2023-06-03 00:00:00 | -9699.000 | CL | 1000008 | 1000016 | 2023-06-03 00:00:00 | N
(2 rows)

euro=# delete from c_bankstatementline where c_bankstatement_id in (1049700,1049896);
DELETE 2
euro=# delete from c_bankstatement where c_bankstatement_id in (1049700,1049896);
DELETE 2
euro=# delete from fact_acct where ad_table_id=392 and record_id in (1049700,1049896);
DELETE 2

#4

Updated by Rijas P over 1 year ago

  • Status changed from Resolved to Closed
#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