How tocalculate the total quantity n value in smart forms

[Former Member]

Hi,

M unable claculate the total quantites n value for quantity in smart from eventhough i declared at calculations of table node and also m unable to print my total amount on last page in words.

Please help me out 4 total quantity n total value in every page n amount in word in final page.

And also give me the standard sales order smart forms(names),so dat i can c how dey r declared in standard forms.

Thanks & regards,

Santhosh kumar.

[Former Member · Accepted solution]

Hi,

declare Global variables to sum the quantity and value. Within the Main Window, inside the table add the value of the quantity to global variable and also do the same for value. if you want to display it at the end of page in footer thenthe checkbox for the same

the otherway inside the table, click on ttabstrip control set the field for which the summation has to be done.

the FM to convert the amount into word is SPELL_AMOUNT

Regards

Shiva

[Former Member]

Hi ,

Double Click on table node .

select calculation tab.

In operation select Total , in field name give the name of the field you want to sum

and in targer field name specify the name of the field that should contain the result .

To convert the total in to words use the function module in program lines

CALL FUNCTION 'HR_IN_CHG_INR_WRDS'

EXPORTING

amt_in_num = w_total

IMPORTING

AMT_IN_WORDS = w_total_words

• EXCEPTIONS

• DATA_TYPE_MISMATCH = 1

• OTHERS = 2

Regards

.