255
We are using Microsoft Dynamics SL 2011 SP1
For the Direct Deposit Advice Slips report the Next Advice Slip Num field is blank. It used to be filled in with the next adivce slip number. We had our payroll check numbers start over at 000000 once they reached 999999 which occurred in the middle of the batch. Not sure if this is causing the issue. There aren't any check numbers below 200001 and the numbers are unique.
Does anyone know how to fix this?
*This post is locked for comments
Hi Carolyn,
No I do not. I think we will keep the same checking account/sub and we will have to enter in the number each time.
Thanks for you help.
Kaci
Hi Kaci,
Do you need any other assistance with this issue?
Hi Kaci,
I set one of my check numbers in PRdoc to 999999. When I launch the Direct Deposit Advice Slips report, 000000 (6 zeros) shows in the Next Advice Slip Num field. Are you saying your Next Advice Slip Num field is completely empty or does it also show 000000?
If you are planning on using the check sequence from 000001 to 200001 for that checking account/sub, you will never get the correct advice slip number to show in that screen because it always looks for the next highest number. So it is looking for a number higher than 999999. If you plan to continue to use that checking account/sub, you will need to manually type in the next highest advice slip number since the range of numbers you plan to use are lower than 999999. Otherwise, you could use a different checking account/sub and start the numbering at 000001 or whatever check number you want.
Let me know if you have any questions.
I ran the script and it returns 999999.
Thanks for you help.
Kaci
Hello Kaci,
What account number shows on the screen when you launch the Direct Deposit Advice Slips report?
Do you have access to run the following statement in SQL Server Management Studio? This is the statement the system executes to find the next check number. Can you execute this statement on your application database to see what number is returned? My account is 1070 and sub is 000000000000. Please substitute the account and subaccount in this script with the one that shows on the Direct Deposit Advice Slip report in your company.
Select MAX(ChkNbr) from PRDoc Where Acct = '1070' And Sub = '000000000000'
Let me know what the script returns.
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,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (