GRN but not invoiced

Kinetic ERP
,
1

Good received but not invoiced report needed.

Dear Consultants ,
I need to bring GRN but not invoiced data with date filter.
Example ,
GRN done at 11 of January
Invoiced the same GRN at 15 the January

If I filter report of 11th then that particular GRN should be fetch to report because it is open
But
When I filter report of 15th then that particular GRN should not be fetch to report because it is invoiced not an open GRN
AND
If I filter for whole month in that case also that GRN should not be fetch to report because it is invoiced on 15 th .

Please help me to derive the data in BAQ.

Best Regards,

2

Start with RcvDtl. It has arrived, received and inspected dates and the InvoiceNum and InvoiceLine to link to APInvDtl and APInvHed to get the invoiced date.

It will probably need to be two queries or subqueries on rcvdtl with parameters that can be used on subqueries.

As I think about this you may be able to just use one received by X date and invoiced by Y date.

3

I checked but , not working …