Topic: Nothing shows in Inventory Item Status
Inventory Item Status does not show any data. I've checked in 2.1 and 2.2 versions and it appears the same issue.
Can you explain something about that?
Thanks,
Re: Nothing shows in Inventory Item Status
Do you have some items received in inventory?
Re: Nothing shows in Inventory Item Status
Of course I have items and existences.
The only way I have is the Stock Check Sheets.
Re: Nothing shows in Inventory Item Status
But what exactly happens? Blank page, or all zero values in status table, or no item in selector?
Janusz
Re: Nothing shows in Inventory Item Status
It's only appears the header of the table, with no data.
Just the headers and then, the Back button.
Re: Nothing shows in Inventory Item Status
Do you have any location defined? Does your location code contain some special char like: ', ", &, < or > ?
Janusz
7 12/09/2009 02:51:37 am (edited by jafu 12/09/2009 04:53:44 am)
Re: Nothing shows in Inventory Item Status
I have one location, the code name is just "DEF".
I was testing on "Reorder Levels" link too, it seems to have the same problem, no data display.
Is it related too?
Re: Nothing shows in Inventory Item Status
And of course not all of your items have Item Type set to 'Service'?
If you have phpmyadmin installed you can make play with the sql query which returns empty result:
Place temporarily line:
display_notification($sql);in function get_loc_details just before return db_query();. This function is placed at the bottom of get_loc_details.inc file.
When sql query s display copy-paste it to phpmyadmin sql query window and try too find what is wrong in your database.
Janusz
Re: Nothing shows in Inventory Item Status
I found the issue.
The table lock_stock was empty. Maybe the records was not copied during a database transfer. I retransfered again and Reorder Levels and Item Status is ok.
Thanks for the test. That was a very good help.