on 01-13-2009 10:52 AM
Hi all,
I designed a layout to print item details, vat details and service tax details within the same main window with different Tables. The result whould be , if there are same Vat codes for each line item, then the vatable amount should be summed up and printed with respect to that particular VAT code. if code is seperate ,then to print diffently. but the problem is, if there are 25 line items then all 25 Vat codes are being printed. they are not summed up into one variable.
Example:
Now the output is:
*lineitemno taxrate vatcode amount.
1 12.5 V1 100.00
2 12.5 V1 200.00
3 12.5 V1 100.00
4 4.00 M1 500.00
5 3.00 M2 700.00*
where as the output should be:
V1 12.5 400.00
M1 4.00 500.00
M2 3.00 700.00
Please help me out.
Hi Kumar,
Use the sort begin with the tax rate and sum up the vatcode amout and using the subtotal and display.
Regards,
Sravanthi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try to use:
SORT itab
COLLECT itab
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you can add the amount based on tax code in your internal table and pass this value ti your window.
loop at itab,
sum = amount + sum.
at end of taxcode.
amount = sum.
endat.
endloop.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.