Items on Hand by Date Report (v6.0)

Modified on Wed, 29 Nov 2023 at 11:23 AM




Items on Hand by Date Report



Purpose of this document


This document explains how to use the Items on Hand by Date Report to display the quantity and total weight on hand as of the date specified.


Ceres Object release 6.00.00 is required for the functionality described in this document.





Running the Items on Hand Report


  1. The Items On hand by Date Report can be accessed by selecting “Search” from the Dynamics 365 Business Central Banner and entering “Items On hand by Date” in “Tell me what you want to do” then selecting “Items On hand by Date” from the results in the Go to Reports and Analysis section OR by selecting the “Items On hand by Date” menu action (if present) from your Role Center home page.



  1. The Items On Hand by Date request Page will be displayed where users can set filter criteria based on how they want to run the report. A description of the fields follows:



As of Date: Enter the date you want to run the report as of. Based on this filter, the report will show the As of Date on the report and all quantities and weights will reflect the status of the inventory on that date.


Filter Item Section: The report is based on the Item so any standard filtering field may be selected to refine the items that you would like to include in the evaluation of the report. Standard filter fields are:

  1. No.
  2. Quantity on Hand


Filter Totals by Section: Filters can be added to this section to specify limiting criteria for items. Set a Location Filter to limit the report to a specific location.


Printing or Previewing the Report


  1. The report can be printed or previewed by clicking on the Print or Preview button.



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article