sign of the TDS amount for the item

[Former Member]

hello expert,

i am working on a TDS certificate.my requirement is as follows

i have three fields such as total amount , tds_amt , ecess_am t.there are two item values for total_amt such as 5000- and 50000-.similarly for the tds_amt values are 101 and 1010 and again for ecess_amt there are two values such as 2 and 20..the first item value for the tds_amt is 101 but this is acting as negative which is also my requirment to act like negative but it is not showing the negative sign such as 101- rather then it is being displayed as 101.how to display the sign for the item detail 101 as 101-.

<removed by moderator>

Edited by: Thomas Zloch on Oct 21, 2010 10:50 PM

[Former Member]

thanks a lot to all the experts

[Former Member]

hi,

Check if there is not length of the field used to display the amount first or the window is not being overlapped.

[Former Member]

hi,

When print amount using option S to suppress the sign: &tds_amt(S)&

Pleas check.

Thanks,

[Former Member]

Dear pham,

my requirement is to display the sign for the TDS amount but it is not displaying the sign where as it is operating as a negative sign and fulfill the requirement.but i have to display the quantity 100 as 100-.

what shall i do?

thanks and regards

[Former Member]

HI,

If u want to display a +ve value to -ve value then

tds_amt = tds_amt * -1.

And also do check the paragraph format alignment .

Regards,

Madhukar Shetty

[Former Member]

Hi,

Sorry for misunderstanding your requirement.

So, Create a code node upper your text node display amount, input and output parameter is your amount and field to check condition (assume it is v_cond)

if v_cond = negative.
amount = amount * (-1).
endif.

Thanks,

[Former Member]

thank u very much pham,MADHUKAR AND EVERYONE

for your replies.

but i want to modify the program in order to get the result.the first line item value for the TDS is displayed as 101 and CESS is displayed as 2 but the total is displayed as 103- . second line item value for the TDS is 1010 and CESS is 20 and this 1010 and 20 are displayed as 1010 and 20. now here i just want to show the 101 as 101- and 2 as 2-.my program is z_j_1iewt_cert which is a copy of the standard program J_1IEWT_CERT.

[Former Member]

Hi Pritee,

If am not wrong then ur requirement is

TDS = 101

CESS = 2

TOTAL = 103-

So if Ur total is less then 0 then u have to show the TDS & CESS in -ve right ?

If YES

Then check tat the

If TOTAL LT 0

TDS = TDS * -1.

CESS - CESS * -1.

endif

Regards,

Madhukar Shetty

Moderator message: please do not use SMS speak when posting in these forums!

Edited by: Thomas Zloch on Oct 21, 2010 10:51 PM

[Former Member]

thank u madhukar,

let me try as per your instruction.thank you agaian for ur help.

regards

Moderator message: please do not use SMS speak in these forums!

Edited by: Thomas Zloch on Oct 21, 2010 10:51 PM

[Former Member]

hello experts,

i got the solution for the -ve sign for the tds_amount and ecess amount which was not previously displayed.actually the tdsamount and ecess_amount datatypes has to be changed. because if u click on data element and domain for the field wt_qsshh you will find that there is a checkbox for the sign and that is being checked/ticked/selected.hence because of this reason what ever the quantity may be positive or negative that is going to consider as positive.hence we have to change the datatype.

thanks and regards

[nabheetscn]

There must be credit/debit indicator based on which you can declare a variable and concatenate the - sign based on the condition.

Nabheet