The SAP error F5144 - "Reconcil. acct missing in master record" occurs when a reconciliation account is not assigned to a customer or vendor master record. The reconciliation account is a key field required for managing transactions in the SAP General Ledger.
Causes of Error
- Master Data Incomplete:
The reconciliation account field is blank or missing from the customer or vendor's master data.
- Customizing Issues:
The reconciliation account is not correctly maintained in the SAP system or is incorrectly assigned to the customer/vendor account group.
- Incorrect Transaction Entry:
A posting is being made to a customer or vendor account that doesn't have a valid reconciliation account.
Solution
1. Check Customer/Vendor Master Data
- Navigate to the master record of the customer or vendor:
- Customer:
T-code XD03
orFD03
- Vendor:
T-code XK03
orFK03
- Customer:
- Verify the Reconciliation Account field under the company code data (for customers) or accounting data (for vendors).
- Assign the correct reconciliation account, if missing.
2. Update the Master Data
- Use the following transactions to update:
- Customer:
XD02
orFD02
- Vendor:
XK02
orFK02
- Customer:
- Assign the appropriate reconciliation account that matches the GL account structure in the field Recon.account for acct type (e.g., customers: 140000; vendors: 160000).
3. Verify Account Groups
- Reconciliation accounts are assigned based on account groups. Check the configuration:
- Navigate to
SPRO
→ Financial Accounting → Accounts Receivable and Accounts Payable → Master Data → Define Account Groups with Screen Layout (Customers/Vendors).
- Navigate to
- Ensure the reconciliation account field is set as mandatory for relevant account groups.
4. Verify GL Account Settings
- Check the GL accounts used for reconciliation:
- Go to
T-code FS00
. - Ensure the account is configured as a reconciliation account and correctly linked to either Accounts Receivable or Accounts Payable.
- Go to
5. Validate Transaction Entries
- Ensure the transaction posting aligns with the correct customer/vendor master data and GL account structure.
Note:
This error is no longer corrected within the reduced maintenance of T-code MR01. When starting the evaluated receipt settlement report, choose another selection that does not contain the non-billable purchase orders. It is not required to exclude individual purchase orders for the incorrect vendor. With the selection options, it is possible to exclude the incorrect vendor completely from the settlement (using the multiple selection screen).