Skip to Content
avatar image
Former Member

CONSUMPTION REPORT SAP B1

dear Experts I need Item wise CONSUMPTION REPORT from  SAP B1

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jan 05, 2015 at 01:28 PM

    Hi,

    Please refer threads:

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

    Thanks & Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • Jan 05, 2015 at 01:15 PM

    Hi,

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

    Regards,

    Manish

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 06, 2015 at 03:42 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 09, 2015 at 06:05 AM

    hi

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

    Add comment
    10|10000 characters needed characters exceeded