Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.
vbdbcoder

vbdbcoder

Programmer
Joined
Nov 23, 2006
Messages
250
Location
US
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.
 
Sort by date Sort by votes
ARCUS.AMTCRLIMT - ARCUS.AMTBALDUET

Sage 300 Whisperer
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question Question
Posted AR Invoice not shown in the GL Entries
Replies
0
Views
430
mis_joy
M
Microiz
  • Locked
  • Question Question
web screen report
Replies
0
Views
274
Microiz
Microiz
vbdbcoder
  • Locked
  • Question Question
Sage 300 Web screen login error message
Replies
3
Views
942
DjangMan
DjangMan
vbdbcoder
  • Locked
  • Question Question
Can VB6 screen with OCX look like Sage 300 native screen with color theme and flat text box ?
Replies
3
Views
989
vbdbcoder
vbdbcoder
vbdbcoder
  • Locked
  • Question Question
"Ship All" function does not work for 1 customer
Replies
2
Views
895
vbdbcoder
vbdbcoder

Part and Inventory Search

Sponsor

Back
Top