Prenotification file ACH format

[former_member215295]

Hi All,

For US clients is it possible to generate prenotification file in ACH format, I am able to generate a file in ACH_PRENOTE format but not in ACH format.

When program RFKKPNFC00 or Tcode FPPNO is executed program creates prenotification file successfully in ACH_PRENOTE format when ACH is given as format it shows a message

Format ACH: No prenotification medium created

Message no. FKK_ID017

thanks in advance

[AmlanBanerjee]

Check whether you have assigned the ACH payment medium format for the company code for which you are running the pre notification program.

Thanks,

Amlan

[former_member215295]

Hi Amlan,

Yes I did assigned the ACH format to company code , we are currently sending ACH files to the bank.

thanks

[oliviawalsh]

Hello,

Have the events 1025 and 1052 been activated?

Please activate them with the below mentioned Func Modules:

Event 1025 : FKK_PRENOTE_ACH_1025

Event 1052 : FKK_PRENOTE_ACH_1052

The master data changes are recorded by these function modules into the

table DFKKPNBKA which is the main data provider for FPPNO.

Please activate these events. Master data changes are recorded only when

these events are activated.

Hope this helps...

Regards

Olivia

[former_member215295]

Hi Olivia,

I did activated the events with the function modules you specified.

For me the issue is - I am able to populate the table DFKKPNBKA with changes in contract account but when I run the FPPNO with format ACH its not generating any file, system says FORMAT ACH: No prenotification medium created , if I run the FPPNO with the format ACH_PRENOTE system is able to generate a file.

I would like to generate the file in ACH format rather than in ACH_PRENOTE format.

thanks in advance

[Former Member]

Hi,

Did you get your issue resolved?

I am facing a similar problem of Format ACH:no prenotification medium created.

Pls respond as to what can be done to resolve the same?

[former_member215295]

I generated the file ACH_PRENOTE format not in ACH format.

[Former Member]

Thanks for the response.

I am able to generate file with ACH_PRENOTE.But the file generated has # coming after every letter.

I understand that it because of a field code page.

I applied the note 1064779.Z_FILL_CODEPAGE pgm which is used to update the value in the field Codepage is not able to update the same for the format ACH_PRENOTE.

Could you pls tell me what can be done to resolve this??

[AmlanBanerjee]

Hi,

Note 1064779 also involves some manual activities to be performed apart from the code changes.

The manual activites are as follows and has to be perfomed one after another-

(a) Transaction Code- SE11

Give table as TFK042F in field "database table".Click on "change".Enter a new field CODEPAGE (Dataelement CPCODEPAGE)

Finally activate table TFK042F.

Note-If the field is preconfigured in TFK042F, then you can go the next step.

(b) Transaction Code-SE37

Give FM as FKK_DME_FILE_OPEN.Click on "change".Go to the "IMPORT" tab

Enter Import parameter as C_FORMAT and TYPE TFK042F-FORMI and activate the two switches "optional" and "pass value".Finally activate function module FKK_DME_FILE_OPEN

Note- If this parameter is already in FKK_DME_FILE_OPEN, then you can go the next step.

(c) Transaction Code- SE11

Give table as V_TFK042F in field "database table". Add field CODEPAGE in view V_TFK042F as following:

Viewfield Table Field

CODEPAGE TFK042FCODEPAGE

Finally activate view V_TFK042F

(d) Fill in the format you use in table TFK042F-CODEPAGE with the value of the codepage you want to use.

For example-

REPORT z_fill_codepage.

UPDATE tfk042f SET codepage = 'your codepage number'

WHERE formi = 'your format'.

COMMIT WORK.

Hope it helps....

Thanks,

Amlan

Edited by: Amlan B on Jan 8, 2011 9:46 AM

[Former Member]

Hi Amlan,

Many thanks for the response.

I have implemented all the 4 parts of that note and for format ACH I am able to update codepage value as 1100 with the program Z_FILL_CODEPAGE.

But when I try the same with format ACH_PRENOTE I am not able to update codepage in the database table.

[Former Member]

Hi guys,

I see that these t-codes belong to FI-CA. Is there any t-code to create the pre-note in FI-AP and also when the bank returns the error file can we automatically upload it and make corrections?

Appreciate your help.

Kalyan