Accounts Receivable Statements or Customer Statements.

[Former Member]

Hi All,

I would greatly appreciate your help on the following issue. Points available.

I need to generate A/R stmts or Customer stmts. The stmts need to list the open items that the customer still has not paid. <b>Does anyone know where I can do this?</b> <b>Do I need to configure the Correspondence settings in FI?</b> If anyone has some step by step documentation, please send it to bw_ani@yahoo.com.

Thanks in advance!

[Former Member · Accepted solution]

Hi there,

Thanks for your responses. I really appreciate it. I have completed the following steps in SPRO:

a) I went to OB77. Did not configure anything there, because I want to use SAP06 correspondence type.

b) Assigned Company Codes to Correspondence Company Codes. Basically I assigned my CoCd (1234) to Corr. CoCd (1234).

c) Create Report Variants for Correspondence: I selected RFKORD10 and executed. I was brought to a <u>Print Program: Account Statement</u> screen. I then entered my Form Set, Sort Var. for Correspondence, Check marked the Open items list, and then did a Test run.

d) The test run showed the Customer stmt (it still needs to be formatted).

e) I now went to F.61 to <u>Correspondence: Print Requests</u>. I selected the Correspondence (SAP06), CoCd, Acct type D (Customers), and also put in the Customer account number in the Open item account filed. However, when I execute, I get this message:

<b>No correspondence requests were selected</b>

<b>Is my config missing anything?</b> I know the Customer account has a balance in it. <b>Do I need to change some config on the Customer master record in the Correspondence tab?</b>

Message was edited by:

United 99

[Former Member · Accepted solution]

Hi,

First you need to create the Correspondence request from FB12 and then F.64 or F.61 to maintain. Or you can maintain the Request from the FBL5N from environment> Correspondence> Request.

Thanks

VK

[Former Member · Accepted solution]

Hi Vijay,

Thanks for your reply. I went to FB12 to a Request Correspondence screen. My CoCd was entered and I hit ENTER. At the bottom, I got a message : "Account Statement was Requested".

I then went to F.61 and again entered the needed info and hit Execute. However, I now got the following error message:

<b>Variant SAP06 does not exist</b>

Message no. DB612

<b>Diagnosis</b>

You selected variant SAP06 for program RFKORD10.

This variant does not exist.

<b>Procedure</b>

Correct the entry.

But I thought SAP06 was already in the system?

Thanks in advance!

[Former Member · Accepted solution]

Hi,

SAP06 does exist but you might have not created a Variant SAP06 for the Program RFKORD10 and while your re-print it might be checking based on the Config. setting in OB78 where you assign the name of print program and name of the variant.

Please check this one and let me know.

Thanks,

Ashok

[Former Member · Accepted solution]

Hi,

Go to SE38 and give you program and select the Variants Radio button and press display give the variant name here and click on diplay, you will know whether the variant is created or not if not press on create and give the following values

Sort Var. for Correspondence K1

Line item sorting P1

Check Box Statement also w/o items

Save your entries.

Now create the request and run the Correspondence.

Thanks

VK

[Former Member · Accepted solution]

Hi Ashok,

Thanks for your response. I am a little confused with your answer. In OB78, this is what my config looks like:

<b>CoCd........Corr. ........Type of Correspondence</b>

1234 .......SAP06.......Account statement

If I double click, I am brought to the following:

Company Code: 1234 Company name

Correspondence: SAP06 Account statement

Name of the print program: RFKORD10

Name of variant: SAP06

<b>Is what I have configured above correct? Or is there a specific t-code I need to go to and maintain?</b>

Thanks!

[Former Member · Accepted solution]

Hi,

This is what I explained. Based on this config. it is looking for a Variant SAP06 for the Program RFKORD10. So you need to create a Variant SAP06. This needs to be done by executing the Program RFKORD10 and then input the following fields in selection screen:

Correspondence Sorting: K1(you can use which ever you need from the drop down)

Line Item Sorting: P1 (you can use which ever you need from the drop down)

Select Open item list check box.

Once the above are keyed-in save the Variant as SAP06.

This should solve your problem.

Please let me the results.

Thanks,

Ashok

[Former Member · Accepted solution]

Hi,

I missed while typing the email. Please add the following:

Statement also w/o items needs to be checked in the Variant.

Thanks,

Ashok

[Former Member]

Hi,

The following Config. needs to be done to execute the Correspondence Statements for Customers with Open items as on date (like F.64):

1. Define Correspondence Types: FA-> FAGS -> Correspondence -> Define Correspondence Types (Ex: SAP06 - Open items)

2. Create Report Variants for Correspondence: Use the Print Program: RFKORD10 and define the Variant say SAP06

3. Assign Programs for Corres. Types: Need to assign the print Program: Standard Program- RFKORD10 & Print Variant SAP06 defined above.

4.Define Form Names for Correspondence Print: Form F140_ACC_STAT_01 has to be assigned to Program RFKORD10. You can define your own form that is copied from Std. one and can define your own layout.

The above configuration is basic stuff needed for the Correspondence Statements. Additional needed depends based on the Client's additional requirements.

I hope this helps you. Please let me know if you need more details.

Thanks,

Ashok

[Former Member]

Hi,

Use correspondence type SAP06.From the user menu select maintain correspondence.

The t.codes are

F.61 Correspondence: Print Requests

F.62 Correspondence: Print Int.Documents

F.63 Correspondence: Delete Requests

F.64 Correspondence: Maintain Requests

F.65 Correspondence: Print Letters (Cust)

F.66 Correspondence: Print Letters (Vend)

F.27 Periodic account statements

Thanks

Aravind

Assign points if useful

[Former Member]

hi,

pls click on the belwo link to see the Customer statmetns....

http://help.sap.com/saphelp_45b/helpdata/en/35/a47e68763e0392e10000009b38f9b7/content.htm

pls assign points... if it is useful...

Ranjit