17-05-2023 09:38:15 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 17-05-2023 09:38:15 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 17-05-2023 09:38:15 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 17-05-2023 09:38:15 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 17-05-2023 09:41:51 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 17-05-2023 09:41:51 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 17-05-2023 09:41:51 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 17-05-2023 09:41:51 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 17-05-2023 09:51:34 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 17-05-2023 09:51:34 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 17-05-2023 09:51:34 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 17-05-2023 09:51:34 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 17-05-2023 10:32:37 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 17-05-2023 10:32:37 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 17-05-2023 10:32:37 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 17-05-2023 10:32:37 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 17-05-2023 11:02:32 ## Error ## ## DataAccess.GetData ## ## GetTablesToBeSync Unable to connect to data base ## ClientType: Web 17-05-2023 11:02:32 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'demo' ## DataAccess.GetConnection ## ## ## ClientType: Web 17-05-2023 11:03:53 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 17-05-2023 11:03:53 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 17-05-2023 11:03:53 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 17-05-2023 11:03:53 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 17-05-2023 11:06:06 ## Error ## ## DataAccess.GetData ## ## GetTablesToBeSync Unable to connect to data base ## ClientType: Web 17-05-2023 11:06:06 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'demo' ## DataAccess.GetConnection ## ## ## ClientType: Web 17-05-2023 11:18:07 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 17-05-2023 11:18:07 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 17-05-2023 11:18:07 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 17-05-2023 11:18:07 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 17-05-2023 11:34:57 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 17-05-2023 11:34:57 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 17-05-2023 11:34:57 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 17-05-2023 11:34:57 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 17-05-2023 12:58:06 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 17-05-2023 12:58:06 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 17-05-2023 12:58:06 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 17-05-2023 12:58:06 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 17-05-2023 13:16:13 ## Exception ## Column 'unit_id' cannot be null ## DataAccess.SetData ## ## Exception in query: SaveEtInvoiceDetail INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-17 13:16:12', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 15, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 69230.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 58670.3, 10560.65, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10560.654, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Column 'unit_id' cannot be null INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-17 13:16:12', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 15, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 69230.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 58670.3, 10560.65, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10560.654, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Inner Exception: NULL Source: MySql.Data Platform: Desktop 17-05-2023 13:16:28 ## Exception ## Column 'unit_id' cannot be null ## DataAccess.SetData ## ## Exception in query: SaveEtInvoiceDetail INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-17 13:16:28', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 15, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 69230.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 58670.3, 10560.65, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10560.654, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Column 'unit_id' cannot be null INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-17 13:16:28', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 15, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 69230.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 58670.3, 10560.65, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10560.654, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Inner Exception: NULL Source: MySql.Data Platform: Desktop 17-05-2023 13:21:56 ## Exception ## Column 'unit_id' cannot be null ## DataAccess.SetData ## ## Exception in query: SaveEtInvoiceDetail INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-17 13:21:56', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 15, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 69231.54, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 58670.8, 10560.74, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10560.744, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Column 'unit_id' cannot be null INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-17 13:21:56', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 15, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 69231.54, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 58670.8, 10560.74, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10560.744, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Inner Exception: NULL Source: MySql.Data Platform: Desktop 17-05-2023 13:23:32 ## Exception ## Column 'unit_id' cannot be null ## DataAccess.SetData ## ## Exception in query: SaveEtInvoiceDetail INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-17 13:23:32', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.71, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.3, 10926.41, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.414, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Column 'unit_id' cannot be null INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-17 13:23:32', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.71, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.3, 10926.41, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.414, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Inner Exception: NULL Source: MySql.Data Platform: Desktop 17-05-2023 13:27:17 ## Exception ## Column 'unit_id' cannot be null ## DataAccess.SetData ## ## Exception in query: SaveEtInvoiceDetail INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-17 13:27:17', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Column 'unit_id' cannot be null INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-17 13:27:17', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Inner Exception: NULL Source: MySql.Data Platform: Desktop 17-05-2023 13:27:34 ## Exception ## Column 'unit_id' cannot be null ## DataAccess.SetData ## ## Exception in query: SaveEtInvoiceDetail INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-17 13:27:34', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Column 'unit_id' cannot be null INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-17 13:27:34', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Inner Exception: NULL Source: MySql.Data Platform: Desktop 17-05-2023 13:27:51 ## Exception ## Column 'unit_id' cannot be null ## DataAccess.SetData ## ## Exception in query: SaveEtInvoiceDetail INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-17 13:27:51', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Column 'unit_id' cannot be null INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-17 13:27:51', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Inner Exception: NULL Source: MySql.Data Platform: Desktop 17-05-2023 13:29:21 ## Exception ## Column 'unit_id' cannot be null ## DataAccess.SetData ## ## Exception in query: SaveEtInvoiceDetail INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-17 13:29:21', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Column 'unit_id' cannot be null INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-17 13:29:21', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Inner Exception: NULL Source: MySql.Data Platform: Desktop 17-05-2023 13:30:28 ## Exception ## Column 'unit_id' cannot be null ## DataAccess.SetData ## ## Exception in query: SaveEtInvoiceDetail INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-17 13:30:28', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Column 'unit_id' cannot be null INSERT INTO tr_invoice_detail(id, updated_at, enterprise_id, company_id, vid, branch_id, vtype, sequence, item_id, sub_item_id, print_description, unit_id, qty, pack_unit_id, pack_qty, rate, mrp, amount, tax_id, taxable, tax_amount, tax_rate, misc1_rate,misc1_value, misc2_rate, misc2_value, misc3_rate, misc3_value, effective_rate, attribute1_id, attribute2_id, attribute3_id, attribute4_id, attribute5_id, service_date, service_location, posting_gl_id, remark, doc_misc1_value, doc_misc2_value, doc_misc3_value, promo_discount_rate, promo_discount_value, sales_return,cgst_tax_rate, cgst_tax_amount, sgst_tax_rate, sgst_tax_amount, igst_tax_rate, igst_tax_amount, gross, tare,item_master_udf1,item_master_udf2,item_master_udf3,item_master_udf4,item_master_udf5,cess_rate,cess_amount,barcode,advance,free_qty, bundle_parent_id, state_cess_rate, state_cess_amount, salesman_id, sales_rate, line_level_barcode, wholesale_rate, gpack_unit_id, gpack_qty, einvoice_description, warehouse_id, dealer_rate, mark_up) VALUES('19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', '2023-05-17 13:30:28', '6700a7e5-5008-4d8c-9671-26fe90448bce', 'da4ea374-92ca-42d7-81f5-91752c307311', '19bf7475-c30a-4d7e-a91e-f6c2ad7ce2aa', 'cbf4b89f-3857-4869-8295-4e0ed5d7b1dc', 35, 16, '18fde49c-29d8-4e6a-883a-ec13f550a2ae', '', 'HDFC Bank GST Filing', '', 1, '', 1, 0, 0, 71628.95, 'fdfce7ef-6faf-4f0b-a5a1-a7641348a1b3', 60702.5, 10926.45, 18, 0, 0, 0, 0, 0, 0, 0, '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '', '', '00000000-0000-0000-0000-000000000000', 'Being Expense Booked Vide Ref No :: may month gst Dated :: 31/05/2023', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 10926.45, 0, 0, '', '', '', '', '', 0, 0, '', 0, 0, '00000000-0000-0000-0000-000000000000', 0, 0, '', 0, '', 0, '', 0, '', '', 0, 0) Inner Exception: NULL Source: MySql.Data Platform: Desktop 17-05-2023 13:34:31 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 17-05-2023 13:34:31 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 17-05-2023 13:34:31 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 17-05-2023 13:34:31 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 17-05-2023 13:37:00 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 17-05-2023 13:37:00 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 17-05-2023 13:37:00 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 17-05-2023 13:37:00 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 17-05-2023 13:39:01 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 17-05-2023 13:39:01 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 17-05-2023 13:39:01 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 17-05-2023 13:39:01 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 17-05-2023 13:45:50 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 17-05-2023 13:45:50 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 17-05-2023 13:45:50 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 17-05-2023 13:45:50 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## 17-05-2023 15:48:13 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ## ## ClientType: Desktop 17-05-2023 15:48:13 ## Error ## ## DataAccess.SetData ## ## Error ## ClientType: Desktop 17-05-2023 15:48:13 ## Error ## ## DataAccess.GetData ## ## GetMisc Unable to connect to data base 17-05-2023 15:48:13 ## Exception ## Authentication to host '192.168.0.200' for user 'root' using method 'mysql_native_password' failed with message: Unknown database 'support' ## DataAccess.GetConnection ## ##