[wildman]

Is there a way to generate a report showing Inventory Edit, amount and price? When I go to Inventory manager I can see QUANTITY HISTORY, ACTION TYPE and that shows Inventory update, sales voids, and Inventory edit, I just don't know how to do it as a report instead of going through thousands of Inventory Items.

[RetailEdge Moderator]

I am not sure that even the inventory manager gives you all that. What is it that you are trying to accomplish. We do track every inventory quantity change in RetailEdge and this is what we are showing in this inventory view, but to do this in a report would end up being potentially a very large report.

You might want to try looking at the Turn or Sell through reports. These reports will show historical sales, receiving on order and "other adjustments" for items.

Let us know more and maybe we can steer you in the right direction if these don't work.

Is there a way to generate a report showing Inventory Edit, amount and price? When I go to Inventory manager I can see QUANTITY HISTORY, ACTION TYPE and that shows Inventory update, sales voids, and Inventory edit, I just don't know how to do it as a report instead of going through thousands of Inventory Items.

[wildman]

Just wanting to see a report that shows what inventory items were manually edited. When a defective item is returned, we manually adjust the inventory, some times the item is not returnable to supplier for credit, Trying to figure out how much was manually removed from inventory, I know from my quickbooks how much I received credit for.

[RetailEdge Moderator]

Not to try and change your way of doing things, but typically we recommend that you do your adjustments through negative receiving so that you can better track this.

For instance, many people create returns to vendor POs with a preface of RTV. That way you can quickly run a report on returns to vendors. If something is removed for other reasons (say shrinkage), then you can create a shrinkage PO that you can continually add to and then at the end of the year have a total of items lost to shrinkage. To make sure that these items are not negatively received against the real vendor totals, you can create a vendor for yourself that would be associated with the PO so that the items as added to this PO and negatively received would show that they went the "store" vendor.

There really is no manual adjustment report other than the ones mentioned before. But you should be able to quickly scan these items and see these types of adjustments.

Just wanting to see a report that shows what inventory items were manually edited. When a defective item is returned, we manually adjust the inventory, some times the item is not returnable to supplier for credit, Trying to figure out how much was manually removed from inventory, I know from my quickbooks how much I received credit for.