Is this possible? via SmartList or custom SSRS Report? You don't specify the next starting check number until you get to the print window, so not sure what table that information is derived from in SQL.
*This post is locked for comments
If you did this, it would have to be calculated on the report. You would have to call the next check number value for the correct checkbook and then calculate forward.
It isn't something I personally would do at all - reason being - you are then locked into using that check number for that vendor and if they print and don't allocate that way it would be a real pain for the users. It also means that you would have to have a way to lock use of those check numbers between generating the report and actually printing the checks.
If you are wanting to investigate further, the next check number is found in table CM00100 (NXTCHNUM) - you would need to ensure you have the CHEKBKID as a reference to call the correct value.
To make sure I understand correctly, do you mean that -
your report could potentially indicate one check number, but in the actual Print Checks window, a user could enter a different starting check number?
Yes, that is what I mean. The check number isn't entered until you start printing the checks. And even without someone manually entering the check number (because you could probably programmatically hide the field), someone could process e.g. a manual check in between the report being printed and the checks being printed. That would mean that the starting check number you just called would now be different.
You also have to ensure the way the check number is allocated to the supplier on the original report matches the sequence that it is assigned when you print the checks (I think that is based on payment number but I am not certain).
What is the overall requirement you are trying to achieve - maybe we can figure out the best overall way to approach it.
We want to see which check numbers will be used before they are printed, and specifically, which check numbers will be used with which vendor and invoice no. Right now, it tells you the payment number, but we'd want to see check numbers instead.
Soma - that is the place to look after printing, the question is about getting the check number before printing.
So the only way to meet the requirement would be to do a calculation on the report based on the above. You would however also have to implement some pretty sound business process around it to ensure that those check numbers weren't used in between. You would also have to have understanding from a management level that there may be things that can't be controlled.
Business process considerations:
- no one can process checks either manually or by printing in between running the edit list and finalising the print for that batch.
- you could not have two batches for the same checkbook going at the same time - otherwise your calculations will need to get quite complex.
- there will need to be a process developed for reprints - i.e. does it need another sign off?
Factors out of your control:
- if the checks don't print correctly and need to be reprinted, the edit report will no longer match.
Hope that helps with the development.
Share
Report
All responses (
Answers (
