[RRowley]

Yes, that is what the extensions directory is for. It’s been awhile since I’ve created an extension. Basically your folder name is the name of the extension and you create files in directory paths within it that are used instead of the standard file. For class files in the Inc/Claz folder, there is a trick to only add the class code that is specific for your need so you don’t have to copy the entire class and thereby put general maintenance of all the class code on you. Otherwise, you might miss some needed changes that future updates provide.

Maybe if you can explain what you want to do, I can see what it takes to set it up.

[RRowley]

You would have to create an extension with logic to do this.

Currently users with a biller role are restricted to accessing things that are related to that biller. So the biller record and the invoices for that biller. Products are universal, not related to any biller, so they can only be modified by and administrator.

[RRowley]

Provide screen shots of your si_system_defaults and si_preferences tables.

[RRowley]

Glad that worked for you. Sounds like an upgrade issue that you were able to resolve. From this point forward, you can maintain this information via the Inv Prefs screen.

[RRowley]

Use the Search box.

[RRowley]

So you are saying the on the new invoice screen that no matter what you select in the Invoice Preference field, the invoice shows Quote in the preference column? Please get a screen shot of the si_invoices database table showing the setting in the preference_id field, and a screen shot of the content of the si_preferences table.

[RRowley]

The processing time is likely the time to transfer the data from the server. Data for all invoices is transferred in a minimized json file in the public/data.json file. The client (your browser) is set to display data after rendering the 15 rows on the first screen (this is the deferRender option in the Datatables module). Bottom line, the current logic is as efficient as per my understanding, as it can be.

If you have additional thoughts, please let me know.

[RRowley]

The error is objecting to the Currency code that you have set in the si_preferences file. You can look in the database si_preferences table and near the end of each record, see what you have in the currency_code field. They should all be alpha values and each 3-characters long. This link, IBAN Currency Codes shows the list of valid codes for each country. Make sure all the currency_code values in the si_preferences table have valid alpha codes from this table.

[RRowley]

What version of php are you on. 7.4 has better performance than older versions.

[RRowley]

The error you are getting is:

[14-Apr-2021 14:02:04 Europe/Paris] SqlPatchManager::runSqlPatch() - PdoDb - query(): Execute error. See error_log.
[16-Apr-2021 17:05:34 Europe/Paris] PdoDb - debugger(): ALTER TABLE <code>si_invoices</code>
                        ADD UNIQUE INDEX <code>UniqDIB</code> (<code>index_id</code>, <code>preference_id</code>, <code>biller_id</code>, <code>domain_id</code>),
                        ADD INDEX <code>IdxDI</code> (<code>index_id</code>, <code>preference_id</code>, <code>domain_id</code>);
[16-Apr-2021 17:05:34 Europe/Paris] PdoDb - query(): Execute error.Array
(
    [0] => 42000
    [1] => 1067
    [2] => Invalid default value for 'date'
)

If you look at the si_invoices structure, you should see that the date column is set to NULL = NO and Default of 0000-00-00 00:00:00. You need to make sure that zero dates are allowed in your database. Do this by commenting out the “sql_mode=” in the my.ini file.

For reference, make the current setting for this value into a comment by adding a # at the front of the line. An example of what this line might be set to is, sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION.

After you make this change, restart your mysql server and access SI again.

• This reply was modified 4 years, 5 months ago by RRowley.

[RRowley]

Check the content of your si_index table. There is probably only one record in it but could be more. Make sure each record contains a numeric 0 in the sub_node_2 column. It is probably blank but should be 0.

[RRowley]

Not sure what you mean by the “second” feature request. If you mean to have it all displayed on one line with description first, I’m less inclined to do that as it impacts the space available for people the have multiple taxes. The line currently handles up to three taxes per item. Also, I don’t see the benefit of such a change given the complexity of template changes to maintain it.

[RRowley]

I just upload the change to add an option to the system defaults table that allows you to enter the invoice new and edit screens with the item descriptions open. Give it a try and let me know how this works out. Note that this is a master_2020 level change.

• This reply was modified 4 years, 5 months ago by RRowley.

[RRowley]

If you have no problem with the description being displayed where it is now, I can look at implementing a SI Defaults option to have it showing on new invoices rather than hidden. This will be a master_2020 feature though.

[RRowley]

For SI master_2019.2, you need to be on PHP 7.2 at a minimum. PHP 7.4 preferably and 7.4 required for SI master_2020. Any reason you can’t do this?

[Author]

Posts