i would divide the discount up between the individual lines based on the % the line contributes to the over all total. so roughly
item price discount new line total
A 720 244 476
B 320 108 212
C 245 83 ...
D 270 91 ...
E 200 89 ...
Slán
~M
>Dear Experts
>
>A customer goes to a shop and purchase five products (from A to E)
>
>The shopkeeper makes bill of =1815
>Now customer asks for discount of = 615
>He want to pay only 1200 instead of =1815
>
>How to adjust rates so that the bill amount will be 1200 with out any changes in quantity
>Product and Rate table is attached.
>
>Item-Qty--Rate--Amount
>A----13----60----780
>B----8-----40----320
>C----7-----35----245
>D----18----15----270
>E----25----8-----200
>
>Bill Amount= 1815
>
>Please help
Go raibh maith agat
~M