Since upgrading to 7.1.5 quotes and invoices are completely broken. Creating a quote seems to work fine, but when converted to an invoice, all of the line items are missing - the grand total carries through without a problem though.
When you go back to the Quote, all of the line items are missing there too. It is possible to add new line items to an invoice, but when you click save, the āmissingā items also appear. But try and edit the line items to remove duplicates and they all disappear again.
Picture 1 below shows the invoice with duplicate line items (there should only be two) and picture 2 shows what happens when you try and edit the invoice.
Iāve tried a repair and rebuild but this has made no difference.
Iām wondering if this issue should actually have been posted in the āBugsā forumā¦
I have checked the sugarcrm.log and there were indeed a couple of errors encountered during the upgrade process, but they all related to the aor_ reports tables/module. There were no apparent issues with the aos_ sales tables/modules.
On a related note - in which table are invoice/quote line items stored? It would be very helpful to know as I will now need to manually alter invoices before they are sent out.
I do have a backup but I have used the system since upgrade - the problem with opportunities and invoices wasnāt apparent until I actually had to make one of each. Is it possible to downgrade the database and retain info, or am I going to have to roll back to Friday?
I have a similar problem but this was not during an upgrade. This is a fresh install of Suite CRM 7.1.5.
I have two issues:
I cannot change any AOS settings in the admin panel - I have to manually edit config_override.php (775 Permissions) to get groups to show in quotes and to adjust the initial quote numbers.
I can enter a quote but have the same issue as ben when I go to edit it - all line items disappear, I can add new line items or groups to quote but cannot change existing line items. If I hit save or, the line items are still visible on the quote details view or when printed.
I have applied the change specified in the linked fix, and performed a repair and rebuild but the problem persists. I think you will have to log this as another bug.
Hi All
I have this too - the contents of the quote still appear, but trying to edit the quote shows no lines (as in the above example)
I have not tried to do the invoicing bitā¦
My instance is installatron installed on a ljnux server
Some more info on the settings not savingā¦ the GUI shows that groups are enabled by default but the quotes donāt show groups until I actually manually enter groups as enabled in the config_override.php file (I have to add a new line of code to it).
I have noticed that the aos_line_item_groups table has no rowsā¦ does this mean the quotes arenāt saving the line items to the table it is supposed to be saving it to? I am not sure the purpose of this table, I am just guessing it could be pertinent, so this is just here to help someone troubleshoot!
I have found a very similar result in my database to that reported by ubernerdsteve. What I cannot find however is the actual line items for quotes/invoices in the database. Does anyone know where these are stored?
I am also struggling to find the details in the DB
The only places I can find the info is in āTrackerā although AOS-Product_Quotes has some of the info in.
I concur that the records are not being entered - though how they show up in the quote details view is unclear.
Weird but I got mine fixed!!
I originally manually edited the file stated in the āfixā but it didnāt work so - Try this:
[ul]
[/ul]- Clear ALL the browsers Cache (I didnāt have Suite opened). I use Chrome with History Eraser Extension
FTP to your Suite CRM site and find modules / AOS_Products_Quotes / line_items.js - SAVE THE ORIGINAL JUST IN CASE!!
OK this is really, really weird. I decided to have another go at SpudRās suggestion, this time checking the file permissions on the newly created Line_Items.php file matched those of the original. I also performed a repair and rebuild operation just to check everything was ok. This time around, I could access invoices and quotes, although there were 50-odd lines of code output at the top of each page. Worse still line items had disappeared from every page - all that remained were the totals.
Again, I restored my original Line_Items.php and repaired the system, and tested to verify that everything was back to how it should be. But this time when I tried to edit an existing quote or invoice, the ability to add and alter line items had returned.
By restoring the original Line_Items.php, in theory nothing has changed. But clearly something has been tweaked in this process because everything now seems to be working correctly. I shall monitor my install and update if I notice anything else.
