• alvin
  • Senior Member
  • Offline
  • From: USA, Guatemala, Honduras
  • Registered: 05/20/2008
  • Posts: 301

Topic: Inactive Items in reports

How can I get inactive items not to show in price lists, and stock check sheets?

"The roots of education are bitter, but the fruit is sweet."  - Aristotle.
  • Registered: 12/25/2007
  • Posts: 2,448

Re: Inactive Items in reports

You have to append something like 'AND NOT".TB_PREF."stock_master.inactive' in where clause of the query used in repxxx.php file. I'm not sure, but probably this should be considered as a bug and changed in FA sources as well.
Janusz

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Inactive Items in reports

In the Price List Report the inactive items are removed.
In other Item related reports the inactive Items are stamped (Inactive) after the description.

CVS Main updated. Affected files: /reporting/...rep104.php, rep301.php to rep305.php.

/Joe

  • alvin
  • Senior Member
  • Offline
  • From: USA, Guatemala, Honduras
  • Registered: 05/20/2008
  • Posts: 301

Re: Inactive Items in reports

Thanks for the updates,  however I think stock check should have a check box for show Inactive or not...

"The roots of education are bitter, but the fruit is sweet."  - Aristotle.
  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Inactive Items in reports

I am not sure about that. You may accidently inactivate an item, and you will never see that there should be shipped a couple of more items, right?

/Joe

  • From: UAE, Dubai
  • Registered: 03/29/2010
  • Posts: 23

Re: Inactive Items in reports

I have MySQL version 5.0.90-community /  Apache version 2.2.15  &   PHP version 5.2.13

But when I click on any reports I am not getting the Button to generate the report.

Please help!