[fearless359]

For some reason, this text box didn’t like my long instructions. So I put them in the attached file. Download the attached zip file, and read the FixInstructsions.txt file in it.

Attachments:

1. bidy_facturier_db_fix.zip

[fearless359]

It works if your set up is correct. You need to have an Inv Prefs record set up and enabled with a description set to the invoice type (aka Quote) that you want to set up. I’ve attached images to show set up and help info.

The inv_number_starting_point shows the setup instructions in the How To… section on the left.
The inv_pregs (should be inv_prefs) the invoice preference set up I have on my test system.
The inv_pref_quote_edit shows the edit screen for the Quote type preference I have set up on my test system.
The inv_pref_numbering_group shows the help information on the Invoice numbering group field of the Inv Prefs record.
The inv_edit shows the edit screen for an invoice of type Quote on my test system. Note the drop down and how it shows the enabled Inv Prefs to select from.

By far the most complex part of the set up is if you want quotes (or other invoice types) numbered in a different sequence than the standard Invoice types. The set up for this is manual and uses the si_index table in the database.

Attachments:

1. 

   inv_number_starting_point_help.jpg
   

2. 

   inv_pref_numbering_group_help.jpg
   

3. 

   inv_pref_quote_edit.jpg
   

4. 

   inv_edit.jpg
   

5. 

   inv_pregs.jpg
   

[fearless359]

Please provide a screen shot of this. I can’t seem to recreate it.

[fearless359]

In the si_system_defaults table, what is the value of the record with name “payment_type”?

Is there a record in the si_payment_types table with a “pt_id” value equal to the “value” of the record in the si_system_defaults table?

[fearless359]

I don’t have a PHP v7.1 environment to test master_2019.1 in. My recommendation is that you upgrade to PHP v7.2x or later and then use master_2019.2. I test this and it handles the multiple emails with semi-colon seperator just fine.

[fearless359]

Extract the Email.php file from the attached zip archive into the Inc/Claz directory replacing the version you currently have. See if this helps.

Attachments:

1. Email.zip

[fearless359]

How are you entering two emails. I just tried it for the “Email To” line and it worked fine. Entry form is first email address, a semi-colon, second email address. Example:

foo@foo.com;bar@bar.com

[fearless359]

No. You can put it in a zip file and submit it here. I’ll check it out at that point.

[fearless359]

I’ve made changes to a couple of files that I would like you to test and report on their performance. They are in the attached zip file. Extract the manage.tpl file into the templates/default/invoices directory, and the Invoice.php file in the Inc/Claz directory. The changes in these files affect the display of invoices on the primary screen. They remove the formatting of the Date column and move the formatting of the Total and Owing columns to the display script. Please give them a try and let me know what if any performance changes you see.

• This reply was modified 4 years, 6 months ago by fearless359.

Attachments:

1. inv_test.zip

[fearless359]

I just performed a fresh install of the simpleinvoices 2013 beta 8 version and then performed an update to the current version of fearless359 master_2019.2 version.

The only issue I ran into is that an error was thrown for an invalid default value for the ‘date’ field. The ‘date’ field is an existing field and defaults to, 0000-00-00 00:00:00. The fix was to change the sql_mode setting in the my.ini file and restarting the mysql service to implement the change. After this, the update process ran without incident.

I updated the Requirements documentation on the left menu to explain how to make this change.

While zero dates are generally frowned upon (hence the default to disallow them), they are ingrained in SI and so for now it makes sense to allow them.

[fearless359]

Ok, I believe you must be overriding the default template. This means your template is in the custom/default_template directory. If this is the case, you can move the files out of this directory (saving them). You will then be using the standard SI default template. Test that. Then you can move your files back to the custom/default_template directory and start fixing them to work how you want.

Let me know what your find.

• This reply was modified 4 years, 9 months ago by fearless359.
• This reply was modified 4 years, 9 months ago by fearless359.

[fearless359]

Please provide me with a zip file of the templates/invoices directory and upload it. Also, give me a screen shot of the SI Defaults screen and of any other screen that shows something that it shouldn’t.

[fearless359]

The instructions “Add a 2nd Domain” have been updated to work in the foreign key environment. Cursory testing of the new domain has been performed but as per the warning in this topic, you should fully test all the features you wish to use prior to putting your new domain into production.

[fearless359]

The foreign key logic breaks the alternate domain logic. I need to do a deep dive on it for a fix.

Concerning site thinking you are a bot, did you have and check the reCaptcha “I’m not a robot” box? It is something that I added recently to help assure that real people are signing up and sending messages on this site.

[fearless359]

I just uploaded an update that add a set_aging flag field to the si_preferences table. When loaded, the first access will update the database and set this field to 1 (true) for the preference ID of 1. All others will be 0 (false). You can then set the other preference records however you like to cause them to set the aging field. So no longer will the aging logic be tied to pref_id of 1, but to this new flag field setting.

I’ll have to look at the domain_id write up. It was written before I added foreign keys and likely does need to be updated to account for this.

[Author]

Posts