Does anyone know why the DAJ (Decrease Adjustments) entries in Cash Management don’t go in order sequentially.
I have checked the tables, and there are gaps in the numbers, sometimes they are very large.
I have looked at the CM20100 and CM20200 tables and there isn’t a rhyme or reason for the missing numbers
*This post is locked for comments
Yes, your answer help out a bunch. Thanks
Hello Larry Carrethers
Just following up on your inquiry, do you still have any issues ?
Initially, you are practically talking about the bank reconciliation module or check book management as derived from the table mentioned above. For that, allow me to provide one single piece of information which might be the missing piece of your puzzle
There are several types of bank transactions such as; check, withdrawal, increase and decrease adjustment. These transactions have the same serial number but different prefix as shown in the setup window below:
Supposing that you create a decrease adjustment considering the setup above, it will have the number (XYZ0000004) by default. Now if you create 10 increase adjustment transactions, they will have the numbers (IAJ00000005 to IAJ00000014). Creating an increase adjustment after that will have the following number by default (XYZ0000015)
In this essence, non of the types will have a sequential "default" number, but a random serialization according to the sequence of transaction entry.
That is only true if you are considering the default serial number included in the bank reconciliation setup, in several sites, we have created a customized add in to default a serial number by transaction type, that would be a better solution to control the document numbers.
Your feedback is highly appreciated,
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (