Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
TaniaMofflin 7/9/2019 2:54:04 AM

Creditor Limit Exceeded

Good afternoon,

I've been having an issue releasing a back order: every time we try to release, a warning comes up in regard of the creditor's limit being exceeded if we decide to proceed.

We've run the below query to find out the outstanding payments against the account:



from RM20101

where CUSTNMBR = custnumbr
and VOIDSTTS = 0
and CURTRXAM <> 0
and DINVPDOF = '01-01-1900'

This gives only one result.

The issue is that the unpaid invoice plus the back order that we are trying to release do not reach the credit limit that we've entered for the customer.

Please note that there is no other orders/invoices in the SOP10100 table but the above mentioned back order.

Is there something I'm not looking at that could breach the customer's credit limit?

The only thing that I can see is if I don't take in consideration the already applied markdown, the creditor's limit is exceeded, although the subtotal of the back order does take it in consideration.

Thank you for your help.

Version: GP 2013
Section: Dynamics GP

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables