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!

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

Query - Prepaid Customers

Status
Not open for further replies.

ravazz

MIS
Dec 8, 2009
112
0
0
JM
Please indicate if there is any feature within Sage 300 (apart from the credit limit option) that can be used to restrict transactions for customers without a prepayment/deposit.

This control mechanism should reflect "Your deposit has been exhausted" when an attempt is made to process a transaction greater than the customers prepayment/ deposit.
 
There's nothing within Sage that will do that.

You could look at Orchid's Extender product which would allow you to introduce new business logic to do what you need.
 
A rather crude way could be using an SQL trigger to place a sales order on hold if your criteria are met. I've done something similar.

Sage 300 Certified Consultant
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top