Open Forum

Expand all | Collapse all

Is it possible to query the check threshold limites from all companies at once, or even 1 at a time?

  • 1.  Is it possible to query the check threshold limites from all companies at once, or even 1 at a time?

    Posted Dec 05, 2018 04:44 PM
    I've poked around but did not find any SQL scripts or information regarding reporting on check threshold amounts. Our accounting team would like to review the check threshold amounts that are setup for each company. Is there an easy way to gather this data or is the only option to go into the setup tables and verify?

    Thank you,

    ------------------------------
    Angela Morehouse
    CC Industries
    Chicago IL
    ------------------------------


  • 2.  RE: Is it possible to query the check threshold limites from all companies at once, or even 1 at a time?

    GOLD CONTRIBUTOR
    Posted Dec 06, 2018 09:25 AM
    Simply put, here's the basic script.
    ****************************************************
    SELECT       RTRIM(CHEKBKID) [Checkbook ID],
                        CAST(MXCHDLR AS decimal (12, 2)) [Maximum Check Amount]
    FROM         CM00100
    ORDER BY [Checkbook ID]

    ****************************************************

    If you have SmartList Builder, create your SmartList
    Step 1
    Click Options
    Under Multicompany SmartList, check all of the companies you want to appear.
    Step 3
    Add the object under security and VOILA!  Hope this helps.

    ------------------------------
    Leah Nolan
    Great Plains Administrator
    XO Group, Inc
    Austin TX
    ------------------------------



  • 3.  RE: Is it possible to query the check threshold limites from all companies at once, or even 1 at a time?

    Posted Dec 11, 2018 11:28 AM
    I realize my post was not clear enough, my apologies. Do you know what table holds the signature thresholds? I appreciate your help.

    Thank you,
    Angela

    ------------------------------
    Angela Morehouse
    CC Industries
    Chicago IL
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role