Combine customer accounts to print on one statement

[Former Member]

Hello all,

I have a scenario where I might have the same customer created in two different account groups, with two different customer numbers., also possibly in two different company codes.

What would be the best method to use to combine these two customers in order for them to receive only one account statment?

I have considered using corporate group field, but that is not a selection on F.27 for printing statements.

Also considered using the fiscal address field to group the customers(similiar to how this works in AP for 1099's) but again that is not a selection.

Also considered using worklists, but again not a choice.

Best choice would be if the customers,even though in different company codes, had the same account number. Then the account number could be used to combine the two accounts. Yes or no?

Any help or guidiance would be greatly appreciated.

Alicia

[Former Member]

Can you elaborate on this? I do not see these fields on F.27 as selections. Is there another T code for running customer statements?

[Former Member]

Check the program documentation for F.27 txn. SAP clearly states

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.

Note where it says spool is created for each correspondence type and company code - that to me denotes that it is not possile to combine the output of the program for a customer if that particular customer exists in multiple co codes, and has open line items in those mulitple co codes.

Please update here if you test and find otherwise.

However, there still might be a way to achieve what you are asking for. If you use a custom program to process the line items, etc. you can try and make yoru custom print program to merge the line items for a given customer across company codes. However, how will you tell the system to merge which co code line items into which?

E.g., if say you have a customer A created in co codes 1000, 1100, 1500 and 1700 and has line items in all of them. Now, while generating acct statements, you want all line items to be shown as under 1100 - how will you tell this to your print program at run time? Or do you intend to hard-code this mapping, which obviously would imply that this mapping will be applicable for all such customers which exist across these co codes, &c.

In short, you'll have to think through exactly what is it you want, before trying to make SAP do it for you.

Rgds

Gulshan

[Former Member]

Hi,

Account Number or even the address can be Used for getting consolidated Account Statement.

Thanks

Goutam