Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Aug 17, 2011 at 03:10 PM

    Consider tables VBRK and VBRP.

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 17, 2011 at 06:39 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 18, 2011 at 06:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 15, 2011 at 07:40 AM

    answered

    Add comment
    10|10000 characters needed characters exceeded