FrontAccounting forum — Nothing shows in Inventory Item Status

Re: Nothing shows in Inventory Item Status

null@example.com (jafu) — Wed, 09 Dec 2009 18:35:49 +0000

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.

Re: Nothing shows in Inventory Item Status

null@example.com (itronics) — Wed, 09 Dec 2009 13:25:02 +0000

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

null@example.com (jafu) — Wed, 09 Dec 2009 02:51:37 +0000

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

null@example.com (itronics) — Tue, 08 Dec 2009 15:15:37 +0000

Do you have any location defined? Does your location code contain some special char like: ', ", &, < or > ?
Janusz

Re: Nothing shows in Inventory Item Status

null@example.com (jafu) — Tue, 08 Dec 2009 14:19:20 +0000

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

null@example.com (itronics) — Tue, 08 Dec 2009 11:19:12 +0000

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

null@example.com (jafu) — Tue, 08 Dec 2009 00:33:29 +0000

Of course I have items and existences.
The only way I have is the Stock Check Sheets.

Re: Nothing shows in Inventory Item Status

null@example.com (itronics) — Mon, 07 Dec 2009 23:31:35 +0000

Do you have some items received in inventory?

Nothing shows in Inventory Item Status

null@example.com (jafu) — Mon, 07 Dec 2009 23:14:38 +0000

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,