cancel
Showing results for 
Search instead for 
Did you mean: 

Merging 2 or more customers financials

0 Kudos

Dear All,

Need help on the below scenario.

Customer Code  X --> Invoice Generated. (DR or RV)

Customer Code  Y --> Advance Payment Received with customer code=Y.

The above scenario was done by mistake by separate users, in actual both customers were same but separate codes were generated.

Is there any functionality on Master level, so the Financial reports such as FBL5N, Outstanding reports, ageing reports club both account data and show the balance.

Note: Client do not need to pass the transfer entries etc.

Thanks in Advance.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

As both the entries are in separate Customer Master Data, though of the same Customer, in FBL5N select both the customer & view the report.

Balances could not be merged until they are transferred & the wrong customer is not blocked, which client do not want to do.

Hence the option which I feel is that you need to view the reports by combination of Customer Master Records in Customer Reports.

Regards,

Jaymin R. Bhatt

0 Kudos

Dear Bhatt,

Combining both customers codes for reports was already known, but such things are not accepted.

We are looking for any functionality wherein system stores the codes and provides the report after combining.

Regards

ramakrishna_ailanani
Contributor
0 Kudos

Hello Firoz,

As for as my knowledge, there is no such standard report exist in SAP.

Option 1) View the reports by combination of Customer Master.

Option 2) Transfer the balance from wrong account to Currect account, and block the wrong account

Option 3) Develop ABAP report based the business requirement

Option 4) Generate the report for both the customers using report Painter

Thanks and Regards

A.Rama Krishna

Former Member
0 Kudos

Hi,

Other than that as per my understanding no such report is avaliable where in clubbing of customer would be allowed.

A) Create a set - GS01 - Assign both the customers in it & write a Query or a ABAP report for output.

Regards,

Jaymin R. Bhatt