Where to find AR customer's credit availble value like in AR customer inquiry screen ?

[vbdbcoder]

Hello there,

Can you please provide any pointer to get the AR customer Credit Available value or Total Outstanding Balance value in AR customer inquiry screen ?

Either SQL pull or macro pull will work for me. I can manage the VBA code.

Thanks in advance.

 

[Jay Converse]

ARCUS.AMTCRLIMT - ARCUS.AMTBALDUET

Sage 300 Whisperer

 

[vbdbcoder]

The idea is to create a sales order with "On Hold" status when a customer's credit limit is exceeded. I also see that there is O/E outstanding balance value. Sorry for not being clear enough. And Thanks for the quick response as always.

 

[Jay Converse]

OK, then add in "select * from oeordh where customer = whatever".

FWIW, if it was me, I would have told the client "No", because you're reinventing the wheel.

Sage 300 Whisperer