Hi,
Similar to how a Customer Limit as below;

Is there a way to setup a Supplier Limit?
Hi,
Similar to how a Customer Limit as below;

Is there a way to setup a Supplier Limit?
Best answer by Steve Milner
@Avishka Janani's right, there's no built-in supplier limit. If you want the limit stored on the vendor and compared against the open balance, you can do that without code. I built this in 2026 R1 and tested it.
Create a Number attribute on Attributes (CS205000), for example SUPPLIMIT. Add it to your vendor class and enter each vendor's limit on the Attributes tab of the Vendors form.
Then build a generic inquiry on Vendor, APInvoice and CSAnswers. Join Vendor to APInvoice on BAccountID = VendorID, and Vendor to CSAnswers on NoteID = RefNoteID. Conditions: APInvoice.OpenDoc = True, APInvoice.Released = True, APInvoice.DocType does not equal PPM, CSAnswers.AttributeID = SUPPLIMIT. Group by Vendor.AcctCD.
Show the vendor, the name, CSAnswers.Value as the limit, and two formulas.
Open balance, aggregate SUM:
=IIf([APInvoice.DocType]='ADR', 0-[APInvoice.DocBal], [APInvoice.DocBal])
Available:
=CDec(Max([CSAnswers.Value])) - Sum(IIf([APInvoice.DocType]='ADR', 0-[APInvoice.DocBal], [APInvoice.DocBal]))

Use CSAnswers. Don't put the attribute field itself on the GI. With grouping on, it fails with "The virtual field ... cannot be used in a condition expression."
Debit adjustments reduce the balance, and prepayments stay out, the same as the Vendors form. It covers open bills, not open POs, and it only reports. It won't stop anything. Blocking a PO over the limit would take a customization.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.