By using this website, you agree to our Terms of Use (click here)
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!
Attached is an update version of the AP check with the bill description, along with an updated version of the remittance report with the bill description. Both of these are working with 2022R2 (without construction).
Any chance you can upload the full report sample? I'm experiencing this same described issue with the Line number being off (which I just adjusted for) and the 0 printing if the description is blank. The zero printing is really the biggest concern. The above previous 2021 solution doesn't seem to work with the variable in the description or the new Adjust group in the updated form.
Thank you for any assistance!!!