Setting up Master Records for Customers and Vendors in SAP FICO

In SAP FICO, customer and vendor master records are essential for managing accounts receivable and accounts payable. These records store critical data needed for transactions and reporting. This article provides a step-by-step guide for creating master records for customers and vendors in SAP FICO with examples.

Steps to Set Up Customer Master Records

Step 1: Access Customer Master Record Creation

To create a customer master record, use the following transaction code:

  • Transaction Code: FD01 (Customer Master Creation for Accounting)

Step 2: Enter General Information

Steps:

  • Enter the Company Code and Account Group (e.g., D001 for Domestic Customers).
  • Specify the Customer Number or leave it blank for automatic number assignment.
  • Click "Enter" to proceed.

Example: Create a customer record for ABC Corporation under account group D001.

Step 3: Fill in the General Data

Complete the general information such as:

  • Customer Name: ABC Corporation
  • Address: 123 Main Street
  • Country: USA
  • Language: English

Step 4: Enter Company Code Data

Specify financial details, including:

  • Reconciliation Account: Enter the G/L account for accounts receivable (e.g., 140000).
  • Payment Terms: Define the terms (e.g., Net 30).

Step 5: Enter Sales Area Data (Optional)

If the customer is linked to sales processes, enter the following details:

  • Sales Organization
  • Distribution Channel
  • Division

Once all the data is filled in, save the record.

Steps to Set Up Vendor Master Records

Step 1: Access Vendor Master Record Creation

To create a vendor master record, use the following transaction code:

  • Transaction Code: FK01 (Vendor Master Creation for Accounting)

Step 2: Enter General Information

Steps:

  • Enter the Company Code and Account Group (e.g., K001 for Domestic Vendors).
  • Specify the Vendor Number or leave it blank for automatic number assignment.
  • Click "Enter" to proceed.

Example: Create a vendor record for XYZ Supplies under account group K001.

Step 3: Fill in the General Data

Complete the general information such as:

  • Vendor Name: XYZ Supplies
  • Address: 456 Market Street
  • Country: USA
  • Language: English

Step 4: Enter Company Code Data

Specify financial details, including:

  • Reconciliation Account: Enter the G/L account for accounts payable (e.g., 200000).
  • Payment Terms: Define the terms (e.g., Net 45).

Step 5: Enter Purchasing Data (Optional)

If the vendor is linked to purchasing processes, enter the following details:

  • Purchasing Organization
  • Order Currency
  • Terms of Payment

Once all the data is filled in, save the record.

Example Scenario: Setting up Records for ABC Corporation and XYZ Supplies

Customer: ABC Corporation

  • Account Group: D001
  • Reconciliation Account: 140000
  • Payment Terms: Net 30
  • Saved as customer number: 10001

Vendor: XYZ Supplies

  • Account Group: K001
  • Reconciliation Account: 200000
  • Payment Terms: Net 45
  • Saved as vendor number: 20001

Conclusion

Setting up master records for customers and vendors in SAP FICO ensures accurate financial data and smooth processing of transactions. By following these steps, businesses can maintain comprehensive and structured records, enabling efficient management of accounts receivable and payable.




Advertisement