Skip to Content
avatar image
Former Member

Invoice

Dear Expert,

Understand sometime invoice / billing is created (VF01) but it can't auto post to FI due to certain error messages. I have a report which wish to only display invoice that has accouting document (has posting to FI).

Any ideas which table/fields that i may use to check if accouting document has been created after invoice / billing is saved (VF01).

Regards.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jul 18, 2007 at 03:40 PM

    <b>VBRK & VBRP</b> ( Invoice SD ) // <b>BKPF & BSEG</b> for invoice in FI .

    <i>with VBRK-VBELN = BKPF-XBLNR</i>

    Hope this helps,

    Erwan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Erwan,

      Can i use VBRK-VBELN = BKPF-XBLNR to check if accouting document been created for <u>cancel invoice</u>?

      Regards.

  • avatar image
    Former Member
    Jul 18, 2007 at 03:49 PM

    In VBRK you have a field RFBSK - Posting Status. If the value is 'C' then the accounting document has been created.

    Regards

    Nadarajah Pratheb

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      In your example, VBRK would have 2 records (Invoice-F2 and Cancellation of Invoice-S1). The entry with F2 would not have 'C' whereas S1 would have 'C'.

      Regards

      Nadarajah Pratheb