Search options (Page 31 of 247)

rep302.php is the Inventory Planning Report.

There are only 2 main SQLs in it in the functions:

getTransactions()
getPeriods()

Do some single stepping and check the value of the $sql variable in them and see if the tables need any (non primary key) indexes to speed it up.

Hope you have the following Unique Indexes:

`stock_category`.`description`
`stock_master`.`description`

The former is there in my default install and the latter may need to be inculcated.

How many transactions are you querying and hope your PHP.ini file has adequate memory allocated.

@joe: Adding an Unique Index for `stock_master`.`description` may be in order.

That is what a Quote is - change the language translation file to replace Quote with Proforma Invoice or hard code it everywhere!

You can fix the tax on a per item basis for purchase - Setup => Item Tax Types - after setting up the tax and tax groups. Then apply the Tax Type for the Item desired.

You are free to make an extension specific to your country and sell it to anyone.
You can, however, donate to the FA project - optional, voluntary and much appreciated.
Videos in English already exist on YouTube and at http://spoken-tutorial.org and you can make one in your preferred language.

It is clear that you are using an old version of the import_transactions module. Get the latest from here.

@joe: Please update the official repo with the one from my GitHub repo (attached herein) for this extension.

Alternatively, can keep a JSON field in each such table that needs extra field data and define all such data definitions in a single table.

Yet another alternative: Keep an XML file for extra fields definition in each application - suppliers, items, customers, invoices, etc and keep all such data in a single table with an application name/type field to segregate them.

@joe: does this deserve a reconsideration?

If you do not want a full fledged double entry book keeping system but just want to keep track of AR/AP, then use the likes of SimpleInvoices. FA may be overkill here.

Check your nginx document root and FA webroot if any in your webserver conf file that you may need an alias for depending on the url you used to install FA.

The nginx configuration file is generally at /etc/nginx/nginx.conf.

Commercial integration is okay. Place info in Job Offers board. No free version is necessary at all. A demo site can showcase it. State clearly what resides on your server and what is needed at the client / client's server end. A full disclosure is best practice.

Anyone who wants integration can manage without any extension as well if DB functions, triggers and procedures are used and both FA and the integrating application reside on the same database server (not necessarily the same database) with appropriate credentials.

Keep a separate Item for Printer Ink and for Tape.
Editable description is for small variations in Item description for the specific Invoice.

@joe: should we entirely delete all changed descriptions from being remembered except for the specific Invoice/Order and where none, take the default for the item?