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
ItemCode = A0001 ItemDesc = Test Item
AcctCode AcctName DocNum Quantity
10000000 Accounting 111 5
10000000 Accounting 112 5
10000000 Accounting 113 5
10000001 Engineering 114 3
10000001 Engineering 115 3
10000002 IT 116 4
10000002 IT 117 1
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.