topic Re: Invoice status in Application Development and Automation Discussions

Invoice status

Former Member — Thu, 27 Mar 2008 21:17:40 GMT

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

Re: Invoice status

Former Member — Thu, 27 Mar 2008 21:33:29 GMT

Hi,

Use the VBUK table

THanks

Naren

Re: Invoice status

Former Member — Thu, 27 Mar 2008 21:34:19 GMT

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

Re: Invoice status

Former Member — Mon, 31 Mar 2008 22:21:40 GMT

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

Re: Invoice status

Former Member — Mon, 31 Mar 2008 23:46:08 GMT

Hi,

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

Thanks

naren

Re: Invoice status

Former Member — Tue, 01 Apr 2008 00:15:24 GMT

Hi,

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

With Regards,

Gandhi Subramani