[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 3 years, 10 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 3 years, 10 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?

[RRowley]

Before pursuing a change, have you used the new invoice form as it comes with SI? The default templates show what you ask for with the exception of the description being on the line below the “Quantity”, etc. You just have to select the “Show Details” button.

This form avoids overflow when you have multiple tax ids, or a long description.

If the issue is that you want to access the screen with detail boxes display by default, I think that is more easily accomplished than rewriting the screens. Although the text box for the description would still follow on the line after the item details.

First try and work with what you get by default. If this causes you headaches, let me know and I’ll see what can be done.

[RRowley]

Zip your old files from the custom directory and attach them to a response to this message. I’ll look to see what you have.

• This reply was modified 3 years, 10 months ago by RRowley.

[Author]

Posts