web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

AP Check customization-SL2015

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Verified answer
    Butch Adams Profile Picture
    4,763 on at

    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

  • Community Member Profile Picture
    on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans