Adding additional lines to Check Stubs

​@rkenna I’m pretty sure you need to click the box to add the Additional Remittance Report. This will print the normal amount on the stub, but then the remittance report will print after it containing the number of lines indicated.

Have you already tried checking that box to print the Additional Remittance Report?

Hi ​@BenjaminCrisman, I have, but the goal is to eliminate the need for additional stock paper being used, so they would like 15/stub. Any other thoughts?

Thanks,
RJ

​@rkenna - unfortunately, the solution is not that simple.  The report is designed to specifically print up to 10 lines as this the capacity that can be printed on a tri-fold check stub.  

If you look at the report design, you’ll see that there are multiple rows with defined variables; each representing a specific field for specific rows.  The first row has a starting sequence value of “00” and increases to “09”.

To allow this form to support 15 rows, there are multiple sets of variables that need to be added; to first clear the row count for each new check, and then define the row numbers that need to be printed.  

It’s a very complicated report layout, that requires some expertise in report designer to support.  Changing the configuration will only work to reduce the rows printed, but increasing the number of rows printed will be governed by report design.  

@rkenna - Sorry I missed the part where you stated you added the variables to create the lines.  There are two sets of varialbles that you need to update.  One set clears the line counter, and the other establishes the lines.  Did you create the additional variables to reset the line count?

Hi ​@PaulMainard55,

I did do this yes in both places, and I updated the rows accordingly. The issue I am running into is for lines 13-15 (which are with Variable 12,13,14) I am receiving some duplicate/non accurate rows in a couple columns from the Payment that is paid… one is the Reference column. It seems very arbitrary and there is no difference in the Variables between 11 and 12, but they are showing duplicates from the payment.

This is the check

This is what is should show

Hi ​@PaulMainard55 ,

The behavior is incredibly inconsistent starting at row 13, or $12 through row 15, or $14. It seems very arbitrary what it is showing vs what it is not showing.

Thanks for the tip on the variables order. That could be something as I have gone through each variable and do not notice any differences. I will give that a shot and let you know. 

-RJ

​@PaulMainard55,

That is it!! Thank you greatly for your help. It was the order of the Variables that was causing the issues. Once I changed this order to match how the rest of the Variables of the Check that Acumatica has out of the box, I printed a new check and it worked. I printed the same Payment with my old layout vs my new one, and the new one was just as I needed.

Thanks so much!

Hey ​@rkenna,

That’s great news!  It was a bit of a shot in the dark, but somewhere in the recesses of my brain, I vaguely remember encountering a similar issue; probably with the same report.  Sometimes, even a blind squirell finds an acorn once in a while.  😀

I’m so glad this worked for you.  Keep posting questions to the community. 

Best of luck, RJ!

Just to add to this win, this is definitely the report I’ve gotten the most cases on regarding variable order. Maybe a few cases on single reports, but a number on this one. Variable order definitely matters :)