Based on SAP documentation: http://help.sap.com/saphelp_crm60/helpdata/en/46/27dcd449fc14dce10000000a155369/content.htm , thus you can use this to process down payments on the basis of document conditions in sales orders.
Down payments based on document conditions are a common form of down payment when buying and selling high-quality products, for example in hardware stores, furniture stores, or for wholesale technical equipment. The down payment is due as soon as the order is made, that is when the sales order is created. The down payment values are stored as conditions in the sales order either in header level or item level.
You can use this type of down payment for delivery-related and order-based billing.
Here I already tested the usage when it is used for billing delivery-related based.
Enhancing Pricing Procedure with Condition Type: AZWA, AZWB, AZDI
The following condition types are supplied in the standard system:
- AZWA for debit down payments. By copying the AZWA you can create a percentage debit down payment condition. AZWA has the calculation type B (fixed amount) and condition type initial. It is configured as a group condition and can be entered for the header or item.
- AZWB for billing. AZWB has the calculation type G (formula) and the condition type E (down payment demand/settlement).
- AZDI for rounding differentials balance. AZDI has the calculation type B (fixed amount), the condition class A (surcharges or discounts), condition type L (generally new when copying) and cannot be edited manually. It is an item condition.
1. Configure Pricing Procedure for condition type: AZWA, AZWB, AZDI.
Routines that is used here is routine 49 and 48:
a. Formulas Condition Value: 49 (Cond. Down Payments)
b. Formulas Condition Base Value: 48 (Cond. Down Payments)
(t-code: VOFM > Formulas > Condition base value)
Make sure that all routines are activated first, then they can affect in your sales document.
2. Condition type AZWA
3. Condition type AZWB.
4. Condition type AZDI.
Setting in Financial Accounting
1. Configure reconciliation account (transaction OBXR)
You must assign the field status area G031 for the G/L accounts Down Payments Received and Down Payments Requested chosen by you.
2. Set Accounting Configuration (transaction OBXB)
You must configure the posting key for the down payments (process ANZ in the standard system) and the output tax billing (process MVA in the standard system).
Aside from this you must perform an account assignment for the tax account.
3. Configure posting key (transaction OB41)
You must set Sales Order as optional entry for the posting key 19.
4. Set field status area (transaction OB14)
You must set Sales Order as optional entry for field status variant 0001, field status group G031.
5. Assign field status variants to company code (transaction OBC5)
Business Process Flow
A customer order 3 materials to you each $ 123,000.00. Since the price of the product is high, thus your customer should paid some amount of debt as down payment. Let say that customer deal to pay $ 50,000.00 as down payment. Thus, you record the customer down payment as condition in sales order item. Then the process is continued to delivery and billing. Since delivery is made partially, thus the down payment amount that affect in billing document is divided proportionally based on quantity in delivery order.
1.1. Create Sales Order (t-code: VA01)
Enter the values of the standard fields that must be filled when creating a sales order.
Change your sales order to enter the customer down payment in condition type AZWA for sales order item 10. Enter $ 50,000.00 as this amount is deal with customer for the payment through down payment.
1.3. Posting Customer Debit Down Payment (t-code: F-29)
The amount that deal with customer is $ 50,000.00. The payment of this customer down payment is record in FI transaction through transaction F-29. Ask your FI consultant how to input transaction down payment using this t-code.
Don’t forget to record the sales order and item number in field provided (in case your down payment is affect in item level).
After simulate, the journal that will create is like screenshot below. Then post your posting.
Accounting document created.
Record in report FBL5N (Customer Line Item Display).
1.4. Create Delivery Order (t-code: VL01N)
Based on scenario, delivery is send partially. Here I only post 1 PC of material to be goods issued.
1.5. Create Billing (t-code: VF01)
The value of condition type AZWB, is calculated from the amount of debit down payment that is posted from transaction F-29. The basis for distribution for the second or third milestone bill is not the debit down payment, but instead the difference between the debit down payment and the cleared down payments in existing billing documents for the item. Similarly, the value to be distributed is no longer the total of the payments received in financial planning but is rather the difference between the total of the payments received and the billing postings for these payments.
The value of AZWB is calculated based on this formula:
The value of condition type AZWB can be processed manually, however you cannot exceed the maximum allocation value. An error message will be thrown if the amount you entered is exceed the maximum allocation value.
Journal in accounting document.
This documentation only provide basic explanation about how to use Down Payment (DP) based on document condition. Later, if you want to modify based on user’s requirement such as block and approval, enhancement in routine and user exit should be made.