CONSUMPTION REPORT SAP B1

[Former Member]

dear Experts I need Item wise CONSUMPTION REPORT from  SAP B1

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please refer threads:

If attached threads does not meet your requirement, please explain your requirement.

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

please look into the below query.please suggest select distinct(ItemCode),SUM(OutQty),Comments  from OINM where  ItemCode in ('Item code' ) and TransType in ('13','15','60') and DocDate>='20140901' group by ItemCode,Comments union all select distinct(ItemCode),-SUM(OutQty),Comments  from OINM where  ItemCode in ( 'Item code') and TransType in ('14','16') and DocDate>='20140901' group by ItemCode,Comments

[former_member716356]

Hello, I am looking for a query for Stock consumption report which provides consumption month by month to highlight high and low Qty turnover per stock code. I would like to generate it for a specific date range. Would it be possible to include

Item Group Item Code January February March April etc.....

Thank you,

Louisa

[former_member188586]

hi

if you get the Solution please close the Thread...

[former_member188586]

Hi Rajeesh

Please check bellow Query and UP Date the Status

SELECT T2.[AcctCode], T2.[AcctName],

(select  (sum(b.[debit])-sum(b.[credit])) from dbo.ojdt a inner join dbo.jdt1 b on a.TransId = b.TransId inner join dbo.oact c

on b.account = c.acctcode

where b.project = [%0] and b.account = T1.Account) as Balances

FROM dbo.OJDT T0  INNER JOIN dbo.JDT1 T1 ON T0.TransId = T1.TransId INNER JOIN dbo.OACT T2 ON

T1.Account = T2.AcctCode

WHERE  T1.[Project] =[%0] and (T1.[Account] like '700%' or T1.[Account]='123456' or T1.[Account]='789101')

GROUP BY T2.[AcctCode], T2.[AcctName], T1.account

Note: T1.[Account]==(HERE REPLACE YOU MATERIAL LEDGERS THEN TRY )

AND IF YOU WANT WISE (AFTER GETTING ABOVE QUERY OUTPUT THEN WITH GL WISE REPORT AS PER OUR SAP GENERAL LEGDER REPORT BY DEFAULT)

Thanks&Regards

AndakondaRamudu

[former_member184146]

Hi,

     Use the Inventory posting report  To open this window, choose   Inventory >>  Inventory Reports>> Inventory Posting List by Item.

Regards,

Manish