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
(10335, 20049, '', '10335', 'E', 1, '<p>\n	our attention is invited to the &nbsp;quote 1569, 1575 and 1715. &nbsp;The sale currency is in Euro. &nbsp;But while checking margin, cost is coming in GBP. &nbsp;Please fix the issue</p>\n', '2020-09-03 08:28:52', '', 'JOHN', 146, 12, '2020-09-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-03 08:28:52', 1, '2020-09-13 05:00:02'),
(10336, 20019, '', '10336', 'E', 1, '<p>\n	ERPlite Purchase return saving problem</p>\n', '2020-09-03 11:05:38', '', 'JOHN', 56, 12, '2020-09-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-03 11:05:38', 1, '2020-09-09 05:00:02'),
(10337, 20003, '', '10337', 'E', 1, '<p>\n	Auto save function in Inspection</p>\n', '2020-09-03 12:08:53', '', 'JOHN', 8, 12, '2020-09-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-03 12:08:53', 1, '2020-09-09 05:00:02'),
(10338, 20013, '', '10338', 'E', 1, '<p>\n	Quotations - please remove the Discount field completely (where we could set item level discount), with this removed, no need to have two printing options - one with discount and one without discount. This is because sometimes, sales people print the quotation &#39;with discount&#39; even when we had not applied any discount. Customer sees zero as discount and demands a discount.&nbsp;</p>\n<p>\n	We can still apply discount in the +/- column, so we will always use this column for increase or decrease in price.&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	Also, the quotation level Additions or Discounts are not working. Please fix it.&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	Thank you.</p>\n', '2020-09-05 06:30:03', '', 'Ganesan K.', 37, 2, '2020-09-05', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 20, '2020-09-05 06:30:03', 69, '2020-09-05 08:14:22'),
(10339, 20020, '', '10339', 'E', 1, '<p>\n	choosing single item from&nbsp; Bundle of items from discount card</p>\n', '2020-09-05 08:15:48', '', 'JOHN', 59, 12, '2020-10-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-05 08:15:48', 1, '2020-10-27 06:00:02'),
(10340, 20001, '', '10340', 'E', 1, '<p>\n	Please round the display of cost price to two decimal places</p>\n<p>\n	refer attached</p>\n', '2020-09-05 16:49:11', 'ace050920.jpg', 'JOHN', 3, 12, '2020-10-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-05 16:49:11', 1, '2020-10-25 06:00:02'),
(10341, 20019, '', '10341', 'I', 5, '<p>\n	1 Updations in alpha erp</p>\n', '2020-09-04 19:19:56', '', 'mereenak', 56, 12, '2020-09-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2020-09-04 19:19:56', 1, '2020-09-16 05:00:01'),
(10343, 20019, '', '10343', 'I', 5, '<p>\n	Norden stock issue&nbsp; -- REF#&nbsp;10317</p>\n', '2020-09-03 15:34:39', '', 'mereenak', 56, 12, '2021-01-16', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 478, '2020-09-03 15:34:39', 1, '2021-01-16 06:00:02'),
(10344, 20001, '', '10344', 'E', 1, '<p>\n	HR attandence , upload checking<br />\n	Hire order to delivery checking</p>\n', '2020-09-07 17:04:26', '', 'JOHN', 2, 12, '2020-09-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-07 17:04:26', 1, '2020-09-13 05:00:02'),
(10345, 20042, '', '10345', 'E', 1, '<p>\n	Pls find the enclosed ledger report . Year closing not reflecting in ledger reports .Opening balances are carried forward.</p>\n', '2020-09-08 08:01:05', 'GL Report (opening ).pdf', 'JOHN', 125, 12, '2020-09-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-08 08:01:05', 1, '2020-09-15 05:00:02'),
(10346, 20048, '', '10346', 'E', 1, '<p style=\"margin-left:.5in;\">\n	While preparing quote/invoice in CRM , total value is wrong if we select IGST . However&nbsp; the calculation of IGST &nbsp;is correct but the Grand &nbsp;Total is wrong.</p>\n<p style=\"margin-left:.5in;\">\n	But if select SGST , total will be correct.</p>\n<p style=\"margin-left:.5in;\">\n	&nbsp;Because of this I cannot release CRM invoice .</p>\n', '2020-09-09 07:34:10', '', 'Shabil -', 142, 12, '2020-09-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 55, '2020-09-09 07:34:10', 1, '2020-09-15 05:00:02'),
(10347, 20042, '', '10347', 'E', 1, '<div>\n	Lebeaute accounts GL SUMMARY REPORTS &amp; TRIAL BALANCE AMOUNTS ,BOTH NOT MATCHING&nbsp;</div>\n<div>\n	<div>\n		<span style=\"background-color:rgb(255,255,0)\">as of 31st March 2020</span></div>\n</div>\n<div>\n	&nbsp;</div>\n<div>\n	<font color=\"#ff0000\">sample accounts&nbsp;are follows</font></div>\n<div>\n	&nbsp;</div>\n<div>\n	as of 31st March 2020</div>\n<div>\n	&nbsp;</div>\n<div>\n	Trade Payable&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2111</div>\n<div>\n	other payable&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5024</div>\n<div>\n	staff salary payable&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2123</div>\n<div>\n	<span style=\"background-color:rgb(0,255,0)\">more accounts there&nbsp;</span></div>\n<div>\n	&nbsp;</div>\n<div>\n	<span style=\"background-color:rgb(0,255,0)\">Pls&nbsp; Academy also set as per Indian accounting standards . We are running out of time ..</span></div>\n', '2020-09-08 08:02:37', '', 'JOHN', 125, 12, '2020-09-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-09 08:02:37', 1, '2020-09-16 05:00:01'),
(10348, 20006, '', '10348', 'E', 1, '<p>\n	Journel entry last line - put sub ledger validation</p>\n', '2020-09-09 12:37:26', '', 'JOHN', 17, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-09-09 12:37:26', 1, '2022-07-29 05:00:04'),
(10349, 20028, '', '10349', 'E', 1, '<p>\n	Journel entry last line - put sub ledger validation</p>\n', '2020-09-09 12:37:47', '', 'JOHN', 83, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-09-09 12:37:47', 1, '2022-07-29 05:00:04'),
(10350, 20042, '', '10350', 'E', 1, '<p>\n	Journel entry last line - put sub ledger validation</p>\n', '2020-09-09 12:38:00', '', 'JOHN', 125, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-09-09 12:38:00', 1, '2022-07-29 05:00:04'),
(10351, 20004, '', '10351', 'E', 1, '<p>\n	Outbound delivery note: 053264 dated 27/08/20 Eva Middle East<br />\n	in delivery grid it shows pre invoiced<br />\n	but in Preinvoice grid no entry connecting 053264 found</p>\n', '2020-09-09 15:14:30', '', 'JOHN', 11, 12, '2020-09-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-09 15:14:30', 1, '2020-09-22 05:00:01'),
(10352, 20003, '', '10352', 'E', 1, '<p>\n	Pls remove the entries in yellow, permanently. Leave the last entry. Its valid.(See Mail)</p>\n', '2020-09-09 17:03:35', '', 'JOHN', 8, 12, '2020-09-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-09 17:03:35', 1, '2020-09-16 05:00:01'),
(10353, 20043, '', '10353', 'E', 1, '<p>\n	Secure Scan - Scanner data import</p>\n', '2020-09-09 17:29:08', '', 'JOHN', 59, 12, '2020-12-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-09 17:29:08', 1, '2020-12-17 06:00:02'),
(10354, 20045, '', '10354', 'E', 1, '<p>\n	Edition- Add button error</p>\n', '2020-09-10 08:17:27', '', 'JOHN', 134, 12, '2020-09-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-10 08:17:27', 1, '2020-09-16 05:00:01'),
(10355, 20042, '', '10355', 'E', 1, '<p>\n	Dear&nbsp; John ,</p>\n<div>\n	&nbsp;</div>\n<div>\n	Reported issues are not resolved&nbsp;.Evening I explained one by one to Alwyn</div>\n<div>\n	&nbsp;</div>\n<div>\n	<span style=\"background-color:rgb(255,255,0)\">Sample reports attached</span></div>\n<div>\n	&nbsp;</div>\n<div>\n	Enclosed reports for&nbsp; Account No 5024. All three places showing different figures as of 31/03/2020</div>\n<div>\n	&nbsp;</div>\n<div>\n	Other accounts also&nbsp; informed him&nbsp; .</div>\n<div>\n	&nbsp;</div>\n<div>\n	Pls fix tomorrow morning itself.</div>\n<div>\n	&nbsp;</div>\n<div>\n	Regards</div>\n<div>\n	&nbsp;</div>\n<div>\n	Anil</div>\n<div>\n	Dear Arun/ John\n	<div>\n		&nbsp;</div>\n	<div>\n		Following bugs reported and not fixed till&nbsp; now</div>\n	<div>\n		&nbsp;</div>\n	<div>\n		Figures&nbsp;showing -Trial Balance -GL Summary&nbsp;-Gl reports following accounts .</div>\n	<div>\n		&nbsp;</div>\n	<div>\n		5024 Other Payables</div>\n	<div>\n		134- Staff Salary Advance &amp; Loans</div>\n	<div>\n		&nbsp;</div>\n	<div>\n		<font color=\"#ff0000\">Also Note</font></div>\n	<div>\n		&nbsp;</div>\n	<div>\n		2023 Petty Cash - GL Transaction Report balance 16910 but not appearing&nbsp;TB.</div>\n	<div>\n		&nbsp;</div>\n	<div>\n		<font color=\"#ff0000\">GL Reports for exp items if a gave 01/01/2020 to 31/03/2020 -opening balance missing&nbsp;, but it will appear if gave date range 01/11/2019 to 31/03/2020. Sample reports enclosed.</font></div>\n	<div>\n		&nbsp;</div>\n	<div>\n		Hope this will fix on priority basis on morning.</div>\n	<div>\n		&nbsp;</div>\n	<div>\n		Regards</div>\n	<div>\n		&nbsp;</div>\n	<div>\n		Anil</div>\n</div>\n', '2020-09-10 08:21:02', '5024 Other payable GL Summery  -Balance 42319.pdf,EXP Opening balance missing.pdf,5024 Other payable GL transaction report -Balance 424332.pdf,5024 Other payable Trial balance  report -Balance 508970.pdf', 'JOHN', 125, 12, '2020-09-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-10 08:21:02', 1, '2020-09-16 05:00:01'),
(10356, 20014, '', '10356', 'E', 1, '<p>\n	Cannot un post Voucher<br />\n	Inv 4585415 dt 16/09/2019, Exit Sila</p>\n<p>\n	inv 2298743 dt 06/10/2019 entry sila</p>\n', '2020-09-10 08:58:34', '', 'JOHN', 41, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-09-10 08:58:34', 1, '2022-07-29 05:00:04'),
(10357, 20048, '', '10357', 'I', 1, '<p>\n	In quotation and Invoice, while editing invoice type, Tax automatic re calculation doesnt work</p>\n', '2020-09-10 08:59:58', '', 'JOHN', 143, 12, '2020-09-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-10 08:59:58', 1, '2020-09-20 05:00:01'),
(10379, 20020, '', '10379', 'E', 2, '<p>\n	A coloumn for showing the vehicle number in sales report, and a filter for vehicle number (but not auto select, using LIKE function)</p>\n', '2020-09-19 08:09:03', '', 'JOHN', 59, 12, '2020-09-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-19 08:09:03', 1, '2020-09-30 05:00:02'),
(10358, 20019, '', '10358', 'E', 2, '<p>\n	New Supplier Portal Development</p>\n', '2020-09-10 15:14:22', '', 'JOHN', 56, 12, '2020-10-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-10 15:14:22', 1, '2020-10-25 06:00:02'),
(10359, 20019, '', '10359', 'I', 5, '<p>\n	AWS -- New server -- integration</p>\n', '2020-09-10 15:47:17', '', 'mereenak', 55, 12, '2021-02-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2020-09-10 15:47:17', 1, '2021-02-03 06:00:02'),
(10371, 20001, '', '10371', 'I', 1, '<p>\n	Ebable user needed for disabled user in user management</p>\n<p>\n	on searching disbaled users must be shown in rose colour, then from menu, select enable user</p>\n', '2020-09-16 09:41:14', '', 'JOHN', 2, 12, '2021-01-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-16 09:41:14', 1, '2021-01-30 06:00:02'),
(10360, 20001, '', '10360', 'I', 1, '<p>\n	Design&nbsp; problem (Refer atached screenshot)</p>\n<p>\n	&nbsp;</p>\n', '2020-09-12 10:31:59', 'WhatsApp Image 2020-09-12 at 10.27.03 AM.jpeg', 'JOHN', 2, 12, '2021-01-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-12 10:31:59', 1, '2021-01-24 06:00:02'),
(10361, 20001, '', '10361', 'I', 1, '<p>\n	In the serial number window, the ware house is wrongly showing</p>\n<p>\n	refer attached screen shots</p>\n', '2020-09-12 10:33:55', 'WhatsApp Image 2020-09-12 at 10.29.15 AM.jpeg,WhatsApp Image 2020-09-12 at 10.28.54 AM.jpeg', 'JOHN', 2, 12, '2020-09-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-12 10:33:55', 1, '2020-09-20 05:00:01'),
(10549, 20013, '', '10549', 'E', 1, '<p>\n	Good evening.</p>\n<p>\n	When we see an in<span style=\"background-color:#ffff00;\"> inventory </span>and check for <span style=\"background-color:#ffff00;\">PO history, </span>we get purchase invoice.if we want to check the PO details and email communication on this with the vendor, we can&#39;t do wiht the purchase invoice. We need to go to the purchase module, enter the&nbsp;purchase invoice and then get the PO #. So, we need to include one coulmn for the PO # in the PO history.</p>\n<p>\n	Similarly, we face a similar problem in <span style=\"background-color:#ffff00;\">SO history</span> as well. Here we need the SO# to be included.&nbsp;</p>\n<p>\n	See the atatched for reference.</p>\n<p>\n	Thanks and regards,</p>\n<p>\n	Ganesan</p>\n<p>\n	&nbsp;</p>\n', '2021-01-18 17:49:01', 'Purchase History.png,Sales History.png', 'Ganesan K.', 38, 2, '2021-12-27', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 20, '2021-01-18 17:49:01', 69, '2021-12-27 09:28:50'),
(10362, 20001, '', '10362', 'I', 1, '<p>\n	Stock Figures not matching</p>\n<p>\n	See attached</p>\n', '2020-09-13 09:50:47', 'WhatsApp Image 2020-09-12 at 10.29.15 AM(1).jpeg,WhatsApp Image 2020-09-12 at 10.28.54 AM(1).jpeg', 'JOHN', 2, 12, '2020-09-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-13 09:50:47', 69, '2020-09-14 08:29:30'),
(10363, 20019, '', '10363', 'E', 1, '<p>\n	Alpha Fianace integration and checking</p>\n', '2020-09-13 09:55:48', '', 'JOHN', 56, 12, '2020-09-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-13 09:55:48', 1, '2020-09-20 05:00:01'),
(10364, 20002, '', '10364', 'E', 1, '<p>\n	Electra Pricing</p>\n', '2020-09-13 14:37:53', '', 'JOHN', 5, 12, '2020-09-21', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-13 14:37:53', 1, '2020-09-21 05:00:02'),
(10365, 20019, '', '10365', 'E', 1, '<p>\n	hardware integration of HID id scANNER<br />\n	<br />\n	<br />\n	<br />\n	&nbsp;</p>\n', '2020-09-10 08:09:10', '', 'JOHN', 56, 12, '2020-09-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-10 08:09:10', 69, '2020-09-26 08:20:33'),
(10366, 20001, '', '10366', 'I', 1, '<p>\n	https://cumuluserp.me/acecentro//index.php?r=inventory/PrintSalesPriceListPDF&amp;id=1458</p>\n<p>\n	correct the header</p>\n', '2020-09-14 09:11:24', '', 'JOHN', 2, 12, '2021-01-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-14 09:11:24', 1, '2021-01-29 06:00:02'),
(10367, 20020, '', '10367', 'E', 2, '<p>\n	<strong>Loyalty Points, SMS feature, sales man commission </strong></p>\n<p>\n	Loyalty Points<br />\n	1. Loyalty points will be stored against customer<br />\n	2. Items will be classified as having / not having loyalty points<br />\n	3. Card purchase have loyalty point?<br />\n	4. Any service availed from card does not have points<br />\n	5. Loyalty point ratio 1 dirham spent = 1 point<br />\n	6. Have a validity of 2 years, the point history must be maintained and available to customer<br />\n	7. Loyalty points can be used for service availed from car center, upon reaching cashier, he can pay from points, if points exist<br />\n	8. Points cannot be en cashed / transferred<br />\n	9. Cash customer / customer without mobile number(ladies having nfc card as heir name) cant use the loyalty until that card is vaild<br />\n	10. List of customers with point<br />\n	Salesman commission<br />\n	1. Sales man commission have any date range? Like period<br />\n	2. A report /dashboard showing whether they achieved or how much more to achieve<br />\n	SMS<br />\n	1. Trigger points they have to give<br />\n	2. Only vaild phone number customers will be considered for SMS<br />\n	3. A report with invalid mobile number will be given<br />\n	4. Cash customer / customer without mobile number(ladies having nfc card as heir name) cant use SMS feature</p>\n', '2020-09-14 09:54:25', '', 'JOHN', 59, 12, '2021-02-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-14 09:54:25', 1, '2021-02-09 06:00:01'),
(10369, 20019, '', '10369', 'E', 1, '<p>\n	HR Onboarding</p>\n', '2020-09-15 17:07:59', '', 'JOHN', 56, 12, '2020-09-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-15 17:07:59', 1, '2020-09-29 05:00:02'),
(10370, 20019, '', '10370', 'E', 2, '<p>\n	HR- In the employee data , we have to introduce a field salary payment type (All, cash, cheque, WPS, Exchange)<br />\n	At the salary distribution time if cheque payment is selected, all employees with cheque type + all employees with all will come there</p>\n<p>\n	All means they will come in all type of payment modes (chque, cash, wps, exchange)</p>\n', '2020-09-15 17:11:22', '', 'JOHN', 56, 12, '2020-09-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-15 17:11:22', 1, '2020-09-27 05:00:01'),
(10372, 20001, '', '10372', 'I', 1, '<p>\n	Go to inventory Grid</p>\n<p>\n	Search for 11-04-00003</p>\n<p>\n	select &quot;Details&quot; from menu</p>\n<p>\n	select &quot;sales History&quot; Tab</p>\n<p>\n	Can you differciate betweeen sales and hire as shown in &quot;quotes Rate&quot; tab</p>\n', '2020-09-16 12:37:07', '', 'JOHN', 2, 12, '2020-10-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-16 12:37:07', 1, '2020-10-02 05:00:05'),
(10373, 20002, '', '10373', 'E', 1, '<p>\n	With reference to our discussion, kindly revise Saudi price margin as follows for Coaxial cables, fiber cables networking and fiber accessories. Also rename Saudi pricing to Saudi project price.</p>\n<ol>\n	<li>\n		Coaxial Cables- Project price +12 % &nbsp;</li>\n	<li>\n		Fibre Cables &amp; Fibre Cables - Cut Piece &nbsp;- Project price + 2.5%</li>\n	<li>\n		Networking Accessories 1, Networking Accessories 2 &amp; Fibre Accessories 1 &nbsp;- Project Pricing + 5%</li>\n</ol>\n<p>\n	Example : 475-011A60 (Coaxial cable) Project price # 170.00 &nbsp;AED , Please revise to 170+12% = 190.4 AED</p>\n', '2020-09-16 16:12:33', '', 'JOHN', 5, 12, '2020-09-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-16 16:12:33', 1, '2020-09-27 05:00:01'),
(10374, 20028, '', '10374', 'E', 1, '<p>\n	Real estate - Finance - Server configuration</p>\n', '2020-09-16 17:57:51', '', 'JOHN', 83, 12, '2020-09-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-16 17:57:51', 1, '2020-09-28 05:00:02'),
(10375, 20066, '', '10375', 'E', 1, '<p>\n	E Sell Setup &amp; Initilisation</p>\n', '2020-09-17 08:45:47', '', 'JOHN', 197, 12, '2021-03-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-17 08:45:47', 1, '2021-03-07 06:00:02'),
(10376, 20061, '', '10376', 'I', 1, '<p>\n	E-sell New Invoice Design</p>\n', '2020-09-16 08:55:37', '', 'mereenak', 182, 12, '2021-02-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2020-09-16 08:55:37', 1, '2021-02-24 06:00:02'),
(10377, 20002, '', '10377', 'E', 1, '<p>\n	Purchase return Posting not working - eg 0Cixi Yonglian Electronics Co Ltd</p>\n', '2020-09-17 12:23:54', '', 'JOHN', 5, 12, '2020-09-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-17 12:23:54', 1, '2020-09-30 05:00:02'),
(10378, 20006, '', '10378', 'E', 1, '<p>\n	We need to some PDC . But in vouchers 2021 is not enable . Pls enable 2021 &amp; 2022 in voucher dates</p>\n<p>\n	Refer attached</p>\n', '2020-09-17 12:28:42', 'image001.png', 'JOHN', 17, 12, '2021-03-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-17 12:28:42', 1, '2021-03-07 06:00:02'),
(10380, 20001, '', '10380', 'I', 1, '<p>\n	Reports - Inventory - Inventory Ledger</p>\n<p>\n	01/01/20 to 31/12/20</p>\n<p>\n	select item 17-04-00008</p>\n<p>\n	load</p>\n<p>\n	excel output showing mis match</p>\n', '2020-09-21 10:04:26', '', 'JOHN', 2, 12, '2020-09-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-21 10:04:26', 1, '2020-09-27 05:00:01'),
(10381, 20001, '', '10381', 'E', 2, '<p>\n	New Report Needed</p>\n<p>\n	(See attached file from them for reference)</p>\n', '2020-09-22 09:46:30', 'Report Requirment.xlsx', 'JOHN', 2, 12, '2020-12-05', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-22 09:46:30', 1, '2020-12-05 06:00:02'),
(10382, 20002, '', '10382', 'E', 1, '<p>\n	1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Debit note is not reflected in the supplier ledger</p>\n<p>\n	2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Credited invoice amount is including VAT.</p>\n', '2020-09-22 12:46:29', 'image0011.png', 'JOHN', 5, 12, '2020-09-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-22 12:46:29', 1, '2020-09-30 05:00:02'),
(10455, 20065, '', '10455', 'E', 1, '<p>\n	Salary before reporting report correction</p>\n', '2020-11-25 16:16:24', '', 'JOHN', 194, 12, '2020-12-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-25 16:16:24', 1, '2020-12-02 06:00:01'),
(10383, 20019, '', '10383', 'I', 1, '<p>\n	Design Support</p>\n', '2020-09-22 21:50:09', '', 'mereenak', 56, 12, '2020-10-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2020-09-22 21:50:09', 1, '2020-10-25 06:00:02'),
(10384, 20012, '', '10384', 'E', 1, '<p>\n	Deduction at Encashment</p>\n', '2020-09-23 12:22:39', '', 'JOHN', 35, 12, '2020-09-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-23 12:22:39', 1, '2020-09-29 05:00:02'),
(10385, 20036, '', '10385', 'I', 1, '<p>\n	I would like to ask for the update I raise before. And also please find below error in adding items on different Warehouse. If you remember I mentioned that we will have multiple warehouse and we should able to transfer and add the items on a specific warehouse for example. However I noticed that in the 2 warehouse we have same kind of item number and barcodes one of the example is Cotton Hand gloves which we have in FLM Warehouse and Dubai-Main Warehouse which has different total qty they should have different model having a parent model as the master. now the problem is that the system should accept both item code considering they are added on different warehouse location(different Model) but the system is not accepting it, please see below for reference.</p>\n', '2020-09-23 12:46:30', 'image003.jpg', 'JOHN', 107, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-09-23 12:46:30', 1, '2022-07-29 05:00:04'),
(10386, 20002, '', '10386', 'E', 1, '<p>\n	<span style=\"font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;;color:#000066\">Please find enclosed Credit note issued on 14/07/2020, but in finance module dash board and in customer ledger it is showing on 13/07/2020</span></p>\n', '2020-09-23 16:23:59', 'image002.jpg', 'JOHN', 5, 12, '2020-09-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-23 16:23:59', 1, '2020-09-30 05:00:02'),
(10387, 20001, '', '10387', 'E', 1, '<p>\n	Material Receipt - Description Length</p>\n', '2020-09-24 09:31:39', 'WhatsApp Image 2020-09-23 at 6.07.02 PM.jpeg', 'JOHN', 2, 12, '2020-09-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-24 09:31:39', 1, '2020-09-30 05:00:02'),
(10388, 20001, '', '10388', 'I', 1, '<p>\n	Purchace QC to Invoice , also that 255 chharacter problem came, as earlier we corrected in QC</p>\n<p>\n	please try to save item description obnly, otherwise increase field length</p>\n', '2020-09-26 15:57:52', '', 'JOHN', 2, 12, '2020-12-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-26 15:57:52', 1, '2020-12-17 06:00:02'),
(10389, 20013, '', '10389', 'E', 1, '<p>\n	Today when making purchase invoice (Material receipt to Invoice conversion), one dummy invoice is generated 803715 with 0 value. plz advise what should be done.</p>\n<p>\n	(The same conversion is done again and PI 803716 is created properly)</p>\n', '2020-09-27 17:20:10', '', 'JOHN', 38, 12, '2020-10-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-27 17:20:10', 1, '2020-10-04 05:00:02'),
(10421, 20002, '', '10421', 'E', 1, '<p>\n	Subject :LPO correction.</p>\n<p>\n	Please find attached Image.</p>\n', '2020-10-19 10:08:35', 'LPO correction.JPG', 'Tebin Kalam', 4, 12, '2020-10-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 9, '2020-10-19 10:08:35', 1, '2020-10-25 06:00:02'),
(10390, 20001, '', '10390', 'E', 1, '<p>\n	when an quotation (which is already approved and converted to order) is copied to make another quotation, quation ststus is coming as order, please correct that</p>\n', '2020-09-28 14:19:06', '', 'JOHN', 2, 12, '2020-12-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-28 14:19:06', 1, '2020-12-17 06:00:02'),
(10391, 20002, '', '10391', 'E', 1, '<p>\n	Change the Item description in order</p>\n<p>\n	(see sattached screenshot)</p>\n', '2020-09-28 15:33:51', 'WhatsApp Image 2020-09-28 at 3.29.19 PM.jpeg', 'JOHN', 5, 12, '2020-10-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-28 15:33:51', 1, '2020-10-10 05:00:02'),
(10392, 20019, '', '10392', 'E', 1, '<p>\n	Server version migration</p>\n', '2020-09-29 08:32:33', '', 'JOHN', 56, 12, '2021-02-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-29 08:32:33', 1, '2021-02-14 06:00:01'),
(10393, 20001, '', '10393', 'I', 1, '<p>\n	Please stick to one decimal correction format</p>\n', '2020-09-30 10:12:48', 'WhatsApp Image 2020-09-30 at 10.06.34 AM.jpeg', 'JOHN', 2, 12, '2021-02-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-30 10:12:48', 1, '2021-02-24 06:00:02'),
(10394, 20001, '', '10394', 'E', 1, '<p>\n	Decimal issue- invoice its very critical</p>\n', '2020-10-01 14:03:20', 'WhatsApp Image 2020-10-01 at 1.24.32 PM.jpeg', 'JOHN', 2, 12, '2021-02-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-01 14:03:20', 1, '2021-02-24 06:00:02'),
(10395, 20001, '', '10395', 'I', 1, '<p>\n	Permission for&nbsp; the Quotes rate tab not working (refer ss)</p>\n', '2020-10-01 14:10:26', 'WhatsApp Image 2020-10-01 at 2.07.13 PM.jpeg,WhatsApp Image 2020-10-01 at 2.06.14 PM.jpeg', 'JOHN', 2, 12, '2020-10-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-01 14:10:26', 1, '2020-10-10 05:00:02'),
(10396, 20001, '', '10396', 'I', 1, '<p>\n	Notification is not proper -see attched</p>\n', '2020-10-04 08:43:40', 'WhatsApp Image 2020-10-04 at 8.41.08 AM.jpeg', 'JOHN', 2, 12, '2020-10-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-04 08:43:40', 1, '2020-10-11 05:00:02'),
(10397, 20028, '', '10397', 'E', 1, '<p>\n	One of our staff have 45 days annual leave , now he applied 45 days leave in cash and 30 day annual leave and system accept to apply both together&nbsp;</p>\n', '2020-10-04 13:26:48', 'surendra annual leave61.png,Surendra leave in cash70.png,surendra leave12.png', 'Tageldin  Shahata', 82, 12, '2020-10-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 35, '2020-10-04 13:26:48', 1, '2020-10-28 06:00:02'),
(10398, 20027, '', '10398', 'E', 1, '<p>\n	I need to do allocation in mumayaz IS system but I got message ( please check total amount ) but it is already equal , please check urgently</p>\n', '2020-10-04 14:41:22', 'allocation.png', 'Administrator ', 79, 12, '2020-10-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 34, '2020-10-04 14:41:22', 69, '2020-10-26 16:49:12'),
(10399, 20048, '', '10399', 'E', 1, '<p>\n	If we give discount in CRM quote Grand total &nbsp;showing as wrong .In CRM , &nbsp;discount is deducting from the Grand total &nbsp;its actually need to be deduct from the total amount then only the tax value become correct .Line item wise discount is possible but cannot give line item wise discount all the times.</p>\n<p>\n	&nbsp;</p>\n<p>\n	Eg : &nbsp;Total Value &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- 599451</p>\n<p>\n	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Discount&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- &nbsp;&nbsp;92940</p>\n<p>\n	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Total Value after discount&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- 506511</p>\n<p>\n	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IGST -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- 91171.98</p>\n<p>\n	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;Grand Total&nbsp; - 506511+91171.98 &ndash; &nbsp;597682.98 /-&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</p>\n', '2020-10-05 07:28:59', '', 'Shabil -', 142, 2, '2020-10-05', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 55, '2020-10-05 07:28:59', 69, '2020-10-05 07:56:22'),
(10400, 20014, '', '10400', 'E', 1, '<p>\n	Allocation Problem</p>\n', '2020-10-05 09:43:17', 'waddah051020.png', 'JOHN', 41, 12, '2020-10-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-05 09:43:17', 1, '2020-10-11 05:00:02'),
(10401, 20003, '', '10401', 'E', 1, '<p>\n	can list 3 requests related the palybook</p>\n<ul>\n	<li>\n		End of shift check list</li>\n	<li>\n		Consumables check list</li>\n	<li>\n		Prepare the list of capabilities (Key Skills per shift)</li>\n</ul>\n', '2020-10-05 17:03:13', '', 'JOHN', 8, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30004', 0, 0, '', '', 69, '2020-10-05 17:03:13', 1, '2022-07-29 05:00:04'),
(10402, 20049, '', '10402', 'E', 1, '<p>\n	<strong><span style=\"font-size:11.0pt\">Please change the word &lsquo;P.O.Box&rsquo; to &lsquo;Post Code&rsquo;. It should reflect in the quotation and invoices too. </span></strong></p>\n<p>\n	<strong><span style=\"font-size:11.0pt\">ERPLite - NORDEN</span></strong></p>\n', '2020-10-06 08:03:47', '', 'JOHN', 146, 12, '2020-10-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-06 08:03:47', 1, '2020-10-14 05:00:02'),
(10403, 20067, '', '10403', 'E', 1, '<p>\n	Software Implimentation</p>\n', '2020-10-05 08:08:54', '', 'JOHN', 200, 12, '2021-02-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-05 08:08:54', 69, '2021-02-22 12:34:59'),
(10404, 20012, '', '10404', 'E', 1, '<p>\n	As discussed, kindly arrange to get the reminder email on daily basis one time to my email id <a href=\"mailto:lathikka@tetraaxis.com\">lathikka@tetraaxis.com</a>.</p>\n', '2020-10-06 17:05:49', '', 'JOHN', 35, 12, '2020-10-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-06 17:05:49', 1, '2020-10-18 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
(10613, 20020, '', '10613', 'E', 1, '<p>\n	please change salesman</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 39564 characters]\" /></p>\n', '2021-02-22 12:17:47', '', 'JOHN', 59, 12, '2021-02-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-22 12:17:47', 1, '2021-02-28 06:00:02'),
(10405, 20002, '', '10405', 'E', 1, '<p>\n	Part Number Renaming (See attached)</p>\n', '2020-10-08 12:22:02', 'WhatsApp Image 2020-10-06 at 12.37.37 PM.jpeg', 'JOHN', 5, 12, '2020-10-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-08 12:22:02', 1, '2020-10-14 05:00:02'),
(10406, 20001, '', '10406', 'E', 1, '<p>\n	Proforma Invoice - Label Changing</p>\n<p>\n	Finance Department Number Changing</p>\n', '2020-10-10 14:54:22', '', 'JOHN', 2, 12, '2020-10-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-10 14:54:22', 1, '2020-10-18 05:00:02'),
(10407, 20002, '', '10407', 'E', 1, '<p>\n	Hi,</p>\n<p>\n	Please remove below file from order as customer has revised LPO and we have made new file against the revised LPO.</p>\n<table aria-describedby=\"tble_order_info\" class=\"table table-hover table-bordered personal-task dataTable\" id=\"tble_order\" role=\"grid\" style=\"box-sizing: inherit; border-spacing: 0px; width: 1458.89px; border-top: none; border-right-style: solid; border-right-color: rgb(221, 221, 221); border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); border-left-style: solid; border-left-color: rgb(221, 221, 221); clear: both; color: rgba(0, 0, 0, 0.68); font-family: Ubuntu, sans-serif; font-size: 14.3px; max-width: none !important; margin-bottom: 0px !important; margin-top: 0px !important;\">\n	<tbody style=\"box-sizing: inherit;\">\n		<tr class=\"odd\" role=\"row\" style=\"box-sizing: inherit; background-color: rgb(245, 245, 245);\">\n			<td style=\"box-sizing: content-box; padding: 3px 8px; line-height: 1.42857; vertical-align: middle; border-bottom: 0px solid rgb(221, 221, 221); border-left: 0px solid rgb(221, 221, 221); border-top-style: solid; border-right-style: solid; border-top-color: rgb(221, 221, 221); border-right-color: rgb(221, 221, 221);\">\n				38031</td>\n			<td class=\"sorting_1\" style=\"box-sizing: content-box; padding: 3px 8px; line-height: 1.42857; vertical-align: middle; border-bottom: 0px solid rgb(221, 221, 221); border-left: 0px solid rgb(221, 221, 221); border-top-style: solid; border-right-style: solid; border-top-color: rgb(221, 221, 221); border-right-color: rgb(221, 221, 221);\">\n				211300</td>\n			<td style=\"box-sizing: content-box; padding: 3px 8px; line-height: 1.42857; vertical-align: middle; border-bottom: 0px solid rgb(221, 221, 221); border-left: 0px solid rgb(221, 221, 221); border-top-style: solid; border-right-style: solid; border-top-color: rgb(221, 221, 221); border-right-color: rgb(221, 221, 221);\">\n				Mesopot Design And Built Building Services LLC</td>\n			<td style=\"box-sizing: content-box; padding: 3px 8px; line-height: 1.42857; vertical-align: middle; border-bottom: 0px solid rgb(221, 221, 221); border-left: 0px solid rgb(221, 221, 221); border-top-style: solid; border-right-style: solid; border-top-color: rgb(221, 221, 221); border-right-color: rgb(221, 221, 221);\">\n				Tebin Kalam</td>\n			<td style=\"box-sizing: content-box; padding: 3px 8px; line-height: 1.42857; vertical-align: middle; border-bottom: 0px solid rgb(221, 221, 221); border-left: 0px solid rgb(221, 221, 221); border-top-style: solid; border-right-style: solid; border-top-color: rgb(221, 221, 221); border-right-color: rgb(221, 221, 221);\">\n				12/10/2020</td>\n			<td style=\"box-sizing: content-box; padding: 3px 8px; line-height: 1.42857; vertical-align: middle; border-bottom: 0px solid rgb(221, 221, 221); border-left: 0px solid rgb(221, 221, 221); border-top-style: solid; border-right-style: solid; border-top-color: rgb(221, 221, 221); border-right-color: rgb(221, 221, 221);\">\n				11/11/2020</td>\n			<td style=\"box-sizing: content-box; padding: 3px 8px; line-height: 1.42857; vertical-align: middle; border-bottom: 0px solid rgb(221, 221, 221); border-left: 0px solid rgb(221, 221, 221); border-top-style: solid; border-right-style: solid; border-top-color: rgb(221, 221, 221); border-right-color: rgb(221, 221, 221);\">\n				AED</td>\n			<td class=\"text-right\" style=\"box-sizing: content-box; padding: 3px 8px; text-align: right; line-height: 1.42857; vertical-align: middle; border-bottom: 0px solid rgb(221, 221, 221); border-left: 0px solid rgb(221, 221, 221); border-top-style: solid; border-right-style: solid; border-top-color: rgb(221, 221, 221); border-right-color: rgb(221, 221, 221);\">\n				728.87</td>\n			<td class=\"text-right\" style=\"box-sizing: content-box; padding: 3px 8px; text-align: right; line-height: 1.42857; vertical-align: middle; border-bottom: 0px solid rgb(221, 221, 221); border-left: 0px solid rgb(221, 221, 221); border-top-style: solid; border-right-style: solid; border-top-color: rgb(221, 221, 221); border-right-color: rgb(221, 221, 221);\">\n				15,306.33</td>\n			<td style=\"box-sizing: content-box; padding: 3px 8px; line-height: 1.42857; vertical-align: middle; border-bottom: 0px solid rgb(221, 221, 221); border-left: 0px solid rgb(221, 221, 221); border-top-style: solid; border-right-style: solid; border-top-color: rgb(221, 221, 221); border-right-color: rgb(221, 221, 221);\">\n				Order</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	&nbsp;</p>\n<p>\n	regards,</p>\n<p>\n	tebin&nbsp;</p>\n', '2020-10-12 11:29:28', '', 'Tebin Kalam', 5, 12, '2020-10-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 9, '2020-10-12 11:29:28', 1, '2020-10-18 05:00:02'),
(10408, 20013, '', '10408', 'E', 1, '<p>\n	Please correct the freight charges to 178 USD instead of 652. Purchased invoice no. 803725.</p>\n', '2020-10-12 12:01:06', 'PI803725.pdf', 'Rhealiza G', 37, 12, '2020-10-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-10-12 12:01:06', 1, '2020-10-18 05:00:02'),
(10409, 20013, '', '10409', 'E', 1, '<p>\n	Need the complete Customer Contact Report in Excel.</p>\n<p>\n	Unable to download the report in Excel format.</p>\n<p>\n	This is required urgently.</p>\n<p>\n	Please send it by email to me and also fix the issue.</p>\n<p>\n	Thanks</p>\n<p>\n	Ganesan</p>\n', '2020-10-12 12:32:16', '', 'Ganesan K.', 37, 12, '2020-10-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-10-12 12:32:16', 1, '2020-10-18 05:00:02'),
(10410, 20036, '', '10410', 'I', 1, '<p>\n	<span style=\"color:#1F497D\">Please find below and kindly add a column for &lsquo;Transact by&rsquo; to determine who is the user who made the transactions. We need to verify who and which transaction he process.</span></p>\n', '2020-10-13 09:48:05', 'Hayat131020.jpg', 'JOHN', 107, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-10-13 09:48:05', 1, '2022-07-29 05:00:04');
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
(10411, 20002, '', '10411', 'E', 1, '<p>\n	&nbsp;</p>\n<p>\n	Please correct Unit price discrepancy in following LPOs to complete purchase.</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65388 characters]', '2020-10-13 12:47:12', 'nordenuae-PO-Change-13-10-20.png', 'Tebin Kalam', 4, 12, '2020-10-19', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 9, '2020-10-13 12:47:12', 1, '2020-10-19 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
(10412, 20036, '', '10412', 'I', 1, '<p>\n	Kindly update on below mail sent from Monday, August 31, 2020 10:33 AManother same problem occurred. Please see images below.</p>\n<p>\n	On the QTY available It was showing 3PCS instead of 0.</p>\n<p>\n	<span style=\"font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D\">While I don&rsquo;t have available QTY on FLM WAREHOUSE, it will show 0 instead of 3.</span></p>\n', '2020-10-14 15:07:47', 'hayat141020-1.jpg,hayat141020-2.jpg', 'JOHN', 107, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-10-14 15:07:47', 1, '2022-07-29 05:00:04'),
(10413, 20013, '', '10413', 'E', 1, '<p>\n	<em>As we discussed yesterday along with Ganesan, we have noticed one more below mentioned item also. Because of the wrong information displayed, sales team committed that the stock exist whereas physically no stock.</em></p>\n<p>\n	<em>We request you to kindly take necessary action to resolve at the earliest to resolve for all items. (Attached below screenshot for your reference).</em></p>\n<p>\n	<em>Item - </em><em>EKI-2712G-4FPI-AE. </em><em>&nbsp;&nbsp;-&nbsp; The correct value should be 0.</em></p>\n<p>\n	<br />\n	&nbsp;</p>\n', '2020-10-14 17:37:51', 'top1.png,top2.png,top3.png', 'JOHN', 38, 12, '2020-10-21', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-14 17:37:51', 1, '2020-10-21 05:00:01'),
(10414, 20002, '', '10414', 'E', 1, '<p>\n	See below inventory transaction report. 21 pcs stock and physically also 21. But in main inventory query showing 22pcs</p>\n<p>\n	<br />\n	&nbsp;</p>\n', '2020-10-15 17:36:20', 'norden151020.jpg', 'JOHN', 5, 12, '2021-01-16', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2020-10-15 17:36:20', 1, '2021-01-16 06:00:02'),
(10415, 20025, '', '10415', 'E', 1, '<p>\n	https://alfadil.weibex.com/betterhome/index.php?r=directorder/index</p>\n<p>\n	BH112, sadmin, demo</p>\n<p>\n	first of all , invoice search is not working</p>\n<p>\n	Invoice No 104074 dt 20/8/20, 2 items are there, one doesnt have sales price</p>\n', '2020-10-17 17:38:34', 'BH112.pdf', 'JOHN', 74, 12, '2020-10-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-17 17:38:34', 1, '2020-10-26 06:00:02'),
(10416, 20001, '', '10416', 'E', 1, '<p>\n	Add one more status in the Customer Details (Do not send flyer)<br />\n	If we mark as &#39;Do not send flyer&#39; the email should not come in the &#39;flyer to be send&#39; report</p>\n', '2020-10-18 09:51:17', '', 'Acecentro User', 1, 2, '2020-10-22', 0, '0000-00-00', '', 0, '0', '', '30004', 0, 0, '', '', 8, '2020-10-18 09:51:17', 69, '2020-10-22 10:28:44'),
(10417, 20001, '', '10417', 'E', 1, '<p>\n	Please add INVENTORY TYPE filter in &#39;Rakwise Report&#39;</p>\n', '2020-10-18 09:52:24', '', 'Acecentro User', 1, 12, '2021-01-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 8, '2020-10-18 09:52:24', 1, '2021-01-29 06:00:02'),
(10418, 20008, '', '10418', 'I', 1, '<p>\n	Zipped File - 6331881</p>\n<p>\n	Kindly unzipped the captioned plan in the CRM, this is one of the files uploaded initially. Please do the needful urgently.</p>\n<p>\n	The new password of the CRM is Computer18.</p>\n', '2020-10-18 12:59:53', '', 'JOHN', 23, 12, '2020-10-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-18 12:59:53', 1, '2020-10-25 06:00:02'),
(10419, 20001, '', '10419', 'E', 1, '<p>\n	Inventory reports are wrong.<br />\n	Stock state as of - details&nbsp;</p>\n<p>\n	NB: Please test and varify all the reports value before making live. Finance team is working based on reports so it should be 100% proper.</p>\n', '2020-10-18 13:08:34', '', 'Acecentro User', 1, 12, '2021-01-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 8, '2020-10-18 13:08:34', 1, '2021-01-29 06:00:02'),
(10420, 20001, '', '10420', 'E', 1, '<h1>\n	<em><strong><span style=\"color:#ff0000;\">Any update on the following Complaint Numbers?</span></strong></em></h1>\n<ol>\n	<li>\n		<strong><span style=\"color:#ff0000;\">10261 dated on 06/08/2020</span></strong></li>\n	<li>\n		<span style=\"color:#ff0000;\">10394 dated on 01/10/2020</span></li>\n	<li>\n		10390 dated on 28/09/2020</li>\n	<li>\n		10381 dated on 22/09/2020</li>\n	<li>\n		<span style=\"color:#ff0000;\">10340 dated on 05/09/2020</span></li>\n</ol>\n', '2020-10-18 13:14:14', '', 'Acecentro User', 1, 12, '2021-01-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 8, '2020-10-18 13:14:14', 1, '2021-01-29 06:00:02'),
(10422, 20002, '', '10422', 'E', 1, '<p>\n	Change in LPO, MR and QC</p>\n<p>\n	check attachment</p>\n', '2020-10-19 10:36:24', 'norden191020.jpg', 'JOHN', 5, 12, '2020-10-19', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-19 10:36:24', 69, '2020-10-19 10:37:50'),
(10423, 20002, '', '10423', 'E', 1, '<p>\n	Dear John,</p>\n<p>\n	&nbsp;</p>\n<p>\n	Kindly note that file 38044 quoted without VAT as it is shipment fare, But invoice has generated with tax. Kindly remove vat from the invoice.</p>\n<p>\n	Quotation and invoice attached for reference.</p>\n<p>\n	&nbsp;</p>\n', '2020-10-20 08:48:44', 'Tax Invoice.JPG,38044_PAN Arabia.pdf,TI-411295.pdf', 'Tebin Kalam', 4, 12, '2020-10-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 9, '2020-10-20 08:48:44', 1, '2020-10-27 06:00:02'),
(10424, 20001, '', '10424', 'E', 1, '<p>\n	Item image not found-</p>\n', '2020-10-20 12:21:18', 'WhatsApp Image 2020-10-20 at 9.16.11 AM.jpeg', 'JOHN', 2, 12, '2020-10-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-20 12:21:18', 1, '2020-10-27 06:00:02'),
(10425, 20001, '', '10425', 'I', 1, '<p>\n	Sales Quoation, Order, Delivery etc now not handling service items qty more than 1</p>\n<p>\n	Eg cutting charge only 1*100 can be selected not 2*100</p>\n', '2020-10-21 10:35:52', '', 'JOHN', 2, 2, '2020-10-21', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2020-10-21 10:35:52', 69, '2020-10-21 10:36:04'),
(10475, 20001, '', '10475', 'I', 1, '<p>\n	Hire invoice , 400804 created by adjusting amount from advance invoice 400797</p>\n<p>\n	but when 400804 is cancelled , the amount taken from 400797 should be put back</p>\n', '2020-12-07 17:40:55', '', 'JOHN', 2, 12, '2020-12-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-07 17:40:55', 1, '2020-12-14 06:00:01'),
(10426, 20067, '', '10426', 'I', 1, '<p>\n	Service item Quantity Problem - Do in ACE</p>\n', '2020-10-21 16:42:04', '', 'JOHN', 200, 2, '2020-10-21', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2020-10-21 16:42:04', 69, '2020-10-21 16:42:26'),
(10427, 20065, '', '10427', 'I', 1, '<p>\n	Design Correction</p>\n<p>\n	https://blueskyhrms.com/hr/index.php?r=employee/ViewProfile</p>\n<p>\n	MTC</p>\n<p>\n	M10019</p>\n<p>\n	M10019</p>\n', '2020-10-21 16:48:13', 'mtc.png', 'JOHN', 194, 12, '2021-01-22', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2020-10-21 16:48:13', 1, '2021-01-22 06:00:01'),
(10428, 20004, '', '10428', 'I', 1, '<p>\n	Please find attached customs inventory report and DA copy for your reference</p>\n<p>\n	Please note that in this report INV NO. 53605 details are not matching with customs inventory reports</p>\n<p>\n	We have requested many times to rectify this issues but it is still pending from day one.</p>\n<p>\n	Kindly solve this issue on priority basis.</p>\n', '2020-10-21 17:16:42', 'delivery_advise 1842-09-20-1018.pdf,customs_inventory (21).xlsx', 'JOHN', 11, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-10-21 17:16:42', 1, '2022-07-29 05:00:04'),
(10623, 20022, '', '10623', 'E', 1, '<p>\n	E Sell Migration</p>\n', '2021-03-01 14:22:55', '', 'JOHN', 65, 12, '2021-05-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-03-01 14:22:55', 1, '2021-05-23 05:00:02'),
(10429, 20007, '', '10429', 'I', 1, '<p>\n	http://erp.weibex.com/2019/</p>\n<p>\n	FST01/sadmin/demo</p>\n<p>\n	Check the cost issue</p>\n<p>\n	they are saying that sales price is less than cost price, but check we have put already<br />\n	only possibility may be from Multiple UOM<br />\n	See attched</p>\n', '2020-10-22 10:50:17', 'WhatsApp Image 2020-10-17 at 10.31.21 AM.jpeg,WhatsApp Image 2020-10-17 at 10.31.21 AM(1).jpeg,WhatsApp Image 2020-10-15 at 3.36.48 PM.jpeg', 'JOHN', 19, 12, '2020-11-06', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-22 10:50:17', 1, '2020-11-06 06:00:04'),
(10430, 20049, '', '10430', 'E', 1, '<p>\n	NORDEN UK- Erp Lite</p>\n<p>\n	Could you please amend the quote format as per the attached excel sheet? We don&rsquo;t need to have columns for tax% and tax amount.</p>\n<p>\n	Better create another print button, so that others running on erplite wont get affected</p>\n<p>\n	<br />\n	&nbsp;</p>\n', '2020-10-22 15:54:26', '1827R1 CMW.xlsx,Screen Shot 2020-10-22 at 10.15.32.png', 'JOHN', 146, 12, '2020-10-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-22 15:54:26', 1, '2020-10-30 06:00:05'),
(10431, 20001, '', '10431', 'E', 1, '<p>\n	Hire Order No 200612, 200613</p>\n<p>\n	Change Billing date from 8/10/2020 to 07/10/20<br />\n	they cant do it because machine returned on 14/10/20</p>\n', '2020-10-26 09:11:40', '', 'JOHN', 2, 12, '2020-11-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-26 09:11:40', 1, '2020-11-01 06:00:02'),
(10432, 20001, '', '10432', 'I', 1, '<p>\n	Hire Quotation File 3558, Q 102209<br />\n	900 Discount given (see screenshot1)</p>\n<p>\n	Print it should show 0, but now showing -900 (see second screenshot)</p>\n', '2020-10-26 10:24:57', 'ace261020-2.png,ace261020-1.png', 'JOHN', 2, 12, '2020-11-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-26 10:24:57', 1, '2020-11-01 06:00:02'),
(10433, 20001, '', '10433', 'I', 1, '<p>\n	Sales Order File no :2490, Q 101268</p>\n<p>\n	quotion optional equipmemts where thereand they took a print of it and kept also (showed to me)</p>\n<p>\n	In Order they removed the optional components since customer doesnt want it</p>\n<p>\n	so now it went away from qutation also</p>\n<p>\n	They found this when copying the old quotation</p>\n<p>\n	We should try in staging and verify</p>\n', '2020-10-26 10:27:47', '', 'JOHN', 2, 12, '2020-11-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-26 10:27:47', 1, '2020-11-01 06:00:02'),
(10434, 20068, '', '10434', 'E', 1, '<p>\n	NewPOS integartion</p>\n', '2020-10-26 15:21:59', '', 'JOHN', 203, 12, '2021-02-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-26 15:21:59', 1, '2021-02-03 06:00:02'),
(10435, 20002, '', '10435', 'E', 1, '<p>\n	Dear John,</p>\n<p>\n	&nbsp;</p>\n<p>\n	Kindly amend below part Number.</p>\n<p>\n	&nbsp;</p>\n<p>\n	39-5S32L3M-Dummy1&agrave;39-5S32L3MX-Dummy1&nbsp; &nbsp;( LC / APC SM FIiber Splitter 2x32 R/M Dummy1)</p>\n<p>\n	&nbsp;</p>\n<p>\n	Regards,</p>\n<p style=\"margin-left:31.5pt;\">\n	&nbsp;</p>\n<p style=\"margin-left:31.5pt;\">\n	<img height=\"321\" src=\"file:///C:/Users/Michelle/AppData/Local/Temp/msohtmlclip1/01/clip_image002.gif\" style=\"height:3.343in;width:3.5in;\" width=\"336\" /></p>\n', '2020-10-27 09:52:48', 'Part Number Amendment.JPG,Part Number Amendment57.JPG', 'Tebin Kalam', 5, 12, '2020-11-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 9, '2020-10-27 09:52:48', 1, '2020-11-02 06:00:02'),
(10436, 20013, '', '10436', 'E', 1, '<div class=\"pull-right\" style=\"box-sizing: inherit; float: right; color: rgba(0, 0, 0, 0.68); font-family: Helvetica, sans-serif; font-size: 16px; font-weight: 600;\">\n	<div class=\"filter_details\" style=\"box-sizing: inherit; font-weight: normal; font-size: 1.3rem; width: 500px; line-height: 19px; align-self: flex-end;\">\n		&nbsp;</div>\n</div>\n<div>\n	<p>\n		Item 10031 Actually no stock&nbsp;&nbsp;</p>\n	<p>\n		CRM - Inventory Report showing 20 qty</p>\n	<p>\n		CRM- Transaction Details&nbsp;showing 0 qty</p>\n	<p>\n		Please rectify and update</p>\n</div>\n', '2020-10-28 14:48:34', '10031.png', 'Rajesh C', 37, 12, '2020-11-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-10-28 14:48:34', 1, '2020-11-10 06:00:01'),
(10437, 20065, '', '10437', 'E', 1, '<p>\n	Report-&gt;Employee- &gt; Emloyee Salary-&gt; Excel and PDF correction</p>\n', '2020-10-28 17:12:45', '', 'JOHN', 194, 12, '2020-11-06', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-28 17:12:45', 1, '2020-11-06 06:00:04'),
(10438, 20065, '', '10438', 'I', 1, '<p>\n	1)Payslip - Sep- Jafza- Emp Javedh - overtime splitup showing in slip eventhough its not taken</p>\n<p>\n	2) Remove the Sick leave 15&nbsp; and Personal leve 365 from bottom</p>\n', '2020-10-28 17:16:43', '', 'JOHN', 194, 12, '2020-11-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-28 17:16:43', 1, '2020-11-10 06:00:01'),
(10439, 20062, '', '10439', 'E', 0, '<p>\n	Test</p>\n', '2020-10-28 17:42:56', '', 'Diatech User', 185, 12, '2020-10-31', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 74, '2020-10-28 17:42:56', 69, '2020-10-31 09:54:38'),
(10440, 20007, '', '10440', 'I', 1, '<p>\n	Reports- Sale- Daily Sale</p>\n<p>\n	Start Date 29/10/20 , End Date :29/10/20, Ware House Van05 Azhar<br />\n	Scrol beow and cme to receipt section<br />\n	see 33rd and 34th line, i think duplicate entry came while saving</p>\n<p>\n	Customer : KING OASAIS SATWA<br />\n	Inv 457805<br />\n	Receits : 49729 and 49730 duplicate</p>\n', '2020-10-31 10:00:43', 'WhatsApp Image 2020-10-31 at 9.09.05 AM.jpeg', 'JOHN', 20, 12, '2020-11-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-10-31 10:00:43', 1, '2020-11-09 06:00:02'),
(10441, 20001, '', '10441', 'I', 1, '<p>\n	Please rewrite the auditlog cron job, so that it will delete the entries over previous 60 days data</p>\n', '2020-11-02 09:05:10', '', 'JOHN', 2, 12, '2020-11-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-02 09:05:10', 1, '2020-11-16 06:00:02'),
(10442, 20004, '', '10442', 'E', 1, '<p>\n	When we select the Despatch notes to make pre invoice, some times the selected DO doesnt affect the Pre invoice. If we go and deselect and then select it will work</p>\n', '2020-11-05 10:03:08', '', 'JOHN', 11, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-11-05 10:03:08', 1, '2022-07-29 05:00:04'),
(10443, 20001, '', '10443', 'I', 1, '<p>\n	Serial Number changing problem while Item Transfer</p>\n', '2020-11-09 11:56:23', '', 'JOHN', 2, 12, '2020-12-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-09 11:56:23', 1, '2020-12-16 06:00:02'),
(10444, 20001, '', '10444', 'I', 1, '<p>\n	Packaging error, see attached files</p>\n', '2020-11-09 15:43:41', 'ERP Correction for Jomin.xlsx,WhatsApp Image 2020-11-09 at 12.18.40 PM.jpeg', 'JOHN', 2, 12, '2020-12-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-09 15:43:41', 1, '2020-12-16 06:00:02'),
(10445, 20002, '', '10445', 'E', 1, '<p>\n	Stock taking report - correction<br />\n	Mapping of Rack</p>\n', '2020-11-10 08:21:16', '', 'JOHN', 5, 12, '2020-12-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-10 08:21:16', 1, '2020-12-23 06:00:02'),
(10446, 20002, '', '10446', 'E', 1, '<p>\n	Make a master called Team, which has same permision as that of Rack</p>\n<p>\n	Provision to add items i Team master</p>\n<p>\n	A deault one is necesary,</p>\n<p>\n	In the edit rack popup, able to link that rack with a particular Team</p>\n<p>\n	In the initila phase all racks will come under default item in team</p>\n', '2020-11-10 11:23:36', '', 'JOHN', 5, 12, '2020-11-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-10 11:23:36', 1, '2020-11-16 06:00:02'),
(10447, 20001, '', '10447', 'I', 1, '<p>\n	Vinayak 2/11 to 5/11 Annual leave change to sick leave</p>\n<p>\n	vinayak 6/11 full week end</p>\n<p>\n	Jomin 28/10 sick, 29/10 public holiday, 30/10 week end</p>\n', '2020-11-10 12:02:33', '', 'JOHN', 2, 12, '2020-11-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-10 12:02:33', 1, '2020-11-16 06:00:02'),
(10448, 20028, '', '10448', 'E', 1, '<p>\n	<span style=\"color:#1F497D\">Regarding below we still facing same issue</span></p>\n<p>\n	<span style=\"color:#1F497D\">see atatched</span></p>\n', '2020-11-10 12:31:16', 'leave.png', 'JOHN', 83, 12, '2020-12-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-10 12:31:16', 1, '2020-12-17 06:00:02'),
(10449, 20001, '', '10449', 'E', 1, '<p>\n	As discussed please find below the account details of M/s. ACE CENTRO ENTERPRISES NBF account.</p>\n<p>\n	&nbsp;</p>\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:561px;\" width=\"0\">\n	<tbody>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:219px;height:20px;\">\n				<p>\n					<strong>Account Name</strong></p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:343px;height:20px;\">\n				<p>\n					M/s. ACE CENTRO ENTERPRISES</p>\n			</td>\n		</tr>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:219px;height:20px;\">\n				<p>\n					<strong>IBAN No.</strong></p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:343px;height:20px;\">\n				<p>\n					AE75-0380-0000-1200-0988748</p>\n			</td>\n		</tr>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:219px;height:20px;\">\n				<p>\n					<strong>Account No.</strong></p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:343px;height:20px;\">\n				<p>\n					0120-0098-8748</p>\n			</td>\n		</tr>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:219px;height:20px;\">\n				<p>\n					<strong>Currency </strong></p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:343px;height:20px;\">\n				<p>\n					AED</p>\n			</td>\n		</tr>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:219px;height:20px;\">\n				<p>\n					<strong>Bank Name</strong></p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:343px;height:20px;\">\n				<p>\n					NATIONAL BANK OF FUJAIRAH</p>\n			</td>\n		</tr>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:219px;height:20px;\">\n				<p>\n					&nbsp;</p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:343px;height:20px;\">\n				<p>\n					Corniche Branch, Abu Dhabi &ndash; U.A.E</p>\n			</td>\n		</tr>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:219px;height:20px;\">\n				<p>\n					&nbsp;</p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:343px;height:20px;\">\n				<p>\n					T: - +971 2 612 5336</p>\n			</td>\n		</tr>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:219px;height:21px;\">\n				<p>\n					<strong>Swift code</strong></p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:343px;height:21px;\">\n				<p>\n					NBFUAEAFAUH</p>\n			</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	&nbsp;</p>\n', '2020-11-14 16:21:01', '', 'Acecentro User', 1, 12, '2020-11-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 8, '2020-11-14 16:21:01', 1, '2020-11-22 06:00:02'),
(10450, 20012, '', '10450', 'E', 1, '<p>\n	These two unpaid leave to be changed to paid leave</p>\n<p>\n	See atatched</p>\n', '2020-11-16 15:39:54', 'WhatsApp Image 2020-11-16 at 3.24.06 PM.jpeg,WhatsApp Image 2020-11-16 at 3.24.33 PM.jpeg', 'JOHN', 35, 12, '2020-11-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-16 15:39:54', 1, '2020-11-25 06:00:02'),
(10451, 20001, '', '10451', 'I', 1, '<p>\n	1. Salary Slip, Annual Leave addition and reduction do not show in print</p>\n<p>\n	2. Employee grid - sort order check</p>\n<p>\n	3. report - leave year ledger- jomin. Sick leave - count difference</p>\n', '2020-11-17 11:49:19', '', 'JOHN', 2, 12, '2020-12-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-17 11:49:19', 1, '2020-12-01 06:00:02'),
(10452, 20007, '', '10452', 'E', 1, '<p>\n	Cash sale office invoice no 461662 AED 38.31 double payment. Pls check and fix this issue permenantly</p>\n', '2020-11-23 14:35:27', 'WhatsApp Image 2020-11-23 at 2.29.42 PM.jpeg', 'JOHN', 20, 12, '2021-01-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-23 14:35:27', 1, '2021-01-11 06:00:02'),
(10453, 20001, '', '10453', 'I', 1, '<p>\n	item 141-04-00001</p>\n<p>\n	transaction detail shows balance 7</p>\n<p>\n	but inventory ledger showing balance 7, but it showuld show some thing like31 24 7</p>\n', '2020-11-23 17:34:03', '', 'JOHN', 2, 12, '2020-12-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-23 17:34:03', 1, '2020-12-01 06:00:02'),
(10454, 20001, '', '10454', 'I', 1, '<p>\n	Serial number mismatch problem</p>\n', '2020-11-23 17:37:26', 'WhatsApp Image 2020-11-22 at 3.54.51 PM.jpeg,WhatsApp Image 2020-11-22 at 3.54.45 PM.jpeg,WhatsApp Image 2020-11-22 at 3.52.23 PM.jpeg', 'JOHN', 2, 12, '2020-12-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-23 17:37:26', 1, '2020-12-16 06:00:02'),
(10456, 20065, '', '10456', 'E', 1, '<p>\n	Sif file correction in&nbsp; wps and Exchange</p>\n', '2020-11-26 09:25:33', '', 'JOHN', 194, 12, '2020-12-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-26 09:25:33', 1, '2020-12-14 06:00:01'),
(10457, 20001, '', '10457', 'I', 1, '<p>\n	1. Direct Transfer -- Transfer -- Edit option before packaging</p>\n<p>\n	2. Qty Checking\\</p>\n<p>\n	3. When item select -- show available qty</p>\n<p>\n	4. When change from warehouse -- clear all items with a confirmation message</p>\n<p>\n	&nbsp;</p>\n', '2020-11-26 11:31:08', '', 'mereenak', 2, 12, '2020-12-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2020-11-26 11:31:08', 1, '2020-12-14 06:00:01'),
(10458, 20001, '', '10458', 'I', 1, '<p>\n	1. Warehouse detailed report</p>\n<p>\n	Description</p>\n<p>\n	2. Filter -- having stock/machine or spare</p>\n<p>\n	&nbsp;</p>\n', '2020-11-26 11:32:28', '', 'mereenak', 2, 12, '2021-01-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2020-11-26 11:32:28', 1, '2021-01-24 06:00:02'),
(10459, 20001, '', '10459', 'I', 1, '<p>\n	1. when take copy-- carryforward optional equipment\\</p>\n<p>\n	2. qtn convert to order-- missing optional equipment</p>\n<p>\n	3.Advance invoice -- againt vs invoice list</p>\n', '2020-11-26 11:40:45', '', 'mereenak', 2, 12, '2020-12-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2020-11-26 11:40:45', 1, '2020-12-16 06:00:02'),
(10460, 20002, '', '10460', 'E', 0, '<p>\n	Dear John,</p>\n<p>\n	I&rsquo;m not able to create the part number from today morning. After saving new part number, I&rsquo;m getting following white screen with loading symbol only.</p>\n<p>\n	Kindly check and resolve it asap.</p>\n<p>\n	&nbsp;</p>\n<p>\n	regards,</p>\n<p>\n	Tebin&nbsp;</p>\n', '2020-11-26 15:07:00', 'Part Number creation.JPG', 'Tebin Kalam', 4, 12, '2020-12-05', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 9, '2020-11-26 15:07:00', 1, '2020-12-05 06:00:02'),
(10461, 20001, '', '10461', 'E', 1, '<p>\n	1. Reports&gt;sales&gt;Invoice --</p>\n<p>\n	Filter for invoice type [ Advance invoice etc]</p>\n<p>\n	&nbsp;</p>\n', '2020-11-27 09:10:50', '', 'mereenak', 2, 12, '2021-01-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2020-11-27 09:10:50', 1, '2021-01-24 06:00:02'),
(10484, 20071, '', '10484', 'E', 1, '<p>\n	HR Installation</p>\n', '2020-12-08 08:29:23', '', 'JOHN', 212, 12, '2021-06-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-10 08:29:23', 1, '2021-06-18 05:00:06'),
(10462, 20007, '', '10462', 'E', 1, '<p>\n	When Invoice save is clicked,</p>\n<p>\n	if invoice type is taxable and Total Tax amount is zero, Display a message : &quot; Please check - Tax value zero&quot;</p>\n<p>\n	and</p>\n<p>\n	if invoice type is taxable - no such checking</p>\n', '2020-11-28 10:03:39', '', 'JOHN', 20, 12, '2021-01-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-28 10:03:39', 1, '2021-01-11 06:00:02'),
(10463, 20001, '', '10463', 'I', 1, '<p>\n	In HR , when we edit the document date , andgive a new date , the date of reminder date is not recalculating<br />\n	since its a locked field, now they delete the old entry and add as new one<br />\n	please correct , and check other HR systems as well</p>\n<p>\n	&nbsp;</p>\n', '2020-11-28 10:19:54', '', 'JOHN', 2, 12, '2020-12-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-28 10:19:54', 1, '2020-12-16 06:00:02'),
(10464, 20065, '', '10464', 'E', 1, '<p>\n	Remove that annual leave addition and deduction from payslip</p>\n<p>\n	they want cash type print to be modified</p>\n<p>\n	Jebal ali type bank sif</p>\n<p>\n	Non wps option (direct bank transfer)</p>\n<p>\n	salaey excel sheet at the end show payment option</p>\n', '2020-11-29 10:43:04', 'WPS SALARY OCT\'20.xls', 'JOHN', 194, 12, '2020-12-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-29 10:43:04', 1, '2020-12-17 06:00:02'),
(10465, 20025, '', '10465', 'E', 1, '<p>\n	Net Purchase Report correction</p>\n', '2020-11-29 11:22:28', '', 'JOHN', 74, 12, '2021-03-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-29 11:22:28', 1, '2021-03-07 06:00:02'),
(10466, 20004, '', '10466', 'I', 1, '<p>\n	Invoice NO. 55298</p>\n<p>\n	Total quantity as per picking- 3398 pcs</p>\n<p>\n	Document generated-3395 pcs</p>\n<p>\n	Despatch notes- 55297,55298,55299,55300,55301,55302,55303,55304,55305,55306,55307,55308,55309,55310,55311,55312,55313,55314,55315,55317,55318,55319,55347,55379,55380,55381,55382,55383,55384</p>\n<p>\n	<u>Missing items as below</u></p>\n<p>\n	&nbsp;</p>\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:1412px;\" width=\"1412\">\n	<tbody>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:210px;height:11px;\">\n				<p align=\"center\">\n					ORDER_NUMBER</p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:217px;height:11px;\">\n				<p align=\"center\">\n					PICK_LIST</p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:232px;height:11px;\">\n				<p align=\"center\">\n					ITEM_CODE</p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:184px;height:11px;\">\n				<p align=\"center\">\n					GLOBAL_CODE</p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:500px;height:11px;\">\n				<p align=\"center\">\n					ITEM_DESC</p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:69px;height:11px;\">\n				<p align=\"center\">\n					QTY</p>\n			</td>\n		</tr>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:210px;height:31px;\">\n				<p align=\"center\">\n					55297</p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:217px;height:31px;\">\n				<p align=\"center\">\n					SI/20/13299</p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:232px;height:31px;\">\n				<p align=\"center\">\n					6.14252E+11</p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:184px;height:31px;\">\n				<p align=\"center\">\n					AAF5479</p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:500px;height:31px;\">\n				<p align=\"center\">\n					LSPIDERV30M2/B[N82273087]</p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:69px;height:31px;\">\n				<p align=\"center\">\n					2</p>\n			</td>\n		</tr>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:210px;height:31px;\">\n				<p align=\"center\">\n					55303</p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:217px;height:31px;\">\n				<p align=\"center\">\n					SI/20/13300</p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:232px;height:31px;\">\n				<p align=\"center\">\n					V3SKA34</p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:184px;height:31px;\">\n				<p align=\"center\">\n					WZ73010</p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:500px;height:31px;\">\n				<p align=\"center\">\n					YAMAHA VIOLIN</p>\n			</td>\n			<td nowrap=\"nowrap\" style=\"width:69px;height:31px;\">\n				<p align=\"center\">\n					1</p>\n			</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	&nbsp;</p>\n<p>\n	Invoice no: 55149</p>\n<p>\n	Total quantity as per picking-453 pcs</p>\n<p>\n	Document generated-1691 pcs</p>\n<p>\n	Despatch notes- as below table</p>\n<p>\n	&nbsp;</p>\n<p>\n	55149,55219,55220,55221,55222,55223,55224,55225,55226,55227,55282,55283,55284,55285,55286, 55287,55288,55289,55290,55291,55292,55293,55294,55295,55296</p>\n<p>\n	&nbsp;</p>\n<p>\n	Please refer documents for further review (Invoice no 55149 &amp; 55298)</p>\n<p>\n	<br />\n	&nbsp;</p>\n', '2020-11-29 11:24:04', '', 'JOHN', 11, 2, '2020-11-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-11-29 11:24:04', 69, '2020-11-29 11:24:15'),
(10467, 20062, '', '10467', 'I', 1, '<p>\n	Landing cost edit not in ARK, its working in ACE</p>\n', '2020-11-30 10:10:56', '', 'JOHN', 185, 12, '2021-01-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-11-30 10:10:56', 1, '2021-01-25 06:00:01'),
(10468, 20062, '', '10468', 'I', 1, '<p>\n	We ghave sorted the following issue in ACE, pleasecorrect oin ACE</p>\n<p>\n	when Purchase invoice is saved donot take item description from PO, take the Inventory description itself</p>\n<p>\n	long character problem<br />\n	&nbsp;</p>\n', '2020-11-30 10:25:31', '', 'JOHN', 185, 2, '2020-11-30', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2020-11-30 10:25:31', 69, '2020-11-30 10:25:38'),
(10469, 20025, '', '10469', 'I', 1, '<p>\n	Purchase Invoices -- reports -- Total amount is wrong</p>\n', '2020-11-30 10:32:15', 'alfadil1.jpg,alfadil2.jpg', 'mereenak', 74, 12, '2020-12-06', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2020-11-30 10:32:15', 1, '2020-12-06 06:00:02'),
(10470, 20069, '', '10470', 'I', 2, '<p>\n	Complete Rework</p>\n', '2020-12-01 11:11:16', 'Screenshot (169).png,Screenshot (168).png,Screenshot (170).png,Screenshot (171).png', 'Arun', 206, 12, '2021-01-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 1, '2020-12-01 11:11:16', 1, '2021-01-04 06:00:02'),
(10471, 20019, '', '10471', 'I', 1, '<p>\n	Gorica -- Configure new cpanel + phpmyadmin access&nbsp;</p>\n', '2020-12-02 20:57:18', '', 'mereenak', 56, 12, '2020-12-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2020-12-02 20:57:18', 1, '2020-12-11 06:00:08'),
(10472, 20070, '', '10472', 'E', 1, '<p>\n	Mobile App</p>\n', '2020-12-03 08:30:03', '', 'JOHN', 209, 12, '2021-01-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-05 08:30:03', 1, '2021-01-08 06:00:04'),
(10473, 20013, '', '10473', 'E', 1, '<p>\n	Quotations or orders or invoices reports should be modified to include&nbsp;</p>\n<p>\n	* ALL products if no product is selected</p>\n<p>\n	* ONLY the particular product value if any BRAND or PART NO. is selected</p>\n<p>\n	Currently, these reports filter the quotations /orders / invoices matching the BRAND or PRODUCT NO. criteria and list the relevant ones, but the value shown is total. The report should include only the values pertaining to the &nbsp;BRAND or PART NO. is selected.&nbsp;</p>\n<p>\n	This has been requested earlier, but so far we have not got this done.</p>\n<p>\n	Thank you</p>\n', '2020-12-06 06:35:30', '', 'Ganesan K.', 37, 2, '2020-12-06', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 20, '2020-12-06 06:35:30', 69, '2020-12-06 08:15:16'),
(10474, 20065, '', '10474', 'E', 1, '<p>\n	1. Hafza emp Robin , applied for leave and final approval also done, but he cannot apply for leave agaian. they said more people cannot . eg Robin</p>\n<p>\n	2.Notification count showing difeerenctly,</p>\n<p>\n	3. if people are absent, whether it will be counted for loss of pay</p>\n<p>\n	4. sujith Hafza -&nbsp; leave from 9/11, acoording to them they have 22 days of loss of pay, but system shows 17</p>\n', '2020-12-06 12:33:32', '', 'JOHN', 194, 12, '2020-12-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-06 12:33:32', 1, '2020-12-13 06:00:01'),
(10476, 20001, '', '10476', 'I', 1, '<p>\n	direct transfer print in ace needed created by persons name<br />\n	refresh after saving transfer<br />\n	serial number printing after transfer<br />\n	inventory - edit- serial number- group by warehouse<br />\n	material receipt - 240 character checking<br />\n	zero quantity transfer avoid<br />\n	transfer button replace by update<br />\n	credit note lpo number needed<br />\n	&nbsp;</p>\n', '2020-12-07 18:01:40', '', 'JOHN', 2, 12, '2021-01-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-07 18:01:40', 1, '2021-01-24 06:00:02'),
(10477, 20013, '', '10477', 'E', 1, '<p>\n	Error occured yesterday during converting material receipt (stores) to material receipt (QC), double entry in QC.</p>\n<p>\n	need to close receipt ID 703818 in QC details, and change the action icon in Purchased order for PO 602788. PO was already converted to invoice 803798.</p>\n<p>\n	see attacched photo.</p>\n', '2020-12-08 10:02:16', 'QC Check 602788.PNG,PO 602788.PNG', 'Rhealiza G', 37, 12, '2021-02-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-12-08 10:02:16', 1, '2021-02-08 06:00:01'),
(10478, 20001, '', '10478', 'I', 1, '<p>\n	ACE whatever products in transfer packing before this new chabge not found</p>\n<p>\n	Eg 146-02-00006 jack hammer trolley</p>\n', '2020-12-08 12:36:43', '', 'JOHN', 2, 12, '2020-12-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-08 12:36:43', 1, '2020-12-15 06:00:01'),
(10479, 20008, '', '10479', 'I', 1, '<p>\n	Server configutaration change</p>\n', '2020-12-08 12:57:12', '', 'JOHN', 23, 12, '2021-02-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-08 12:57:12', 1, '2021-02-14 06:00:01'),
(10524, 20007, '', '10524', 'I', 1, '<p>\n	when the cost price is greater than sales price warning, show item name also, dont show cost</p>\n', '2021-01-02 12:55:34', 'WhatsApp Image 2021-01-02 at 12.17.17 PM.jpeg', 'JOHN', 20, 12, '2021-01-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-02 12:55:34', 1, '2021-01-11 06:00:02'),
(10480, 20049, '', '10480', 'E', 1, '<p>\n	Norden UK, erplite</p>\n<p>\n	Earlier we used to download price list which we uploaded in ERP lite. Now I am not able to see where we can download. &nbsp;Please check and confirm from where we can download price list which we uploaded.</p>\n', '2020-12-08 14:46:57', '', 'JOHN', 146, 2, '2020-12-08', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2020-12-08 14:46:57', 69, '2020-12-08 14:47:12'),
(10481, 20053, '', '10481', 'E', 1, '<p>\n	Web site correction</p>\n', '2020-12-08 15:14:39', '', 'JOHN', 158, 12, '2020-12-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-08 15:14:39', 1, '2020-12-15 06:00:01'),
(10550, 20002, '', '10550', 'E', 1, '<p>\n	In production order add, please provide a checking so that same material doesnt come in raw material</p>\n', '2021-01-19 08:56:51', '', 'JOHN', 5, 7, '2023-12-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-19 08:56:51', 4, '2023-12-29 13:51:14'),
(10487, 20072, '', '10487', 'I', 1, '<p>\n	Software Implementation</p>\n', '2020-12-11 21:01:42', '', 'mereenak', 215, 12, '2021-02-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2020-12-11 21:01:42', 1, '2021-02-08 06:00:01'),
(10482, 20058, '', '10482', 'I', 2, '<p>\n	New cpanel created for trio and everything upload to new domain</p>\n<p>\n	&nbsp;</p>\n', '2020-12-08 21:04:06', '', 'mereenak', 173, 12, '2020-12-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2020-12-08 21:04:06', 1, '2020-12-15 06:00:01'),
(10483, 20007, '', '10483', 'E', 1, '<p>\n	When the supplier name is cahnged, it doent affect the Fiance Ledger</p>\n<p>\n	I tried Sync Sub ledger option</p>\n<p>\n	please correct it</p>\n', '2020-12-09 16:10:59', 'WhatsApp Image 2020-12-09 at 3.59.27 PM.jpeg,WhatsApp Image 2020-12-09 at 3.59.06 PM.jpeg,WhatsApp Image 2020-12-09 at 3.59.16 PM.jpeg', 'JOHN', 20, 12, '2020-12-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-09 16:10:59', 1, '2020-12-15 06:00:01'),
(10486, 20006, '', '10486', 'E', 1, '<p>\n	If we settle leave salary through payroll process , paid leave days not deducting from staffs due encashment leave days. Pls fix it urgently.</p>\n<p>\n	<br />\n	&nbsp;</p>\n', '2020-12-10 17:35:42', '', 'JOHN', 17, 12, '2020-12-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-10 17:35:42', 69, '2020-12-11 08:37:39'),
(10485, 20002, '', '10485', 'E', 1, '<p>\n	Stock taking/report - lock permission</p>\n', '2020-12-10 09:20:52', '', 'JOHN', 5, 12, '2021-01-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-10 09:20:52', 1, '2021-01-08 06:00:04'),
(10488, 20019, '', '10488', 'E', 1, '<p>\n	Mobile App for ERP</p>\n', '2020-12-12 07:54:23', '', 'JOHN', 56, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30004', 0, 0, '', '', 69, '2020-12-12 07:54:23', 1, '2022-07-29 05:00:04'),
(10489, 20013, '', '10489', 'E', 1, '<p>\n	Inventory discrepancy between transactions details and Bin wise report.</p>\n<p>\n	Please correct it as shown in the attachment.</p>\n<p>\n	Thanks</p>\n<p>\n	Rajesh</p>\n', '2020-12-13 10:35:50', 'MS100210DX.png,MS140033-GT.png,MS700456.png', 'Rajesh C', 37, 12, '2020-12-21', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-12-13 10:35:50', 1, '2020-12-21 06:00:02'),
(10490, 20013, '', '10490', 'E', 1, '<p>\n	Inventory discrepancy between transactions details and Bin wise report.</p>\n<p>\n	Please correct it as shown in the attachment.</p>\n<p>\n	Thanks</p>\n<p>\n	Rajesh</p>\n', '2020-12-13 11:40:04', '2110P.png,Misc Item-NS.png,IPC322LR3-VSPF28-C.png,IPC2122LR3-PF40-C.png', 'Rajesh C', 37, 12, '2020-12-21', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-12-13 11:40:04', 1, '2020-12-21 06:00:02'),
(10491, 20013, '', '10491', 'E', 1, '<p>\n	Please correct the descripancy as shown in the attachment.</p>\n<p>\n	Thanks</p>\n<p>\n	Rajesh</p>\n<p>\n	&nbsp;</p>\n', '2020-12-13 14:22:39', '40002-EA(old).png', 'Rajesh C', 37, 12, '2020-12-21', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-12-13 14:22:39', 1, '2020-12-21 06:00:02'),
(10492, 20013, '', '10492', 'E', 1, '<p>\n	PO 601659 was converted to PI 802432 &amp; PI 802436 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 fro, order to invoice. see attached flies for reference.</p>\n', '2020-12-14 10:26:15', 'PO 601659 161.PNG,PO 60165962.PNG,PI 80243217.pdf,PI 80243632.pdf', 'Rhealiza G', 37, 12, '2020-12-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-12-14 10:26:15', 1, '2020-12-26 06:00:03'),
(10493, 20073, '', '10493', 'I', 1, '<p>\n	Software Implementation</p>\n', '2020-12-16 21:36:08', '', 'mereenak', 218, 12, '2021-01-31', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2020-12-16 21:36:08', 1, '2021-01-31 06:00:03'),
(10494, 20002, '', '10494', 'E', 1, '<p>\n	Part no. 3106-11006OS2CL, Actual stock balance is 03 rolls, but in transaction details showing 04 rolls instead of 03. Please see the below details</p>\n<p>\n	mail dated 15/12/2020</p>\n', '2020-12-17 08:52:04', '', 'JOHN', 5, 12, '2021-01-18', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2020-12-17 08:52:04', 1, '2021-01-18 06:00:02'),
(10495, 20074, '', '10495', 'E', 1, '<p>\n	HR Instalation</p>\n', '2020-12-17 09:20:42', '', 'JOHN', 221, 12, '2021-02-05', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-17 09:20:42', 1, '2021-02-05 06:00:04'),
(10496, 20075, '', '10496', 'E', 1, '<p>\n	CRM</p>\n', '2020-12-17 09:21:54', '', 'JOHN', 224, 12, '2021-01-06', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-17 09:21:54', 69, '2021-01-06 08:46:36'),
(10497, 20077, '', '10497', 'E', 1, '<p>\n	HR Instalation</p>\n', '2020-12-17 09:23:47', '', 'JOHN', 230, 12, '2021-07-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-17 09:23:47', 1, '2021-07-16 05:00:05'),
(10498, 20076, '', '10498', 'E', 1, '<p>\n	HR Instalation</p>\n', '2020-12-17 09:24:22', '', 'JOHN', 227, 12, '2021-05-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-17 09:24:22', 1, '2021-05-30 05:00:02'),
(10499, 20002, '', '10499', 'E', 2, '<p>\n	Rack Updation from Stock Taking data</p>\n', '2020-12-17 10:10:25', '', 'JOHN', 5, 12, '2021-01-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-17 10:10:25', 1, '2021-01-22 06:00:01'),
(10500, 20078, '', '10500', 'E', 1, '<p>\n	HR Instalation, Amazon, Noon etc</p>\n', '2020-12-17 16:35:58', '', 'JOHN', 233, 12, '2021-06-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-17 16:35:58', 1, '2021-06-25 05:00:06'),
(10501, 20013, '', '10501', 'E', 1, '<p>\n	<span style=\"color: rgba(0, 0, 0, 0.68); font-family: Ubuntu, sans-serif; font-size: 14.3px; white-space: nowrap;\">Please correct the descripancy as shown in the attachment. Thanks Rajesh&nbsp;&nbsp;</span></p>\n', '2020-12-19 17:25:23', 'Lev-01.jpg,Lev-02.jpg,Lev-03.jpg.png', 'Rajesh C', 37, 12, '2021-01-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-12-19 17:25:23', 1, '2021-01-18 06:00:02'),
(10502, 20002, '', '10502', 'E', 1, '<p>\n	Please refer below report, pending order status, received value showing including VAT amount, so we cannot find out pending materials value.</p>\n', '2020-12-20 11:36:46', 'norden201220.png', 'JOHN', 5, 12, '2021-01-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-20 11:36:46', 1, '2021-01-10 06:00:02'),
(10503, 20002, '', '10503', 'E', 1, '<p>\n	Please refer below screen shot, inventory report showing 54 pcs., but when changing rack number qty showing 55 pcs. Please check</p>\n<p>\n	<br />\n	<span style=\"color:black\">71-3102222</span></p>\n', '2020-12-20 14:43:04', 'norden20120-2.jpg,norden20120-1.jpg', 'JOHN', 5, 12, '2020-12-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-20 14:43:04', 1, '2020-12-30 06:00:02'),
(10504, 20042, '', '10504', 'E', 1, '<p>\n	Dear John</p>\n<p>\n	Unlock year 2021 &amp; 2022&amp; 2023 for Voucher creations</p>\n<p>\n	Regards</p>\n<p>\n	&nbsp;</p>\n<p>\n	Anil</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n', '2020-12-22 09:48:31', '', 'Admin User', 124, 12, '2021-01-05', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 49, '2020-12-22 09:48:31', 1, '2021-01-05 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
(10505, 20013, '', '10505', 'E', 1, '<p>\n	Please assist to cancel SO 205705 in CRM, invalid entry.</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 18040 characters]\" /></p>\n', '2020-12-22 15:59:51', '', 'Maria Theresa', 37, 12, '2020-12-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-12-22 15:59:51', 1, '2020-12-29 06:00:02'),
(10506, 20079, '', '10506', 'E', 1, '<p>\n	Website</p>\n', '2020-12-23 08:25:40', '', 'JOHN', 236, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30010', 0, 0, '', '', 69, '2020-12-23 08:25:40', 1, '2022-07-29 05:00:04'),
(10507, 20019, '', '10507', 'I', 2, '<p>\n	HR - Empoloyee Self Service Module App</p>\n', '2020-12-23 08:36:28', '', 'Arun', 57, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30004', 0, 0, '', '', 1, '2020-12-23 08:36:28', 1, '2022-07-29 05:00:04'),
(10508, 20001, '', '10508', 'I', 1, '<p>\n	Credit Note 500460<br />\n	600<br />\n	30<br />\n	630</p>\n<p>\n	Correction</p>\n', '2020-12-23 12:05:07', '', 'JOHN', 2, 12, '2020-12-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-23 12:05:07', 1, '2020-12-29 06:00:02'),
(10509, 20002, '', '10509', 'E', 1, '<p>\n	Please refer the below item transaction details, As per the attached MRN the transaction &lsquo;IN&rsquo; qty should be 26pcs for MRN 702141 &amp; 10 pcs for MRN 702142, As we have 26 pcs execs against current Inventory qty which is 15pcs. please check and let me know</p>\n<p>\n	ENV-HBU7M-50R-20</p>\n', '2020-12-23 16:55:08', 'MRN 702141.pdf,MRN 702142.pdf', 'JOHN', 5, 12, '2021-01-18', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2020-12-23 16:55:08', 1, '2021-01-18 06:00:02'),
(10510, 20013, '', '10510', 'E', 1, '<p>\n	<span style=\"color: rgba(0, 0, 0, 0.68); font-family: Ubuntu, sans-serif; font-size: 14.3px; white-space: nowrap; background-color: rgb(245, 245, 245);\">Please correct the descripancy as shown in the attachment.</span></p>\n<p>\n	<span style=\"color: rgba(0, 0, 0, 0.68); font-family: Ubuntu, sans-serif; font-size: 14.3px; white-space: nowrap; background-color: rgb(245, 245, 245);\">Thanks Rajesh&nbsp;</span></p>\n', '2020-12-26 10:22:18', '5018508.png,E-STHSM-E7.png', 'Rajesh C', 37, 12, '2021-01-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-12-26 10:22:18', 1, '2021-01-18 06:00:02'),
(10511, 20014, '', '10511', 'E', 1, '<p>\n	Need option to send account statement through mail directly</p>\n<p>\n	PDC (I and PDC (R) should refelct in Balance sheet</p>\n', '2020-12-27 11:21:03', '', 'JOHN', 41, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-12-27 11:21:03', 1, '2022-07-29 05:00:04'),
(10512, 20013, '', '10512', 'E', 1, '<p>\n	<span style=\"color: rgba(0, 0, 0, 0.68); font-family: Ubuntu, sans-serif; font-size: 14.3px; white-space: nowrap; background-color: rgb(245, 245, 245);\">Please correct the descripancy as shown in the attachment. Thanks Rajesh&nbsp;</span></p>\n', '2020-12-27 16:53:05', '2110P68.png', 'Rajesh C', 37, 12, '2021-01-18', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 20, '2020-12-27 16:53:05', 1, '2021-01-18 06:00:02'),
(10513, 20001, '', '10513', 'I', 1, '<p>\n	Serial No Duplication</p>\n', '2020-12-28 20:11:07', '', 'mereenak', 1, 12, '2021-01-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2020-12-28 20:11:07', 1, '2021-01-29 06:00:02'),
(10514, 20001, '', '10514', 'I', 1, '<p>\n	Check the status of serial no / batch changing - when item in QC or MR</p>\n', '2020-12-29 08:07:23', '', 'JOHN', 2, 2, '2020-12-29', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2020-12-29 08:07:23', 69, '2020-12-29 08:07:59'),
(10515, 20067, '', '10515', 'I', 1, '<p>\n	Check the status of serial no / batch changing - when item in QC or MR</p>\n', '2020-12-29 08:07:42', '', 'JOHN', 200, 12, '2021-01-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-29 08:07:42', 1, '2021-01-30 06:00:02'),
(10516, 20001, '', '10516', 'I', 1, '<p>\n	Serial Number Trimming</p>\n', '2020-12-29 08:08:28', '', 'JOHN', 2, 12, '2021-01-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-29 08:08:28', 1, '2021-01-11 06:00:02'),
(10517, 20067, '', '10517', 'E', 1, '<p>\n	Serial Number Trimming</p>\n', '2020-12-29 08:08:43', '', 'JOHN', 200, 12, '2021-01-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-29 08:08:43', 1, '2021-01-11 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
(10518, 20002, '', '10518', 'E', 0, '<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65491 characters]', '2020-12-29 14:15:07', '', 'Tebin Kalam', 5, 12, '2021-01-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 9, '2020-12-29 14:15:07', 1, '2021-01-04 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
(10519, 20001, '', '10519', 'I', 1, '<p>\n	serial number issue</p>\n', '2020-12-30 08:29:07', 'WhatsApp Image 2020-12-30 at 8.20.57 AM(1).jpeg,WhatsApp Image 2020-12-30 at 8.20.57 AM.jpeg', 'JOHN', 2, 12, '2021-01-06', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-30 08:29:07', 1, '2021-01-06 06:00:02'),
(10520, 20065, '', '10520', 'I', 1, '<p>\n	Please note that the loan amount is not being deducted from the face value since last two months.</p>\n<p>\n	Also, the values given earlier needs correction and I&rsquo;ve attached the sheet for your perusal.</p>\n', '2020-12-30 08:39:14', 'salary loan correction - HRMS.xlsx', 'JOHN', 194, 12, '2021-03-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-30 08:39:14', 1, '2021-03-02 06:00:01'),
(10521, 20002, '', '10521', 'E', 1, '<p>\n	<span style=\"font-family:&quot;Century Gothic&quot;,&quot;sans-serif&quot;;color:#000066\">Stock ageing (amount wise) is showing some errors,&nbsp; the report is not matching with stock as of date report. The difference is showing in quantity and accordingly amount is varying. So please rectify immediately we have to submit auditors.</span></p>\n', '2020-12-30 08:59:45', '', 'JOHN', 5, 12, '2021-02-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-12-30 08:59:45', 1, '2021-02-24 06:00:02'),
(10522, 20001, '', '10522', 'I', 1, '<p>\n	Rreports-&gt;Hire-&gt;Hire Transaction List-&gt;need purchase date</p>\n', '2020-12-31 15:17:09', '', 'mereenak', 2, 12, '2021-01-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2020-12-31 15:17:09', 1, '2021-01-24 06:00:02'),
(10523, 20001, '', '10523', 'I', 1, '<p>\n	Update cost rate of some items</p>\n', '2020-12-31 15:18:14', 'Cost(2).xlsx', 'mereenak', 2, 12, '2021-01-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2020-12-31 15:18:14', 1, '2021-01-08 06:00:04'),
(10525, 20067, '', '10525', 'E', 1, '<p>\n	see attached screenshots</p>\n', '2021-01-03 10:52:52', 'WhatsApp Image 2021-01-03 at 10.45.09 AM.jpeg,WhatsApp Image 2021-01-03 at 10.45.08 AM(1).jpeg,WhatsApp Image 2021-01-03 at 10.45.08 AM.jpeg,WhatsApp Image 2021-01-03 at 10.45.07 AM.jpeg,WhatsApp Image 2021-01-03 at 10.45.07 AM(1).jpeg', 'JOHN', 200, 12, '2021-02-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-03 10:52:52', 1, '2021-02-24 06:00:02'),
(10526, 20080, '', '10526', 'E', 1, '<p>\n	New Customer creation omn E Sell - New</p>\n', '2021-01-03 11:14:08', '', 'JOHN', 239, 12, '2021-01-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-03 11:14:08', 1, '2021-01-10 06:00:02'),
(10527, 20081, '', '10527', 'E', 1, '<p>\n	Migration from Weibex - Al Majaz to Weibex - Al Mehaz</p>\n<p>\n	2 logins</p>\n<p>\n	Xusatomer, Supplier and Inventory Porting</p>\n', '2021-01-03 11:15:44', '', 'JOHN', 242, 12, '2021-01-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-03 11:15:44', 1, '2021-01-09 06:00:01'),
(10528, 20042, '', '10528', 'E', 1, '<p>\n	Allow future date entry</p>\n', '2021-01-03 14:01:40', '', 'JOHN', 125, 12, '2021-01-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-03 14:01:40', 1, '2021-01-09 06:00:01'),
(10529, 20019, '', '10529', 'E', 1, '<p>\n	Weibex to E sell Data Migration and checking</p>\n', '2021-01-03 17:55:25', '', 'JOHN', 56, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2021-01-03 17:55:25', 1, '2022-07-29 05:00:04'),
(10531, 20065, '', '10531', 'E', 1, '<p>\n	Annual leave for 2021 cannot added for &ndash;ve leave employees</p>\n<p>\n	Salary before locking report- mode of payment needed</p>\n<p>\n	Overtime report &ndash; Employee grouping with total</p>\n<p>\n	Overtime calculation checking</p>\n<p>\n	Shibu david leave on sajeev john notification cleared</p>\n', '2021-01-06 08:44:27', '', 'JOHN', 194, 12, '2021-01-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-06 08:44:27', 1, '2021-01-17 06:00:02'),
(10530, 20002, '', '10530', 'I', 1, '<p>\n	Norden stock taking report</p>\n<p>\n	Team report- PDF</p>\n<p>\n	Deleted history &ndash; Item not coming</p>\n', '2021-01-04 12:49:09', '', 'JOHN', 5, 12, '2021-01-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-04 12:49:09', 1, '2021-01-10 06:00:02'),
(10532, 20067, '', '10532', 'I', 1, '<p>\n	Getting <em><strong>NAN</strong></em> in order when we open avaibale qty box then close.</p>\n<p>\n	Showing wrong avaiable qty</p>\n', '2021-01-06 20:29:03', '', 'mereenak', 200, 12, '2021-01-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-01-06 20:29:03', 69, '2021-01-13 08:22:16'),
(10533, 20013, '', '10533', 'E', 1, '<p>\n	Sales Invoice - Invoice type : Export , open the tax coloumn, so that either they can switch to 5 or 0 depending on inventory/service item</p>\n<p>\n	&nbsp;</p>\n', '2021-01-07 11:21:33', '', 'JOHN', 38, 12, '2021-01-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-07 11:21:33', 1, '2021-01-15 06:00:02'),
(10534, 20013, '', '10534', 'E', 1, '<p>\n	Unable to get contact names while entering activity for a customer&nbsp;</p>\n<p>\n	See the screenshot attached</p>\n<p>\n	Thanks</p>\n', '2021-01-10 10:21:57', 'Screenshot 2021-01-10 at 10.18.47.png', 'Ganesan K.', 37, 12, '2021-01-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2021-01-10 10:21:57', 1, '2021-01-16 06:00:02'),
(10535, 20065, '', '10535', 'E', 1, '<p>\n	please change Ambi (M10043) to 0 as he has paid off all amount</p>\n', '2021-01-10 14:01:38', 'WhatsApp Image 2021-01-10 at 1.27.58 PM.jpeg', 'JOHN', 194, 12, '2021-01-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-10 14:01:38', 1, '2021-01-25 06:00:01'),
(10551, 20001, '', '10551', 'I', 1, '<p>\n	ARK</p>\n<p>\n	File id 1143<br />\n	purchase Invoice 900104</p>\n<p>\n	Direct purchase annenu thonnuu</p>\n<p>\n	PO undo ennu njan chekkiyila</p>\n<p>\n	Quantity rate koode maari poi</p>\n<p>\n	50 screw 0.63 fils vangikandathu thirinju 0.63 scree 50 dirhams nu ennu ayyi poi</p>\n<p>\n	Quantity onnu thiruthanem, cost onnu recalculate cheythu azhuthanem</p>\n', '2021-01-19 12:53:01', '', 'JOHN', 2, 12, '2021-01-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-19 12:53:01', 1, '2021-01-25 06:00:01'),
(10536, 20067, '', '10536', 'I', 1, '<p>\n	Purchase Invoice 80015, stock not updated . please check</p>\n', '2021-01-10 14:27:03', '', 'JOHN', 200, 12, '2021-01-19', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-10 14:27:03', 1, '2021-01-19 06:00:01'),
(10537, 20006, '', '10537', 'E', 1, '<p>\n	Pls fix urgently</p>\n<p>\n	When we are paying Leave Salary through &nbsp;&nbsp;monthly Salary , accounts entry passing , but there is again one payment voucher also listing . such case no need to list payment voucher.</p>\n<p>\n	Also payment voucher &nbsp;print and save ,voucher is printing but voucher still listing &nbsp;solution find out</p>\n<p>\n	<br />\n	&nbsp;</p>\n', '2021-01-10 14:31:05', '', 'JOHN', 17, 12, '2021-03-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-10 14:31:05', 1, '2021-03-07 06:00:02'),
(10538, 20074, '', '10538', 'I', 1, '<p>\n	Below is the summarized understanding,</p>\n<ul>\n	<li>\n		John to set up user group to restrictions of branches as below,</li>\n	<li>\n		Only Muktha and Charu &ndash; Full admin access for Rethink MHQ and RAA</li>\n	<li>\n		Muktha, Charu and Varsha &ndash; Full admin access to the rest of the branches (to be added)</li>\n	<li>\n		John to include leave &lsquo;Email Notification&rsquo; to LM &amp; HR</li>\n	<li>\n		John to Scroll down and see Muktha&rsquo;s email sent on 6<sup>th</sup> January 2021</li>\n</ul>\n<p>\n	Rethink HR Team,</p>\n<ul>\n	<li>\n		Muktha to provide Payslip/NOC/Salary Certificate/Offer Letter Template to John for the set up</li>\n	<li>\n		Varsha to provide excel template with required field to John &ndash; Will send by today.</li>\n</ul>\n', '2021-01-10 14:38:56', '', 'JOHN', 221, 12, '2021-01-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-10 14:38:56', 1, '2021-01-26 06:00:01'),
(10539, 20065, '', '10539', 'E', 1, '<p>\n	Notification for appraisal is not available</p>\n<p>\n	LM review value and HR review value not available in report</p>\n', '2021-01-10 17:37:43', 'WhatsApp Image 2021-01-10 at 5.32.38 PM.jpeg', 'JOHN', 194, 12, '2021-05-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-10 17:37:43', 1, '2021-05-30 05:00:02'),
(10540, 20013, '', '10540', 'I', 1, '<p>\n	Stock - Internal Tables Correction</p>\n', '2021-01-11 09:03:30', '', 'JOHN', 38, 12, '2021-01-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-11 09:03:30', 1, '2021-01-18 06:00:02'),
(10558, 20019, '', '10558', 'E', 1, '<p>\n	Erplite &amp; Diatech<br />\n	excel and pdf - file naming</p>\n', '2021-01-23 08:36:48', '', 'JOHN', 56, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2021-01-23 08:36:48', 1, '2022-07-29 05:00:04'),
(10541, 20002, '', '10541', 'E', 1, '<p>\n	<span style=\"color:#1F497D\">Please find below screen shot of stock as of report as on 31.12.2020, actual stock is 46 and physically also 46 but stock as of report is 48 and we are &nbsp;using stock as of report for the closing. Please look in to this &nbsp;and also check if its affected to any other items.</span></p>\n', '2021-01-13 11:53:18', 'image010.jpg,image002.png', 'JOHN', 5, 12, '2021-01-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-13 11:53:18', 1, '2021-01-22 06:00:01'),
(10542, 20013, '', '10542', 'E', 1, '<p>\n	Leads Report does not show status&nbsp;</p>\n<p>\n	Any individual leads when searched through the file name, shows the correct status - Quotation, Won, etc. But in the report, it does not show status, it is blank. Please see the attached</p>\n<p>\n	Pleade include the correct status for all the leads in the report</p>\n<p>\n	&nbsp;</p>\n<p>\n	Ganesan</p>\n', '2021-01-14 12:47:27', 'Screenshot 2021-01-14 at 12.44.13.png,LeadList.pdf', 'Ganesan K.', 37, 12, '2021-01-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2021-01-14 12:47:27', 1, '2021-01-22 06:00:01'),
(10543, 20001, '', '10543', 'I', 1, '<p>\n	Remove Invoice and related tables [invoice#&nbsp;400901&quot;]</p>\n', '2021-01-14 21:25:53', '', 'mereenak', 2, 12, '2021-01-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-01-14 21:25:53', 1, '2021-01-22 06:00:01'),
(10544, 20075, '', '10544', 'E', 1, '<p>\n	Remove Authorised Signature from Qtn</p>\n', '2021-01-14 21:26:45', '', 'mereenak', 224, 12, '2021-01-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-01-14 21:26:45', 1, '2021-01-22 06:00:01'),
(10545, 20075, '', '10545', 'I', 1, '<p>\n	View All option in customer list</p>\n', '2021-01-14 21:28:37', '', 'mereenak', 224, 12, '2021-01-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-01-14 21:28:37', 1, '2021-01-22 06:00:01'),
(10548, 20013, '', '10548', 'E', 1, '<p>\n	Good morning.</p>\n<p>\n	When we take print of quotations (or even sales orders etc) from the Report section (under Actions), the PDF of the quote does not show some details such as:</p>\n<p>\n	* Project reference</p>\n<p>\n	* VAT&nbsp;</p>\n<p>\n	These are required,&nbsp;</p>\n<p>\n	But it includes the Discount column, which is not required&nbsp;</p>\n<p>\n	See two files attached:</p>\n<p>\n	QUOTE-124449-from-Quote-Report -- &gt; this does not have the VAT amount and the Project Reference, but it shows the Discount column&nbsp;</p>\n<p>\n	QUOTE-124449-actual&nbsp;</p>\n<p>\n	I have also attached the screen shot of the Quotation report from where we can take the PDF of the Quote which is incomplete.</p>\n<p>\n	Due to this we can&#39;t rely on the PDF from the report section and we have to print it from the Sales Module / Operations / Quotations.&nbsp;</p>\n<p>\n	<strong>Please ensure any PDF of quotations (or other documents) from the Report section is EXACTLY the same as the actual quotations (or other documents) and it should not show the Discount column.&nbsp;</strong></p>\n<p>\n	Thanks</p>\n<p>\n	Ganesan</p>\n', '2021-01-16 11:34:03', 'QUOTE-124449-actual.pdf,QUOTE-124449-from-Quote-Report.pdf,Screenshot 2021-01-16 at 11.20.33.png', 'Ganesan K.', 37, 2, '2021-12-27', 0, '0000-00-00', '', 0, '0', '', '30006,30012', 0, 0, '', '', 20, '2021-01-16 11:34:03', 69, '2022-04-05 07:28:58'),
(10546, 20001, '', '10546', 'I', 1, '<div>\n	Show purchase date in the &quot;Hire transaction list&quot; Report.</div>\n<div>\n	Correct the &quot;total discount&quot;&nbsp; to &quot;Discount per Item&quot; in the quotation.</div>\n', '2021-01-14 21:30:28', '', 'mereenak', 2, 12, '2021-01-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-01-14 21:30:28', 1, '2021-01-22 06:00:01'),
(10547, 20001, '', '10547', 'I', 1, '<p>\n	All Report Headers as same as &quot;Stock State as of - New&quot;.</p>\n', '2021-01-14 21:31:04', '', 'mereenak', 2, 2, '2021-01-14', 0, '0000-00-00', '', 0, '0', '', '30003', 0, 0, '', '', 478, '2021-01-14 21:31:04', 478, '2021-01-14 21:31:13'),
(10552, 20002, '', '10552', 'E', 1, '<p>\n	Please change the amount in words of currency of &quot;Performa print&quot; Same as that of &quot; Invoice print&quot;</p>\n', '2021-01-19 15:42:45', '', 'JOHN', 5, 12, '2021-01-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-19 15:42:45', 1, '2021-01-25 06:00:01'),
(10554, 20019, '', '10554', 'E', 1, '<p>\n	E sell Mobile Application - Modification</p>\n', '2021-01-21 08:50:14', '', 'JOHN', 56, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30007', 0, 0, '', '', 69, '2021-01-21 08:50:14', 1, '2022-07-29 05:00:04'),
(10555, 20065, '', '10555', 'E', 1, '<p>\n	Overtime correction - Lunch time reduction on off day/ holiday</p>\n', '2021-01-21 09:39:25', '', 'JOHN', 194, 12, '2021-01-31', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-21 09:39:25', 1, '2021-01-31 06:00:03'),
(10556, 20028, '', '10556', 'E', 1, '<p>\n	Real estate Logo<br />\n	server slow<br />\n	date Issue</p>\n', '2021-01-21 09:51:58', '', 'JOHN', 83, 12, '2021-06-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-21 09:51:58', 1, '2021-06-20 05:00:01'),
(10557, 20067, '', '10557', 'E', 1, '<p>\n	1. Stock value difference between tally &amp; Inventory Ledger</p>\n<p>\n	2. When converting from order to invoice for service item (from multiple invoice) - service items comes twice</p>\n', '2021-01-21 10:56:28', '', 'JOHN', 200, 12, '2021-03-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-21 10:56:28', 1, '2021-03-07 06:00:02'),
(10578, 20002, '', '10578', 'E', 1, '<p>\n	Please find enclosed Stock as of 31/01/2021 report vs Stock ageing as of 31/01/2021 and noticed</p>\n<p>\n	1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; several materials are not matching.</p>\n<p>\n	2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; part number ENC-HBCWF-10R-80 was not in ageing report but was in stock as of report, we have manually added in Ageing report, please refer highlighted row in ageing report.</p>\n<p>\n	3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Several items quantity is matching but amount is not matching, Yellow highlighted in stock as of report.</p>\n', '2021-02-03 08:29:30', '', 'JOHN', 5, 12, '2021-02-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-03 08:29:30', 1, '2021-02-14 06:00:01'),
(10559, 20019, '', '10559', 'E', 1, '<p>\n	Remove tghe unwanted DB (Like aramed etc) after confirming with Arun<br />\n	please make sure program and DB backed up properly</p>\n', '2021-01-23 08:38:52', '', 'JOHN', 56, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2021-01-23 08:38:52', 1, '2022-07-29 05:00:04'),
(10561, 20074, '', '10561', 'I', 1, '<p>\n	When a new employee is added to a branch, set his/her weekend as that of that branch</p>\n', '2021-01-26 08:44:34', '', 'JOHN', 221, 12, '2021-02-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-26 08:44:34', 1, '2021-02-12 06:00:02'),
(10560, 20002, '', '10560', 'I', 1, '<p>\n	in inventoy Receipt, bring a cost column(Editable) hidden/ unhidden against each item, and cost has to be recalulated</p>\n<p>\n	Also check when Creditote comes, how the cot deletion happens</p>\n', '2021-01-24 17:10:41', '', 'JOHN', 5, 7, '2023-12-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-24 17:10:41', 4, '2023-12-29 13:51:31'),
(10562, 20001, '', '10562', 'E', 1, '<p>\n	Invoice No 400915</p>\n<p>\n	2nd line item 13 x 270= 3510, please round to nearest hour when calculating</p>\n<p>\n	3rd line item. break down 4.58 hrs&nbsp; x270 - its showing 1 x 270</p>\n', '2021-01-26 11:19:34', '', 'JOHN', 2, 12, '2021-05-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-26 11:19:34', 1, '2021-05-30 05:00:02'),
(10563, 20067, '', '10563', 'I', 1, '<p>\n	item 82 qty @7 Dh, and inventory receipt 1 item with 0 cost, then total quantity 83 and cost becomes zero for all</p>\n', '2021-01-26 11:39:33', '', 'JOHN', 200, 12, '2021-02-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-26 11:39:33', 1, '2021-02-09 06:00:01'),
(10564, 20001, '', '10564', 'I', 1, '<p>\n	1. @MR, @ Creditnote @ Goods Receipt - when material is received it should come to the item&#39;s default rack</p>\n<p>\n	2. Eg: 25-04-00013, sales history inside item,when we chage the drop down from all to individual customer, type disapperas</p>\n<p>\n	3. eg Q 102976, when 2 items @2000, 4000 should show</p>\n', '2021-01-26 11:45:25', '', 'JOHN', 2, 2, '2021-01-28', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2021-01-26 11:45:25', 69, '2021-01-28 17:13:00'),
(10565, 20002, '', '10565', 'E', 1, '<p>\n	Remove some quantity of SKU as per List given from damage</p>\n', '2021-01-27 08:16:18', '', 'JOHN', 5, 12, '2021-02-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-27 08:16:18', 1, '2021-02-02 06:00:02'),
(10566, 20067, '', '10566', 'I', 1, '<p>\n	when converting quotation to order- Dont save the order if it contain atleast one dummy item<br />\n	also check when addiding direct order item</p>\n', '2021-01-27 10:01:09', '', 'JOHN', 200, 12, '2021-02-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-27 10:01:09', 1, '2021-02-03 06:00:02'),
(10567, 20067, '', '10567', 'I', 1, '<p>\n	1)crop the picture to 120 x120 using thumpnail</p>\n<p>\n	@ quotation dummy item&nbsp; picture upload</p>\n<p>\n	@inventory Picture upload</p>\n<p>\n	2) Upload documnent in quotation doesnt allow .xlsw</p>\n', '2021-01-27 14:08:33', 'WhatsApp Image 2021-01-27 at 1.23.07 PM.jpeg', 'JOHN', 200, 12, '2021-02-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-27 14:08:33', 1, '2021-02-03 06:00:02'),
(10568, 20067, '', '10568', 'I', 1, '<p>\n	Sort transaction details report by date [html,pdf,excel]</p>\n<p>\n	Rate changed</p>\n<p>\n	Corrected Qtn Pdf</p>\n', '2021-01-27 19:10:45', '', 'mereenak', 200, 12, '2021-02-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-01-27 19:10:45', 1, '2021-02-03 06:00:02'),
(10569, 20001, '', '10569', 'I', 1, '<p>\n	1)Item No 25-04-00012</p>\n<p>\n	Sales history from inventory Tab, File No 1924 / 200285 is not showing</p>\n<p>\n	but this is sold to that customer and have an active invoice (I checked)</p>\n<p>\n	2)Can you bring the customers in sales history drop down in Alphbetical order sorting</p>\n<p>\n	30 Reports- Inventory - Sales/purchase history - product 25-04-00012- Report not loading</p>\n', '2021-01-28 12:29:18', '', 'JOHN', 2, 12, '2021-02-05', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-28 12:29:18', 1, '2021-02-05 06:00:04'),
(10570, 20002, '', '10570', 'I', 1, '<p>\n	<span style=\"font-size:12.0pt;color:#1F497D\">Please refer below screen shot, when you revised the quantity unit price missing and value showing zero. As per your previous report unit price was AED 0.664 per mtr.</span></p>\n', '2021-01-28 17:09:11', 'norden280121.jpg', 'JOHN', 5, 12, '2021-02-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-28 17:09:11', 1, '2021-02-09 06:00:01'),
(10573, 20067, '', '10573', 'I', 1, '<p>\n	New Reports</p>\n<p>\n	Profit in qtn</p>\n<p>\n	stock ageing</p>\n', '2021-01-29 21:31:18', '', 'mereenak', 200, 12, '2021-02-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-01-29 21:31:18', 1, '2021-02-08 06:00:01'),
(10695, 20019, '', '10695', 'E', 1, '<p>\n	ESell - New database creation</p>\n', '2021-05-24 10:29:03', '', 'JOHN', 56, 12, '2022-03-12', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2021-05-24 10:29:03', 1, '2022-03-12 06:00:02'),
(10571, 20019, '', '10571', 'E', 1, '<p>\n	Restaurent Software</p>\n', '2021-01-28 17:30:17', '', 'JOHN', 56, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30004', 0, 0, '', '', 69, '2021-01-28 17:30:17', 1, '2022-07-29 05:00:04'),
(10572, 20066, '', '10572', 'I', 1, '<p>\n	E sell migration</p>\n', '2021-01-28 17:59:57', '', 'JOHN', 197, 12, '2021-02-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-28 17:59:57', 1, '2021-02-24 06:00:02'),
(10574, 20002, '', '10574', 'I', 1, '<p>\n	Item 3106-11004OS2CL-CT</p>\n<p>\n	30/12/2020 damage out - update cost rate</p>\n<p>\n	take stock state as of report with item 3106-11004OS2CL-CT and date 31/12/2020 now cost is zero</p>\n', '2021-01-30 10:00:49', '', 'JOHN', 5, 12, '2021-02-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-01-30 10:00:49', 1, '2021-02-08 06:00:01'),
(10575, 20019, '', '10575', 'E', 1, '<p>\n	Inventory Management</p>\n', '2021-02-01 08:39:27', '', 'JOHN', 56, 2, '2021-02-06', 0, '0000-00-00', '', 0, '0', '', '30012', 0, 0, '', '', 69, '2021-02-01 08:39:27', 69, '2021-02-06 15:55:48'),
(10576, 20067, '', '10576', 'I', 1, '<p>\n	PDF-- Quotation-&gt;profit print</p>\n<p>\n	PDF-Purchase Stock List</p>\n', '2021-02-01 21:15:25', '', 'mereenak', 200, 12, '2021-02-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-02-01 21:15:25', 1, '2021-02-08 06:00:01'),
(10577, 20067, '', '10577', 'I', 1, '<p>\n	Dashboard--Todays Sales</p>\n', '2021-02-01 21:17:25', '', 'mereenak', 200, 12, '2021-02-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-02-01 21:17:25', 1, '2021-02-08 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
(10579, 20067, '', '10579', 'E', 1, '<p>\n	<strong>Please find the following issues in the Service Module.</strong></p>\n<p>\n	&nbsp;</p>\n<p>\n	1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In Quotation / Contract change Schedule to List of Equipment and Liabilities to Additional Terms and conditions &nbsp;if we requires for some customers</p>\n<p>\n	<img border=\"0\" height=\"196\" id=\"Picture_x0020_1\" src=\"data:image/png;base64,[encoded data, 65155 characters]', '2021-02-03 09:01:37', '', 'JOHN', 200, 12, '2021-02-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-03 09:01:37', 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
(10580, 20002, '', '10580', 'E', 1, '<p>\n	<span style=\"font-size:12.0pt;color:#1F497D\">We assume, that in case of credit note issued, materials are returned to stock with the sales price, and this is a serious issue and most of our inventory value is exaggerated in that case.</span></p>\n', '2021-02-03 10:26:30', '', 'JOHN', 5, 12, '2021-02-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-03 10:26:30', 1, '2021-02-15 06:00:02'),
(10581, 20019, '', '10581', 'E', 1, '<p>\n	E- Sell</p>\n<p>\n	In inventory new save - in API , put barcode same as product id</p>\n', '2021-02-03 11:29:01', '', 'JOHN', 56, 12, '2021-02-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-03 11:29:01', 1, '2021-02-12 06:00:02'),
(10582, 20019, '', '10582', 'I', 1, '<p>\n	Server Cleaning</p>\n<p>\n	Blueskytechnologies.in ---&gt;phpmyadmin issue</p>\n<p>\n	Domain Creation + Support Rahul</p>\n', '2021-02-03 20:23:10', '', 'mereenak', 56, 12, '2021-02-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-02-03 20:23:10', 1, '2021-02-17 06:00:02'),
(10583, 20067, '', '10583', 'I', 1, '<p>\n	Please find the answers to the questions below &nbsp;</p>\n<p>\n	&nbsp;</p>\n<ol>\n	<li>\n		Regarding the purchase module, we need this movement details on the purchase section not on reports.</li>\n</ol>\n<p style=\"margin-left:.25in;\">\n	Purchase Module&agrave;Operation &agrave;New Order Movement Analysis &agrave;Purchase Enquiry &agrave;Purchase Order, etc.,</p>\n<p style=\"margin-left:.25in;\">\n	The New Order Movement Analysis would be below in the Operations Menu as an Excel Report.</p>\n<p>\n	&nbsp;</p>\n<ol>\n	<li>\n		<strong><u>New Order Movement Analysis:-</u></strong></li>\n</ol>\n<p>\n	Serial No,</p>\n<p>\n	Item Description,</p>\n<p>\n	1year,</p>\n<p>\n	180days,</p>\n<p>\n	90days,</p>\n<p>\n	30days,</p>\n<p>\n	Closing Stock,</p>\n<p>\n	Upcoming Shipment Qty (The software should take automatically details of upcoming stocks (or) we can type in the column manually if it is editable),</p>\n<p>\n	Average movement per month (should be calculated based on 3months),</p>\n<p>\n	Expected 2months movement ,</p>\n<p>\n	Expected closing stock after 2months,</p>\n<p>\n	New order proposal quantity (editable, as we need to insert the quantity manually)</p>\n<p>\n	Remarks (editable, we need to mention our remarks on product that we are ordering)</p>\n<p>\n	<strong><em>Credit note is not required. </em></strong></p>\n<p>\n	We need to have &ldquo;Filter option&rdquo; to select multiple product category &amp; date range selection option (for eg: 01-09-2021 to 31-08-2022).</p>\n<p>\n	&nbsp;</p>\n<p>\n	The filters available would be End Date ONLY &amp; Multiple selection of Generic Names.</p>\n<p>\n	The Excel File Sample with Calculation is attached herewith.</p>\n<p>\n	In this Phase we would be able provide you an Excel File only. Maybe in Phase 2, we could work out Approval within the system or whatever after discussion.&nbsp;</p>\n', '2021-02-04 17:55:13', '', 'mereenak', 200, 12, '2021-02-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2021-02-04 17:55:13', 1, '2021-02-12 06:00:02'),
(10584, 20019, '', '10584', 'I', 1, '<p>\n	Integrate project module into Demo ERP</p>\n', '2021-02-05 19:58:40', '', 'mereenak', 56, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 478, '2021-02-05 19:58:40', 1, '2022-07-29 05:00:04'),
(10585, 20074, '', '10585', 'E', 1, '<p>\n	Emp field Type of cost (Overhead /COS). Come in master file<br />\n	Remove/ increase&nbsp; the Threshold Salary, reminder for new employee also large threshold salary<br />\n	For Mariia &ndash; R012 &ndash; her medical leave seems to have been deducted &ndash; can this be fixed.<br />\n	For the below can we change him to RAA pls &ndash; we will be careful to put staff only under their visa entity- RISHABH SAGE PINGAULT( R016), Change to M HQ entity -HARESH KUMAR(R026)<br />\n	From Employee details page &ndash; can we add the WPS of the company instead of going to a different screen to add<br />\n	&nbsp;M015 &ndash; the total calculation is wrong<br />\n	Got threshold issues for two staffs &ndash; M050 &amp; M049<br />\n	Rethink &ndash; R012 her leaves are getting deducted in payroll.<br />\n	Master salary report &ndash; can you please include a column for Date of joining of the staff.</p>\n', '2021-02-05 08:09:22', '', 'JOHN', 221, 12, '2021-02-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-06 08:09:22', 1, '2021-02-17 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
(10586, 20067, '', '10586', 'E', 1, '<p>\n	1) The option &ldquo;New order Movement Analysis&rdquo;, kindly move it above the purchase enquiry.</p>\n<p>\n	&nbsp;</p>\n<p>\n	<img height=\"304\" id=\"_x0000_i1050\" src=\"data:image/png;base64,[encoded data, 42284 characters]\" width=\"530\" /></p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	2) Kindly show unit ( eg: &ldquo;boxes&rdquo; or &ldquo;pcs&rdquo; )</p>\n<p>\n	Decimal is not required, is it possible to remove or round off the decimals.</p>\n<p>\n	&nbsp;</p>\n<p>\n	<img height=\"320\" id=\"_x0000_i1051\" src=\"data:image/png;base64,[encoded data, 22757 characters]', '2021-02-06 09:01:43', '', 'JOHN', 200, 12, '2021-02-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2021-02-06 09:01:43', 1, '2021-02-14 06:00:01');
