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

Pending Good Receipt Po

Hi friends

i want your help regarding this matter. in our (SAP B1 system ) company we want a report of pending document (Goods Receipt Po,Goods Return) report

which is indicate as a balance in Goods in Transist accounts. that mean balance of GIT account should equal to pending Good Receipt Po Values. how can i get this report

( this can not do with document find level, because open Goods Receipt Po value not equal to GIT account balance)

thank you

saman

Edited by: saman_wm on Dec 9, 2011 3:16 PM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2011 at 02:24 PM

    Try this,

    SELECT T0.[DocNum], T0.[DocStatus], T1.[ItemCode], T1.[Dscription], T1.[Quantity], (T1.[OpenQty] * T1.[Price]) as 'PO B/O' FROM OPOR T0 INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry WHERE T1.[LineStatus] ='o'

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2011 at 02:22 PM

    Hi Saman,

    Is GIT in your posting Goods In Transit ?

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2011 at 06:57 PM

    Try:

    SELECT T0.refdate,

    Case when T0.TransType = 30 then 'Journal Entry'

    when T0.TransType = 18 then 'AP Invoice'

    when T0.TransType = 19 then 'AP CR Memo'

    when T0.TransType = 20 then 'GRPO'

    when T0.TransType = 21 then 'Goods return'

    End as 'Trans Type',

    T0.BaseRef as 'Doc No',

    T0.transid as 'Trans ID',

    t1.contraact as 'Offset Acct',

    (T1.debit -T1.credit) as 'C/D(LC)'

    from ojdt T0

    inner join jdt1 T1 on T0.TransId = T1.TransId

    where T0.refdate >= [%0\] AND T0.refdate <= [%1\]

    and t1.contraact like '21041%'

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Try this for GRPO:

      SELECT T0.refdate,

      Case when T0.TransType = 30 then 'Journal Entry'

      when T0.TransType = 18 then 'AP Invoice'

      when T0.TransType = 19 then 'AP CR Memo'

      when T0.TransType = 20 then 'GRPO'

      when T0.TransType = 21 then 'Goods return'

      End as 'Trans Type',

      T0.BaseRef as 'Doc No',

      T0.transid as 'Trans ID',

      t2.AcctName as 'Offset Acct',

      t3.Itemcode,

      t3.quantity,

      t3.lineTotal,

      (T1.debit -T1.credit) as 'C/D(LC)'

      from ojdt T0

      inner join jdt1 T1 on T0.TransId = T1.TransId

      inner join OACT T2 on T2.AcctCode=t1.contraact

      LEFT JOIN PDN1 T3 ON T3.DocEntry = Cast(T1.Ref1 AS Integer)

      where T0.refdate >= [%0\] AND T0.refdate <= [%1\]

      and t1.contraact like '21041%'

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2011 at 11:59 AM

    Hi Saman.......

    Are you keeping any track for Goods in Transit till the supplier gets that material back to his warehouse?

    I don't think you have mentioned here that you are keeping any track for GIT based on Goods return......

    Please specify.....

    Regards,

    Rahul

    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.