7. Appendix A – Report Options

Home/Advanced Inventory Count/User Guide/7. Appendix A – Report Options

7. Appendix A – Report Options

Created On
Last Updated On
byInsight Works
You are here:

A.1 – Uncounted Items

This report is used to validate count sheets before and after the count.

Option Description
Show Items not on Sheets When set, the report shows any items not on the count sheet, based on any filters set on the Item or Count Sheet Line filter tabs.
Include Only Items in Stock For use with the Show Items not on Sheets option, when set, the report only shows those items
Location Filter For use with the Show Items not on Sheets option, when set, the report only shows those items for the selected location.
Variant Filter For use with the Show Items not on Sheets option, when set, the report only shows those items with the selected variant filter.
Add Items to Count Sheet When a valid count sheet is specified here, all items that were not on count sheets will be added to this specified sheet.
Show Items not Counted When selected, the report displays any items that have not had a value entered for them in the Count Sheet Lines page.
Show Partially Counted Items If not set, the report only shows items that have not been counted on any sheet. Since an item can appear on more than one sheet, it is possible that it was counted on one sheet but not another. It is best to select this option, as all lines for which entry clerks have not made an entry, should be reviewed.
Show Detail When set, the report displays those sheets upon which the item was not counted.

A.2 – Counted Inventory Differences

The Counted Inventory Differences report is used to identify discrepancies between the inventory count and the existing inventory levels based on the Date Filter specified on the Count Sheet Line tab.

Option Description
Show All Inventory When set, the report displays differences for all items, whether normal inventory or differences due to WIP changes.
Show WIP Difference Only When set, the report displays only the current adjustment for WIP based on the count sheets.
Show Item Description When set, an extra line for each item, showing the item description, is included on the report.
Show Details When set, the report includes all count sheet lines that contribute to the total difference. Otherwise, only a total per item is displayed.
Show Zero Differences When set, the report includes items that do not have a count difference
Show Serial No Issues When set, the report displays serial number issues based on the following options: Show Extra Serial Nos – When set, displays serialized items that have not been posted into Navision. Show Uncounted Serial Nos – When set, displays the uncounted serialized items. Show Duplicate Serial Nos – When set, displays items with duplicate serial numbers. Show Only Items with Issues – When set, the report will only display serialized items with issues. It will not include nonserialized items.
Show Lot No. Issues When set, shows any missing or extra lot numbers on the count sheets.
Sort by Amount When set, the report sorts the lines by the highest absolute difference in inventory value to the lowest absolute difference in value.
Sort by Quantity When set, the report sorts the lines by the highest absolute difference in count quantity to the lowest absolute difference in quantity. Quantities are always displayed in the base unit of measure.
Sort by Item No When set, the report sorts the lines by the item number.
Sort by Bin Code When set, the report sorts the lines by bin code.
Sort by Production Order This option is only available when viewing WIP differences. When set, the report sorts by the production order number.

A.3 – Missing Serial No Details

The Missing Serial No Details report is used to provide transactional details for uncounted serialized items. These details can be useful in locating the uncounted items.

Option Description
Show All Inventory When set, the report displays the transactions for the uncounted serialized items in inventory.
Show WIP Difference Only When set, the report displays the transactions for the uncounted serialized WIP items.
No of Transactions to Show Specify the number of transactions the report displays for each uncounted item.
Export to Excel Place a checkmark here to export this report to Excel.
Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Need help?
Tags:

Leave A Comment

Go to Top