Bank Statement No.

(0) Share

Report

Posted on by Dv Acuma

Hi All,

Is there a way where I can edit the statement no. in the Bank Reconciliation page? Because the system is automatically trying to use a number that I already used. Hence, it's showing an error since that is not allowed. I tried using the Statement No. change function and it doesn't do anything unfortunately.

Here's the error that is showing. Statement No. 1-5 is already in use.

Here/s the follonw

All responses (4)

Answers (1)

Gavin 2,444 on at

Like (0)

Report

RE: Bank Statement No.

Hi,

No problem at all. Glad I could help :)

Thanks

Gavin
Dv Acuma 34 on at

Like (0)

Report

RE: Bank Statement No.

Hi Gavin,

Such a simple fix and I wasn't able to consider this beforehand. This worked!

Thank you again, Gavin!

Regards,

Lawrence
Verified answer

Gavin 2,444 on at

Like (0)

Report

RE: Bank Statement No.

Hi,

Are you able to go to the "Bank Account" page for this bank account and manually change the "Last Statement No" so you are offered a different number?

Hope this helps

Thanks

Gavin
Suggested answer

DAnny3211 9,276 Moderator on at

Like (0)

Report

RE: Bank Statement No.

Hi

the Statement No. field is part of the primary key of the table

modifying it would mean renaming the record's primary key, which would be feasible, but unfortunately in the table's OnRename trigger
Bank Acc. Reconciliation table, there is the code I enclose below, which blocks the rename

check my answer if it helped you, thanks

DAniele