Notifications
Announcements
No record found.
When you to Transactions->Financials->Bank Transactions and change the type to Withdrawals the Number field will go to DAJ00000NNNN. It gets this number from the Bank Reconciliation setup screen. Is there an eConnect procedure to get that number? In the taBRBankTransactionHeader node there is a field called CMTrxNum. I need a way to get that number.
Hello Richard,
Thank you for your post. When importing in Withdrawals, you would want to set up the taBRBankTransactionHeaderPre proc to call the NXTNUM in the CM40100 table and use that for the CMTrxNum in the main procedure.
Once you set up the logic to use the number there, you should have a value for your next number.
Let me know if that helps!
Thank you,
Another note on this. When you use the Pre proc to pull the next value, you will want to increment the value at the same time to keep the system from running into duplicates.
Regards,
You folks are best. That was going to be my next guess but I wanted to be sure that I would not be doing the incrementing twice. I owe you another cup of coffee.
I used these two statements to get the next transaction number and to get the next sequence number. So I do two updates. The first is to update the bank transaction number and the second is to set the BACHNUMB using the SY01000.NTRXSNUM. I found that this batch number will be used when naming the resulting GL batch. So I also update this number.
SELECT @CMTRXNUM = 'DAJ'+REPLICATE('0',(8-LEN(CONVERT(CHAR(10),NXTNUM))))+ CONVERT(CHAR(10),NXTNUM) FROM CM40100
SELECT @BACHNUMB = TRIM(TRXSRCPX) + REPLICATE('0',(8-LEN(CONVERT(CHAR(10),NTRXSNUM))))+ CONVERT(CHAR(10),NTRXSNUM) FROM SY01000 WHERE SERIES=2 AND TRXSRCPX='CMTRX'
Happy to help! Hopefully the rest works out smoothly for you.
Everything is working perfectly now thanks to your help. The client wants to see these transactions in both the checkbook and the ledger since these are payroll transactions that come directly out of their payroll checkbook account.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 669 Super User 2025 Season 2
André Arnaud de Cal... 449 Super User 2025 Season 2
Martin Dráb 384 Most Valuable Professional
