TMIbyndoor
New Member
- Joined
- Jun 17, 2018
- Messages
- 1
i had one excel sheet .there is 6 column there quantity, recievd qnty ,,balance qty, rate ,tax 5%,and Discount in %. . i need last cell used all
<colgroup><col><col span="2"><col><col><col span="2"><col span="10"><col span="2"><col span="2"><col><col><col span="2"><col><col><col><col><col><col></colgroup><tbody>
</tbody> cell in one answer
Material Received Detail (With GRN) | Total Amount | |||||||||||||||||||||||||||||
Do/Inv No | Date | GRN | Qty | Do/Inv No | Date | GRN | Qty | Do/Inv No | Date | GRN | Qty | Do/Inv No | Date | GRN | Qty | Do/Inv No | Date | GRN | Qty | Rcvd Qty | Balance Qty | Rate | Currency | Discount % | Price | 5% VAT | Discount Amount | Total (AED) | Discounted PO Amount | Total Amount |
I 318/943 | 06/03/2018 | 690385 | 1.0000 | 1.0000 | 0.0000 | 95,000.000 | AED | 0 | 95,000.000 | 4,750.000 | 0.000 | 99,750.000 | 99,750.000 | 99,750.000 | ||||||||||||||||
0.0000 | 1.0000 | 500.000 | AED | 0 | 500.000 | 25.000 | 0.000 | 525.000 | 525.000 | |||||||||||||||||||||
0.0000 | 1.0000 | 500.000 | AED | 0 | 500.000 | 25.000 | 0.000 | 525.000 | 525.000 | |||||||||||||||||||||
0.0000 | 1.0000 | 700.000 | AED | 0 | 700.000 | 35.000 | 0.000 | 735.000 | 735.000 |
<colgroup><col><col span="2"><col><col><col span="2"><col span="10"><col span="2"><col span="2"><col><col><col span="2"><col><col><col><col><col><col></colgroup><tbody>
</tbody>