Question

Can you Create a Count Report to include Empty bin locations?

  • 16 February 2023
  • 2 replies
  • 175 views

Userlevel 2
Badge +3

Hi,

When we create a count report in IFS, it seems to only create count reports for a bin location within whatever parameters that we define where inventory exists.  Is it possible to create a count report to include ALL bin locations within specific parameters to also include the empty bin locations?  If not, has anyone come up with a viable solution to also be counting empty bin locations to ensure that physically something isn’t in them, but not in the system?

 

Thanks,

Curtis Carpenter


2 replies

Badge

Sure, here's an example of a Count Report that includes empty bin locations: Flying Together

Count Report

Date: [Insert Date]

Location: [Insert Location]

Bin Number    Product Code    Description    Quantity
001    PROD001    Product A    10
002    PROD002    Product B    5
003            0
004    PROD003    Product C    20
005            0
Note: Empty bin locations are included in the report and marked with a quantity of 0. This allows for better tracking of inventory levels and ensures that all bin locations are accounted for, even if they are currently empty.

Badge +1

Yes, you can create a count report to include empty bin locations. Depending on the inventory management system you're using, the specific steps for creating the report may vary, but the general process is as follows:

  1. Identify the data source for your count report. This could be a database or spreadsheet that contains the inventory data you want to include in the report.

  2. Define the parameters for your report. This could include the date range for the report, the location(s) you want to include, and any filters or sorting criteria you want to apply.

  3. Define the fields to include in the report. This could include the item number, item description, location, bin, and quantity fields.

  4. Configure the report to include empty bin locations. Depending on your inventory management system, this may require configuring the report to show zero quantity values for empty bins or including a separate section of the report that lists empty bins.

  5. Generate the report and review the results. Depending on the format of the report, you may be able to export the results to a spreadsheet or other format for further analysis.

It's worth noting that including empty bin locations in your count report can be helpful for identifying potential inventory discrepancies and ensuring that all items are accurately tracked and accounted for. However, it's important to verify that the empty bins are actually empty and not just missing from the count before making any adjustments to the inventory.

Reply