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 8 days ago
    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 8 days ago
    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 3 days ago
    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
    ------------------------------