web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / Item Inventory Report ...
Business Central forum

Item Inventory Report for Danmark

(0) ShareShare
ReportReport
Posted on by Community Member

Hi experts,

I was tring to get all the QTY from Item Inventory Report. You could find this report by navigating to Items-More Option -Report-Inventory-Inventory Availability. The Inventory Report for US Version is quite straight forward and I could found where are these QTYs come from. However, the Danmark version is different from US version and I'm not sure how to find the QTY source for the colum. Does anyone have any idean about this Issue? I just want to figure out where to find the QTY for Gross Requirement, Scheduled Receipt, Planned Order Receipt, and Quantity on Back Order for Danmark Version. Thanks in advance.

WeChat-Screenshot_5F00_20190227174206.png

The US Version

WeChat-Screenshot_5F00_20190227174717.png

The Danmark Version

WeChat-Screenshot_5F00_20190227174257.png

Categories:
Other
I have the same question (0)
  • Verified answer
    Alexey Finogenov Profile Picture
    Alexey Finogenov 1,659 on at

    US version of the system uses for menu item (action) “Inventory Availability” local Report 10131 Availability Status
    DK version uses standard W1 (global) Report 705 Inventory Availability for this menu item (action).
    I’ve tried to find good enough help for these report (705).. not fully success ( https://docs.microsoft.com/en-gb/dynamics365/business-central/inventory-how-availability-overview ...), yes the columns captions not so clear, need to check the code (on-prem version) for understood the logic.

  • Community Member Profile Picture
    Community Member on at

    Thank you so much, that's help me a lot. I found it show as below

    ProjAvailBalance :=      Inventory +      ScheduledReceipt -      GrossRequirement +      "Purch. Req. Receipt (Qty.)" -      "Res. Qty. on Req. Line";

    PlannedOrderReceipt :=      "Planned Order Receipt (Qty.)" +      "Purch. Req. Receipt (Qty.)";

    BackOrderQty :=      "Qty. on Purch. Order" + "Scheduled Receipt (Qty.)" + "Planned Order Receipt (Qty.)" +      "Qty. in Transit" + "Trans. Ord. Receipt (Qty.)" +      "Planning Receipt (Qty.)" + "Purch. Req. Receipt (Qty.)";

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans