AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Report De...
Change the number o...
 
Notifications
Clear all

Questions Change the number of rows in the check remittance field

 
Acumatica Report Designer
Last Post by Michael 2 years ago
5 Posts
3 Users
1 Reactions
2,350 Views
RSS
CodeOfArms
Posts: 4
 CodeOfArms
Topic starter
February 3, 2020 11:04 pm
(@codeofarms)
Active Member
Joined: 6 years ago

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!


4 Replies
CodeOfArms
Posts: 4
 CodeOfArms
Topic starter
February 6, 2020 10:37 pm
(@codeofarms)
Active Member
Joined: 6 years ago

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".


Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
February 29, 2020 3:23 am
(@timrodman)
Famed Member
Joined: 10 years ago

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.


Reply
Michael
Posts: 2
 Michael
March 23, 2023 7:34 pm
(@mrhoades)
New Member
Joined: 3 years ago

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.

ap641000.rpx

 


Reply
Michael
Posts: 2
 Michael
April 19, 2023 1:30 pm
(@mrhoades)
New Member
Joined: 3 years ago

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.


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 42 Online
  • 2,338 Members
Our newest member: Shoaib Shafquat
Latest Post: Pick List report suddenly not splitting on Shipment
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

  • Tim Rodman Anne Trockman David Edmonson
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×