400
Bank Transaction Entry has [CM Trx Number] but it can be duplicated in multiple Bank Trx Entries. What I've understood from reading dbo.BankTransactions view is: [Record Number] is the unique column for every Transaction.
1. How can i get current [Record Number] on ClickBeforeOriginal or ClickAfterOriginal event of POST button at Bank Transaction Entry screen?
2. Is there some other way to uniquely identify the Bank Transaction Entry?
*This post is locked for comments
and just tried to post Bank Trx Entry (withdraw) with repeated CM Trx Number (duplicated) ... its also allowed ... its a mess...please help....
Hello Bron,
I've already checked Cards > Financial> Checkbook options and even then it can repeat the CM Trx Number e.g. If we manually enter the same CM Trx Number twice......Plus Check Book ABC can have the same CM Trx Number as Check Book XYZ...so CM Trx Number does not uniquley identify any CRM Trx Number..
I've a custom report to be shown on POST event of Bank Trx Entry. This report is being shown on a CUSTOM GP Form which is developed using GP VS Tool. To generate this report i need to send Bank Trx Entry's primary key or uniquely identifying key to fetch data from BankTransactions view...[Record number] column uniquely identifies it, but i cannot get it on the form, as before Post event [Record Number] property contains 0.00000 and after POST its lost as form get cleared.....
I hope i cleared the picture for a more helpful reply...
Sohaib -
What type of bank transactions are you looking for? GP has a check-box at > Cards > Financial> Checkbook which allows users to have duplicate check numbers and separate checkbox to allow users to override the system defaulted numbers..........
All other bank transactions - deposits, adjustments, etc. should have unique numbers.
What is it you are trying to do - seems like you are modifying a form in Modifier? Are you trying to populate a NON GP table with bank transaction number????? Just guessing - maybe if we had more information we could be more helpful.........
Good Luck........
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (