INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10587, 20016, '', '10587', 'E', 1, '<p>\n	Modifications of E sell on Al Baraka</p>\n', '2021-02-06 09:05:54', '', 'JOHN', 47, 12, '2021-03-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-06 09:05:54', 1, '2021-03-07 06:00:02'),
(10588, 20014, '', '10588', 'E', 1, '<div class=\"gmail_default\" style=\"\">\n	<span class=\"gmail_default\" style=\"\"><font color=\"#3d85c6\" face=\"times new roman, serif\" size=\"4\">I bring your attention to the customer statement and GL Report</font></span></div>\n<div class=\"gmail_default\" style=\"\">\n	<span class=\"gmail_default\" style=\"\"><font color=\"#3d85c6\" face=\"times new roman, serif\" size=\"4\">when i unpost and Re-Post&nbsp; any invoice the datewise orderf the statement and GL becomes miss aligned</font></span></div>\n<div class=\"gmail_default\" style=\"\">\n	&nbsp;</div>\n<div class=\"gmail_default\" style=\"\">\n	<span class=\"gmail_default\" style=\"\"><font color=\"#3d85c6\" face=\"times new roman, serif\" size=\"4\">Please refer the GL and Statement for your reference</font></span></div>\n<div class=\"gmail_default\" style=\"\">\n	<span class=\"gmail_default\" style=\"\"><font color=\"#3d85c6\" face=\"times new roman, serif\" size=\"4\">The Modified invoice of January 31st 2021 in both Customer Statement and GL shows after invoices of 04, Feb 2021</font></span></div>\n<div class=\"gmail_default\" style=\"\">\n	<span class=\"gmail_default\" style=\"\"><font color=\"#3d85c6\" face=\"times new roman, serif\" size=\"4\">So&nbsp; Whether&nbsp;or not the invoice is modified&nbsp; i&nbsp; want the statement&nbsp; and GL to show in the datewise order </font></span></div>\n', '2021-02-06 09:53:25', '', 'JOHN', 41, 12, '2021-02-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-06 09:53:25', 1, '2021-02-12 06:00:02');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10589, 20014, '', '10589', 'E', 1, '<p>\n	Report Customer list - needs a &quot;Clearence type&quot; field</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65418 characters]', '2021-02-07 10:36:33', '', 'JOHN', 41, 12, '2021-02-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-07 10:36:33', 1, '2021-02-14 06:00:01');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10590, 20067, '', '10590', 'E', 1, '<p>\n	New order movement analysis convert with approval to Purchase enquiry</p>\n', '2021-02-08 10:11:00', '', 'JOHN', 200, 12, '2021-02-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-08 10:11:00', 1, '2021-02-17 06:00:02'),
(10591, 20067, '', '10591', 'E', 1, '<p>\n	1. Report- Customer - Activity List<br />\n	515 customer on 7th- put new order, but in reports its coming as calls</p>\n<p>\n	(activity showing wrong in activity list</p>\n<p>\n	2. Activity List - User dropdown all for admin only, otherwise lock to respective user only</p>\n<p>\n	3. customer view all option (when i am seeing other salesman&#39;s customer, block the edit button, otherwise they will change salesman</p>\n<p>\n	only edit open for his customers</p>\n', '2021-02-08 10:21:05', '', 'JOHN', 200, 12, '2021-02-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-08 10:21:05', 69, '2021-02-08 15:44:32'),
(10592, 20067, '', '10592', 'E', 1, '<p style=\"margin-left:45.0pt;\">\n	<strong><u>Customers</u></strong></p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Need customer contact person search option in activity.</p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Kindly add &ldquo;Product Type&rdquo; in activity.</p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date of activity follow up in the calendar</p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Daily tasks/follow ups in dashboard</p>\n<p style=\"margin-left:45.0pt;\">\n	&nbsp;</p>\n<p style=\"margin-left:45.0pt;\">\n	<strong><u>QUOTATION</u></strong></p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Remove borders for Payment, Terms &amp; Condition &amp; Bank details. Make heading bold with underline.</p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Need to see quotation preview before approval.</p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Option to delete photo from quotation which is made by dummy item.</p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Document delete rights for an authorized person (admin) in case we upload wrong attachment.</p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Need to see RFQ number in the quotation print out below RFQ title (Eg: 10081)</p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Revision number is not coming in the quotation print out.</p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Quotation date sort option.</p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Profit percentage and supplier details need in the quotation window.</p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Option to add alternative product within the same serial number.</p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dummy item unit pair is not available.</p>\n<p style=\"margin-left:45.0pt;\">\n	&nbsp;</p>\n<p style=\"margin-left:45.0pt;\">\n	<strong><u>PAYMENT TRACKER</u></strong></p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Payment tracker &ndash; SOA can be print by sales person.</p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Delivery Tracker error.</p>\n<p style=\"margin-left:45.0pt;\">\n	&nbsp;</p>\n<p style=\"margin-left:45.0pt;\">\n	<strong><u>INVENTORY</u></strong></p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tool tip, show full description of the product in the inventory.</p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Inventory &ndash; Picture and description details should be in details.</p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Inventory need to show the selling price of the product.</p>\n<p style=\"margin-left:45.0pt;\">\n	&nbsp;</p>\n<p style=\"margin-left:45.0pt;\">\n	<strong><u>REPORT</u></strong></p>\n<p style=\"margin-left:45.0pt;\">\n	&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Some Reports &ndash; There is no company logo. (Eg: Lead List, Quotation List, etc.,)</p>\n', '2021-02-08 11:13:13', '', 'JOHN', 200, 12, '2021-02-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-08 11:13:13', 1, '2021-02-22 06:00:02'),
(10593, 20067, '', '10593', 'E', 1, '<p>\n	1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sub Ledger Account report &ndash; Allwyn</p>\n<p>\n	1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Post and allocate button in finance &ndash; receipts</p>\n<p>\n	&nbsp;</p>\n', '2021-02-09 08:22:00', '', 'JOHN', 200, 12, '2021-02-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-09 08:22:00', 1, '2021-02-15 06:00:02'),
(10594, 20037, '', '10594', 'E', 1, '<p>\n	whether we can extract the complete HS code numbers that we have used in last 24 months from Bluesky</p>\n', '2021-02-09 12:27:58', '', 'JOHN', 110, 12, '2021-02-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-09 12:27:58', 1, '2021-02-15 06:00:02'),
(10595, 20019, '', '10595', 'E', 1, '<p>\n	Purchase last price</p>\n<p>\n	E Sell - Top View</p>\n<p>\n	order taking from app and saving (API needed)- web already working</p>\n', '2021-02-11 16:51:26', '', 'JOHN', 56, 7, '2023-12-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-11 16:51:26', 4, '2023-12-29 13:51:23'),
(10596, 20001, '', '10596', 'I', 1, '<p>\n	Order No 200838</p>\n<p>\n	advance invoice 400851,</p>\n<p>\n	invoice 400964 made and used the advance invoice</p>\n<p>\n	then cancelled 400964,</p>\n<p>\n	now when again invoice is created, the advance invoice is already used</p>\n', '2021-02-15 17:12:50', '', 'JOHN', 2, 12, '2021-02-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-15 17:12:50', 1, '2021-02-22 06:00:02'),
(10597, 20019, '', '10597', 'I', 1, '<p>\n	Matrimonial Site</p>\n', '2021-02-15 21:40:45', '', 'mereenak', 56, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 478, '2021-02-15 21:40:45', 1, '2022-07-29 05:00:04'),
(10598, 20020, '', '10598', 'E', 1, '<p>\n	Show/ hide commission for that grouped component</p>\n', '2021-02-16 09:57:56', '', 'JOHN', 59, 12, '2021-02-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-16 09:57:56', 1, '2021-02-24 06:00:02'),
(10599, 20062, '', '10599', 'E', 1, '<p>\n	ARK Purchase Invoice number</p>\n<p>\n	900161</p>\n<p>\n	ARK ENGINEERING SERVICES LLC mattitt Abdul Razaq Talib Mohd. Workshop LLC. akkanam</p>\n<p>\n	&nbsp;</p>\n', '2021-02-16 12:02:43', '', 'JOHN', 185, 12, '2021-02-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-16 12:02:43', 1, '2021-02-22 06:00:02'),
(10600, 20074, '', '10600', 'E', 1, '<p>\n	Appraisal Report</p>\n', '2021-02-16 15:16:15', '', 'JOHN', 221, 12, '2021-03-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-16 15:16:15', 1, '2021-03-02 06:00:01'),
(10601, 20001, '', '10601', 'I', 1, '<p>\n	In (Sale &amp; Hire) Quotation and order if rate is null, display error message, otherwise save doesnt happen and all the data will be lost</p>\n<p>\n	Allow zero price</p>\n', '2021-02-16 17:56:35', '', 'JOHN', 2, 2, '2021-02-16', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2021-02-16 17:56:35', 69, '2021-02-16 17:56:47'),
(10602, 20006, '', '10602', 'I', 1, '<p>\n	Audit close - Year</p>\n', '2021-02-17 16:02:05', 'WhatsApp Image 2021-02-17 at 3.32.44 PM.jpeg', 'JOHN', 17, 12, '2021-03-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-17 16:02:05', 1, '2021-03-07 06:00:02'),
(10603, 20019, '', '10603', 'I', 1, '<p>\n	Software Implementation -ERP&nbsp;</p>\n', '2021-02-17 21:31:58', '', 'mereenak', 56, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 478, '2021-02-17 21:31:58', 1, '2022-07-29 05:00:04'),
(10604, 20067, '', '10604', 'E', 1, '<p>\n	In service quotation when we approve the approved person name is showing in created by</p>\n', '2021-02-18 09:10:01', '', 'JOHN', 200, 12, '2021-02-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-18 09:10:01', 1, '2021-02-24 06:00:02'),
(10605, 20071, '', '10605', 'E', 1, '<p>\n	please enable Leave mail, Emp to LM, After LM approval to HR, After HR approval to employee</p>\n<p>\n	hrmena@viola.ae - use this email id for sending mails</p>\n<p>\n	Document expiry - One mail every Night to Ara&#39;s mail (Documents already expired and&nbsp; going to expire in next 2 months)</p>\n', '2021-02-18 10:37:07', '', 'JOHN', 212, 12, '2021-03-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-18 10:37:07', 1, '2021-03-02 06:00:01'),
(10606, 20067, '', '10606', 'I', 1, 'Refer Document', '2021-02-18 11:14:10', 'Diatech mail 17022021.docx', 'JOHN', 200, 12, '2021-03-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-18 11:14:10', 1, '2021-03-07 06:00:02'),
(10615, 20071, '', '10615', 'E', 1, '<p>\n	HR modifications</p>\n', '2021-02-16 14:37:16', '', 'JOHN', 212, 12, '2021-06-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-22 14:37:16', 1, '2021-06-04 05:00:07'),
(10614, 20067, '', '10614', 'E', 1, '<p>\n	when we try to export the inventory report in excel file it is downloading in different format and not as excel</p>\n<p>\n	please check</p>\n', '2021-02-22 12:32:10', '', 'JOHN', 200, 12, '2021-03-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-22 12:32:10', 1, '2021-03-29 05:00:01'),
(10616, 20078, '', '10616', 'E', 1, '<p>\n	HR modifications</p>\n', '2021-02-16 14:37:36', '', 'JOHN', 233, 12, '2021-05-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-22 14:37:36', 1, '2021-05-23 05:00:02'),
(10617, 20074, '', '10617', 'E', 1, '<p>\n	HR modifications</p>\n', '2021-02-16 14:37:52', '', 'JOHN', 221, 12, '2021-05-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-22 14:37:52', 1, '2021-05-23 05:00:02'),
(10690, 20067, '', '10690', 'E', 1, '<p>\n	Diatech- when creating fresh quotation, the sales price of uploaded items is locked. But after saving and when editing again, its coming open<br />\n	Diatech- In quotation suppose we use 2# price is changing, but when its going forward to order and invoice &ndash; only 2 is taking</p>\n', '2021-05-17 17:22:10', '', 'JOHN', 200, 12, '2021-05-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-05-17 17:22:10', 1, '2021-05-26 05:00:02'),
(10618, 20003, '', '10618', 'E', 1, '<p>\n	Issues</p>\n', '2021-02-22 08:12:15', '', 'JOHN', 8, 12, '2021-03-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-23 08:12:15', 1, '2021-03-12 06:00:07');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10619, 20002, '', '10619', 'E', 1, '<p>\n	&nbsp;</p>\n<p>\n	Dear Bluesky Team,</p>\n<p>\n	Kindly note, we are not able to see the remarks column in LPO after completing the purchase, provide an option to view the remarks column as we need to check what are the line items will be for back-to-back delivery and stock.</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65211 characters]', '2021-02-23 08:51:51', 'Screeshot.png,screeshot 1.png', 'Tebin Kalam', 4, 12, '2021-03-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 9, '2021-02-23 08:51:51', 1, '2021-03-03 06:00:02');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10607, 20067, '', '10607', 'I', 1, '<p>\n	Please see the attached documents related with HR.</p>\n<p>\n	&nbsp;</p>\n<p>\n	Review:</p>\n<p>\n	1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Regarding the punch in and punch out &ndash; We need the employee to do both punch in and out for calculate the attendance.</p>\n<p>\n	2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Working hour &ndash; 10 hours per day (If the employee didn&rsquo;t complete the 10 hour per day, then that minutes should be deducted) <strong>For Exp: Ajmal punch in @ 8.15 AM &amp; if he punch out @ 6.15 PM then there is no deduction. But, if he punch in @ 8.15 AM &amp; punch out @ 6.00PM then the balance 15mins considered as late &amp; should be deducted from the salary)</strong></p>\n<p>\n	3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Working hour &ndash; Ramzan Time &ndash; 7 hours per day (From 9.00AM till 4.00PM)</p>\n<p>\n	4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Salary Increment Report: (Individual employee report should detailed by mentioning his/her each increment amount and date)(Group &ndash; that particular period which employee received increment with total amount)</p>\n<p>\n	5.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Salary should be seen by the employee in his/her user, only after the final salary is locked, before that no any user should see their salary slip.</p>\n<p>\n	6.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If the HR announce any memo (as per management information or instruction)then this memo should reach to each user in his/her calendar or as a notification.</p>\n<p>\n	7.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Employee Undertaking letters should not view or download by any employee in their user. Rest of the documents they can view &amp; download &nbsp;(Visa copy, Emirates ID copy etc)</p>\n', '2021-02-18 11:15:29', '', 'JOHN', 200, 12, '2021-03-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-18 11:15:29', 1, '2021-03-26 06:00:03'),
(10608, 20002, '', '10608', 'E', 1, '<p>\n	Stock Ageing Report - HTML Vs XLS difference- as on 31 Dec 2020</p>\n', '2021-02-18 12:50:25', 'norden ageing report html vs xl difference as on 31122020.xlsx', 'JOHN', 5, 12, '2021-03-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-18 12:50:25', 1, '2021-03-02 06:00:01'),
(10609, 20082, '', '10609', 'E', 1, '<p>\n	Software Implementatation - ERP</p>\n', '2021-02-18 21:46:18', '', 'mereenak', 245, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 478, '2021-02-18 21:46:18', 1, '2022-07-29 05:00:04'),
(10610, 20083, '', '10610', 'I', 1, '<p>\n	<font color=\"#222222\" face=\"Arial, Verdana, sans-serif\">Software Implementation&nbsp;- ERP</font></p>\n', '2021-02-18 21:47:08', '', 'mereenak', 248, 12, '2021-05-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-02-18 21:47:08', 1, '2021-05-23 05:00:02'),
(10611, 20006, '', '10611', 'E', 1, '<p>\n	Hr WPS salary is not posting</p>\n<p>\n	Marked as posted . But not come accounts</p>\n', '2021-02-21 08:50:14', 'WhatsApp Image 2021-02-21 at 8.35.53 AM.jpeg', 'JOHN', 17, 12, '2021-02-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-21 08:50:14', 1, '2021-02-28 06:00:02'),
(10612, 20006, '', '10612', 'E', 1, '<p>\n	Year Selection Problem</p>\n', '2021-02-21 09:55:59', 'image003.png', 'JOHN', 17, 12, '2021-02-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-21 09:55:59', 1, '2021-02-28 06:00:02'),
(10620, 20004, '', '10620', 'E', 1, '<p>\n	&nbsp;Login Screen<br />\n	incorporating Terms and conditions before&nbsp; login</p>\n', '2021-02-24 15:06:54', '', 'JOHN', 11, 12, '2021-03-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-24 15:06:54', 1, '2021-03-02 06:00:01'),
(10621, 20019, '', '10621', 'I', 1, '<p>\n	DEMO ERP- Production and Assembly</p>\n', '2021-02-24 20:42:04', '', 'mereenak', 56, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 478, '2021-02-24 20:42:04', 1, '2022-07-29 05:00:04'),
(10622, 20020, '', '10622', 'I', 1, '<p>\n	ar centre needs the following modifications ,<br />\n	please segregrate possible/ not possible, if possible how much time to do (Consider App modification also whereever needed)<br />\n	<br />\n	1, Discount Approval procees by owner - Alraedy discuseed with Arun and Manu, Car care approved the flow chart<br />\n	2. when a discount card is purchased - an sms will go to the customer upon payment if mobile number is valid<br />\n	3.when the discount card is used, send sms with remaining offers in card and date of expiry<br />\n	4. if the invoice amount is greater than 500, trigger a thanks sms<br />\n	5. after the job card is raised, some servieces (Eg: ceramic) needs to add a scheduled time for this work. because if load of ceramic work is there, user will park car here and go usually.&nbsp; in this case they will give a schedule time for work , and customer will bring car at that time<br />\n	5. after the scheduled work is finished, triger an smsto customer that work is over, he can pay and take the car<br />\n	6.a report of cancelled jobs<br />\n	7. A list of pending jobs (Waiting for payment)<br />\n	8. option to change the salesman of a particular transaction ( Because the salesman forgets to logout and new user continious in the old login)</p>\n', '2021-02-25 16:40:14', '', 'JOHN', 59, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2021-02-25 16:40:14', 1, '2022-07-29 05:00:04'),
(10624, 20084, '', '10624', 'E', 1, '<p>\n	CRM - Software Implementation</p>\n', '2021-03-01 20:35:46', '', 'mereenak', 251, 12, '2021-06-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-03-01 20:35:46', 1, '2021-06-20 05:00:01'),
(10625, 20085, '', '10625', 'E', 1, '<p>\n	Sales Module</p>\n', '2021-03-01 20:38:59', '', 'mereenak', 254, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 478, '2021-03-01 20:38:59', 1, '2022-07-29 05:00:04'),
(10626, 20001, '', '10626', 'I', 1, '<p>\n	File Number 4407 Sales order 200970 converted to delivery withoutlast approval<br />\n	some problem occured so they made another sales ordr 200971 (I think copied from 200970), but the file Number is SAME</p>\n<p>\n	they did delivery on that also, but cannot convert to invoice<br />\n	So they made another sales order 200972 , File No 4728 , did deleivery and invoiciong</p>\n<p>\n	&nbsp;</p>\n<p>\n	PLEASE CHECK</p>\n', '2021-03-02 10:37:47', '', 'JOHN', 2, 2, '2021-03-02', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2021-03-02 10:37:47', 69, '2021-03-02 10:38:03'),
(10627, 20086, '', '10627', 'I', 1, '<p>\n	Software Implemenation</p>\n', '2021-03-02 21:02:52', '', 'mereenak', 257, 7, '2023-12-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-03-02 21:02:52', 4, '2023-12-29 13:50:31'),
(10628, 20073, '', '10628', 'I', 1, '<p>\n	View option -- context menu in sales order [Finance User group]</p>\n', '2021-03-02 21:04:18', '', 'mereenak', 218, 12, '2021-03-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-03-02 21:04:18', 1, '2021-03-09 06:00:02'),
(10629, 20073, '', '10629', 'E', 1, '<p>\n	Manager Dash board - Modification - Customer graph</p>\n', '2021-03-04 10:58:30', '', 'JOHN', 218, 12, '2021-03-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-04 10:58:30', 1, '2021-03-12 06:00:07'),
(10630, 20031, '', '10630', 'E', 1, '<p>\n	E Sell Installation</p>\n', '2021-03-07 17:57:24', '', 'JOHN', 92, 12, '2021-05-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-07 17:57:24', 1, '2021-05-23 05:00:02'),
(10631, 20007, '', '10631', 'E', 1, '<p>\n	Current stock mismatch</p>\n', '2021-03-08 08:55:17', 'WhatsApp Image 2021-03-08 at 8.52.58 AM.jpeg,WhatsApp Image 2021-03-08 at 8.52.54 AM.jpeg,WhatsApp Image 2021-03-08 at 8.52.56 AM.jpeg', 'JOHN', 20, 12, '2021-04-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-08 08:55:17', 1, '2021-04-13 05:00:02'),
(10632, 20061, '', '10632', 'E', 1, '<p>\n	Modifications / Enhancements</p>\n', '2021-03-08 09:03:55', '', 'JOHN', 182, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2021-03-08 09:03:55', 1, '2022-07-29 05:00:04'),
(10633, 20087, '', '10633', 'E', 1, '<p>\n	Software Instalation</p>\n', '2021-03-08 14:59:54', '', 'JOHN', 260, 12, '2021-05-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-08 14:59:54', 1, '2021-05-23 05:00:02'),
(10634, 20088, '', '10634', 'I', 1, '<p>\n	Software Implementation</p>\n', '2021-03-08 21:26:04', '', 'mereenak', 263, 12, '2022-03-12', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 478, '2021-03-08 21:26:04', 1, '2022-03-12 06:00:02'),
(10635, 20067, '', '10635', 'E', 1, '<p>\n	[11:31 AM, 3/10/2021] Ajmal Diatech: The inventory edit part is again enabled for the sales team,<br />\n	they are editing the description of the inventory which we created in the system.<br />\n	please check that<br />\n	[11:32 AM, 3/10/2021] Ajmal Diatech: also before i saw that service contract after receiving the signature from customer we can scan and upload in the order (Upload file option was there) when i check now i cannot find it</p>\n', '2021-03-11 08:58:28', '', 'JOHN', 200, 12, '2021-03-19', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-11 08:58:28', 1, '2021-03-19 06:00:04'),
(10636, 20081, '', '10636', 'E', 1, '<p>\n	AL Mehaz E Sell Instalation</p>\n', '2021-03-11 12:51:28', '', 'JOHN', 242, 12, '2021-05-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-11 12:51:28', 1, '2021-05-23 05:00:02'),
(10637, 20019, '', '10637', 'E', 1, '<p>\n	WMS</p>\n', '2021-03-14 08:03:00', '', 'JOHN', 56, 12, '2022-03-12', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2021-03-14 08:03:00', 1, '2022-03-12 06:00:02'),
(10638, 20002, '', '10638', 'E', 1, '<p>\n	Please Insert Sales order date as shown in picture</p>\n', '2021-03-14 16:56:57', 'norden140321.png', 'JOHN', 5, 12, '2021-04-06', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-14 16:56:57', 1, '2021-04-06 05:00:01'),
(10639, 20065, '', '10639', 'I', 1, '<p>\n	After resetting password also following&nbsp; persons couldnt login</p>\n<p>\n	PRINCE KATTLA PAUL</p>\n<p>\n	ALLAN GEORGE PETER</p>\n', '2021-03-14 17:20:31', '', 'JOHN', 194, 12, '2021-04-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-14 17:20:31', 1, '2021-04-03 05:00:03'),
(10640, 20033, '', '10640', 'E', 1, '<p>\n	E Sell instalation</p>\n', '2021-03-14 17:22:38', '', 'JOHN', 98, 12, '2021-05-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-14 17:22:38', 1, '2021-05-23 05:00:02'),
(10641, 20093, '', '10641', 'E', 1, '<p>\n	Software instalation</p>\n', '2021-03-13 15:49:54', '', 'JOHN', 278, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30004', 0, 0, '', '', 69, '2021-03-16 15:49:54', 1, '2022-07-29 05:00:04'),
(10642, 20067, '', '10642', 'E', 1, '<p>\n	Stock report - Excel correction</p>\n', '2021-03-16 15:59:18', '', 'JOHN', 200, 12, '2021-03-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-16 15:59:18', 1, '2021-03-24 06:00:02'),
(10643, 20091, '', '10643', 'I', 1, '<p>\n	Software Implementation</p>\n', '2021-03-16 18:00:48', '', 'mereenak', 272, 12, '2021-05-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-03-16 18:00:48', 1, '2021-05-23 05:00:02'),
(10644, 20001, '', '10644', 'E', 1, '<p>\n	RE ORDER Level report</p>\n<p>\n	mail at every thursday 6:00 am</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n', '2021-03-17 10:24:53', '', 'JOHN', 2, 12, '2021-03-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-17 10:24:53', 1, '2021-03-26 06:00:03'),
(10645, 20013, '', '10645', 'E', 1, '<p>\n	Please enable the footer fro quaotation, order, invoice and credit note</p>\n', '2021-03-17 10:30:45', '', 'JOHN', 38, 12, '2021-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-17 10:30:45', 1, '2021-03-28 05:00:02'),
(10646, 20067, '', '10646', 'E', 1, '<p>\n	service module.<br />\n	<br />\n	1. After this upload option there is a issue in schedules the calendar goes back again in 0001 form.</p>\n<p>\n	2. As per Management (Mr. Muhammad and Mr. Ahmad ) the serial no. of the Contract there is no Logic/Sequence in the contracts we Prepared.</p>\n<p>\n	3. The Serial no. should come on each page of the contract.<br />\n	4. The page no should also be there in the pdf/Printed Contract (e g page 1/4 ,2/4,3/4,4/4)etc. at the end of each page.<br />\n	5. As in last time the Software changed we were seeing the Word form of the contract and they fixed it but some terms and condition Wording is missed which we added last time if &nbsp;ican talk with &nbsp;Mr. John over the phone line or WhatsApp it can be fixed at same time. could you fix a call with Mr john so we can fix this issue at the same time.<br />\n	6. If we are preparing the Daily Activity the names we mention (Contact Person) its going to reflect in the contract either the contract was previously prepared but still it adds the name. we kindly request you to provide the solution for this. like in the contract the name should come which we will select and in customer contact details all the names should be there that will be helpful.</p>\n', '2021-03-15 02:22:53', '', 'JOHN', 200, 12, '2021-03-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-18 02:22:53', 69, '2021-03-23 14:37:54'),
(10647, 20071, '', '10647', 'E', 1, '<p>\n	Attendce file upload to server</p>\n', '2021-03-18 08:08:35', '', 'JOHN', 212, 12, '2021-05-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-18 08:08:35', 1, '2021-05-24 05:00:01'),
(10648, 20082, '', '10648', 'E', 1, '<p>\n	HR Implementation<br />\n	just copy latst version to this</p>\n', '2021-03-18 09:04:28', '', 'JOHN', 245, 7, '2022-04-28', 0, '0000-00-00', '', 0, '0', '', '30002', 0, 0, '', '', 69, '2021-03-18 09:04:28', 3, '2022-04-28 06:07:49'),
(10649, 20001, '', '10649', 'E', 1, '<p>\n	See the attached Picture</p>\n<p>\n	Change the serial No to XF9E0500E00091H07001</p>\n<p>\n	if possible</p>\n', '2021-03-18 15:08:55', 'WhatsApp Image 2021-03-18 at 12.29.59 PM.jpeg', 'JOHN', 2, 12, '2021-03-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-18 15:08:55', 1, '2021-03-26 06:00:03'),
(10650, 20067, '', '10650', 'I', 1, '<p>\n	User duplication&nbsp;</p>\n<p>\n	Pls check the part no. LTXPF-1001 - Sales team edited the inventory description. This part i said to block and again it is unblock? They are adding extra things in what we created in inventory</p>\n<p>\n	&nbsp;</p>\n', '2021-03-18 17:25:55', '', 'mereenak', 200, 12, '2021-03-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-03-18 17:25:55', 1, '2021-03-26 06:00:03'),
(10651, 20019, '', '10651', 'I', 1, '<p>\n	Remove hacking files</p>\n', '2021-03-19 19:07:11', '', 'mereenak', 56, 12, '2021-03-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-03-19 19:07:11', 1, '2021-03-26 06:00:03'),
(10652, 20019, '', '10652', 'E', 1, '<p>\n	HR APP</p>\n', '2021-03-21 17:31:45', '', 'JOHN', 56, 12, '2022-03-12', 0, '0000-00-00', '', 0, '0', '', '30007', 0, 0, '', '', 69, '2021-03-21 17:31:45', 1, '2022-03-12 06:00:02'),
(10653, 20002, '', '10653', 'E', 1, '<p>\n	Refer to below purchase screen shot it&rsquo;s not reflecting in transaction details ( ATTACHED) and not in inventory. &nbsp;We have 6 pcs excess physically. Please check and update.</p>\n<p>\n	mail support dated 22/03/21</p>\n<p>\n	<br />\n	&nbsp;</p>\n', '2021-03-22 10:44:16', 'nordenimage004.jpg', 'JOHN', 5, 12, '2021-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-22 10:44:16', 1, '2021-03-28 05:00:02'),
(10654, 20067, '', '10654', 'E', 1, '<p>\n	Management want to see all the sales person sales report in dashboard , even if the sales person didn&#39;t do any sales<br />\n	If the sales person didn&#39;t do the sales then that person name should be there mentioning as zero<br />\n	<br />\n	Management given an example also<br />\n	Suppose Mr. Fazil did sales in January and his name is appeared in the sales details in graph<br />\n	But if he didn&#39;t do sales means his name even will not appear as zero so how it can be called as report<br />\n	<br />\n	So,<br />\n	Kindly take all the sales person name in the daily and graph report even if they didn&#39;t do sales<br />\n	&amp; also kindly details from sales person higher to lower drop down by sales figure.</p>\n<p>\n	Diana sales figure is high but her name in 3rd<br />\n	Ross sales figure is higher than Vangie<br />\n	<br />\n	So boss need to make it from higher to lower as per sales figure/amoun</p>\n', '2021-03-23 12:17:26', '', 'JOHN', 200, 12, '2021-06-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-23 12:17:26', 1, '2021-06-20 05:00:01'),
(10655, 20094, '', '10655', 'E', 1, '<p>\n	Software Instalation</p>\n', '2021-03-23 13:02:21', '', 'JOHN', 281, 12, '2021-06-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-23 13:02:21', 1, '2021-06-29 05:00:02'),
(10656, 20006, '', '10656', 'E', 1, '<p>\n	Loan voucher from HR Not posting in accounts .</p>\n', '2021-03-23 14:01:28', 'image00143.png', 'JOHN', 17, 12, '2021-03-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-23 14:01:28', 1, '2021-03-30 05:00:01'),
(10657, 20013, '', '10657', 'E', 1, '<p>\n	Include Project Reference in Sales Order, Invoice, Purchase order and Purchase Invoice</p>\n<p>\n	We have project reference field for Quotations which are converted to SO, but the Project Reference field is missing in SO. Please make it available in SO &nbsp;&amp; Invoice.</p>\n<p>\n	Similarly we need Project Reference in PO / Purchase Invoice also&nbsp;<br />\n	&nbsp;</p>\n<p>\n	Thanks</p>\n', '2021-03-23 19:32:50', '', 'Ganesan K.', 37, 2, '2021-03-24', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 20, '2021-03-23 19:32:50', 69, '2021-03-24 09:30:36'),
(10658, 20067, '', '10658', 'E', 1, '<p>\n	Mail Points</p>\n', '2021-03-24 14:06:02', '', 'JOHN', 200, 12, '2021-06-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-24 14:06:02', 1, '2021-06-20 05:00:01'),
(10659, 20006, '', '10659', 'E', 1, '<p>\n	<strong>MARCH &nbsp;VOUCHERS IN HR ,NOT POSTED TO ACCOUNTS</strong>.</p>\n<p>\n	Following are the missing Vouchers &nbsp;(sample attached)</p>\n<p>\n	Voucher # ASV/176 , &nbsp;ASV/175, &nbsp;ASV/174, &nbsp;ASV/173</p>\n', '2021-03-24 15:39:56', '', 'JOHN', 17, 12, '2021-03-31', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-24 15:39:56', 1, '2021-03-31 05:00:01'),
(10660, 20020, '', '10660', 'I', 1, '<p>\n	Server Migration -- File moved to new server</p>\n', '2021-03-25 21:35:40', '', 'mereenak', 59, 12, '2021-04-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-03-25 21:35:40', 1, '2021-04-02 05:00:06'),
(10661, 20004, '', '10661', 'E', 1, '<p>\n	Invoice Print Alignment correction mail dated 28/03/21</p>\n', '2021-03-29 10:00:42', '', 'JOHN', 11, 12, '2021-04-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-29 10:00:42', 1, '2021-04-04 05:00:01'),
(10662, 20067, '', '10662', 'E', 1, '<p>\n	Diatech HR Implementation</p>\n', '2021-03-29 12:44:02', '', 'JOHN', 200, 12, '2021-05-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-29 12:44:02', 1, '2021-05-23 05:00:02'),
(10663, 20071, '', '10663', 'I', 1, '<p>\n	ERP</p>\n', '2021-03-29 08:10:09', '', 'JOHN', 212, 12, '2022-03-12', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2021-03-29 08:10:09', 1, '2022-03-12 06:00:02'),
(10664, 20019, '', '10664', 'E', 1, '<p>\n	E Sell - Database connecting view</p>\n', '2021-03-29 08:10:33', '', 'JOHN', 56, 7, '2023-12-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-29 08:10:33', 4, '2023-12-29 13:50:39'),
(10674, 20090, '', '10674', 'E', 1, '<p>\n	Document attachement from naming&nbsp; criteria</p>\n', '2021-04-07 14:16:05', '', 'JOHN', 269, 12, '2021-04-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-04-07 14:16:05', 1, '2021-04-14 05:00:01'),
(10665, 20090, '', '10665', 'E', 1, '<p>\n	HR Installation</p>\n', '2021-03-30 08:13:30', '', 'JOHN', 269, 12, '2021-07-05', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-30 08:13:30', 1, '2021-07-05 05:00:02'),
(10666, 20013, '', '10666', 'E', 0, '<p>\n	Kindly register COO <strong><span style=\"background-color:#ffff00;\">BOSNIA &amp; HERZEGOVINA</span></strong> (BA) in Purchase Order - Convert to material receipt</p>\n', '2021-03-31 12:25:57', '', 'Rhealiza G', 37, 12, '2021-03-31', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2021-03-31 12:25:57', 69, '2021-03-31 17:34:12'),
(10667, 20048, '', '10667', 'E', 1, '<p>\n	Please clear File no: 2877, purchase order: 600191.</p>\n<p>\n	CRM is got stuck while submitting the purchase order-invoice. Now the purchase invoice is showing empty details</p>\n', '2021-03-31 16:09:07', '2877-600191.pdf', 'Subi S', 142, 12, '2021-04-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 55, '2021-03-31 16:09:07', 1, '2021-04-07 05:00:01'),
(10668, 20089, '', '10668', 'I', 1, '<p>\n	Software Implementation&nbsp;</p>\n', '2021-03-31 19:14:00', '', 'mereenak', 266, 12, '2021-04-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-03-31 19:14:00', 69, '2021-04-01 08:31:56'),
(10669, 20004, '', '10669', 'E', 1, '<p>\n	https://ymgflogistics.azurewebsites.net</p>\n<p>\n	Outbound (LS menu)- &gt; Pre Invoice (Sub Menu) -</p>\n<p>\n	click + Sign on right top</p>\n<p>\n	Delivery Term Dropdown should have an extra &quot; FCA&quot; and also by default, Now FOB is default</p>\n<p>\n	<span style=\"color:#ff0000;\">NB: NOT coming from a master</span></p>\n', '2021-04-01 16:52:25', 'Yamaha010421.jpg', 'JOHN', 11, 12, '2021-04-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-04-01 16:52:25', 1, '2021-04-11 05:00:02'),
(10670, 20002, '', '10670', 'E', 1, '<p>\n	Please look the issue , see ttached file</p>\n', '2021-04-03 09:52:35', 'norden030421.png', 'JOHN', 5, 12, '2021-06-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-04-03 09:52:35', 1, '2021-06-20 05:00:01'),
(10671, 20067, '', '10671', 'I', 1, '<p>\n	Sales/ Service Quotaion, Sales/ Service&nbsp; order, Sales/ Service invoice &ndash; payment term lock- only change from customer by Finance</p>\n', '2021-04-05 09:50:23', '', 'JOHN', 200, 12, '2021-04-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-04-05 09:50:23', 1, '2021-04-13 05:00:02'),
(10672, 20019, '', '10672', 'E', 1, '<p>\n	New ESell Database Creation</p>\n<p>\n	<strong>Create admin@afbh&nbsp; , admin@nibak , admin@IS2023</strong></p>\n', '2021-04-05 15:48:22', '', 'JOHN', 56, 12, '2021-04-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-04-05 15:48:22', 1, '2021-04-13 05:00:02'),
(10673, 20095, '', '10673', 'E', 1, '<p>\n	HR Instalation</p>\n', '2021-04-05 17:23:16', '', 'JOHN', 284, 12, '2021-07-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-04-05 17:23:16', 1, '2021-07-09 05:00:06'),
(10675, 20019, '', '10675', 'E', 1, '<p>\n	VIOlLA HR<br />\n	server current time API<br />\n	locatiom login time, geo cordinates, is recognised etcAPI</p>\n', '2021-04-07 16:40:49', '', 'JOHN', 56, 12, '2021-05-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-04-07 16:40:49', 1, '2021-05-23 05:00:02'),
(10676, 20071, '', '10676', 'I', 1, '<p>\n	1. Birthday Wishes -- email sending</p>\n', '2021-04-07 21:19:55', '', 'mereenak', 212, 12, '2021-05-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-04-07 21:19:55', 1, '2021-05-23 05:00:02'),
(10677, 20019, '', '10677', 'E', 1, '<p>\n	E Sell</p>\n<p>\n	Finance - &gt;Cost of sale Report &ndash; MUOM not taking care Inv 3139, 3140 admin@demo01 login</p>\n', '2021-04-08 14:58:07', '', 'JOHN', 56, 2, '2021-04-08', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2021-04-08 14:58:07', 69, '2021-04-08 14:58:18'),
(10678, 20096, '', '10678', 'E', 1, '<p>\n	E Sell Instalation and checking</p>\n', '2021-04-11 08:12:46', '', 'JOHN', 287, 12, '2021-05-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-04-11 08:12:46', 1, '2021-05-23 05:00:02'),
(10679, 20002, '', '10679', 'E', 0, '<p>\n	Hi John,<br />\n	I&#39;m not able to create a new part number in CRM, after saving the part number display shows the processing screen too long and not completing the saving process. Kindly sort the issue. Screenshot attached for reference.<br />\n	Regards,<br />\n	Tebin.</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 10576 characters]\" /></p>\n', '2021-04-15 10:09:10', '183.png', 'Tebin Kalam', 5, 12, '2021-04-21', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 9, '2021-04-15 10:09:10', 1, '2021-04-21 05:00:01'),
(10680, 20019, '', '10680', 'E', 1, '<p>\n	Current cost report- Needs total at bottom, in html/pdf/excel</p>\n<p>\n	A new report needed - sales profit report</p>\n<p>\n	filters - salesman, date from , date to</p>\n<p>\n	date, invoice number, salaman, customer, invoice amout without vat, cost, profit, profit %</p>\n', '2021-04-21 12:25:49', '', 'JOHN', 56, 2, '2021-04-21', 0, '0000-00-00', '', 0, '0', '', '30003', 0, 0, '', '', 69, '2021-04-21 12:25:49', 69, '2021-04-21 12:26:01'),
(10681, 20014, '', '10681', 'I', 1, '<p>\n	https://blueskylogistics.me/waddah/index.php?r=site/login</p>\n<p>\n	username : nimda123 and its password</p>\n<p>\n	go to finance</p>\n<p>\n	Data table error</p>\n', '2021-04-22 12:11:39', '', 'JOHN', 41, 12, '2021-04-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-04-22 12:11:39', 1, '2021-04-30 05:00:04'),
(10682, 20065, '', '10682', 'E', 1, '<p>\n	Software Upgradation, Data Porting, New branch and Employee Add</p>\n', '2021-04-22 12:54:57', '', 'JOHN', 194, 12, '2021-07-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-04-22 12:54:57', 1, '2021-07-16 05:00:05'),
(10683, 20013, '', '10683', 'E', 1, '<p>\n	Hi,</p>\n<p>\n	In inventory module, when checking Purchase history, it does not show the PO number, it only shows the Inv no. Please include the PO number also.</p>\n<p>\n	https://cumuluserp.me/topnet/index.php?r=inventory/index&nbsp;</p>\n<p>\n	See attached</p>\n<p>\n	Similarly, in the same inventory module, for Sales History, we need the SO number to be shown as well. It only shows the Inv, this is not enough.&nbsp;</p>\n<p>\n	Thanks and regards,</p>\n<p>\n	Ganesan</p>\n<p>\n	&nbsp;</p>\n', '2021-04-23 11:03:49', 'Screenshot 2021-04-23 at 11.00.11 (2).png', 'Ganesan K.', 38, 2, '2021-04-26', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 20, '2021-04-23 11:03:49', 69, '2021-04-26 07:52:56'),
(10684, 20097, '', '10684', 'I', 1, '<p>\n	Software Implementation</p>\n', '2021-04-26 22:04:29', '', 'mereenak', 290, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30004,30005', 0, 0, '', '', 478, '2021-04-26 22:04:29', 1, '2022-07-29 05:00:04'),
(10685, 20048, '', '10685', 'E', 1, '<p>\n	One of our product ENV-HBU5M-80R-89&nbsp; is completely &nbsp;billed out and as per CRM report its showing &ldquo;0&rdquo;&nbsp; Nos . But &nbsp;in inventory its showing &nbsp;still &nbsp;&ldquo;30 &ldquo; &nbsp;nos as free quantity</p>\n', '2021-04-27 12:51:49', '', 'Subi S', 142, 12, '2021-05-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 55, '2021-04-27 12:51:49', 1, '2021-05-23 05:00:02'),
(10686, 20004, '', '10686', 'E', 1, '<p>\n	Implement Duo Security</p>\n', '2021-04-26 15:47:36', '', 'JOHN', 11, 12, '2021-06-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-04-27 15:47:36', 1, '2021-06-20 05:00:01');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10698, 20002, '', '10698', 'E', 1, '<p>\n	As informed please do the needful to transfer the below &nbsp;item- 2pc &nbsp;from service stock to main stock.</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 24528 characters]\" /></p>\n', '2021-05-31 08:40:50', '', 'JOHN', 5, 12, '2021-06-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-05-31 08:40:50', 1, '2021-06-07 05:00:02'),
(10687, 20004, '', '10687', 'I', 1, '<p>\n	https://ymgflogistics.azurewebsites.net/index.php?r=reports/transaction_history<br />\n	username:RB309740; Anas@123</p>\n<p>\n	item vaz 1580 not connecting eventhough item in stock</p>\n<p>\n	want to hide some user groups</p>\n', '2021-05-09 11:33:50', '', 'JOHN', 11, 12, '2021-06-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-05-09 11:33:50', 1, '2021-06-14 05:00:01'),
(10688, 20048, '', '10688', 'E', 1, '<p>\n	Please change the values from &quot;Additions&quot; and &quot;Hndling Charges&quot; to zero from the file ID :1587.</p>\n<p>\n	Purchase Invoice :222</p>\n<p>\n	<span style=\"font-family: Arial, Helvetica, sans-serif; font-size: small;\">&quot;Purchase -&gt; Bonded operations -&gt; Purchase bonded invoice&quot;</span></p>\n', '2021-05-12 17:27:16', 'PurchaseInvoice 222.pdf', 'Subi S', 142, 12, '2021-05-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 55, '2021-05-12 17:27:16', 1, '2021-05-23 05:00:02'),
(10689, 20067, '', '10689', 'E', 1, '<p>\n	1. When we prepare the sales order - can you show the quantity in the side for the sales team to&nbsp; select the item which is having stock? It is hard that after selecting the item and check if the selected item have stock or not.</p>\n<p>\n	2. Can you add LPO column here.</p>\n', '2021-05-17 15:13:18', 'WhatsApp Image 2021-05-17 at 2.58.33 PM.jpeg,WhatsApp Image 2021-05-17 at 2.58.39 PM.jpeg', 'JOHN', 200, 12, '2021-05-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-05-17 15:13:18', 1, '2021-05-23 05:00:02'),
(10691, 20001, '', '10691', 'I', 1, '<p>\n	Annual Leave Insertion</p>\n<p>\n	<strong>Ace Annual Leave insertion</strong></p>\n<p>\n	Pedru - 14th Jan to 15th Feb</p>\n<p>\n	Lawrence - 16th Jan 15th Feb</p>\n<p>\n	Sohail -&nbsp; 17th Feb to 24 Feb</p>\n<p>\n	Zubair - 02nd Jan to 04th March</p>\n<p>\n	Bharat - 06th Feb to 07th March</p>\n<p>\n	Sujay - March 29-31</p>\n<p>\n	<strong>Kindly mark as Present - following</strong></p>\n<p>\n	Jomin 14th and 15th April</p>\n<p>\n	&nbsp;</p>\n', '2021-05-17 08:15:06', '', 'JOHN', 2, 12, '2021-05-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-05-18 08:15:06', 1, '2021-05-24 05:00:01'),
(10692, 20006, '', '10692', 'E', 1, '<p>\n	So many duplicate policies &nbsp;posting in accounts. Here is a sample for you &hellip; Please sort it out and update</p>\n', '2021-05-18 17:02:26', 'jimage001.png', 'JOHN', 17, 12, '2021-05-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-05-18 17:02:26', 1, '2021-05-26 05:00:02'),
(10693, 20071, '', '10693', 'E', 1, '<p>\n	HR Attendance - Pushing Arrangements</p>\n', '2021-05-20 08:20:34', '', 'JOHN', 212, 12, '2021-06-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-05-20 08:20:34', 1, '2021-06-20 05:00:01'),
(10694, 20043, '', '10694', 'E', 1, '<p>\n	Carrefour - Mobile App- Visitor Management</p>\n', '2021-05-20 08:23:15', '', 'JOHN', 128, 12, '2022-01-14', 0, '0000-00-00', '', 0, '0', '', '30004', 0, 0, '', '', 69, '2021-05-20 08:23:15', 1, '2022-01-14 06:00:07'),
(10696, 20082, '', '10696', 'E', 1, '<p>\n	CRM Mobile App for Property</p>\n', '2021-05-24 17:07:33', '', 'JOHN', 245, 2, '2021-05-24', 0, '0000-00-00', '', 0, '0', '', '30004', 0, 0, '', '', 69, '2021-05-24 17:07:33', 69, '2021-05-24 17:07:53'),
(10697, 20048, '', '10697', 'E', 1, '<p>\n	&quot;ENR-16128 - N-USK&quot; Please remove space before and after&nbsp; second &quot;-&quot;</p>\n', '2021-05-27 14:52:51', '', 'Subi S', 142, 12, '2021-06-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 55, '2021-05-27 14:52:51', 1, '2021-06-16 05:00:02'),
(10699, 20067, '', '10699', 'E', 1, '<p>\n	<strong>Diatech</strong>- in sales quotation, depending on the cost view permission</p>\n<p>\n	&ndash; if cost view is off, for dummy items and local items show cost and international items don&rsquo;t show cost</p>\n<p>\n	-if cost view is On, for dummy items and local items show cost and international items also show cost</p>\n', '2021-05-31 10:26:23', '', 'JOHN', 200, 12, '2021-06-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-05-31 10:26:23', 1, '2021-06-18 05:00:06'),
(10700, 20067, '', '10700', 'E', 1, '<p>\n	<strong>Diatech</strong> &ndash; When creating quotation using dummy products and saved. They cannot edit the description any more. Please open it</p>\n', '2021-05-31 10:26:48', '', 'JOHN', 200, 12, '2021-06-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-05-31 10:26:48', 1, '2021-06-18 05:00:06'),
(10701, 20067, '', '10701', 'E', 1, '<p>\n	<strong>Diatech</strong>- upon Revision, hang the old pdf to documents in quotation- After the final approval if hang the pdf print with file name qtn No, next Qtn No(1), next Qtn No (2) etc</p>\n', '2021-05-31 10:27:10', '', 'JOHN', 200, 12, '2021-06-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-05-31 10:27:10', 1, '2021-06-13 05:00:01'),
(10717, 20067, '', '10717', 'I', 1, '<div>\n	Previous rate info not showing&nbsp;</div>\n<div>\n	&nbsp;</div>\n<div>\n	Customer name : Al Garhoud Hospital</div>\n<div>\n	NTRPF-1008 - they purchased from us before but not showing here</div>\n', '2021-06-10 21:51:07', 'WhatsApp Image 2021-06-10 at 12.12.38 PM.jpeg,WhatsApp Image 2021-06-10 at 12.12.43 PM.jpeg,WhatsApp Image 2021-06-10 at 12.12.45 PM.jpeg', 'mereenak', 200, 12, '2021-06-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-06-10 21:51:07', 1, '2021-06-18 05:00:06'),
(10702, 20067, '', '10702', 'E', 1, '<p>\n	Report for salary paid via cheque, cashm wps and exchange- WPS entity and month wise</p>\n', '2021-05-31 12:01:26', '', 'JOHN', 200, 12, '2021-06-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-05-31 12:01:26', 1, '2021-06-07 05:00:02'),
(10703, 20060, '', '10703', 'E', 1, '<p>\n	Zemeydacademy.com changed to zemydacademy.net</p>\n', '2021-05-31 17:12:17', '', 'JOHN', 179, 12, '2021-06-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-05-31 17:12:17', 1, '2021-06-20 05:00:01'),
(10704, 20067, '', '10704', 'E', 1, '<p>\n	Invoice header report every page repeat</p>\n<p>\n	customer trn# should come in one stretch</p>\n<p>\n	&nbsp;</p>\n', '2021-06-01 09:02:34', 'TAX INVOICE - 44141.pdf,DA 41770.pdf', 'JOHN', 200, 12, '2021-06-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-01 09:02:34', 1, '2021-06-18 05:00:06'),
(10705, 20061, '', '10705', 'E', 1, '<p>\n	Create 2 outlets under Al Baraka Dates with following details (Like al zoubi, fresh apple etc)</p>\n<p>\n	TRN number not received till now</p>\n<p>\n	create the account check the UOM, etc and try one invoice</p>\n<p>\n	Company No:1<br />\n	Company Name: BUSTAN ALRAIHAN GENERAL TRADING LLC<br />\n	Address: Warehouse No:5, Industrial Area-3, Al Qusais, Duabi - UAE<br />\n	TRN:0<br />\n	Phone No: +971 50 152 3510<br />\n	Email: alraihanbustan@gmail.com<br />\n	Users: 1-admin and 1-Sales user<br />\n	<br />\n	Company No:2<br />\n	Company Name: RUKN ALAJWA FOOD &amp; BEVERAGES TRADING<br />\n	Address: Warehouse No:5, Industrial Area-3, Al Qusais, Duabi - UAE<br />\n	TRN:0<br />\n	Phone No: +971 55 152 8052<br />\n	Email: ruknalajwa@gmail.com<br />\n	Users: 1-admin and 1-Sales user</p>\n', '2021-06-01 09:11:15', '', 'JOHN', 182, 12, '2021-06-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-01 09:11:15', 1, '2021-06-08 05:00:02'),
(10706, 20012, '', '10706', 'E', 1, '<p>\n	Annual Leave opening correction inorder to match their closing balance</p>\n', '2021-06-01 10:09:01', 'Tetra Leave Clarification1.xlsx', 'JOHN', 35, 12, '2021-06-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-01 10:09:01', 1, '2021-06-07 05:00:02'),
(10707, 20067, '', '10707', 'E', 1, '<p>\n	Invoice Header Correction - Second Page</p>\n', '2021-06-02 11:26:51', '', 'JOHN', 200, 12, '2021-06-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-02 11:26:51', 1, '2021-06-16 05:00:02'),
(10708, 20002, '', '10708', 'E', 1, '<p>\n	Stock ageing Report - Amount Wise Wrong<br />\n	but quantity wise is correct</p>\n', '2021-06-02 12:46:07', '', 'JOHN', 5, 2, '2021-12-27', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2021-06-02 12:46:07', 69, '2021-12-27 09:28:29'),
(10709, 20081, '', '10709', 'E', 1, '<p>\n	in customer statement pdf (the one with the graph) needs Bank details</p>\n', '2021-06-05 08:41:49', '', 'JOHN', 242, 12, '2021-06-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-05 08:41:49', 1, '2021-06-14 05:00:01'),
(10710, 20067, '', '10710', 'E', 1, '<p>\n	Service invoice also like sales invoice</p>\n<p>\n	Header repeating to second page</p>\n', '2021-06-06 15:40:36', '', 'JOHN', 200, 12, '2021-06-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-06 15:40:36', 1, '2021-06-16 05:00:02'),
(10711, 20067, '', '10711', 'E', 1, '<p>\n	Sales invoice design error invoice 44647</p>\n', '2021-06-06 15:43:13', 'WhatsApp Image 2021-06-06 at 3.35.00 PM.jpeg', 'JOHN', 200, 12, '2021-06-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-06 15:43:13', 1, '2021-06-13 05:00:01'),
(10716, 20067, '', '10716', 'E', 1, '<p>\n	Delivery date by default 3 days not 30 days<br />\n	Quotation validity by default 7 days not 30 days.<br />\n	Purchase order default validity need to change from 30 days to 3 days</p>\n', '2021-06-10 08:53:24', '', 'JOHN', 200, 12, '2021-06-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-10 08:53:24', 1, '2021-06-18 05:00:06'),
(10712, 20004, '', '10712', 'E', 1, '<p>\n	Balance Quantity Showing in Invoice</p>\n', '2021-06-07 09:57:30', '', 'JOHN', 11, 2, '2021-06-07', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2021-06-07 09:57:30', 69, '2021-06-07 09:59:40'),
(10713, 20067, '', '10713', 'E', 1, '<p>\n	Inventory - Creattion- On Approval they want to change the brand&nbsp; and then approve</p>\n', '2021-06-07 09:58:37', '', 'JOHN', 200, 12, '2022-03-12', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2021-06-07 09:58:37', 1, '2022-03-12 06:00:02'),
(10714, 20028, '', '10714', 'E', 1, '<p>\n	HR posting Response</p>\n', '2021-06-07 10:00:23', '', 'JOHN', 83, 2, '2021-06-07', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2021-06-07 10:00:23', 69, '2021-06-07 10:00:34'),
(10715, 20048, '', '10715', 'E', 1, '<p>\n	<span style=\"font-family: Arial, Helvetica, sans-serif; font-size: small;\">Please change the base cost price of ENV-HVD5F-30R-20.</span></p>\n', '2021-06-07 11:16:50', '', 'Subi S', 142, 12, '2021-06-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 55, '2021-06-07 11:16:50', 1, '2021-06-28 05:00:02'),
(10718, 20065, '', '10718', 'E', 1, '<p>\n	<strong>Magnum</strong>- Shamsudeen &ndash; Jafza 15/05/21 12 hours not showing in his ESS</p>\n<p>\n	<strong>Magnum-</strong>Document &ndash; Bulk upload &ndash; not possible</p>\n<p>\n	<strong>Magnum-</strong>Holiday/ weekend how considering in womm, jafza and hafza</p>\n<p>\n	<strong>Magnum-</strong>Alternate Saturday off- Difficult to amend</p>\n<p>\n	<strong>Magnum-</strong>Shamsudden Friday working -1 hour lunch is not reduced In OT</p>\n<p>\n	<strong>Magnum-</strong>Enable Dashboard</p>\n<p>\n	<strong>Magnum-</strong>Meeting / suggestion, closing date, status, and remarks needed</p>\n<p>\n	<strong>Magnum-</strong> Dash board- Leave applied / Approved for Today</p>\n<p>\n	<strong>Magnum- </strong>Any way to incorporate mid day break 12:30 to 3:30 in summer</p>\n', '2021-06-12 11:40:45', '', 'JOHN', 194, 12, '2021-06-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-12 11:40:45', 1, '2021-06-29 05:00:02'),
(10719, 20002, '', '10719', 'E', 1, '<p>\n	Brand Class Report</p>\n<p>\n	Date filter also Needed</p>\n<p>\n	Check Excel and Pdf</p>\n', '2021-06-13 09:34:34', '', 'JOHN', 5, 12, '2021-06-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-13 09:34:34', 1, '2021-06-27 05:00:01'),
(10720, 20013, '', '10720', 'E', 1, '<p>\n	There is error in BC amount.&nbsp;</p>\n', '2021-06-14 08:44:10', 'BC Value-14-06-2021.jpg', 'Rajesh C', 37, 12, '2021-06-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2021-06-14 08:44:10', 1, '2021-06-20 05:00:01'),
(10721, 20002, '', '10721', 'E', 1, '<p>\n	Dear John,</p>\n<p>\n	Please find attached the screenshots, File 41012 / 137098 / Vtech Engineering Systems LLC showing wrong incentive margin calculation.</p>\n<p>\n	Please rectify the issue.</p>\n<p>\n	Regards,</p>\n<p>\n	Tebin</p>\n<p>\n	0559972176</p>\n<p>\n	043926391</p>\n', '2021-06-14 09:21:39', 'Margin Calculation V Tech.png,116.png,2.png', 'Tebin Kalam', 4, 12, '2021-06-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 9, '2021-06-14 09:21:39', 1, '2021-06-20 05:00:01'),
(10722, 20013, '', '10722', 'I', 1, '<p>\n	Please lock <strong>Exchange rate to 1 </strong>when currency is <strong>AED</strong></p>\n<p>\n	@Quotation, Order and Invoice</p>\n', '2021-06-14 15:31:32', '', 'JOHN', 38, 12, '2022-02-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-14 15:31:32', 1, '2022-02-10 06:00:02'),
(10723, 20071, '', '10723', 'E', 1, '<p>\n	Mail dated 13/06/21 and 14/06/21</p>\n', '2021-06-14 17:46:26', '', 'JOHN', 212, 12, '2021-06-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-14 17:46:26', 1, '2021-06-23 05:00:02'),
(10724, 20065, '', '10724', 'E', 1, '<p>\n	Internal Job Vacancy Posting in HR portal</p>\n<p>\n	Job posting details as below: with an end date, put edit option also, to change some thing, but one mail once<br />\n	Position -<br />\n	Dept -<br />\n	Experience required-<br />\n	Description -<br />\n	Remarks -</p>\n<p>\n	<br />\n	notify all employees by mail and notifcation</p>\n<p>\n	Employee ESS employe can view it</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n', '2021-06-14 17:50:30', '', 'JOHN', 194, 12, '2021-06-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-14 17:50:30', 1, '2021-06-23 05:00:02');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10725, 20002, '', '10725', 'E', 1, '<p>\n	Dear John,</p>\n<p>\n	Please help me to sort below concern.</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65424 characters]', '2021-06-15 10:29:01', '', 'Tebin Kalam', 5, 12, '2021-06-21', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 9, '2021-06-15 10:29:01', 1, '2021-06-21 05:00:01');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10726, 20019, '', '10726', 'E', 1, '<p>\n	Face recognition researchon Android</p>\n', '2021-06-15 17:33:26', '', 'JOHN', 56, 12, '2021-06-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-15 17:33:26', 1, '2021-06-23 05:00:02'),
(10727, 20028, '', '10727', 'E', 1, '<p>\n	Financial Year closing</p>\n', '2021-06-17 16:57:33', 'year close.png', 'JOHN', 83, 12, '2021-06-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-17 16:57:33', 1, '2021-06-27 05:00:01'),
(10728, 20071, '', '10728', 'E', 1, '<p>\n	17/06/21 Mails and Isues</p>\n', '2021-06-17 17:58:01', '', 'JOHN', 212, 12, '2021-06-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-17 17:58:01', 1, '2021-06-25 05:00:06'),
(10729, 20074, '', '10729', 'E', 1, '<p>\n	17/06/21 - Salary view - permission</p>\n', '2021-06-17 17:58:39', '', 'JOHN', 221, 12, '2021-06-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-17 17:58:39', 1, '2021-06-25 05:00:06'),
(10730, 20097, '', '10730', 'E', 1, '<p>\n	HR Implementation</p>\n', '2021-06-19 09:57:29', '', 'JOHN', 290, 12, '2021-12-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-19 09:57:29', 1, '2021-12-28 06:00:03'),
(10731, 20067, '', '10731', 'E', 1, '<p>\n	Net sales report need &quot;Emirate&quot; Filter</p>\n', '2021-06-19 10:30:27', '', 'JOHN', 200, 12, '2021-06-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-19 10:30:27', 1, '2021-06-27 05:00:01'),
(10732, 20067, '', '10732', 'E', 1, '<p>\n	Cost of sales report needed, include one filter samples, which means invoice amout zero</p>\n', '2021-06-19 10:31:14', '', 'JOHN', 200, 12, '2021-07-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-19 10:31:14', 1, '2021-07-03 05:00:02'),
(10735, 20067, '', '10735', 'E', 1, '<p>\n	Purchase Order and Purchase Invoice - Address coming wrong from location also</p>\n', '2021-06-21 10:21:29', '', 'JOHN', 200, 12, '2021-06-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-21 10:21:29', 1, '2021-06-28 05:00:02'),
(10733, 20004, '', '10733', 'I', 1, '<p>\n	Vulnerablties check</p>\n', '2021-06-19 20:15:33', '', 'mereenak', 11, 12, '2022-03-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-06-19 20:15:33', 1, '2022-03-07 06:00:02'),
(10734, 20021, '', '10734', 'E', 1, '<p>\n	Annual Leave Deletion (Due to Journey cancel)</p>\n', '2021-06-20 15:05:59', '', 'JOHN', 62, 12, '2021-06-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-20 15:05:59', 1, '2021-06-28 05:00:02'),
(10736, 20002, '', '10736', 'E', 1, '<p>\n	Item code: 3108-31004OS2CL</p>\n<p>\n	Allocation Error</p>\n<p>\n	&nbsp;</p>\n', '2021-06-21 14:39:00', '', 'JOHN', 5, 12, '2021-06-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-21 14:39:00', 1, '2021-06-28 05:00:02'),
(10737, 20019, '', '10737', 'I', 1, '<p>\n	Absent / Leave</p>\n', '2021-06-22 08:51:21', '', 'JOHN', 56, 2, '2021-06-22', 0, '0000-00-00', '', 0, '0', '', '30005,30002,30003,30004,30006,30012,30014', 0, 0, '', '', 69, '2021-06-22 08:51:21', 69, '2021-11-15 12:48:14'),
(10738, 20002, '', '10738', 'E', 1, '<p>\n	LPO amount change</p>\n', '2021-06-22 17:14:51', 'WhatsApp Image 2021-06-22 at 4.25.35 PM.jpeg', 'JOHN', 5, 12, '2021-06-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-22 17:14:51', 1, '2021-06-29 05:00:02'),
(10739, 20002, '', '10739', 'E', 1, '<p>\n	Run a cron Job to deallocate the items allocated in quotation after the quatation validity is over</p>\n<p>\n	&nbsp;</p>\n<p>\n	Reference to the phone conversation yesterday please note that quotation allocation is not cancelling automatic after the quotation validity as you said yesterday. Please find below screen shot&nbsp; and refer File id 38740- Fasal Muhammed Al Onizi cont, which quotation validity is up to 05.01.2021 only but in inventory still showing allocated. Please check and rectify</p>\n', '2021-06-22 17:21:22', 'nimage004.png,nimage006.jpg,nimage005.jpg', 'JOHN', 5, 2, '2021-06-22', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2021-06-22 17:21:22', 69, '2021-06-22 17:21:41'),
(10740, 20065, '', '10740', 'E', 1, '<p>\n	Timesheet Project</p>\n', '2021-06-23 08:44:47', '', 'JOHN', 194, 12, '2022-05-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-23 08:44:47', 1, '2022-05-02 05:00:02'),
(10741, 20071, '', '10741', 'E', 1, '<p>\n	Viola issues came through E mail dt 22/06/021 and backwards</p>\n', '2021-06-23 16:44:57', '', 'JOHN', 212, 12, '2021-07-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-23 16:44:57', 1, '2021-07-02 05:00:05'),
(10742, 20067, '', '10742', 'E', 1, '<p>\n	Payslip Modification<br />\n	EOS header Correction&nbsp; Branch wise</p>\n<p>\n	&nbsp;</p>\n', '2021-06-23 16:52:54', '', 'JOHN', 200, 12, '2021-07-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-23 16:52:54', 1, '2021-07-02 05:00:05'),
(10743, 20002, '', '10743', 'I', 1, '<p>\n	In sales order there is a print called &quot; Remaining Items Need to be picked&quot;</p>\n<p>\n	In that print , Total quantity, allocated qtyfor this order, allocated for other orders, Free qty<br />\n	Display as above</p>\n', '2021-06-23 17:15:14', '', 'JOHN', 5, 2, '2021-06-23', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2021-06-23 17:15:14', 69, '2021-06-23 17:15:27'),
(10744, 20065, '', '10744', 'E', 1, '<p>\n	Mail regarding OVERTIME 23/06/2021 12:10 pm</p>\n', '2021-06-23 08:14:45', '', 'JOHN', 194, 12, '2021-07-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-24 08:14:45', 1, '2021-07-04 05:00:01'),
(10745, 20019, '', '10745', 'E', 1, '<p>\n	Attendance Time Integration in Bluesky Support</p>\n', '2021-06-24 08:47:35', '', 'JOHN', 56, 12, '2022-02-06', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-24 08:47:35', 1, '2022-02-06 06:00:02'),
(10746, 20067, '', '10746', 'E', 1, '<p>\n	ACCOUNT RECEIVABLES in balancesheet one entry is like this np subledger could you please remove this one</p>\n', '2021-06-26 08:19:50', 'WhatsApp Image 2021-06-26 at 8.18.22 AM.jpeg', 'JOHN', 200, 2, '2021-06-26', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2021-06-26 08:19:50', 69, '2021-06-26 08:20:07'),
(10747, 20067, '', '10747', 'E', 1, '<p>\n	In balancesheet these two are no subledger items pls remove</p>\n<p>\n	Finance-report -balance sheet-accured salary</p>\n', '2021-06-27 08:03:42', 'WhatsApp Image 2021-06-26 at 1.19.51 PM.jpeg,WhatsApp Image 2021-06-26 at 1.19.50 PM.jpeg', 'JOHN', 200, 2, '2021-06-27', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2021-06-27 08:03:42', 69, '2021-06-27 08:04:05'),
(10748, 20019, '', '10748', 'E', 1, '<p>\n	E-Sell account creation</p>\n<p>\n	Company No:1<br />\n	Company Name: AL MANAR TRADING<br />\n	Address: PO Box: 4950, Fujairah - UAE<br />\n	TRN:100029544200003<br />\n	Phone No: +971 50 779 7065<br />\n	Email: almanarplasticfuj@gmail.com<br />\n	Users: 1-admin and 2-Sales users<br />\n	<br />\n	Company No:2<br />\n	Company Name: AL AHLAM AUTOMATIC BAKERY<br />\n	Address: PO Box: 3276, Ajman - UAE<br />\n	TRN:0<br />\n	Phone No: +971 6&nbsp; 743 7800<br />\n	Email: sales.alahlam@outlook.com<br />\n	Users: 2-admin users and 5-sales users</p>\n', '2021-06-28 10:13:48', 'Al Manar Inventory.xlsx,WhatsApp Image 2021-06-28 at 10.07.55 AM.jpeg,WhatsApp Image 2021-06-28 at 8.43.10 AM.jpeg', 'JOHN', 56, 2, '2021-06-28', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2021-06-28 10:13:48', 69, '2021-06-28 10:14:08'),
(10749, 20071, '', '10749', 'E', 1, '<p>\n	VIOLA HR Issues - Mail dated 27/06/21 &amp; 28/06/21 in hrteam@mailbluesky.com</p>\n', '2021-06-28 17:44:41', '', 'JOHN', 212, 12, '2021-07-05', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-28 17:44:41', 1, '2021-07-05 05:00:02'),
(10750, 20002, '', '10750', 'I', 1, '<p>\n	536 Material 2 material Error</p>\n', '2021-06-30 16:04:50', '', 'JOHN', 5, 12, '2021-07-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-30 16:04:50', 1, '2021-07-07 05:00:01'),
(10751, 20019, '', '10751', 'E', 1, '<p>\n	New Esell NIBAK<br />\n	NI2003<br />\n	NI2007<br />\n	NI1019<br />\n	change the End date 01/06/2022</p>\n', '2021-06-30 16:31:10', '', 'JOHN', 56, 12, '2021-07-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-06-30 16:31:10', 1, '2021-07-07 05:00:01'),
(10752, 20098, '', '10752', 'E', 1, '<p>\n	Logistics Software, Invoice updation etc</p>\n', '2021-06-30 17:08:19', '', 'JOHN', 293, 2, '2021-06-30', 0, '0000-00-00', '', 0, '0', '', '30005,30006', 0, 0, '', '', 69, '2021-06-30 17:08:19', 69, '2021-06-30 17:18:34'),
(10753, 20019, '', '10753', 'E', 1, '<p>\n	All HR with new approval Heirarchy<br />\n	<br />\n	please show &quot;Pending Approval request&quot; message in approval heirrrchy for the persons whose approval is on the way</p>\n', '2021-07-01 10:54:57', '', 'JOHN', 56, 12, '2021-07-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-01 10:54:57', 1, '2021-07-07 05:00:01'),
(10754, 20071, '', '10754', 'E', 1, '<p>\n	<strong>Viola -</strong>can we get a notification to Ara and myself for employees 3 month probation, say 1 month ahead? Or can we set ourselves</p>\n<p>\n	-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; There is a confirmation date for each employee. You can fill in that detail (Or we can make JOD=CONFIRM Date by coding) After filling the joining dates correctly, we can trigger a mail on daily basis whose confirmation date is nearing</p>\n<p>\n	<em>Viola- Notification for payment not required since they don&rsquo;t have loan</em></p>\n<p>\n	<strong>Viola </strong>&ndash; Ticket Rate master</p>\n', '2021-07-03 17:02:55', '', 'JOHN', 212, 12, '2021-07-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-03 17:02:55', 1, '2021-07-09 05:00:06'),
(10755, 20078, '', '10755', 'E', 1, '<p>\n	<strong><em>Moative</em></strong><em>- Can employee list report show basic and total salary</em></p>\n<p>\n	<em>Moative - Salary Slip - Amount in words correction</em></p>\n', '2021-07-03 17:03:46', '', 'JOHN', 233, 12, '2021-07-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-03 17:03:46', 1, '2021-07-09 05:00:06'),
(10756, 20067, '', '10756', 'E', 1, '<p>\n	Holiday Time Loss</p>\n', '2021-07-03 17:04:05', '', 'JOHN', 200, 12, '2021-07-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-03 17:04:05', 1, '2021-07-09 05:00:06'),
(10757, 20090, '', '10757', 'E', 1, '<p>\n	Shift filter, employee filter at MIJ shit</p>\n', '2021-07-03 17:05:11', '', 'JOHN', 269, 12, '2021-07-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-03 17:05:11', 1, '2021-07-09 05:00:06'),
(10758, 20074, '', '10758', 'E', 1, '<p>\n	Salary Variable component Edit affects the salary calculation problem</p>\n', '2021-07-05 10:29:28', '', 'JOHN', 221, 12, '2021-07-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-05 10:29:28', 1, '2021-07-12 05:00:02'),
(10759, 20078, '', '10759', 'E', 1, '<p>\n	Motive- In the report- Employee list &ndash; They need one coloumn category with a filter</p>\n<p>\n	Motive - Graph Modification</p>\n', '2021-07-06 12:33:08', '', 'JOHN', 233, 12, '2021-07-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-06 12:33:08', 1, '2021-07-30 05:00:03'),
(10760, 20071, '', '10760', 'E', 1, '<p>\n	Egypt - Time correction (2 Hours Less)</p>\n', '2021-07-06 17:01:11', '', 'JOHN', 212, 12, '2021-07-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-06 17:01:11', 1, '2021-07-14 05:00:02'),
(10761, 20067, '', '10761', 'E', 1, '<p>\n	Diatech - new order Analysis &ndash; search by item name also</p>\n<p>\n	Diatech - new order Analysis &ndash; modifying on their request</p>\n<p>\n	Diatech &ndash; Dashboard correction invoice count</p>\n', '2021-07-07 11:43:11', '', 'JOHN', 200, 12, '2021-07-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-07 11:43:11', 1, '2021-07-14 05:00:02'),
(10762, 20067, '', '10762', 'I', 1, '<p>\n	&nbsp;New order movement Analysis &ndash; Date opening and Displaying the vales of 30,90,180,360 sales count depending on the new date, current stock and upcoming quantity will remain static as of today</p>\n', '2021-07-08 08:52:25', '', 'JOHN', 200, 12, '2021-07-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-08 08:52:25', 1, '2021-07-16 05:00:05'),
(10763, 20001, '', '10763', 'I', 1, '<p>\n	<em>Item 20-04-00116 item purchased in Ark and transferred to Ace, Now costing part comes Negative &ndash; Whatsapp message dt 06/07/21 17:27pm</em></p>\n', '2021-07-08 08:55:20', 'WhatsApp Image 2021-07-07 at 3.30.55 PM.jpeg,WhatsApp Image 2021-07-07 at 3.30.56 PM.jpeg,WhatsApp Image 2021-07-07 at 3.33.14 PM.jpeg,WhatsApp Image 2021-07-06 at 4.06.00 PM.jpeg,WhatsApp Image 2021-07-06 at 4.07.11 PM.jpeg', 'JOHN', 2, 12, '2021-07-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-08 08:55:20', 1, '2021-07-16 05:00:05'),
(10764, 20001, '', '10764', 'I', 1, '<p>\n	Cost Issue (Negative while external transfer)</p>\n<p>\n	The attached image is only negative values they found<br />\n	please write code to find out any other negative value also<br />\n	Find out the root cause and change urgently</p>\n', '2021-07-08 11:14:56', 'WhatsApp Image 2021-07-08 at 11.06.02 AM.jpeg', 'JOHN', 2, 12, '2021-07-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-08 11:14:56', 1, '2021-07-17 05:00:02'),
(10765, 20019, '', '10765', 'E', 1, '<p>\n	Demo ERP work</p>\n', '2021-07-08 12:04:10', '', 'JOHN', 56, 12, '2022-07-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-08 12:04:10', 1, '2022-07-13 05:00:02'),
(10766, 20095, '', '10766', 'E', 1, '<p>\n	Saalry calculation</p>\n', '2021-07-08 17:14:39', '', 'JOHN', 284, 12, '2021-07-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-08 17:14:39', 1, '2021-07-16 05:00:05'),
(10767, 20019, '', '10767', 'E', 1, '<p>\n	Various HR- Correction of missing employees on sorting of encrypted names</p>\n', '2021-07-08 17:18:02', '', 'JOHN', 56, 12, '2021-12-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-08 17:18:02', 1, '2021-12-28 06:00:03'),
(10768, 20071, '', '10768', 'I', 1, '<p>\n	Viola- Can the leave delete button before first approval can be provided at Admin level- when deleting inform the applicant and HR via a mail(with a static body), so that later there will be no confusion</p>\n', '2021-07-08 17:57:42', '', 'JOHN', 212, 12, '2021-07-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-08 17:57:42', 1, '2021-07-16 05:00:05'),
(10769, 20067, '', '10769', 'I', 1, '<p>\n	Dash board Invoice Graph - Split into two, 1, sales 2. Credit note</p>\n', '2021-07-10 08:57:31', '', 'JOHN', 200, 12, '2021-07-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-10 08:57:31', 1, '2021-07-16 05:00:05'),
(10770, 20067, '', '10770', 'E', 1, '<p>\n	Salary Cutting based on timing</p>\n<p>\n	8:00- 18:00 -No cutting<br />\n	7:00-18:10 -No cutting<br />\n	8:10-18:10 -10 min cutting<br />\n	8:00-17:00-1 Hour cutting<br />\n	8:10-17:50- 20 minute cutting</p>\n', '2021-07-10 10:21:39', '', 'JOHN', 200, 12, '2021-07-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-10 10:21:39', 1, '2021-07-30 05:00:03'),
(10771, 20067, '', '10771', 'I', 1, '<p>\n	HIS ONE HOW COME UNDER HUZEFA NAME SIR.ITS MR.SHABAB CLIENT</p>\n<p>\n	when using the add function in invoice to merge more than one DO to invoice- instead of Lead owner, login user was taken as Lead owner<br />\n	correct the lead owner, unpost and post</p>\n', '2021-07-11 08:40:25', 'WhatsApp Image 2021-07-11 at 8.21.59 AM.jpeg', 'JOHN', 200, 12, '2021-07-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-11 08:40:25', 1, '2021-07-17 05:00:02'),
(10772, 20099, '', '10772', 'E', 1, '<p>\n	HR Implementation</p>\n', '2021-07-11 09:34:51', '', 'JOHN', 296, 12, '2022-01-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-11 09:34:51', 1, '2022-01-12 06:00:02'),
(10773, 20077, '', '10773', 'E', 1, '<p>\n	Copy Program and Database&nbsp; to Ista&#39;s local server</p>\n', '2021-07-11 11:49:43', '', 'JOHN', 230, 12, '2021-07-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-11 11:49:43', 1, '2021-07-18 05:00:02'),
(10774, 20037, '', '10774', 'E', 1, '<p>\n	an you please do the needful to cancel below DNs in BS system</p>\n', '2021-07-12 09:35:13', 'image001120721.png', 'JOHN', 110, 12, '2021-07-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-12 09:35:13', 1, '2021-07-18 05:00:02'),
(10775, 20067, '', '10775', 'E', 1, '<p>\n	Dashboard - Graphs- Sales and Credit note percentage displaying</p>\n', '2021-07-12 15:11:35', '', 'JOHN', 200, 12, '2021-07-19', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-12 15:11:35', 1, '2021-07-19 05:00:02'),
(10776, 20067, '', '10776', 'E', 1, '<p>\n	Un post these in finance Inv 44974, CN50387, CN50422, Inv 47852</p>\n<p>\n	Invoice No 44974 File id: 16814 &ndash; Amount 87000</p>\n<p>\n	CN No 50387 File id: 16814 &ndash; Amount 34800</p>\n<p>\n	CN No 50422 File id: 16814 &ndash; Amount 52200</p>\n<p>\n	They created a new invoice 47852 file id:20075 dt 10/07/2021 with amount 87000</p>\n<p>\n	Swap the invoice numbers and file id</p>\n<p>\n	After that Inv 47852 dt file id:&nbsp; 16814will be 10/07/21</p>\n<p>\n	Inv 44974 file id :20075 dt will be 21/06/21</p>\n<p>\n	post these in finance Inv 44974, CN50387, CN50422, Inv 47852</p>\n', '2021-07-13 12:31:46', 'Diatech Invoice date cahnge.xlsx', 'JOHN', 200, 12, '2021-07-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-13 12:31:46', 1, '2021-07-20 05:00:02');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10777, 20002, '', '10777', 'E', 1, '<p>\n	Dear John,</p>\n<p>\n	Please help me to amend below item unit price to <span style=\"background-color:#ffff00;\">274.52 .</span></p>\n<p>\n	&nbsp;</p>\n<p>\n	Line item 2 -1323-428813BK- 42U 800 x 800 Floor Standing Cabinet F/Glass B/Perforated</p>\n<p>\n	<span style=\"background-color:#ffff00;\">LPO Ref: 601210</span></p>\n<p>\n	&nbsp;</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65158 characters]', '2021-07-13 16:45:53', 'norden LPO edit.xlsx', 'Tebin Kalam', 5, 12, '2021-07-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 9, '2021-07-13 16:45:53', 1, '2021-07-20 05:00:02');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(10778, 20078, '', '10778', 'E', 1, '<p>\n	Confirmation Date = DOJ+180 for every body<br />\n	when changing the DOJ change the Date of confirmation On change<br />\n	when Adding new employe DOC filled automatically<br />\n	in employee upload from csv , DOC updated automatically</p>\n', '2021-07-13 16:51:40', '', 'JOHN', 233, 12, '2021-07-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-13 16:51:40', 1, '2021-07-30 05:00:03'),
(10779, 20002, '', '10779', 'I', 1, '<p>\n	Hide old delivery orders only from screen window- no need of Year 2014 and 2016</p>\n', '2021-07-13 17:55:35', 'norden 130721-01.png', 'JOHN', 5, 12, '2021-07-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-13 17:55:35', 1, '2021-07-20 05:00:02'),
(10780, 20019, '', '10780', 'E', 1, '<p>\n	Bluesky HRMS - Module converting</p>\n', '2021-07-14 09:51:16', '', 'JOHN', 56, 12, '2022-03-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-14 09:51:16', 1, '2022-03-10 06:00:01'),
(10781, 20067, '', '10781', 'I', 1, '<p>\n	Mail Points 14/07/2021</p>\n', '2021-07-15 17:24:01', 'Diatech Issues Mail 140721.xlsx', 'JOHN', 200, 12, '2022-07-13', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2021-07-15 17:24:01', 1, '2022-07-13 05:00:02'),
(10782, 20090, '', '10782', 'E', 1, '<p>\n	<strong><em>MIJ- They want branch name in company document </em></strong></p>\n<p>\n	<strong><em>Reset all the approval levels because, no leave encashment are no where</em></strong></p>\n', '2021-07-15 17:28:39', '', 'JOHN', 269, 12, '2021-07-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-15 17:28:39', 1, '2021-07-30 05:00:03'),
(10783, 20069, '', '10783', 'E', 1, '<p>\n	Quarry App</p>\n', '2021-07-17 08:14:03', '', 'JOHN', 206, 12, '2022-03-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-17 08:14:03', 1, '2022-03-08 06:00:02'),
(10784, 20020, '', '10784', 'E', 1, '<p>\n	Report Modification - to accomodate load<br />\n	please instruct the programeers to strictly follow coding rules</p>\n', '2021-07-18 11:25:52', '', 'JOHN', 59, 12, '2022-03-12', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2021-07-18 11:25:52', 1, '2022-03-12 06:00:02'),
(10785, 20020, '', '10785', 'I', 1, '<p>\n	https://blueskyprojects.me/carcenter/</p>\n<p>\n	admin/admin@5115</p>\n<p>\n	see attached file for details</p>\n', '2021-07-18 12:50:25', 'Car Centre Work.docx', 'JOHN', 59, 12, '2022-03-12', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2021-07-18 12:50:25', 1, '2022-03-12 06:00:02'),
(10786, 20020, '', '10786', 'E', 1, '<p>\n	Car center- Reports - Items sales list</p>\n<p>\n	include Generic filter, customer phone number<br />\n	HTML sorting based on generic and amount</p>\n', '2021-07-18 12:54:41', '', 'JOHN', 59, 12, '2022-07-13', 0, '0000-00-00', '', 0, '0', '', '30004', 0, 0, '', '', 69, '2021-07-18 12:54:41', 1, '2022-07-13 05:00:02'),
(10787, 20101, '', '10787', 'E', 1, '<p>\n	Software Implementation</p>\n', '2021-07-19 18:08:13', '', 'mereenak', 302, 2, '2021-07-19', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 478, '2021-07-19 18:08:13', 478, '2021-07-19 18:28:56'),
(10788, 20013, '', '10788', 'E', 1, '<p>\n	Dear CRM Team,</p>\n<p>\n	With reference to the purchase invoice :&nbsp;804045, Please requesting to cancell and covert into Invoice status.&nbsp;</p>\n<p>\n	PO ref# 602898</p>\n<p>\n	&nbsp;</p>\n<p>\n	Thanks&nbsp;</p>\n<p>\n	&nbsp;</p>\n', '2021-07-25 17:11:25', '', 'Rhealiza G', 37, 12, '2021-07-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2021-07-25 17:11:25', 20, '2021-07-28 10:47:31'),
(10789, 20067, '', '10789', 'I', 1, '<p>\n	Quotation if converted to order- approve or unappore menu should not come<br />\n	if Order is converted to Delivery Note (Either partial or full)- Approve/unapprove menu should not come</p>\n', '2021-07-26 15:53:29', '', 'JOHN', 200, 2, '2021-07-26', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2021-07-26 15:53:29', 69, '2021-07-26 15:53:44'),
(10790, 20067, '', '10790', 'I', 1, '<p>\n	Quotation No <span dir=\"ltr\" role=\"presentation\" style=\"left: 60.9933px; top: 110.781px; font-size: 17.5px; font-family: sans-serif; transform: scaleX(1.1564);\">11658<br />\n	Take the check quanity print- Available quantity showing -18</span></p>\n<p>\n	<span dir=\"ltr\" role=\"presentation\" style=\"left: 60.9933px; top: 110.781px; font-size: 17.5px; font-family: sans-serif; transform: scaleX(1.1564);\">But same time inventory stock is +8</span><br />\n	&nbsp;</p>\n', '2021-07-26 16:02:13', '', 'JOHN', 200, 12, '2021-08-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-26 16:02:13', 1, '2021-08-03 05:00:02'),
(10791, 20067, '', '10791', 'I', 1, '<p>\n	1)Allocation from date and to date</p>\n<p>\n	2)trial balance</p>\n', '2021-07-28 15:52:06', '', 'JOHN', 200, 12, '2022-07-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-28 15:52:06', 1, '2022-07-28 05:00:02'),
(10792, 20098, '', '10792', 'I', 1, '<p>\n	1. purchase posting</p>\n<p>\n	2. auto connect receipt</p>\n<p>\n	3. Bank Transfer-Rak bank</p>\n', '2021-07-28 15:53:22', '', 'JOHN', 293, 12, '2022-07-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-28 15:53:22', 1, '2022-07-28 05:00:02'),
(10793, 20097, '', '10793', 'E', 1, '<p>\n	New Print for Payment voucher<br />\n	Copy Diatech P&amp; L, Balance to German Tech</p>\n<p>\n	<strong><em>G Tech-Cash report</em></strong></p>\n<p>\n	<strong><em>G Tech-Day book</em></strong></p>\n<p>\n	<strong><em>G Tech-MIS- Cash total</em></strong></p>\n', '2021-07-28 15:56:22', '', 'JOHN', 290, 12, '2022-07-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-28 15:56:22', 1, '2022-07-28 05:00:02'),
(10794, 20071, '', '10794', 'I', 1, '<p>\n	Attendence Clarification - Bulk<br />\n	Leave cancellation , encashment Mail,</p>\n', '2021-07-28 17:34:05', '', 'JOHN', 212, 12, '2021-08-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-28 17:34:05', 1, '2021-08-15 05:00:02'),
(10795, 20074, '', '10795', 'E', 1, '<p>\n	Compensatory leave mail</p>\n', '2021-07-28 17:39:25', '', 'JOHN', 221, 12, '2021-08-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-28 17:39:25', 1, '2021-08-04 05:00:02'),
(10796, 20065, '', '10796', 'E', 1, '<p>\n	Appraisal end date</p>\n', '2021-07-28 17:40:27', '', 'JOHN', 194, 12, '2021-08-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-28 17:40:27', 1, '2021-08-04 05:00:02'),
(10797, 20083, '', '10797', 'E', 1, '<p>\n	Removal of employee</p>\n', '2021-07-28 17:41:37', '', 'JOHN', 248, 12, '2021-08-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-28 17:41:37', 1, '2021-08-04 05:00:02'),
(10798, 20095, '', '10798', 'E', 1, '<p>\n	Salary Calculation Support</p>\n', '2021-07-28 17:42:26', '', 'JOHN', 284, 12, '2021-08-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-28 17:42:26', 1, '2021-08-10 05:00:02'),
(10799, 20001, '', '10799', 'I', 1, '<p>\n	SErial Number - wrong - See attached</p>\n', '2021-07-29 08:10:37', 'WhatsApp Image 2021-07-27 at 6.13.05 PM.jpeg,WhatsApp Image 2021-07-27 at 6.11.08 PM.jpeg,WhatsApp Image 2021-07-27 at 6.10.55 PM.jpeg,WhatsApp Image 2021-07-27 at 5.54.39 PM.jpeg,WhatsApp Image 2021-07-27 at 5.54.12 PM.jpeg', 'JOHN', 2, 12, '2021-08-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-07-29 08:10:37', 1, '2021-08-04 05:00:02'),
(10800, 20054, '', '10800', 'I', 1, '<p>\n	Change Logo in website</p>\n', '2021-08-01 08:10:44', '', 'JOHN', 161, 12, '2022-07-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-01 08:10:44', 1, '2022-07-28 05:00:02'),
(10801, 20077, '', '10801', 'I', 1, '<p>\n	Onine Meeting</p>\n', '2021-08-03 17:32:28', '', 'JOHN', 230, 12, '2021-08-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-03 17:32:28', 1, '2021-08-10 05:00:02'),
(10802, 20095, '', '10802', 'I', 1, '<p>\n	Report- Employee- Document List- Additional expiry date coloumn, correct pdf and excel</p>\n', '2021-08-03 17:33:27', '', 'JOHN', 284, 12, '2021-08-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-03 17:33:27', 1, '2021-08-10 05:00:02'),
(10803, 20098, '', '10803', 'I', 1, '<p>\n	Pruchase Invoice edit by Admin, for unposted</p>\n', '2021-08-04 10:58:21', '', 'JOHN', 293, 12, '2022-06-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-04 10:58:21', 1, '2022-06-30 05:00:02'),
(10804, 20002, '', '10804', 'I', 1, '<p>\n	In the attached Credit note, &ldquo;HFZA Exit Charges&rdquo; not selected while converting, you are requested to add the same in Credit note. Copy of Invoice against Credit note is attached for your reference.</p>\n<p>\n	Credit note total amount should be AED 1466.79</p>\n<p>\n	&nbsp;</p>\n<p>\n	In the Credit Note add the Hazfa charge 90 as footer (</p>\n', '2021-08-04 15:15:57', 'inv 500197.pdf,CN 411910.pdf', 'JOHN', 5, 12, '2021-08-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-04 15:15:57', 1, '2021-08-13 05:00:04'),
(10805, 20001, '', '10805', 'E', 1, '<p>\n	Purchase Invoice No: 900201 date change from 05/08/2021 to 16-06-2021</p>\n', '2021-08-05 10:53:05', 'WhatsApp Image 2021-08-05 at 10.42.26 AM.jpeg', 'JOHN', 2, 12, '2021-08-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-05 10:53:05', 1, '2021-08-11 05:00:02'),
(10812, 20018, '', '10812', 'I', 1, '<p>\n	Serial Number Tracking Solution</p>\n', '2021-08-11 14:21:46', '', 'JOHN', 53, 12, '2021-08-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-11 14:21:46', 1, '2021-08-17 05:00:01'),
(10806, 20019, '', '10806', 'E', 1, '<p>\n	ESell - Daily Sales Report - Correction</p>\n<p>\n	05/08/21 20:00 means 04/08/21 20:00 pm to 05/08/21 20:00 pm</p>\n', '2021-08-05 17:11:50', '', 'JOHN', 56, 12, '2021-08-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-05 17:11:50', 1, '2021-08-15 05:00:02'),
(10807, 20095, '', '10807', 'E', 1, '<p>\n	Documnetary Field in SCR line of Sif</p>\n<p>\n	Attendeance, Bulk Present/ Absent</p>\n<p>\n	&nbsp;</p>\n', '2021-08-09 17:05:07', '', 'JOHN', 284, 12, '2021-08-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-09 17:05:07', 1, '2021-08-15 05:00:02'),
(10808, 20074, '', '10808', 'E', 1, '<p>\n	Salary Modification<br />\n	EOS along with Salary<br />\n	leave encashment along with Salary</p>\n', '2021-08-05 17:06:48', '', 'JOHN', 221, 7, '2022-03-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-05 00:00:00', 3, '2022-03-22 08:03:19'),
(10809, 20013, '', '10809', 'E', 1, '<p>\n	<span style=\"color: rgba(0, 0, 0, 0.68); font-family: Ubuntu, sans-serif; font-size: 14.3px; text-transform: capitalize;\">PO&nbsp;</span>601615&nbsp;<span style=\"color: rgba(0, 0, 0, 0.68); font-family: Ubuntu, sans-serif; font-size: 14.3px; text-transform: capitalize;\">Was Converted To PI&nbsp;</span>802442&nbsp;<span style=\"color: rgba(0, 0, 0, 0.68); font-family: Ubuntu, sans-serif; font-size: 14.3px; text-transform: capitalize;\">But PO Status Was Not Change To Invoice And Balance Qty Is Still Showing In The Inventory PO Summary. Please Close And Change The Status From Order To Invoice. See Attached Flies For Reference.</span></p>\n', '2021-08-10 12:27:00', 'SP8183824.PNG', 'Rhealiza G', 37, 12, '2021-08-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2021-08-10 12:27:00', 20, '2021-08-15 10:47:44'),
(10810, 20013, '', '10810', 'E', 1, '<p>\n	On converting order to Purchased invoice the notes comment is not showing on the PDF file. <strong><u>Kindly include the notes comment when converting the PI to PDF file</u></strong>. see attached file for reference.</p>\n<p>\n	comment was entered during conterting to purchased invoice, but when it is converted the comment is not showing.</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 15868 characters]\" /></p>\n', '2021-08-10 14:09:16', 'PI 804072 notes.PNG,PI804072.pdf', 'Rhealiza G', 37, 12, '2021-08-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2021-08-10 14:09:16', 20, '2021-08-26 17:10:46'),
(10811, 20067, '', '10811', 'I', 1, '<p>\n	Stock ledger code checking and correction</p>\n', '2021-08-11 09:08:59', '', 'JOHN', 200, 12, '2021-08-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-11 09:08:59', 1, '2021-08-17 05:00:01'),
(10813, 20019, '', '10813', 'I', 1, '<p>\n	CRM-Software Implementation</p>\n', '2021-08-15 23:46:09', '', 'mereenak', 56, 12, '2022-03-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-08-15 23:46:09', 1, '2022-03-10 06:00:01'),
(10814, 20071, '', '10814', 'E', 1, '<p>\n	is there a way I can manually delete this transaction since the employee hasn&rsquo;t taken this leave and he needs to apply for a new one but couldn&rsquo;t do so since his leave balance is inadequate?</p>\n<p>\n	&nbsp;</p>\n', '2021-08-17 08:36:32', 'image002170821.jpg', 'JOHN', 212, 12, '2021-08-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-17 08:36:32', 1, '2021-08-25 05:00:02'),
(10815, 20078, '', '10815', 'E', 1, '<p>\n	Ceva Logisistics- Aug - uploaded file was wrong- delete it</p>\n', '2021-08-17 08:38:30', '', 'JOHN', 233, 12, '2021-08-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-17 08:38:30', 1, '2021-08-25 05:00:02'),
(10816, 20090, '', '10816', 'E', 1, '<p>\n	Report- Compnay document - permission</p>\n<p>\n	report - company document - add branch filter and branch coloumn</p>\n<p>\n	make changes in excel and pdf</p>\n', '2021-08-17 08:41:26', '', 'JOHN', 269, 12, '2021-08-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-17 08:41:26', 1, '2021-08-25 05:00:02'),
(10817, 20078, '', '10817', 'E', 1, '<p>\n	Report- Salary- Payslip (After locking)- pdf needed</p>\n', '2021-08-17 08:44:22', '', 'JOHN', 233, 12, '2021-08-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-17 08:44:22', 1, '2021-08-30 05:00:02'),
(10818, 20003, '', '10818', 'I', 1, '<p>\n	Forgot Password Option Needed</p>\n<p>\n	&nbsp;</p>\n<p>\n	how it should be, In the login page there should be a forgot password, when clicking it will ask for the username, if username is correct, system will send a random password to the employees email id in the system and that password will be updated in system</p>\n', '2021-08-17 08:52:01', '', 'JOHN', 8, 12, '2022-01-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-17 08:52:01', 1, '2022-01-12 06:00:02'),
(10819, 20071, '', '10819', 'E', 1, '<p>\n	HR- Mass Approval</p>\n', '2021-08-19 10:35:17', '', 'JOHN', 212, 12, '2021-10-19', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-19 10:35:17', 1, '2021-10-19 05:00:02'),
(10820, 20071, '', '10820', 'E', 1, '<p>\n	Egypt Employees cc mail Mariane</p>\n', '2021-08-19 11:14:29', '', 'JOHN', 212, 12, '2021-08-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-19 11:14:29', 1, '2021-08-30 05:00:02'),
(10821, 20071, '', '10821', 'E', 1, '<p>\n	Provision to delete the approved leave by HR<br />\n	(In between Line manager rejected leaves)</p>\n', '2021-08-19 11:16:06', '', 'JOHN', 212, 12, '2021-09-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-19 11:16:06', 1, '2021-09-04 05:00:03'),
(10822, 20013, '', '10822', 'E', 1, '<p>\n	Dear CRM Team,</p>\n<p>\n	With reference to the PO#&nbsp;603050 receipt needs to be cancelled.&nbsp;</p>\n<p>\n	an we requires PO to : Convert to Material Receipt.&nbsp;</p>\n<p>\n	Please assit to resolve the same on priority.&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	Thanks &amp; Regards</p>\n<p>\n	Sekar</p>\n<p>\n	Mobile: +971 55 8253752</p>\n', '2021-08-19 12:36:55', '', 'Sekar Lingam', 37, 12, '2021-08-19', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2021-08-19 12:36:55', 0, '2021-08-19 17:43:51'),
(10823, 20013, '', '10823', 'E', 1, '<p>\n	<span style=\"color: rgba(0, 0, 0, 0.68); font-family: Ubuntu, sans-serif; font-size: 14.3px; text-transform: capitalize;\">Please Correct The Freight Charges To 668 EUR Instead Of 854. Purchased Invoice No. 804090.</span></p>\n', '2021-08-22 16:14:23', '', 'Rhealiza G', 37, 12, '2021-08-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2021-08-22 16:14:23', 20, '2021-08-24 11:10:13'),
(10824, 20002, '', '10824', 'E', 1, '<p>\n	&nbsp;</p>\n<p>\n	Dear John,</p>\n<p>\n	Please help me to correct the 9<sup>th</sup> line item unit price to 2.46. As I&#39;m not able to edit now.</p>\n<p>\n	&nbsp;</p>\n<p>\n	9<span role=\"presentation\">-332-14OS2S1L1010</span><span role=\"presentation\">-SC/PC - LC/PC OS2 Duplex Fiber Patch Cord PVC 10M</span> &ndash; Price 2.46 USD</p>\n<p>\n	LPO Reference 601252</p>\n<p>\n	Supplier Optichina</p>\n<p class=\"MsoNormal\">\n	<span style=\"mso-bidi-font-family:Calibri;mso-bidi-theme-font:\nminor-latin\">&nbsp;</span></p>\n', '2021-08-23 08:28:23', '601252 Optichina.jpg', 'Tebin Kalam', 5, 12, '2021-08-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 9, '2021-08-23 08:28:23', 1, '2021-08-29 05:00:01'),
(10825, 20020, '', '10825', 'E', 1, '<p>\n	Car centre &ndash;report- item sales list &ndash; excel &ndash; coloums not matching ith heading-</p>\n', '2021-08-24 09:48:02', '', 'JOHN', 59, 12, '2021-09-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-24 09:48:02', 1, '2021-09-01 05:00:01'),
(10826, 20071, '', '10826', 'E', 1, '<p>\n	Viola- Attendence report &ndash; all type of leave counts availed during that date range</p>\n<p>\n	Viola-In the official meeting request, you need an additional (optional) file upload named &quot;Documents&quot;</p>\n', '2021-08-24 12:28:33', '', 'JOHN', 212, 12, '2021-12-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-24 12:28:33', 1, '2021-12-28 06:00:03'),
(10827, 20013, '', '10827', 'E', 1, '<p>\n	Dear CRM Team,</p>\n<p>\n	Kindly assist to change the customer address against to the invoice number# 406611 and Delivery note &amp; Packing list # 306622 and associated all other reports pertaining to the particular invoice report&nbsp; only.&nbsp;</p>\n<p>\n	This is from our customer request please treat this us on priority.&nbsp;</p>\n<p>\n	<span style=\"background-color:#00ffff;\">Customer Correct Address :&nbsp;</span></p>\n<div>\n	PACC Information &amp; Communication Technology</div>\n<div>\n	PO BOX. 54110</div>\n<div>\n	32ND FLOOR, ADDAX TOWER</div>\n<div>\n	AL REEM ISLAND</div>\n<div>\n	Abu Dhabi , UNITED ARAB EMIRATES</div>\n<div>\n	VAT TRN#&nbsp;1003701100800003</div>\n<div>\n	&nbsp;</div>\n<div>\n	&nbsp;</div>\n<div>\n	Thanks &amp; Regards</div>\n<div>\n	Sekar</div>\n<div>\n	&nbsp;</div>\n', '2021-08-24 13:52:35', '306622-DELIVERY NOTE..pdf,406611 - INVOICE.pdf', 'Sekar Lingam', 37, 12, '2022-02-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2021-08-24 13:52:35', 1, '2022-02-10 06:00:02'),
(10828, 20013, '', '10828', 'E', 0, '<p>\n	Hi,</p>\n<p>\n	Please advise .I can&#39;t find the copy icon in CRM to copy a quotation .</p>\n<p>\n	Deepti Manoj&nbsp;</p>\n', '2021-08-24 16:04:42', '', 'Deepti Manoj', 37, 12, '2021-09-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2021-08-24 16:04:42', 1, '2021-09-01 05:00:01'),
(10829, 20013, '', '10829', 'I', 1, '<p>\n	Kindly Assist To Change The Customer Address Against To The Invoice Number# 406611 And Delivery Note &amp; Packing List # 306622 And Associated All Other Reports Pertaining To The Particular Invoice number Only.&nbsp;</p>\n<p>\n	This Is From Our Customer Request , We are committed to provide invoice/DN with revised address, Please Treat This Us On Priority get the revised reports.&nbsp;</p>\n<p>\n	Customer Correct Address :&nbsp;</p>\n<p>\n	PACC Information &amp; Communication Technology</p>\n<p>\n	PO BOX. 54110</p>\n<p>\n	32ND FLOOR, ADDAX TOWER</p>\n<p>\n	AL REEM ISLAND</p>\n<p>\n	Abu Dhabi , UNITED ARAB EMIRATES</p>\n<p>\n	VAT TRN#&nbsp;1003701100800003</p>\n', '2021-08-25 21:04:37', '', 'mereenak', 38, 12, '2022-02-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-08-25 21:04:37', 1, '2022-02-09 06:00:01'),
(10830, 20102, '', '10830', 'I', 1, '<p>\n	ERP-Software Implementation</p>\n', '2021-08-25 21:15:25', '', 'mereenak', 305, 12, '2022-09-04', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 478, '2021-08-25 21:15:25', 1, '2022-09-04 05:00:02'),
(10831, 20002, '', '10831', 'I', 1, '<p>\n	Report Modification</p>\n', '2021-08-26 09:18:19', 'norden260821-1.png,norden260821-2.png,Norden260821.docx', 'JOHN', 5, 12, '2022-08-08', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2021-08-26 09:18:19', 1, '2022-08-08 05:00:02'),
(10832, 20098, '', '10832', 'E', 1, '<p>\n	<strong>Infinity- </strong>AWB number search in invoice grid &ndash; Mereena</p>\n<p>\n	Infinity &ndash; AWB number &ndash; common- think of old data</p>\n<p>\n	Infinity- invoice- show DHL, Ups agent, if agent change in JO also</p>\n<p>\n	Infinity &ndash; lead without customer issue</p>\n<p>\n	Infininity &ndash; customer change -mail 26/08/21 12:48</p>\n', '2021-08-26 15:59:27', '', 'JOHN', 293, 12, '2022-06-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-26 15:59:27', 1, '2022-06-30 05:00:02'),
(10833, 20006, '', '10833', 'I', 1, '<p>\n	Dear John</p>\n<p>\n	Staff ID : 82499</p>\n<p>\n	Name : Atyat Mohd mohd</p>\n<p>\n	Join date : 27/04/2020</p>\n<p>\n	She took 5 days leave.</p>\n<p>\n	Her leave Salary showing only 22 days , pls send me the reason , and the way of calculation applied in system .</p>\n<p>\n	Most of the staffs Leave pay is wrong . Kindly revert back urgently</p>\n<p>\n	See file attached - Check other employees also if applied leaaves in same ranges approved</p>\n<p>\n	http://blueskytechno.com/juelmin</p>\n<p>\n	admin/demo</p>\n', '2021-08-26 16:45:00', 'Juelmin260821.png', 'JOHN', 17, 12, '2021-09-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-08-26 16:45:00', 1, '2021-09-04 05:00:03');
