If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
deduct order quantity from credit limit
I have on my customer master, a field for credit limit. The user can input
the credit limit for that particular customer. When the user then goes in to the order screen, in the line item section, I would like for an message to come up if they have reached their credit limit. So I know I would have to compare the order quantity against the credit limit. Would I do this in a query? Do I need to create a different type of query instead of a standard one? So I would want to see: Customer Credit Limit Qty Ordered Amt Avail ACE Hardware 650 20 630 ACE Hardware 60 570 And have it keep it going for every order. Is this possible? What is the easiest way to do this? Thanks in advance Kim P -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201006/1 |
#2
|
|||
|
|||
deduct order quantity from credit limit
You need to have customer and their credit limit in one table and their
ordering and payments (transactions) in another. You have to keep a running balance or otherwise you would not let them order more even though they have paid the bills. A query would sum their transactions and real-time reduce their credit limit as of that date by the total outstanding balance. -- Build a little, test a little. "klp via AccessMonster.com" wrote: I have on my customer master, a field for credit limit. The user can input the credit limit for that particular customer. When the user then goes in to the order screen, in the line item section, I would like for an message to come up if they have reached their credit limit. So I know I would have to compare the order quantity against the credit limit. Would I do this in a query? Do I need to create a different type of query instead of a standard one? So I would want to see: Customer Credit Limit Qty Ordered Amt Avail ACE Hardware 650 20 630 ACE Hardware 60 570 And have it keep it going for every order. Is this possible? What is the easiest way to do this? Thanks in advance Kim P -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201006/1 . |
Thread Tools | |
Display Modes | |
|
|