Settlement Downpayment with Installment payment Term

Scenario :- Problem with Down payment settlement using installment payment term. 

1.  When we create Sales order, (sales item value = 100) use payment term : 
     0009 (Installment Payment term, 30%, 40%, 30%). In the Billing Plan, I specify 2 records, 1st record is 
     Downpayment  request 30% of Order value, billing type is FAZ . the 2nd record is Final invoice 100%, billing 
     type is F2.

2. Create Billing type Down payment request , it will document as Noted item in the accounting document.

3. Receive Downpayment from customer via FI screen , at this stage the asccounting document is created as following
      Dr. Cash/Bank 30
         Cr. Advance from customer 30

4. When I create Billing document for the sales item, the down payment value will be proposed for settlement at Billing 
    Creation, I then accept the default value of down payment clearing.  The accounting document is as below
     Dr. AR 30  (*split AR by installment payment term)
           AR 40
           AR 30
         Cr. Sales 100
      Dr.  Advance from customer 30
         Cr. AR 9  (DP. 30% * 30)
         Cr  AR 12  (DP. 30% * 40)
         Cr  AR 9  (DP. 30% * 30)

It seems SAP settlement Down payment by Installment Payment term.  I was wondering that is there are alternative or an option  to setup the Down payment settlement independent of Installment term. I meant, I don't want to have the last 3 Credit item as above, I want only 1 line item of credit,  the accounting should be
     Dr. AR 30  (*split AR by installment payment term)
           AR 40
           AR 30
         Cr. Sales 100
     Dr.  Advance from customer 30
         Cr. AR 30 (Not separate by Installment payment term)

Solutions : Suggesstions on how I could proceed?

Your problem with Down payment settlement is common. Many users object to the down payment or security lodgement mechanism. In our case we often park and apply the advance manually to final invoice.

However, following the above case we sometimes use this with our PS orders:

1. Create Sales order, (sales item value = 100) with billing plan with three steps 30% down payment,30% std billiing on 
    order completion and 70% on delivery. A little different to your original Billing Plan, but 1st record is Downpayment 
    request 30% of Order value, billing type is FAZ . the 2nd & 3rd records are std F2 invoices 30% ,70%.

2. Create Billing type Down payment request , it will document as Noted item in the accounting document.

3. Receive Downpayment from customer via FI screen , at this stage the accounting document is created as following :-
    Dr. Cash/Bank 30
       Cr. Security deposit payment 30 ( In many countries this may be subject to TAX laws)

4. Create the First Billing documents , the down payment value will be proposed for settlement at Billing Creation, then 
    accept the default value of down payment clearing as these equal each other.  The accounting document is as below
    Dr. AR 30
        Cr. Sales 30
    Dr.  Advance from customer 30
        Cr. AR 30

5. Create the Second Billing document ( down payment value has expired and will not be proposed) The accounting 
    document is as below is then standard for the last installement.
     Dr. AR 60
        Cr. Sales 60

This alternative provides a cleaner option with the Downpayment.

Why the Default First Date isn't Today?
Default First Date is not Today

SAP Sales and Distribution Books
SAP SD Books - Certification, Interview Questions and Configuration

SAP Sales and Distribution Tips
SAP SD - Sales/Distribution Tips

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG. 
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk. 
 The content on this site may not be reproduced or redistributed without the express written permission of 
www.erpgreat.com or the content authors.