Skip to Content

Customer Down Payment in SD

Good afternoon.

I am trying to build customers down payment in SD, but I can't get it to work.

I tell you how far I've come:

I have set up a billing plan with rule 04 (partial percentage advance)

I have assigned the billing plan to the order and position.

I have configured the CME D accounts as proposed by SAP in its documentation.

The material has item type group 0005 which determines the item type TAO.

I have set up copy control with the FAZ invoice in the way that SAP explains.

Problem encountered:

The billing plan is generated correctly in the order, but when I invoice, the invoice is generated with net 0, therefore there is no invoice in FI.

Analyzing the conditions, I see that the AZWR condition does have an amount, BUT SAP PUTS IT AS A STATISTIC !!!, therefore, its amount does not pass it to the invoice, and this remains with amount 0.

Please, can you help me?


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    Posted on Jul 04, 2020 at 03:34 PM

    I hope you use the same pricing procedure in the sales order and in the billing documents.

    Any custom routines, code in pricing exits that may be causing this?

    I noticed that you use a custom billing plan type - did you try with billing plan type 01 as well?

    Your billing plan does not seem correct - you have entered just two down payments (rule 4) and there is no closing invoice (billing rule 3).

    Start with a simple example like this one:

    Bill one date at a time and check the outcome after each posting.

    Once you get this working - try other examples like:

    Just in case, I am adding the settings from my system (you did not share how you have configured yours and we cannot know if it is set up correctly or how it is set up):

    If you still cannot find the root cause for the conditions being set as statistical (after verifying and correcting all other settings related to billing plan and down payments) - you can try to debug the pricing by using the guide from here: Pricing Programs and their logic – Help for debugging.

    01.jpg (19.4 kB)
    02.jpg (20.5 kB)
    03.jpg (30.9 kB)
    04.jpg (32.7 kB)
    05.jpg (16.9 kB)
    06.jpg (68.4 kB)
    07.jpg (69.9 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 04, 2020 at 01:21 PM

    Billing Plan

    Billing Plan in Sales Order

    1º payment : 300 €

    Conditions in Sales Order

    Create Billing Document VF01 ( Bill FAZ )

    As we can see, the conditions have an amount, but SAP makes them static, therefore, the net is 0 Cannot be billed in FI

    Best Regards.

    bill-plan.jpg (27.8 kB)
    condition.jpg (148.1 kB)
    bill-faz.jpg (82.7 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 10, 2020 at 10:54 AM

    Good Morning Veselina.

    Thank you very much for your excellent explanation. You were right, I made two mistakes:

    • My billing plan was wrong, I had not included the closing invoice
    • I put different pricing procedure in the order and the invoice.

    Once these errors were corrected, the FAZ invoice was correctly generating the net price, and therefore, you could now save the FI invoice.

    Later, the main problem was getting the advance payment to a CME account, but in the end I did it (my fundamental problem is that I am alone, there is no FI consultant, so all the FI customization I had to do).

    I think everything is correct, I only have two small doubts:

    1. My billing plan was like this:

    The billing plan does not allow me to associate two DCat, I can only associate 1.

    Is this correct?

    2. These are the generated invoices

    FAZ ( Down Payment )

    Now we will see the note in detail:

    The account has been successfully derived to the CME 437001 account. The VAT of 48 euros is also generated

    Is this correct?

    F2 ( Closing invoice)

    Should the income be 700 instead of 1000 ?, Because there has been a Down Payment of 300.

    Is this correct ?

    Thanks and best regards !!

    bplan.jpg (31.9 kB)
    faz1.jpg (32.3 kB)
    faz2.jpg (37.7 kB)
    f2.jpg (89.8 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 10, 2020 at 12:15 PM

    Javier López

    Did you post the actual down payment with F-29?

    From FAZ you post a noted item (special G/L indicator F), then you post the payment from the customer with special G/L indicator A.

    Maybe you did, but I do not see it in the screenshots, so, please check this in your system (FBL5N can help you with this).

    Your F2 invoice (assuming that you do not want to have multiple partial F2 invoices) should have 2 items - one is with the description of the material item, the second one has description down payment settlement.

    It looks like this:

    In the generated posting to accounting you should have something similar to mine (I already posted down payment in FI):

    Are you using billing plan type 01 which, I think, is delivered in standard? If not, maybe you can compare the settings that you made for your billing plan type to 01. To be able to select different date categories, you have to allocate them to your billing plan type in customizing (the settings are in the Billing plan node for SD).

    It is strange that you cannot have other date categories than 01, as you can see from my previous screenshots, I have different date categories. Yes, you assign a default date category to your billing plan, and for 01 billing plan type the default is 01, but this does not mean that you cannot use the other date categories which you have assigned to it, so, please check the settings for your billing plan type.

    Check also what date proposals you have assigned to the billing plan type in node Maintain Date Proposals For Billing Plan Types.

    Here is an example:

    It makes entering dates a lot easier.

    I do not know what documentation you use when you configure and test the process, but this blog helped me a lot when I first tried to test it: How to understand the FI postings made in SD down payment scenario?. I think that it will be useful for you, too.

    And thank you for providing feedback on your progress, this is becoming very rare in the past few years. :)

    Meh, I had to post this as an answer instead of a comment because of this ridiculous limitation of 2 screenshots in a comment :(

    01.jpg (18.4 kB)
    02.jpg (21.4 kB)
    03.jpg (44.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 20, 2020 at 10:13 AM
    Good morning Veselina
    Unfortunately I haven't made any progress in 1 week
    This is what I do:
    1. I believe order
    2. Advance invoice (FAZ invoice) with VF04 300 €
    3. Collection advance with F-29
    2. Invoice closing invoice (invoice F2) with VF04 1000 - 300 = 700 €

    The closing invoice does not take into account the advance, it is wrong:

    The Order, FAZ invoice, and F2 invoice have the same pricing procedure.

    The copy control between order and invoice F2 for item TAO has copy control 21 (I have also tried 20 and 23, without result)

    Analyzing the pricing procedure of the F2 invoice, I see something strange, the AZWR condition is not determined:

    What am I doing wrong?

    Thanks and best regards !!

    azwr.jpg (74.8 kB)
    f2.jpg (78.2 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.