Hi all;
When trying to run Inventory Valuation, whenever I try to get the valuation for a single Category I get
Quote:INFORMATION Message : There were no items with any value to print out for the location specified
However when I run for many categories I get the expected output. I am sure that when a single Category is selected there is stock and avalue so something should come out. In fact, capturing $SQL from (line 75)
Code:
$InventoryResult = DB_query($SQL,$db,'','',false,true);
and then executing it in MySQL WorkBench returns relevant lines. However
Code:
DB_num_rows($InventoryResult)
returns a 0 (zero).
Any advice or suggestions welcome.
Regards
I.