INVENTORY REPORT

(1) Share

Report

Posted on by DynamicsBC

Hi,

I'm trying to generate a report for inventory Like each Location & warehouse without Physical Inventory Journal. Is there any standard report in which I can see Items availabillity by location. Items on Purchase & sales Orders.

Categories:

Business Central

All responses (6)

Answers (1)

Verified answer

YUN ZHU 73,472 Super User 2024 Season 2 on at

Like (1)

Report

INVENTORY REPORT

If it is only at the location level, it is recommended to use the following function, which is the fastest.

Hope this helps.

Thanks.

ZHU
Suggested answer

Valentin Castravet 24,785 Super User 2024 Season 2 on at

Like (1)

Report

INVENTORY REPORT

You can also use in the Item List/Card Page the Items by Location and Item Availability By Pages.

The Item Availability by Location has several fields such as Gross Requirement and Schedule/Planned Receipt to show the item on Sales/Purchase Orders

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

Valentin Castravet 24,785 Super User 2024 Season 2 on at

Like (1)

Report

INVENTORY REPORT

You can also use in the Item List/Card Page the Items by Location and Item Availability By Pages.

The Item Availability by Location has several fields such as Gross Requirement and Schedule/Planned Receipt to show the item on Sales/Purchase Orders

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

tanya07 1,554 on at

Like (1)

Report

INVENTORY REPORT

Hello ,

Please look into Inventory Valuation Report , if this can help you with your requirement. You can also narrow your report output with the Location.

Regards,

TK
Suggested answer

Bilal Haider 45 on at

Like (1)

Report

INVENTORY REPORT

Hi,

There are reports like Inventory availability and Inventory list that fulfill some of your requirement, but unfortunately there are no reports out of the box that fulfill these requirements.
Mustafa Omerbegović 1,079 on at

Like (2)

Report

INVENTORY REPORT

Hello,

You can use the Inventory Valuation report that will surely give you the correct inventory quantities and values, but you will need to use Filter totals by location if you want to filter values by locations. You can see increases and decreases in the period from start to end date, quantities on Start and End Date.

For quantities on purchase/sales documents, I would recommend the next solutions.

If you want to see information for one item, then go to the Item Card and in the Inventory tab, you will see quantities listed by orders.

If you want data for all items on all purchase or sales documents then I would recommend that you open the Sales Order card, select a line on the sales order, and then click Ctrl+Shift+F1 (page inspection) and then View table. Depending on your permissions or BC version you could do this, which will open you a table of all sales document lines. The procedure is same for purchase documents.

You will see which document type is that row, and all other information from lines of sales documents. Export to excel and enjoy. :D

You can try also Inventory Availability or Inventory Reorder, depending on your needs, but I will also recommend you to check the quantity for one item for all reports because sometimes filters for locations or dates can't do their job on Item ledger entries.

If you have any other questions related to this answer fell free to ask,

Greetings.