Credit Limit By Material with Customer
Could you please suggest me any body how to maintain credit limit by material (Product).
Let say Customer Pepsi has 3 products i.e X,Y and Z....pepsi (customer) has credit limit 100 USD. Here the customer credit limit is 100 usd but this customer has that credit limit by product wise that is:
X Product 30 usd
Y Product 50 usd
Z Product 20 USD
When they are creating they wont cross credit limit by product wise even though the customer has credit limit if X product credit limit 20 usd exceeded. Could you please suggest me how to maintain this scenario.
Thanks in advance,