Skip to Content
author's profile photo Former Member
Former Member

Get data from a particular Delivery document in XL reporter

hi,

i am trying to design a report in which i need to display the data from a specific delivery document in a cell. how do i get this data? please advise.

thanks in advance,

Regards,

Vasu Natari.

Edited by: Marc Riar on Jan 31, 2008 2:36 PM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2008 at 08:22 PM

    In the Advanced Report Builder Window, at the bottom, click on "Parameters", choose New. Give it a name ie DocNum, choose the Literal type, numeric, and click OK.

    In the Transaction Row section, choose Sales AR, Document number = then add the parameter.

    This will ask for the number when the report runs.

    I haven't tested this, let me know if it works for you

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2008 at 02:50 PM

    Hi Vasu,

    Follow these steps in Report Composer

    1. goto Sales- A/R

    2. drag & drop the Sales Docment Type to Selections pane

    or

    Follow these steps in Report Designer

    1. Select a cell and and the goto Advanced Report Builder

    2. In Advanced Report Builder select Sales Document Type and the Press on ... icon

    3. choose ARDelivery from the Dimension Lookup window.

    4. press on Apply Button

    4. select the same cell

    5. press on fx (Formula Builder) in XL Repoter Toolbar

    6. goto Display tab.

    Now u can get information regarding Delivery Document.

    Plz, Let me know is it usefull to u?

    Thanks,

    Suresh Yerra

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2008 at 03:15 PM

    Hello

    can i know which function module you wanted to use in the report development?.

    There are several Function modules to be called to import the data to XL Sheet

    Regards

    Sunku

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.