#1876 - "There is no commission" message is displayed when trying to calculate a commission
We have created a commission calculation according to the steps in demo, "Quotes commission testing", in your env (http://suitesalescommissions.varianceinfotech.net) and we are getting the message "There is no commission" when trying to run it.
nam2931996tk
5 years ago
Thanks for reviewing our Demo.
OK Let us review and we will come back to you
5 years ago
Hello YonatanR,
We've updated changes on demo instance. Please check now & let us know if you've any query.
Regards, Variance Infotech PVT LTD
5 years ago
Hi, Thanks. It does seems to work now. We have purchased this extension, and having the same bug and also 2 other errors when trying to save commissions:
Thu Apr 4 13:25:05 2019 [17939][1][FATAL] Query Failed: INSERT INTO vi_sla_policy_details (sla_policy_id,policy_name,module_name,operational_hours,sla_log,status,trigger_field,trigger_value,resolved_time,resolved_type_time,add_additional_conditions,conditional_operator,status_field,pause_values,fulfillment_values,date_entered) VALUES('42c0d986-d6f6-3512-9f5e-5ca605382195','SLA Basic Policy','Cases','business_hours','1','Active','priority','P1','60','Minutes','','AND','state','Hold','Closed','2019-04-04 13:25:05'): MySQL error 1366: Incorrect integer value: '' for column 'add_additional_conditions' at row 1
Wed Mar 27 11:48:24 2019 [17174][1][FATAL] Query Failed: INSERT INTO vi_set_commissions(commission_id,commission_name,module_name,due_date,team_member_user_id,commission_type,calculation_type,auto_generate_commission,run_commission_calculation,calculation_date_start_time,weekly_days,time_from,recipients,email_id,subject,template_id,conditional_operator)values('dad120f4-0b6a-765b-8930-5c9b63e39314','Quotes test commission','AOS_Quotes','date_entered','8e960f5d-d7c1-62ab-ee62-5c9780e62a44,1,seed_chris_id,seed_jim_id,seed_max_id,e0b3d3be-a4fb-297e-bc2d-5c9234229845,seed_sally_id,seed_sarah_id,seed_will_id','on_percentage','sum_amount','0','','','',':00','','','','','AND'): MySQL error 1292: Incorrect datetime value: '' for column 'calculation_date_start_time' at row 1
Maybe we just don't have the updated code? Can you please provide it?
Thanks in advance
5 years ago
Hello YonatanR
Can you please tell us which version of SuiteCRM you've used and which zip you've downloaded from SuiteCRM Store ?
Also can you please provide us your CRM Credentials on info@varianceinfotech.com & Server Details for checking issue if you don't mine.
Regards, Variance Infotech PVT LTD
5 years ago
Hello YonatanR
One more thing as per your comment, you mentioned you've faced 2 more issues. You've added Query failed log and the table which mentioned in log is two different Addons. One Table for Sales Commission and another for SLA(Service Level Agreement).
SLA Addons Query failed Log : http://i.prntscr.com/tJsSEXXSRiemK9KURg99_Q.png Sales Commission Query failed Log : http://i.prntscr.com/Cfw9qChhQ0u41aQg6e2cJA.png
Can you please confirm both errors come from different Addons?
5 years ago
Hi, Yes, you are correct. This are 2 different addons (we have purchased both).
5 years ago
Ok.
We've checked on our server by installing zip and we didn't faced this kind of issue.
Is it possible to give us your CRM credentials and Server Details for checking your issue if you don't mind.
If yes then please send us on "info@varianceinfotech.com"
Regards, Variance Infotech PVT LTD
5 years ago
Hello,
Please let us know if you have any more questions on this ticket. If not then we will close this ticket.
Regards, Variance Infotech PVT LTD
5 years ago
Hi, We have sent email today for you to check the issues mentioned.
Thanks in advance, Yonatan
5 years ago
Hello YonatanR,
Can you please give admin access of CRM. Without admin access we can't able to see "Admin" Link of CRM.
Also give us FTP and Databse access so we can fix your issue quickly.
Regards, Variance Infotech PVT LTD.
5 years ago
Hello YonatanR,
We've got your email regarding SSH access but still we didn't get Admin User Credentials for CRM. You've sent us Credentials of CRM which is non-admin user.
For checking your issue we need Admin User Credentials. Please send us on "info@varianceinfotech.com".
So we can check and fix your issue quickly.
Regards, Variance Infotech PVT LTD
5 years ago
Hi, The user we have sent you (test) is a system administrator.
Thanks, Yonatan
5 years ago
Hello YonatanR
We'll check and update you soon regarding your issue.
Regards, Variance Infotech PVT LTD
5 years ago
Hello YonatanR
The issue which you mentioned above like when click on "CALCULATE COMMISSION" button, it shows message "There is no commission" has been fixed.
See below are the screenshot of your instance where we tested functionality. http://i.prntscr.com/Jp8plX9gTZ_beatDB-cKUg.png http://i.prntscr.com/dMQr7xwvSY2WOhoBFHWE0g.png
Regards, Variance Infotech PVT LTD
4 years ago
Hello
Thanks for your valuable support and being our customer. As per our last discussion related to ticket, hope you've received satisfied answer from our support team. For now, We're closing the ticket but if you've any questions or concern feel free to email us on techsupport@varianceinfotech.com or reply to the same ticket.
Regards, Support Team Variance InfoTech Pvt Ltd www.varianceinfotech.com