2 downpayment lines on Final Invoice

[Former Member]

Hello - I am trying to generate a final invoice for a sales order with a milestone billing plan.  When I invoice, it shows 2 downpayment settlement lines which cancel each other out.  The invoice also will not post to acctg and states "Downpayment is already cleared and cannot be applied".  I have never seen this before and not sure how to resolve.   Thanks!

[former_member131691]

Hi Carol

This error message F5 847 Down Payment XXXXXXX was already cleared and cannot be used in offsetting, is raised here: 

LFACIF68 FORM BSID_GET
...
* begin of note 507816
  IF NOT SY-SUBRC IS INITIAL.
    SELECT   * FROM  BSEG INTO BSEG
           WHERE  BUKRS       = XACCDPC-BUKRS
           AND    BELNR       = XACCDPC-BELNR
           AND    GJAHR       = XACCDPC-GJAHR
           AND    BUZEI       = XACCDPC-BUZEI.
      IF NOT BSEG-AUGBL IS INITIAL.
        MESSAGE E847 WITH XACCDPC-BUKRS XACCDPC-BELNR XACCDPC-GJAHR.
      ENDIF.

If the BSEG-AUGBL field is filled you will find that the FI document
has already been cleared in another FI transaction (maybe FB1D)

The downpayment proess with SD will only work when executed exactly as
outlined in note 213852.

In VF01 the system calls function SD_DOWNPAYMENT_READ and looks for down payments
posted in FI for the reference document using the VBEL2 and POSN2 fields of the reference document in the key. If there are 2 down payment clearing items proposed then you will find that
2 down payments have been posted against this reference order and item.

I hope this helps you further
Kind regards
Brian

[Former Member]

Hi Brian,

I've been facing the exact same issue that carol is/was facing.

The note: 507816 that you had mentioned was showing as "cannot be implemented" in our system.

Is there another note/workaround for this?

Thanks in advance.

GCP

[Former Member]

Hi GCP

As a workaround we made the duplicate downpayment item $0 on the invoice.  This was the only way we could get it to post.

Hope this helps!

[former_member216544]

Hi Carol,

We had faced the same issues recently.

This could be SAP issue ,regarding down payment.

Below are the analysis/finding which we arrived with the help of FI Consultant.

Analysis

When down payment request is created with T.Code : VF01 (Referring Sale order number)

System generated 2 down payment requests (by mistake) instead of one, in our case.

A) One down payment request, generated while creating inT.Code:VF01, which is updated in     the document flow.

B) Duplicate down payment request ,generated by the system,and not reflecting in

    document flow.

But both the documents were displayed in T.Code : FBL5N (Customer Line item display) as an open item with Special G/L indicator -A

IN OUR CASE,the user by mistake had cleared both the down payment request.

1) One generated through T.Code:VF01

2) System generated one without any record.

This we identified with the Clearing document against each down payment request, with the help of FI Consultant.

So while doing final invoice in VF01,system will call function

SD_DOWNPAYMENT_READ and look for down payments posted in FI.

Since 2  dwn.pymt document was cleared,while doing final invoice system displayed

2 down payment record (one original + duplicate).

THIS COULD BE THE CASE.....

Solution

Since the down payment is already cleared,system will not allow to reverse the down payment request.

Hence

A)  Reverse the Down payment FI Clearing document with T. Code: FBRA

      So that status of the accounting document of Down payment request, in the document flow

      of sales order will become OPEN.

B) Then cancel the down payment request, with T.Code : VF11

C) Try creating a new Down payment request in VF01, after clearing the newly created     

     accounting document for Down payment request.

D) Try Creating Final Invoice.

Hopefully it should solve your problem.

Kindly rewards points if the solution works for  you.

Regards

Jeeva

[arnabsarkar2601]

HI ,

For better resolution pls provide us the screen shot of that invoice where ur line items are canceling and also give us the error msg screen shot.

Regards,

Arnab

[Former Member]

Hi Arnab

Here is the screen shot & error.  

The Accounting Document has not yet been created

Down Payment XXXXXXX was already cleared and cannot be used in offsetting

Thanks for your input!