Invoice status

[Former Member]

Hi ,

I want to retrieve invoice status like cleared, not cleared, open, completed, canceled.

I have retrieved Cleared status using BSAD table, Not cleared status using BSID table and based on fkart or fksto from VBRK retrieved Canceled status. How to retrieve open and completed status of Invoice ?.

Any body to help.

With Regards,

Gandhi Subramani

[Former Member]

Hi ,

I want to retrieve invoice status like cleared, not cleared, open, completed, canceled.

I have retrieved Cleared status using BSAD table, Not cleared status using BSID table and based on fkart or fksto from VBRK retrieved Canceled status. How to retrieve open and completed status of Invoice ?.

Any body to help.

With Regards,

Gandhi Subramani

[Former Member]

Hi,

Use the VBUK table

THanks

Naren

[Former Member]

Hi ,

Check VBRK-RFBSK for Status for transfer to accounting .

Or Check VBUK- FKSTK / VBUK-FKSAK/ VBUK-BUCHK for header level status and go to VBUP for item level status.

Let me know if you have any questions.

Thanks,

Greetson

[Former Member]

Hi ,

Thanks for the reply.

I have a scenario where in VF03 the sales document flow shows the accounting document is cleared

but when I check in VBUK-BUCHK it is completely processed. But when I checked in BSAD table there is no record with the accounting document number. So please let me know how to check the accounting document is cleared ?.

Thanks.

With Regards,

Gandhi Subramani

[Former Member]

Hi,

In the table BSEG if the fields AUGDT & AUGBL are populated for that accounting document then it is cleared

Thanks

naren

[Former Member]

Hi,

AUGDT & AUGBL in BSEG are blank but document flow shows cleared.

With Regards,

Gandhi Subramani