Skip to Content

Report Problem, please help

hello everyone,

our company buy/purchase materials but we do not sell the items that we have bought, we use it in the company internally. the new items that was bought is stock in the Warehouse, and it will be withdrawn by each department that will use the item. we use the Goods Issue function of SBO so that we can charge the value of the item against the withdrawing party. now this is what i want to happened in my report

EX.

ItemCode = A0001 ItemDesc = Test Item

AcctCode AcctName DocNum Quantity

10000000 Accounting 111 5

10000000 Accounting 112 5

10000000 Accounting 113 5

15

10000001 Engineering 114 3

10000001 Engineering 115 3

6

10000002 IT 116 4

10000002 IT 117 1

5

Grand Total 26

I did some query but i cannot achieve my desired report look like and specially the details of the report. anyway this is my query

SELECT T0.DocNum, T0.DocDate, T2.FormatCode,T2.AcctName, T1.ItemCode, T1.Dscription, T1.Quantity FROM OIGE T0 INNER JOIN IGE1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OACT T2 ON T1.AcctCode = T2.AcctCode WHERE T1.ItemCode = '[%0]' AND T0.DocDate >= '[%1]' AND T0.DocDate <= '[%2]' ORDER BY T2.FormatCode

i saved this query, and tried if i can achieve my desire report in query print layout, adding Sort and Sub total is not possible coz it is disabled in query print layout. im really having a hard time on how to achieve this report..

please, if u have idea on how i can achieve this report, share your ideas and expertise.

thanks in advance.

FIDEL

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 21, 2008 at 06:26 AM

    Hi Avelino Fidel,

    Try this one by using XL Reporter. XL Reporter ia an add-on from SAP. It's free. Spend some time to know how it work then it will be very easy to create any type of report.

    Good Luck.

    Thanks,

    Suresh Yerra.

    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.