We have very Specific Type of requirement and i am struggling to make it work.
Case 1.
Product A : 1 ltr bottle (NOS) / selling to distributors in BOX ( pack of 20 ).
Rate Based on bottle (NOS) - fetched from rate list
QTY based on BOX BOX ( pack of 20 )
so when creating invoice type no of box want to sell.
example :- 2
calculate nos = 40 (2 * 20 in each box).
price per nos = 100
item value = 100 * 40 = 4000.
option to give discount per NOS = -1000
Value = 3000
Print on Invoice :- QTY of BOX , Conversion Rate, QTY of NOS, Price per NOS, Discount on Rate List in percentage. Extra Discount Freight etc.
i was able to come this far but problem is i want price to be based on nos not box. so 100 per nos. and that price should be based on price list on which i will give discount. hope this clarifies my problem