AP Check customization-SL2015

(0) Share

Report

Posted on by Community Member

We want to print the APDoc.description field on both AP check stubs. The docdesc field was added to the AP Voucher & Adjustment screen to capture that info, and the field was added to the top stub of the Stub-Stub-Check format report, replacing an unused field. The description field prints fine on the top stub, as it is in a details section of the Crystal report where one line contains all field references used for printing the check stub detail.

The second stub's handling of fields differs because it is in a page footer of the Crystal report. The fields for refnbr, invoice number, invoice date, etc. appear as formula fields Stubfield011, Stubfield012, Stubfield013, etc. through all stub detail lines. I don't see where the values printed on the top stub are assigned to the variables used on the second stub. Directly referencing the APDoc.docdesc field here would only print the correct information for checks paying one voucher. Any suggestions?

*This post is locked for comments

All responses (2)

Answers (1)

Community Member on at

Like (0)

Report

RE: AP Check customization-SL2015

Thanks Butch for the confirmation, I didn't know if I was missing something in the report design.

This installation is using MaxQ MICR checks, but the formula is from the standard SL multi-stub check report:

WhilePrintingRecords;
StringVar StubFld011;

StubFld011

I hoped to find how the values for the first check stub were assigned to the variables "StubFldxxx" as they were read from the database. It appears that this is done in code and not in a stored procedure that could be modified, so adding a new field to the second stub doesn't appear to be an option.
Verified answer

Butch Adams 4,763 on at

Like (0)

Report

RE: AP Check customization-SL2015

Brian,

I believe that particular check template you describe is from the MaxQ MICR Checks product. If you open a support ticket with them, they should be able to point you toward a solution.

I suspect the formula is referencing data that streams at print time. I took a look and couldn't come up with an idea either.

...b