How do I produce a 'Goods Received Not Yet Invoiced' report?

(0) Share

Report

Posted on by bigweed

510

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 Yet' please?

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Community Member on at

Like (0)

Report

Hi, there are many built in PO reports in AX you can run to accomplish this. A good one is AP > Reports > Transactions > Purchase Order > Purchase header. You can run the report with this criteria to get received but not invoiced over a certain date range.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

the solution to this seems to be very simple, and suitable too.

I beleive using the delivery reciept pro forma, may possibily help you in this. because this is pro forma it doesn't post anything so you don't have to reverse it at month end. and if this complies perfect to what you have been asking means a comfortable life adopting this technique.

hope the answer helped you...

warm regards,

Was this reply helpful? Yes No
bigweed 510 on at

Like (0)

Report

Thanks for the answers buys, but neither works!

Bob - This would have worked great but we also have part delivered purchase orders. The status for these remains at 'Open Order' until they are fully delivered, so using the above settings would not pick up these as Goods Received Not Invoiced.

Waqar - We have to post at delivery stage, as we are recording committed / accrued costs.

I have been trying out different reports but cannot see how to pick up fully delivered and not invoiced Purchase Orders, AND also part-delivered and not invoiced Purchase Orders.

Was this reply helpful? Yes No
bigweed 510 on at

Like (0)

Report

Just to give some further information, our situation is as follows:

1 - We may have part-delivered order lines

2 - We may have full-delivered order lines

1 - We may fully invoice part-delivered order lines

2 - We may part invoice part-delivered order lines

3 - We may fully invoice full-delivered order lines

4 - We may part invoice full-delivered order lines

So I am looking for a report which is as broad as possible when picking up transactions. I need it to find all lines which have been part or full delivered, but not yet fully invoiced. Is there a report which can do that?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

If you have a developer or AX partner you can ask them to write a SQL query for you that pulls from table: purchLine.

It should be a very simple query to write. Would just need to add some filters to look at both open orders and delivered orders with dlv remainder > 0 and received amount > 0.

That would cover the partial delivery.

Was this reply helpful? Yes No
Brian Vittrup on at

Like (0)

Report

A simple way to obtain the list over what you would have as output, is the following

Under accounts payable/reports/transactions/purchase order - Select the report showing purchase lines.

In the query add the field invoice remaining, and make the criteria >0

This will return all the lines where you have received some quantities, but not received the invoice, independent of whether it is full or partial delivery.

Regards

Brian

Was this reply helpful? Yes No
bigweed 510 on at

Like (0)

Report

We have been looking at going about this a different way here, and have decided to not use Delivery Notes at all now. So all that we have are open and closed Purchase Orders. Presumably there is a report which I will be able to print, of all open Purchase Orders, and this will reconcile with the Goods Ordered Not Invoiced GL account?

Was this reply helpful? Yes No
Anisha 375 on at

Like (0)

Report

Hi Bigweed,

The suggestion posted by Brian will work. You need to look at the lines and not the headers especially if you have partly delievered orders.

Regards,

Anisha

Was this reply helpful? Yes No
gg2 10 on at

Like (0)

Report

See menu path: Procurement and sourcing > Reports > Status > Accrued purchases

Was this reply helpful? Yes No
Weaveriski 23,618 Moderator on at

Like (0)

Report

The report mentioned by GG2 is a GRNI report, but it has a US key so only available when the US regional setting is turned on. There are some blogs showing how to "easily" alter this and get it into your localization.

This is the blog blogs.msdn.com/.../do-you-need-the-accrued-purchases-report-in-a-uk-localization-in-dynamics-ax-2012.aspx

However as the thread is nearly 4 years old if they do not have a solution by now they probably will not be that worried!

Was this reply helpful? Yes No