Physical inventory report

When i select the inventory tab, select physical inventory and choose the option for a manual count, is there anyway i can generate a report after inputting all items that tells me what product i haven't entered. Any help would be appreciated.

why don't you use a report where cost > $0 (if you entered your cost information) and quantity = 0? the 'and' statement in reports lets you drill down quite a bit. also if you use the bin location then you can block off each area of the store and cross reference the "this is in" vs. "this is not"

Justin

Information about physical inventory count is stored in the PhysicalInventoryEntry table.

Doing the following query should tell you what items have not been counted...

select i.itemlookupcode, i.description from item i where i.id not in (select itemid from physicalInventoryEntry)

Danny

why don't you use a report where cost > $0 (if you entered your cost information) and quantity = 0? the 'and' statement in reports lets you drill down quite a bit. also if you use the bin location then you can block off each area of the store and cross reference the "this is in" vs. "this is not"