F.27-error no records found

[Former Member]

Hi Experts,

We want vendor periodic statement to be issued to vendor. We tried in F.27 but no records were found.Kindly suggest some other T-code to get data like vendor code,gross amount, withholding tax base and tax amount, service tax amount, net amount etc.

We are in ERP 4.7 functional and ECC 6.0 technical.

Thanks in advance.

[former_member221582]

Hi Sethu - Sorry I assumed it is for Customer. For Vendor, this field is "Bank statement". Most of the cases this field is suppressed. Check the filed settings in your vendor group.

Once you make it optional or required, you will get the acct statement field in vendor master.

Thanks,

Vignesh

[Former Member]

Hi Vignesh,

Thanks for your reply. We have configured as per your suggestion still some error occurs.

I have attached configs and message screenshots.

Kindly help.

[former_member221582]

Sethu - I guess you haven't created the variant for the report program. Correspondence configuration involves following steps

1. Define new correspondence type (As per your screen shot this step is complete)

2. Assign report program to correspondence type (for SAP06 standard program RFKORD10 would have been assigned already)

3. Create a variant for the program RFKORD10. The name of the variant should be SAP06. (I guess this step is missing)

4. Assign forms to the report program

Thanks,

Vignesh

[Former Member]

Hello Sethuraman,

In SPRO, please check that all the below customizations are complete.

1. Define correspondence type

2. Assign co. code to correspondence co. code.

3. Assign Programs for Correspondence types.

4. Define form names for correspondence print.

Please also make sure that the Sender details for correspondence form and sort variants are also mainatianed. Additionally, mantain the account statement field in master data as well.

This should resolve your issue when the t. code F.27 is executed.

Hope it helps.

Amitash

[Tayo_Oyesile]

Very helpful. Thanks

[sanilbhandari]

Hi

You need to assign the correspondence in Vendor Master Company Code View under correspondence tab

Regards

Sanil Bhandari

[Former Member]

Hi Sanil,

What needs to be assigned in vendor master-correspondence.

Can you explain.

[sanilbhandari]

Hi

You need to maintain the Account Statement Indicator in the correspondence tab of Vendor Master Company Code view to be able to generate Vendor Account Statement. Refer the attached screen shot.

Regards

Sanil Bhandari

[Former Member]

Hi Sanil,

Its been activated still the error comes.

Kindly help.

[narasimhulu_konnipati]

Check if the standard correspondence SAP06 is assigned to your company code to run F.27.

Thanks

[Former Member]

Hi Narasimhulu,

Thanks for your prompt reply.

SAP06 is assigned still no data was selected.

[former_member221582]

Check if you have maintained the indicator for periodic account statement in customer master record (Correspondence tab in company code data).

Thanks!

[Former Member]

Hi Vignesh,

Account statement indicator is available in customer master. But We want account statement for vendors. There is no indicator in vendor master.

Kindly suggest.