Open Forum

Expand all | Collapse all

Sales/Customer/credit limit

Jump to Best Answer
  • 1.  Sales/Customer/credit limit

    Posted Jan 15, 2019 10:13 AM

    We are running Dynamics GP 2013 and need to set the credit limit for a customer to $1,250,000,000,000.00. Unfortunatly the RM00101 table has a data type of numeric(19,5) is there any way this can be altered or overridden without dropping and re-creating a new table? I have tried generating a new drop and create script including Schema and data but when ran with the change to numeric (21,7) I get completed with errors "'CK__RM10101__POSTEDD__2EB0D91F' is not a constraint" and the change needed is not updated

    Thank you, any help is greatly appreciated


  • 2.  RE: Sales/Customer/credit limit
    Best Answer

    Posted Jan 15, 2019 11:08 AM
    Hi @Renee Boucher​​

    First, I highly advise that you do NOT alter the GP tables at all.  At. All.

    Second, does the possibility exist that this customer could ever max their credit limit?  If not, it may not be worth setting up in this field.  You could set it to the max that field holds $999,999,999,999.99 and then use either of the standard User Defined Fields to contain the real number or use Extender to track this real number.

    If you must track this number because the ability for the customer to exceed it exists, you can write some custom "Sales Hold" functionality to accomplish this.

    But, never change those data types in the GP tables, they interact highly with the GP business logic and too many other tables.

    Kindest Regards,
    Jo deRuiter , MCP, DCP
    "That GP Red Head"
    GPUG Academy Instructor
    Dynamics GP Credentialing Council-Vice Chair
    770-906-4504 (Cell)


  • 3.  RE: Sales/Customer/credit limit

    Posted Jan 18, 2019 12:42 PM
    RM00103.CUSTBLNC is also a numeric(19,5) field (as are pretty much every other numeric field in RM). So even if you could find a way to make the credit limit field accept the higher credit limit, I think GP would either throw errors or at the least, never know if the customer attained that level, because the balance can't go that high. I could be wrong, but that's what it looks like.

    I think you'd have to set the credit limit to Unlimited, and then have a SQL job to calculate the current balance based on sum of RM20101.CURTRXAMT for the customer. That job would update RM00101.HOLD to 1 if the sum was > than the desired credit limit.

    Mark LeRette
    Application System Analyst II
    Muscatine Power and Water
    Muscatine IA

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