Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Answered

INVENTORY REPORT

Posted on by 45
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. 
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 62,096 Super User on at
    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 Profile Picture
    Valentin Castravet 5,288 Super User on at
    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
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 5,288 Super User on at
    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
     
  • Suggested answer
    tanya07 Profile Picture
    tanya07 1,535 on at
    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 Profile Picture
    Bilal Haider 41 Super User on at
    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.
  • 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.

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,652 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,573 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans