Invoice report question

[Former Member]

Is there a standard report that will show me the following details:

1) Original invoice number

2) Cancelled invoice number

3) New invoice number

As an example, if we invoice a customer for $100, but then realize it was suppose to be $50, we cancel the invoice and generate a new one for $50. I would like to see a report that shows all the 3 invoice numbers.

If not standard, how can I create one in SQVI?

Thanks!

[Former Member]

I have a client asking the same question for the same report.   I have tried a query but I think it requires ABAP help to find the new invoice.

[od_manikandan]

Hi Mr O K,

For your requirement, if report to be given to users then it can be done by ABAP easily.

Few details on SQVI,

In this SQVI query builder, u can connect two tables and

system list the table fields for Selection (for main screen) and display (in the report).

Like if u want to check a list of

Sales order - Delivery order - Invoice

Then by joining all the table a report can be generated,

In case, if data gets repeated then try from

Invoice item - Inv Header - Delivery header - sales order.

And u can give a T CODE for sqvi program.

Now for you requirement in SQVI, U can try

VBRP - LIKP - VBRK.

Regards,

Mani

[Former Member]

Hi,

Try in VF05  or table level  Get the invoice from VBRk by specifying relevant billing types

Raneesh

[Former Member]

Hi O K,

Assuming that your question is not yet answered,

Just before  I answer your question to understand the requirement:

First Invoice : 1000001- value 50

2nd Invoice : 10000002-cancelled

3rd invoice : 10000003-value 70

If it is so...

Please check report VF05N you will get the Original Invoice No, Cancelled Invoiced No, and New Invoice No.

It is a standard report. Please find the screen shot of the same.

Regards,

Deb

[Former Member]

Anyone with an ideas to the original question posted?

also, some help on sap queries? basic tutorial maybe?

[Lakshmipathi]

As already suggested, type SQ01 tutorial in Google and execute.  You will find lot of documentation on Info set.

G. Lakshmipathi

[former_member184701]

as far as i know  - no

you would build a sap query (or ask abaper) based on table VBFA - quick and easy

regards,

[Former Member]

could you help with building the sap query with SQVI? Thanks!

[former_member184701]

SQVI is not the best ...

please use SQ01, SQ02

regards,

[Former Member]

Where can i learn about creating queries? I've never actually created one myself.

[former_member184701]

dear, search SCN - there are many useful threads

the best idea if you request abaper - to build such query will take max 15 minutes

good luck

[rahul_vishwakarma2]

Hi Omar,     Try this then,VF24 for Invoice List along with invoice type. Regards, Kundan Vishwakarma

[Former Member]

that doesn't help either, sorry.

i need a report that shows the original invoice number, subsequent column should be the canceled invoice number for the original invoice and lastly it should have the new invoice number created from the cancelled invoice or original invoice. for example, if i went through each of the 3 steps for a particular invoice, it'll show me the details in order in the document flow. i would like to see this in a report.

Thanks!

[rahul_vishwakarma2]

Hi Omar,     Please try T-Code: SDM0 and type Invoice in Text in Search Field, and you will get all the related t-Code for the same. If it is Helpful...<text removed> Begging for rewards/points not allowed  ...

Regards, Kundan vishwakarma

Message was edited by: Jyoti Prakash

[Former Member]

No, that does not help at all, sorry.