[Foreword]

Decision has been deeply involved in the SAP field for more than 18 years and has been praised by many customers. In order to better help customers implement digital projects, the "Decision Expert Column" is completely free and open source, paying tribute to Musk's open source spirit!

Based on the senior capabilities of Decision's expert consultant team with more than 20 years of SAP experience, combined with Decision's 1,000+ successful project cases, this article summarizes and publishes the corresponding research experience and suggestions of enterprises in promoting ERP project implementation, and continues to escort the SAP implementation and delivery of enterprises.
 

[Problem Description]

When selling invoices, the customer's accounts receivable control account is obtained from two methods:
1. Obtained from the OV64 transaction code configuration;
2. Obtained from the customer master data company code; the system gives priority to obtaining the control account from the configuration OV64.

There are only two configuration subdivisions provided by transaction code OV64:
1. Specify the control account by sales organization;
2. Distinguish the control account by sales organization + channel. Neither of these two methods can meet the requirements of financial accounts receivable segmentation accounting (segmented into: domestic-related parties, domestic-non-related parties, export-related parties, export-non-related parties).

As for the transaction code BP customer master data, only one control account can be specified. How to achieve this requirement in the system?
 

[Problem Analysis]

1. If the OV64 transaction code configuration, BP customer master data, and the specified reconciliation account cannot meet customer needs, you can consider using enhancements.
2. Transaction code SE80, check the sales invoicing enhancement function group XVVF and you can see that SAP has reserved EXIT_SAPLV60B_002 to enhance the processing of customer reconciliation accounting line items.
 

3. Discuss with the user to determine the judgment logic of the customer reconciliation account, which is generally a combination of sales organization + sales channel + customer account allocation group.
After discussing the above requirements with the user, it is confirmed that the sales invoicing reconciliation account is determined by the "customer account allocation group" in the BP customer master data.
 

[Solution]

1. Activate the enhancement of transaction code CMOD and replace the reconciliation account according to the "Customer Account Assignment Group".
 

2. Transaction code SPRO->Financial accounting->Accounts receivable and accounts payable->Business transactions->Posting with alternative reconciliation accounts->Determine alternative reconciliation accounts, configure the alternative relationship between master data reconciliation accounts and posting reconciliation accounts:
 

3. In addition to sales integration business, when manual vouchers also need to select different reconciliation accounts,
Transaction code FS00, set the master data reconciliation account and alternative reconciliation account to: allow manual input.
 

4. Test posting results: Controlling account replacement is successful!

【Service Guide】
For more information on SAP courses, project consultation and operation and maintenance, please call Decision's official consultation hotline: 400-600-8756

【About Decision】
Global professional consulting, technology and training service provider, SAP gold partner, SAP software partner, SAP implementation partner, SAP official authorized training center. Eighteen years of quality, trustworthy!