Create documents in docx, xlsx (MS Office Word and Excel), odt, ods (LibreOffice and OpenOffice) and pdf format without MS Office or others plugins installed from any module and subpanel using templates.
#2533 - Bug with Quotes: Deleted Groups of Line Items are still exported.
The generated document should not show any deleted record of the Quote. Now it happens for deleted Groups that they always appear in the document.
-
"It has improved our processes so much! Admin cut in half! We send a webform to clients to sign up straight into CRM then generate and print their paperwork to sign."
Read More Reviews
WSiedler
4 years ago
Hi,
The component excludes all records with deleted = 1. The specific cases of each module for which they should or should not be excluded are not covered. These specific cases of exclusion must be treated by code, creating a "CalculatedField" class.
Send us the document template that is not getting the correct data and the necessary steps to reproduce the error. We will publish an update if it is a component error or an additional functionality that needs to be added.
In case you need to finally add a specific filter, please see custom/modules/Opportunities/DHA_DocumentTemplatesCalculatedFields.php example for Calculated Fields - ShowRow event to filter main module data - OrderRows event to order main module data - BeforeMergeBlock event to order and/or filter subpanel data.
Regards
4 years ago
I see that the standard behavior of Suite when deleting a Group of Line Items is to set field group_qty_u=0 instead of setting deleted=1. In fact, you can see that any deleted Group has deleted=0 and group_qty_u=1. Can you please check on this?
By the way, I need your direct contact to send you my document template. I tried to contact you on your online contact form (https://www.izertis.com/en/contact-us) and I'm waiting for an answer. Thanks Kind Regards
4 years ago
Hi,
We have just uploaded version 2.5.15 of the component that fixes this problem.
Tested with SuiteCRM v7.11.5 it was found that when deleting a group of quote lines, SuiteCRM deletes its lines (deleted = 1) but leaves the group record undeleted (remains as deleted = 0). You can check the code of modules/AOS_Products_Quotes/Line_Items.php as while reading of the lines it's not checked that the group is deleted, but only the line. The fact that the group remains undeleted would be a bug in SuiteCRM.
This affected the component. If a document was requested with a list of quote lines it would work fine, but if request the line groups of the quote it would also show the deleted groups. This would be a bug in the component derived from the SuiteCRM bug.
As for the way to contact us, better by email. Please use the email address listed in our store.suitecrm.com user profile or the email address listed in the 'Contact' section of the 'Readme.txt' file that accompanies the component (these are the same email address).
Regards
4 years ago
Thank you very much for the update. Best Regards