Sum table in SFP form

[Former Member]

Hi,

I want to display the dunning Letter with Adobe.

I have copy the SAP standard , F150_DUNN_SF, for one Z_F150_DUNN_SF form.

Problem is: when I have items with different currency, just display the Total in local currency.

I want display the total by currency.

I have one table that has the all open items, so is possible do the sum in form????

I don't want change the function module PRINT_DUNNING_NOTICE_PDF.

All ideas and soluctions are welcome.

Best regards,

Ana Moreira

[chintan_virani]

Anabela,

It's possible to have a Sum field and calculate it. Have a look at Sum function in Adobe LiveCycle Designer Help

You can also goto c:\program files\adobe\designer 8.0\en\samples\purchase order\dynamic interactive\forms and open the Purchase Order form in LiveCycle Designer. Check the script written for Total Field and it will give you a fair idea on same.

This is how it looks in the form:-

// Verify at least one instance of the numAmount field exists.
if (exists(detail[0].numAmount) == 1) then
	Sum(detail[*].numAmount)
endif

Chintan

[Former Member]

Hi Chintan,

Thank you by your idea.

I have put like you described and just I have one line for total.

I describe better my problem:

My table has some lines like:

1 EUR 10,00

2 DKK 20,00

3 EUR 15,00

4 DKK 10,00

And after, I want one total like:

Open item EUR 25,00

Open item DKK 30,00

I want create this total, just in adobe form not by program.

has solution for it??

Best regards,

Ana Moreira

[Former Member]

Hi,

I'm not sure it's possible to do the sum in the layout , but in the interface part you can define a table as a global attribute.

In the initialization part of the form , populate the global attributes by doing a "collect" ... then display in the layout the new global attributes.

Hope this help you

Best regards.

[Former Member]

Hi,

I have tried define the sum in the initialization of interface.

But my problem now is define one table that Form show the fields7lines of this table.

Can you help me?

Thanks in advance.

Ana Moreira

[Former Member]

Problem solved.

Save the table in the interface

Ana Moreira

[Former Member]

Hello,

I have created a Dunning ADOBE form. In the config, there is a SMARTFORM already. If I replace this SMARTFORM with my ADOBE form, will it work automatically? Do I need to do something for the FM PRINT_DUNNING_NOTICE_PDF to work with my form?

Thanks.

Update: RESOLVED! Had to put the above FM in business transaction Event. BF31 - P/S modules of SAP app - 00001720, FI-FI, PRINT_DUNNING_NOTICE_PDF. Thanks.

Edited by: AdobeNewbie on Aug 21, 2008 1:38 AM

[Former Member]

Hi,

How do I get the adobe form in customizing? I have put the FM 'PRINT_DUNNING_NOTICE_PDF' in business transaction Event, BF31 - P/S modules of SAP app - 00001720, Fi-FI. But it is still not recognizing the ADOBE form.

Any help is greatly appreciated.