Forum Replies Created
-
Posts
-
Check out the Extensions menu option. What you want to do is set up an extension for the templates/invoices/manage.tpl file. If the data you want to display is not in the data.json file that feeds the DataTables, then you will need to add the module/invoices/manage.php file to the extension and include the field/fields that you want to display. Try and keep your changes to these files as it can get more complicated if you have to add other classes and such to the change. If you need data that is not provided by an existing class method, try making the PdoDb request withing the manage.php file and adding it to the $invoices array prior to submitting it to the json encode function.
Hope this helps get you going. If you need more help, try explaining what it is you want to see versus what is there now.
Unfortunately, the search option is a feature of the DataTables module that SI uses to render the tables on the various manage screens. It is limited to searching only the data retrieved by the current inquiry. Knowing this, I hope that over time you will come to know if you need to review all history or just recent and do an all inquiry first if needed.
Concerning the enable/disable option for customers. Disabled just means they don’t appear in the drop down list of customers for new/updated invoices (though if you are editing an invoice for a disabled customer their new still appears in the list). It also places them after enabled customers on the customer management table screen.
You can always re-enable a previously disabled customer if they show up in your shop again.
Check the setting of the Invoice Display Days field in the SI Defaults screen. This specifies how many days in the past to display invoices for unless you request all of them. I added this when I noticed that having years of invoices did slow the typical retrieval and display on the invoices list screen. If this is set to 0, then all invoices are displayed every time. Mine is set to 366 so I get a years worth of invoices by default. There is a tab on the screen to get ALL invoices if you need them. For me, I very seldom need more the a years worth and displaying this is quite fast (virtually instantaneous for me). You may have a different volume of invoices but can tweak this setting to what works be for performance versus number of historical invoices regularly needed.
I haven’t done anything for customers I don’t have so many that it has been an issue. Not sure if you mark customers as enabled/disabled for active vs inactive customers. If so, I could add an option to display active customers only by default and an option then to show all customers. Let me know if you think that might help.
The files in the custom directory are not part of the library. They are ones you develop. Try copying the invoices/manager.tpl from your backed up, previous version to the custom/default_template directory. See if that doesn’t resolve your issue.
For pdf characteristics such as font size, use the exportPdf… values in the config/custom.config.ini file.
This is the same error that you had before. As if the items you deleted from the invoice_item_tax table, were not deleted. Here is an example of a SQL DELETE statement for multiple records at a time:
DELETE FROM si_invoice_item_tax WHERE invoice_item_id IN (1354, 1355, 1356, 1357);Not sure how if you deleted these records before, they still show up. But you should verify that once they are deleted, an inquiry no longer finds one or more of them. Delete the php.log file and run SI again. Hopefully, you will be past this error.
What errors are showing in your tmp/log/php.log file? If there are a bunch of old ones, delete the content of the file and run your inquiry again so only current errors are in the file. You can zip the file and attach to a response for me to review. Concerning a zoom, that is possible. Let’s try reviewing current errors first and if nothing there, do the zoom thing. As far as cost, I would leave that to you and ask that you post it via the GoFundMe link on the group page.
Obviously the deleted items won’t appear in the si_invoice_item_tax any longer. So I’m wondering that items you are thinking of deleting from this table. I did run a test where I created an invoice with a tax item, then manually deleted it from the si_invoice_item_tax table. Although the si_invoices record still contained the total tax value in the record, when I displayed the invoice, it no longer showed the total tax. And when I went back to the database, the si_invoices tax_amount field was reset to zero (the correct value). So you should be able to reset the values by simply accessing the invoices.
By the way, how is your original issue? Everything displaying OK?
You had me there for a second. You meant the Default Invoice Type which is a folder containing the template for the invoice that you want to use. I selected measurements and then did a print invoice on an existing invoice. The result was fine. I’ve attached a copy of what I got using this. Don’t mind the blanked out fields, the data was correct in them but the info more or less confidential.
Attachments:
The NumberFormatter class is part of the Intl extension. You need to uncomment this extension in the php.ini file and then restart your Apache server.
Your issue will be setup related. For your setup, I suggest using port 26 for TLS. That is what I am using on my live system. If that doesn’t work, check your email provider to see what they recommend for TLS settings on SMTP server.
The invoice number and date are set the same as if you generated a new invoice manually. The invoice is the next available and the data is the current system date.
You are making progress. From what I find by googling his error, is that you exceeded the maximum number of SQL queries that are allowed within and hour. There are various solutions but before you try any of them, just try SI again and see if it completes; since an hour has passed since you got the error. If that doesn’t help, google the error and see the various solutions that those who have encountered this error have tried. This is what I googled:
User 'marvel_smp' has exceeded the 'max_questions' resource (current value: 150000)Turns out there are two duplicate entries in the cron log file. If you delete these, SI should run past this point. In the si_cron_log table, delete the records with id of 223 and 231.
Not sure why you are getting this error, but have attached files to see if you can get past it using a database I generated from a fresh install. This database should be at the point where you will need to enter customer, biller and product. Then you can add invoices. Just delete all tables from your existing database, the upload the SQL file contained in the attached zip file. Let me know if this helps.
Recent Comments