Skip to Content

Goods Received Not Invoiced

Hi all

Is there any way to retrieve backdated Goods Receipt PO not Invoiced?

Example

how to include those Open Goods Receipt PO as at 31 Dec 2014
even if they are Closed in 2014?

Kedalene Chong

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Jul 14, 2014 at 09:10 AM

    Hi,

    Have you checked my latest query?

    Thanks & Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 10, 2014 at 08:00 AM

    Hi,

    Are you looking for this information?

    SELECT T0.[DocNum], T0.[DocStatus],T0.[DocDate], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity] FROM OPDN T0 INNER JOIN PDN1 T1 ON T0.DocEntry = T1.DocEntry WHERE (T0.[DocStatus] = 'O' OR T0.[DocManClsd] = 'Y' ) and T0.[DocDate] >= [%1] and year(T0.[DocDate]) = 2014

    Thanks & Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 10, 2014 at 08:57 PM

    Hi Kedalene,

    If GRPO is closed without creating related invoice, you just need to check if the GRPO has invoice as target or not.

    Try:

    SELECT T0.[DocNum], T0.[DocStatus],T0.[DocDate], T0.[CardName], SUM(T1.LineTotal) 'GRNI'

    FROM OPDN T0 INNER JOIN PDN1 T1 ON T0.DocEntry = T1.DocEntry WHERE T1.TargetType = -1

    GROUP BY T0.[DocNum], T0.[DocStatus],T0.[DocDate], T0.[CardName]

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 10, 2014 at 08:54 AM

    Hi

    Are you try the General Ledger report with date condition.

    With Regards

    Balaji

    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.