Invoice report by document value

[Former Member]

Hi Gurus,

I need your assistance in producing a report. Basically we need to get a report showing how much invoices we have entered on a Sales Org with a value below £250.00 for the last 3 months (Oct, Nov & Dec). Can you please advise how I should proceed?

Many Thanks

Kumar

[Lakshmipathi]

Dear Kumar

Go to VF05 or VF05N and execute the report. There you can see a tab Net Value. Sort it in ascending order so that the report will be sorted based on the least value of the billing document to maximum value of billing document.

If you want to specifically have an option to key in maximum or minimum document value, then you need to go to SE16, key in table VBRP and consider the field NETWR for net value of the billing document.

thanks

G. Lakshmipathi

[Former Member]

Hi

for this you need to develop a report with the help of ABAPer, for document value less than £250.00, you need to search the table VBRK for the fields of net value + tax amount and currency, for the period you need to select document date

generate a functional spec and send to ABAPer for developement

Regards

srini

[Former Member]

Thank You Srini,

How about creating a report using SQ01 using the table VBRK and the document value field?

Regds

Kumar

[Former Member]

Hi Friends,

There is a standard report available with the TCode MIR5. Choose the field Gross Invoice Amount.

Thank You for your kind help.

Best Regards

Kumar