AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Live
  • Login
  • Start Here
  • Rolodex
  • Courses
  • Consulting
  • Register
Acumatica Forums

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

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
Adding bill descrip...
 
Notifications
Clear all

Adding bill description on check stub  

    Last Post
RSS

Mauricio Camara
Posts: 2
 Mauricio Camara
February 7, 2018 10:15 am
(@mauricio-camara)
Member
Joined: 3 years ago

 Hello,

I am trying to add the bill description field in the check stub. All info in the check stub comes from variables to reflect information from multiple invoices.

How can I create variables to show DocDesc00,DocDesc01,DocDesc02 ... The other variables are something like DocType00, DocType01 , InvcNbr00 , InvcNbr01 ... but I can't see how they are linked to the database data.

Thanks,

Mauricio

12 Replies
Tim Rodman
Posts: 2527
 Tim Rodman     ★★ All-Star ★★
February 8, 2018 11:05 pm
(@timrodman)
Over 200 Posts
Joined: 5 years ago

Hi Mauricio,

Variables are weird because they might be defined in the section above where they actually get used.

In this case, they are defined in detailSection1.

Reply
Mauricio Camara
Posts: 2
 Mauricio Camara
February 9, 2018 3:23 pm
(@mauricio-camara)
Member
Joined: 3 years ago

Thanks a lot Tim ... 

Reply
Tim Rodman liked
Chip Fritsch
Posts: 12
 Chip Fritsch
July 27, 2019 2:29 pm
(@cfritsch)
6-20 Posts
Joined: 11 months ago

Mauricio, I would be interested in knowing the additional Schema Fields you added to get the ApAdjust.DocDesc, which could then be added to the Variable grouping as outlined above. 

Looking to also add the Bill Description to the Remittance section of the check stub. 

Thanks,

Chip

Reply
Chip Fritsch
Posts: 12
 Chip Fritsch
July 30, 2019 1:41 pm
(@cfritsch)
6-20 Posts
Joined: 11 months ago

Never Mind, I was able to use the report you uploaded to pull the required information. Thank you for providing a copy of that to the forum.

Here is another very standard three part blank check stock design. 

AP641000billdescriptionchecksignature.rpx
Reply
Jswartz
 Jswartz
(@jswartz)
Joined: 11 months ago

6-20 Posts
Posts: 16
January 15, 2021 6:08 pm
Reply toChip FritschChip Fritsch

@cfritsch Chip great modifications. Just a quick question. How did you prevent the description from printing 0 if no line is present? Currently trying to figure out how to prevent that from happening. TIA

Reply
Chip Fritsch
 Chip Fritsch
(@cfritsch)
Joined: 11 months ago

6-20 Posts
Posts: 12
January 21, 2021 8:33 am
Reply toJswartzJswartz
Chip Fritsch

@jswartz There are two collections that need to be filled out to hide the values.

Are you adding new fields? or the Bill Descriptions? There is a collection in the detail 1 section, and a collection in the group header section 1.

Hope that helps Jswartz.

Reply
Chip Fritsch
 Chip Fritsch
(@cfritsch)
Joined: 11 months ago

6-20 Posts
Posts: 12
January 21, 2021 9:15 am
Reply toJswartzJswartz
Chip Fritsch

@jswartz, Here are two screen shots of the collections for the Detail and header sections. I believe the header section is likely what is causing your issue.

Bill   Header Collection
Bill   Detail collection
Reply
Jswartz
 Jswartz
(@jswartz)
Joined: 11 months ago

6-20 Posts
Posts: 16
January 22, 2021 2:01 pm
Reply toChip FritschChip Fritsch
Jswartz
Chip Fritsch

@cfritsch Chip thank you for that. I did stumble upon that the other day and that fixed the issue. One thing I wanted to point out was your bill variables with the if statements. If you leave them at the bottom it will print the info on the wrong line unless they are organized with the other 00 and 01 etc. Does that make sense?

Reply
Chip Fritsch
 Chip Fritsch
(@cfritsch)
Joined: 11 months ago

6-20 Posts
Posts: 12
January 22, 2021 2:05 pm
Reply toJswartzJswartz
Chip Fritsch
Jswartz
Chip Fritsch

@jswartz Yes, that does make sense, and yes without those changes the rows print "one" line below. Thanks.

I had previously done the "lazy mans" fix before which worked but was not elegant or clean which was to just adjust the numbering sequence in the remit stub grid. Which worked, but was not ideal.

Thank you,

Reply
Jswartz
 Jswartz
(@jswartz)
Joined: 11 months ago

6-20 Posts
Posts: 16
February 8, 2021 7:53 pm
Reply toChip FritschChip Fritsch
Jswartz
Chip Fritsch
Jswartz
Chip Fritsch

@cfritsch For the routing number and account number for the MICR did you just add that info on the remittance settings under payment methods and then added account and router number under cash accounts? I noticed that there was an additional table on your form. Did you create your own table instead?

Reply
Chip Fritsch
 Chip Fritsch
(@cfritsch)
Joined: 11 months ago

6-20 Posts
Posts: 12
February 15, 2021 11:24 am
Reply toJswartzJswartz
Chip Fritsch
Jswartz
Chip Fritsch
Chip Fritsch

@jswartz Yes, that is correct. You do have to account for the new fields in the schema as well of course.

This report is now pretty old, it was built in Jan 2018 and updated several times over the years. Acumatica may now include the schema for the account/ routing number in newer versions out of the box, but I would need to verify.

Reply
Tim Rodman
Posts: 2527
 Tim Rodman     ★★ All-Star ★★
August 14, 2019 7:51 am
(@timrodman)
Over 200 Posts
Joined: 5 years ago

Thanks for attaching your version Chip!

Reply
  All forum topics
  Previous Topic
Next Topic  
  Forum Statistics
11 Forums
1,723 Topics
7,913 Posts
6 Online
1,169 Members

Latest Post: AUGForums.com Live Suggestions Our newest member: ibvbghujhu05 Recent Posts Unread Posts

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×