Sales report: Profit center wise includes net, gross and sales tax URGENT

[narasimhulu_konnipati]

Helllo Friends,

Please help me on the below report

Client requirement is: Sales report which includes the below

1. Profit center

2. Net sales

3. Sales tax

4. Gross sales

5. Period

Please help me

Thanks for your help in advance

Narasim

[narasimhulu_konnipati]

answered

[od_manikandan]

Hai Narasim,

As Mr Lakshmi said use VBRK and VBRP table in

T CODE : SQVI

Create a report

Joing tables

VBRP and VBRK

and select the list of selection screen amd fields to be listed inside the report.

and execute

show it to client once satisfied, create a T CODE for the report using

T CODE: se93 and assign to the users.

Regards,

Mani

[Former Member]

Hi,

You will have to get a Z report developed for this requirement, it will be a Sales Register looking at the requirement

Firstly discuss with the client and finalize the selection screen , based on which parameters the client wants nto check this report

1. Customer

2. Billinng Document

3. Sales Area

4. Billing Type

5, Period

And based on this system can collect all the billing documents (except cancelled) and pick up the required values from the billing document tables.

Finalize if the client would also like to see the all the discounts, freights, rebate (if any) , taxes (separetly) , exchange rates (exports) and any other condition types, this will save all the modifications in the future.

Also finalize what all billing types have to be excluded, like cancelled, credit notes, debit notes etc and also how the values have to be displayed, rounded off.

[Lakshmipathi]

Consider tables VBRK and VBRP.

G. Lakshmipathi