Inventory export reports no inventory to export, when inventory exists

[ghost]

ScreenShots Supporting Issue:

1. Inventory Levels
   
2. Export Attempt (the response to it)
   

OB Version:

© 2013 OpenBoxes | Application Version: 0.6.0.5 | Build Number: v0.5.6-349-g7d67720 | Environment: development | Build Date: 21 Dec 2013 10:17:50 AM Grails Version: 1.3.7 | Locale: English French Spanish | Debug Mode: off | IP Address: 0:0:0:0:0:0:0:1%0 | Data load: 0.3s | Page load: 0.728s

Stacktrace:

2013-12-21 13:12:22,766 [http-8080-3] INFO inventory.InventoryService - searchTerms = null
2013-12-21 13:12:22,766 [http-8080-3] INFO inventory.InventoryService - command.tag = null
2013-12-21 13:12:22,849 [http-8080-3] INFO inventory.InventoryService - * Get all categories: 83 ms
2013-12-21 13:12:22,886 [http-8080-3] INFO inventory.InventoryService - * Query for products: 37 ms
2013-12-21 13:12:22,886 [http-8080-3] INFO inventory.InventoryService - * Get unique IDs: 0 ms
2013-12-21 13:12:22,886 [http-8080-3] INFO inventory.InventoryService - Max 10
2013-12-21 13:12:22,886 [http-8080-3] INFO inventory.InventoryService - Offset 0
2013-12-21 13:12:22,919 [http-8080-3] INFO inventory.InventoryService - * Re-query for products by ID: 33 ms
2013-12-21 13:12:22,919 [http-8080-3] INFO inventory.InventoryService - * Get products by terms and categories: 70 ms
2013-12-21 13:12:22,923 [http-8080-3] INFO inventory.InventoryService - * After removing all hidden products: 3 ms
2013-12-21 13:12:22,923 [http-8080-3] INFO inventory.InventoryService - * Sort products 0 ms
2013-12-21 13:12:22,923 [http-8080-3] INFO inventory.InventoryService - * Get quantity on hand map 0 ms
2013-12-21 13:12:22,923 [http-8080-3] INFO inventory.InventoryService - * Get outgoing map 0 ms
2013-12-21 13:12:22,924 [http-8080-3] INFO inventory.InventoryService - * Get incoming map: 0 ms
2013-12-21 13:12:22,928 [http-8080-3] INFO inventory.InventoryService - * process product : 1 ms
2013-12-21 13:12:22,928 [http-8080-3] INFO inventory.InventoryService - * process on hand quantity: 1 ms
2013-12-21 13:12:22,928 [http-8080-3] INFO inventory.InventoryService - * Get category to product map: 0 ms
2013-12-21 13:12:22,928 [http-8080-3] INFO inventory.InventoryService - Total time - Get current inventory: 162 ms
SQLQueryImpl(select tag.id, count(*)
from product_tag join tag on tag.id = product_tag.tag_id
where tag.is_active = true
group by tag.tag order by tag.tag)
2013-12-21 13:12:24,979 [http-8080-2] INFO filters.SecurityFilters - Request duration for (inventory/browse): 1519ms/2961ms
2013-12-21 13:12:24,980 [http-8080-3] INFO filters.SecurityFilters - Request duration for (inventory/browse): 317ms/1973ms
2013-12-21 13:12:25,133 [http-8080-3] INFO web.Timer - Cached request for /openboxes/grails/dashboard/megamenu.dispatch took 0:00:00.003
2013-12-21 13:12:25,195 [http-8080-2] INFO web.Timer - Cached request for /openboxes/grails/dashboard/megamenu.dispatch took 0:00:00.008
2013-12-21 13:12:25,761 [http-8080-3] INFO inventory.InventoryService - quantity on hand for location Boston Headquarters product 18 Inch Black Screw Driver
2013-12-21 13:12:25,833 [http-8080-3] INFO inventory.InventoryService - * getQuantityByProductAndInventoryItemMap(): 8 ms
2013-12-21 13:12:25,839 [http-8080-3] INFO inventory.InventoryService - getQuantityByProductMap(): 15 ms
2013-12-21 13:12:25,868 [http-8080-4] INFO filters.SecurityFilters - Request duration for (json/getQuantityToReceive): 210ms/2ms
2013-12-21 13:12:25,875 [http-8080-3] INFO filters.SecurityFilters - Request duration for (json/getQuantityOnHand): 259ms/1ms
2013-12-21 13:12:25,991 [http-8080-2] INFO filters.SecurityFilters - Request duration for (json/getQuantityToShip): 287ms/2ms
2013-12-21 13:12:51,696 [http-8080-5] INFO filters.SecurityFilters - Request duration for (inventoryLevel/export): 292ms/1ms

[jmiranda]

Sorry, confusing error message. This is actually probably true. An inventory level is associated with a product at a given location. It is used to set the min, max, reorder levels, assign bin location, etc. In this case the error message is stating that there are no inventory level associated with any products in stock. I'll improve the error message, but the code is working correctly.

[ghost]

Understood, I should have paid closer attention to the wording.