Customer downpayments

[Former Member]

Hello all,

We use customer down payment process where our down payments are booked with transaction code F-28(incoming payment) instead of F-29 and also we use F-32(customer clearing) for clearing the down payment against the customer invoice. This clearing books with document type SU. Now if we want to track down the customer down payments by just using the document type in our custom reports, it is becoming difficult because SU document type is used for other business transactions too. We know that SAP standard customer down payment process includes F-39 for clearing the down payments which books with document type DA.

F-28(customer down payment):  Cr. Customer (19A)
                                                                     Dr. Bank clearing (40)  

F-32(Customer down payment clearing):  Dr.  Customer (Customer advances Recon.) 09A
                                                                                  Cr. Customer (Customer AR Recon.) 17

What is the best way of booking/clearing customer down payments and tracking them?

All your valuable suggestions are most appreciated. Thanks!

[sreeharli_tokala]

Hi Thirsha Reddy,

I think this DOC might be helps you.

1. 15.2. Assign Advance from Customers Account

Path: SPRO- Financial Accounting- Accounts Receivable and Accounts Payable- Business Transactions- Down Payment Received- Define Reconciliation Accounts for Customer Down Payments (Tcode: OBXR)

Execute

Double click on

D          A          Dwn pmt         Down payment

Chart of Accounts                           :

Enter

1. Recon.acct                                         : 290300

Special G/L account                        : 190200

Save and enter

1. 16. Scenario 1

Advance From Customer              : 100000

Customer Invoice                            : 100000

1. 16.1. Advance from Customer

Path: Accounting - Financial Accounting - Accounts Receivable - Document Entry -Down Payment - F-29 - Down Payment (Tcode: F-29)

Enter header data (Type DZ)

Account                                             :__________ (Customer number)

Special G/L Ind                                : A

Account                                             : 290100 (Bank A/C)

Amount                                             : 100000

Enter

Amount                                             😘

Save

See Report (Tcode: FBL5N)

1. 16.2. Create Customer Invoice (Tcode:F-22)

Enter Header data (Type DR)

PstKy                                                 : 01

Account                                             :

Enter

Amount                                             : 100000

PstKy                                                 : 50

Account                                             : 300100

Enter

Amount                                             😘

Go to Menu bar

Document - simulate

Save

See Report (Tcode: FBL5N)

1. 16.3. Clear Down payment against Invoice

Path: Accounting - Financial Accounting - Accounts Receivable - Document Entry - Other - F-30 - Transfer with Clearing (Tcode: F-30)

Enter header data (Type DA)

Select Transfer posting with clearing

Click on Choose open items (F6)

Company code                                 :

Account                                             :

Special G/L Ind                                : A

Click on process open items (Shift+F4)

Save

1. 17. Scenario 2

Advance from customer     : 100000

Customer Invoice                : 50000

1. 17.1. Create Advance from customer (Tcode: F-29)
2. 17.2. Customer Invoice (Tcode: F-22)
3. 17.3. Transfer posting

Path: Accounting - Financial Accounting - Accounts Receivable - Document Entry - Down Payment - F-39 - Clearing (Tcode: F-39)

Enter header data (Type DA)

Account                                             :________ (Customer number)

Keep blank Invoice ref. field

Enter

Transfer posting                              : 50000

Go to Menu bar

Document - simulate

Save

1. 17.4. Clear Invoice against Down payment (Tcode: F-30)

Enter header data (Type DA)

Select Transfer posting with clearing

Click on Choose open items (F6)

Company code                                 :

Account                                             :

Click on process open items (Shift+F4)

Save

1. 18. Scenario 3

Advance from customer     : 100000

Customer Invoice                : 150000

1. 18.1. Advance from customer (Tcode: F-29): Rs100000

1. 18.2. Customer Invoice (Tcode: F-22): Rs150000

1. 18.3. Transfer posting (Tcode: F-39): Rs100000

1. 18.4. Reciept of Remaining amount (Tcode: F-28): Rs50000

[Former Member]

Hi Trisha,

In my opinion, customer down payment has document type DZ and Special GL indicator.

You can filter document base on Document type and Special GL indicator.

Besides this, in order to track them, the cleared customer down payment documents will updated clearing document data on Clearing date, Clearing document fields.

You can see these fields in so many reports. By looking these fields, you can know which document clear your customer down payment.

Hope it can help you.

Julie