cancel
Showing results for 
Search instead for 
Did you mean: 

Invoice (VF01)

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Logic to derive Accounting Document Number for Billing Document:

Table Joint: VBRK-XBLNR = BKPF-XBLNR

Accounting Document Number: BKPF-BELNR

Regards,

Rajesh Banka

reward suitable points

Former Member
0 Kudos

All you need to do is run t code VFX3.

This will show all billing docs that have not been passed to accounting.

Not only that it will provide the reason as well in the log.

Please award points if useful.

Former Member
0 Kudos

Hi,

For a Billing document you can get the Accounting document number from Table VBRK (Billing document header data).

Document flow details can be obtained from VBFA.

Thanks

Murali.

Former Member
0 Kudos

Hi there,

Would you so happened to know the fields name for <u>accounting document number</u> in invoice header?

Regards

Former Member
0 Kudos

Hi,

Field name of Accounting document VBRK-BELNR.

Thanks

Murali.