By using this website, you agree to our Terms of Use (click here)
I've been asked to modify the check form so that it utilizes the entire remittance area rather than only 10 lines per check. This appeared easy enough by adding all of the field variables but it seems there is some form of data paging that is limiting the page to 10 line items. Looking over the schema and other filtering sections I've not found anything that seems to address this. Any help is greatly appreciated!
I stumbled into the answer to this earlier today. The number of remittance rows is controlled by the check payment method. On the Settings for Use in AP tab you'll find the check printing settings and a text field for the "Lines Per Stub".
Hey Eric,
Glad you found the solution. just curious, have you tried the Print Remittance Report option? I like it because you don't have to burn checks for the additional remittance information.
I am trying to compress the size of the content showing in the remittance area of the Check Form with Remittance. I have that task completed. My employer would like for me to squeeze as many lines into that section with smaller font sizes as possible, ideally between 30 and 40 entries being displayed. I have the structure of the layout completed on the ap641000.rpx form in Designer. I've checked all the field values and incremented them according to the pattern in the "canned" items on the report. However, I am only successful in getting a total of 12 invoice item values to display. The remaining items do show up on the form output, but "Invoice Date" shows zero, "Invoice Number" shows zero, and Invoice "Invoice Amt" and "Payment Amt" both show "0.00" instead of the appropriate values. I have adjusted the Payment Method "Lines per Stub" to 33 since I have 33 items ready to be paid with a single check and listed in the remittance area. Can the form not be manipulated in this way perhaps? Anyone had any luck attempting this. I am fairly new to Report Designer, but have been modifying the OOTB forms for our corporate needs for a couple months now and am fairly successful. In case you are wondering, my employer DOES NOT want to use the Additional Remittance form. I modified that and presented it as an option already. We tend to have remittances with >50 payments being made to single vendors at times. Thank you in advance for any help!! I've attached the ap641000.rpx if you with to review in Report Designer. Still somewhat rough, but you can see where I'm headed with trying to meet the requested purpose.
CodeOfArms - If you have not already completely satisfied your requirements, check over on the Acumatica Community. You'll find a conversation I had looking to do much the same as you. That conversation may be helpful to you. My issue with wanting to have as many remittances show as possible on a single check remittance area. I was able to configure the Check with Remittance form to support 50 remittances. Making the necessary change to variables and also the Check Printing Settings to allow that many Lines Per Stub for a check will, as you mention, be required. The full thread is over in the Acumatica Community. Hope this is helpful.