our Business scenario as follows:
we have Maximum billing value for each customer.
for example customer XYZ is having maximum billing value of 200000(this maximum billing value is varies customer to customer and this is fixed to each customer depending on his deposit).
when ever customer palces a sales order woth of more than 200000, system will spilt the invoice into number of invoices according to his maximum billing value.
if cystomer XYZ order value could be the 450000 , system will spilt into three invoices.200000,200000 and 50000.
where we define the maximum billing value for each customer and how to split the invoice.
plz help me out.
Thankns & Regards,
Splitting of invoice on value is not correct. This may result into error is the quantity gets splitted in fraction considering the amount. What you can do is at copy control u can check at what qty the amount becoems more than limit. If limit is crossed then the qty will be rounded to below value. Now remaining qty will considered for next invocie creation . Hence u will not get exact invoices like 50000, 50000, 40000 etc but will always in the limit.
Reward if helpful.