Small and medium business | Business Central, N...

Trying to get goods received not invoiced at a point in time

(1) Share

Report

Posted on by OM-05061640-0

Hi all I am trying to get the goods received but not invoiced at a specific date, ie the year end. I have tried a number of solutions online but none have been helpful. I don't have the AP to GL reconcile option when I type it in or the accrued purchases report when i go into the accounts payable.

Would someone be able to give me a solution or a reason as to why these options are not available for me, many thanks for your help

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (9)

Answers (0)

Valentin Castravet 31,340 Super User 2025 Season 2 on at

Like (1)

Report

What about the Inventory to G/L Reconcile report? You should be able to find it using the Tell me search button. This report has a Received not Invoiced column.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
OM-05061640-0 10 on at

Like (0)

Report

Thanks for your reply, when ever I use this function it shows a screen and then select the date and show matrix, not to run a report as such. my company doesn't really use the inventory function and it is finding the goods received relating to purchase orders, in order to do an end year accrual. Would you have any other suggestions?

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,340 Super User 2025 Season 2 on at

Like (1)

Report

I believe you are opening the Inventory - G/L Reconciliation, and not the Inventory to G/L Reconcile. That's why you are seeing the matrix. Please open the Inventory to G/L Reconcile.

Can you show a screenshot of what you see when you search? In addition, you should be able to see the Reconcile AP to GL report as well, as far as I know its available in all localizations of BC

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
OM-05061640-0 10 on at

Like (0)

Report

Thanks for your help, this is what I see when I search for both. Is it possible that the environment administrator has disabled these reports?

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,200 Super User 2025 Season 2 on at

Like (1)

Report

it is possible, you could take a look at your user card and if any of your permission sets are customized instead of out of box ones.

then ask your IT to allow you to access it

Jun Wang

Was this reply helpful? Yes No
Suggested answer

Yi Yong 2,555 Super User 2025 Season 2 on at

Like (0)

Report

Hello,

Unless your environment is created under region: US, you cannot find this report.

If you are using W1, consider using the 'Inventory Valuation' report and enable the 'Include Expected Cost' option.

The 'Expected Cost Included' row under the 'Increases' column is the goods received but not invoiced items.

Was this reply helpful? Yes No
OM-05061640-0 10 on at

Like (0)

Report

Hi Yi, thanks for getting back to me. The environment is in the UK so that might explain it. I have tried the solution that you suggested however it says that it cant produce because it is empty. Would you have any other suggestions?

Was this reply helpful? Yes No
Suggested answer

Yi Yong 2,555 Super User 2025 Season 2 on at

Like (0)

Report

Hello,

It means that there is no inventory movement during the period.

I will suggest you have an understanding of the report first by creating a new purchase order and post a receipt without invoice to look at the result.

Was this reply helpful? Yes No
Suggested answer

D365 Business Centr... 56 on at

Like (0)

Report

Hi,
You can also check out not-invoiced receipts from item ledger entries with easy filters if you have enabled estimated cost posting.
Take a filter as follows:.
1. Entry Type: Purchase
2. Document Type: Purchase Receipt and
3. The cost amount (expended) is not equal to zero.

I hope this helps.
Thanks!

Was this reply helpful? Yes No