By using this website, you agree to our Terms of Use (click here)
In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman
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
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.
Thanks a lot Tim ...
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
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.
@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
@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.
@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.
@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?
@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,
@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?
@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.
@jswartz Hi, I am experiencing the same issue where the lines are one off. What do you mean when you say "if you leave them at the bottom it will print the info on the wrong line" Where should it be located to print correct?
Thanks for attaching your version Chip!
Online Members
