Search options (Page 206 of 247)

In the file includes/db/connect_db.inc inside the said function db_fetch_assoc ($result) precede the line:

return mysql_fetch_assoc($result);

with

if (is_bool($result) === true && $result === false) return false;

You can either use the PDFCreator or such PDF driver to print from the screen to PDF or modify the appropriate reporting/repXXX.php file to do your bidding.

Also check the db user privileges for the database tables.
Modifying the sql backup and restoring it could have also done the trick.

Sorry you had to wait so long for your solution. It's nice that you have shared your solution despite the delayed response from the FA Forum users who are generally quite quick to assist. Welcome to the FA fraternity.

Such a modified report to be Inventory Item Reorder Level List is a candidate for the FA core.

How it affects the audit trail and other tables need to be verified.

Wiki-ed it.

The exchange rates table is where you would need to manually put in such data but how would that be useful since you will not be entering any transactions for that period?

It will need the db user to have trigger and some other privileges as well I think.

Best is to make a single non-normalised table of all the transactions in an excel sheet like manner from the old program and then in FA use a subset of the data for the textcart extension and import them in!
If the excel sheet is standardized and and FA Import extension is made for it, that would be great!

Any chance of hacking it into the core?

Is this a candidate for fixing the script that writes the installed_extensions.php file everywhere?

Please do not add any fields to existing tables. Make a new table and have a 1:1 relationship with the table you intended to extend and then create an extension to do your extra work.