How to generate 'Goods Received Not Yet Invoiced' Report in AX 2012

Finance and Operations/AX Technical Forum
1

How do I produce a ‘Goods Received Not Yet Invoiced’ report? I post all delivery notes for goods to an account called ‘GRNI’ in the Balance Sheet. When the delivery note is invoiced, the original delivery note posting is reversed. At every month end, I need to reconcile the balance on the GRNI GL account, with a list of all outstanding Delivery Notes. How do I produce this list of 'Goods Received Not Invoiced Report?

2

You could use the inventory value report for reconciliation.

Or

Filter the inventory transactions with Type - Purchase order and Receipt Status - Received.

3

Hi,

Thank you for your reply. But is the existing report Accrued Purchase Reliable to generate, Goods Received but not yet Invoiced?

Thanks

Avani Rao

4

That is a country specific report(available for US and Canada). Yes the report is intended to show the same information.

5

Have a read of this relating to GRNI reporting:

http://blogs.msdn.com/b/axinthefield/archive/2014/01/20/do-you-need-the-accrued-purchases-report-in-a-uk-localization-in-dynamics-ax-2012.aspx

6

Hi Adam,

Thanks for your help. I have checked this link. I think this is something that we were searching for.

Thanks

Avani Rao

7

Hi Kranthi,

I kno wthe post is too old, but I have just come across the same need :slight_smile:

I have two questions regarding the Inv. Transaction solution you mentioned above(to know the Goods received but not invoiced) :

(1) I have got the “receipt status” empty, what does that mean?

(2) Can I use -instead - the field “Financial Cost Amount” if it is empty then this mean the PO is not invoiced (just received)?

Regards,

Ehab Radwan

8

Hi Kranthi,

I know the post is too old, but I have just come across the same need :slight_smile:

I have two questions regarding the Inv. Transaction solution you mentioned above(to know the Goods received but not invoiced) :

(1) I have got the “receipt status” empty, what does that mean?

(2) Can I use -instead - the field “Financial Cost Amount” if it is empty then this mean the PO is not invoiced (just received)?

Regards,

Ehab Radwan

9

Hi Ehab,

2). Receipt status is the field to use

1). If you’ve an Inventory transaction related to a purchase order and the field ‘Receipt status’ is empty, it means it’s not a receipt. Presumably the ‘Issue status’ field has some value?

A Purchase order transaction which is not a receipt must be a negative quantity line (for example, for a return of items to a vendor).

10

Thanks Terry,

The empty status were really to a return Purchase transactions.

Regards,

Ehab