How to find unposted invoices

[Former Member]

Dear All,

Can any one guide me further in finding unposted invoices, my scenario is for every saving of invoice automatically the accounting document also generated by the system with integration with FICO, now they are some of the invoices and credit notes which are not posted into FICO, so please tell me a t.code or way to find out those invoices.

Thanks in advance

Regards

Karunakaran

[Lakshmipathi · Accepted solution]

If you execute VF05 or VF05N, you can see the posting status against each billing documents.

thanks

G. Lakshmipathi

[Former Member]

Hi,

There are two options.

1.Goto VF05/VF05N T.Code.

Execute.

Check the posting status for each document which is against the document number.

2.Goto FBL5n T.Code.

Enter your customer number.

Company code.

Select "open items".

Also select "Normal Items",special G/L transactions,Noted,parked and vendor items.

Execute.

Reagrds,

Krishna.

[Former Member]

Use t code

VFX3

to identify the unposted invoices for Accounting

Regards

Kishore

[Former Member]

Hi Karunakaran,

Try below Transactions.

1) VFX3 - List Blocked Billing Documents

You can execute this with either of "Payer", "Created By", "Created On", "SD Document (Billing Document)", "Billing Type". In the same you can mark the relevant Incompleteness as well.

Once execute, highlight the relevant billing document line & press "Release to Accounting" button (Green Flag)

Once released, you can see the issue log from "Notes" button (Blue Color)

2) VF05N - List of Billing Documents

You can execute this for multiple Payers, etc.

Execute this with marking "Open Billing Documents" tick box. "Posting Status" column will display the reason why it's blocked.

Reasons:

BLANK - Error in Accounting lnterface

A - Billing document blocked for forwarding to FI

B - Posting document not created (account determ.error)

C - Posting document has been created

D - Billing document is not relevant for accounting

E - Billing Document Canceled

F - Posting document not created (pricing error)

G - Posting document not created (export data missing)

H - Posted via invoice list

I - Posted via invoice list (account determination error)

K - Accounting document not created (no authorization)

L - Billing doc. blocked for transfer to manager (only IS-OIL)

M - Analyst Approval refused (only IS-OIL)

N - No posting document due to fund management (only IS-PS)

3) VF05 - List of Billing Documents

Can execute for only single "Payer"

Best regards,

Anupa

[Former Member]

Hi,

Goto the Table VBRK and give the Posting status which is not equal to C and check the BELNR field which is the Accounting document number which lists the Billing documents.

Here you will get the Billing documents which were not released to Accounting.

[Former Member]

Hi,

Try T.code : VFX3. Pending invoice not released to accounting.

Regards,

R.Janakiraman