T code F.27

[Former Member]

Hi,

F.27 is supposedly used for the purpose of issuing periodic account statements to customers and vendors for the open items in the account. But from our case, seems that the statement includes both OPEN as well as CLEARED items.  It should have shown only open items.  I am just wondering what should I do to make the statement include the OPEN items only.

Any input would be greatly appreciated.

[Former Member]

Can any experts give me a hint on this? Thank you for your response.

[Former Member]

This question has more chances of getting answered in functional space.

Check the list of spaces and posting in another forum.

[Former Member]

Thank you Manish.

So this is a functional issue, our functional people in the team should fix this, instead of ABAP developers, right?

[Former Member]

hello,

Please check this help for transaction F.27

Periodic Account Statements

Description

The program selects the customers for whom account statements or open items
lists are to be output periodically and places corresponding requirements in the
table for Financial Accounting correspondence requests.

After selection, the current correspondence requests are output for periodic
account statements or open items lists by means of the triggering report for
correspondence and the print reports and processed correspondence requests are
reorganized for periodic account statements or open items lists.

Requirements

1. Configuration

The correspondence types you require must be configured by means of the
Financial Accounting configuration menu in the suboption Business volume ->
Correspondence. You will find detailed information on configuration of the
individual correspondence types in the documentation for the correspondence
print reports. The name of the print report for account statements and open
items lists delivered with the standard system is RFKORD10. The name of the
print report for customer statements and open item lists delivered with the
standard system is RFKORD11.

2. For customers for whom account statements are to be created periodically,
the account statement field must be maintained in the customer master
record.

Output

If correspondences are printed, a log with the spool requests created by the
print programs is output for each program run. If you do not specify in the
program on which printer the log is to be printed, the program may take the
printer specified in the user master of the user who started the program or the
printer specified when the job is scheduled. If the program is carried out
online, the log is displayed on the screen. If the program is planned as a job,
the spool request name of the log is made up of the identifier F140, the printer
destination, the date of creation and the program ID KORK.

The correspondences are printed by means of the corresponding print programs.
If printing is possible on the basis of the data and the configuration, a spool
request is created for each correspondence type and company code. Regardless of
whether printing actually takes place, the processed correspondence requests are
marked as completed by means of a print date, so that reorganization can be
carried out.

Note; It says it only picks the open items and also there is some configuration required for it.

Let me know if this helps.

best regards,

swanand

[Former Member]

Hello,

From the BSEG table look for BELNR, for the BELNR corresponding AUGBL is blank thenit should come in the output.

Execute all documents( BELNR ) for which AUGBL is blank

[Former Member]

Hi Swanand,

Thanks for your post, it definitely helps.

I am just wondering is there a step by step guideline to show how to to set up the selection criteria, like in this case, just output the open items, instead of both OPEN and CLEARED items?