Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- import frappe
- # 1. reimport_invoice js
- # 1.1. reimport_invoice py
- # 1.1.1. cancel_sales_invoices
- # 1.1.2. change_import_status
- # 1. get all invoices from the doc
- # file_location = "C:/Users/Soporte/Downloads/Revision Facturas Duplicadas.xlsx"
- # file = pd.read_excel(file_location, sheet_name="Sheet1")
- # invoice_ncfs = [row[1] for row in file.values.tolist()[1:]]
- invoice_ncfs = [
- '00000000B0100036464', '00000000B0100037087', '00000000B0100037088', '00000000B0100037089', '00000000B0100037090',
- '00000000B0100037181', '00000000B0100037196', '00000000B0100037197', '00000000B0100037198', '00000000B0100037199',
- '00000000B0100037200', '00000000B0100037399', '00000000B0100037400', '00000000B0100037401', '00000000B0100037475',
- '00000000B0100037689', '00000000B0100037936', '00000000B0100038604', '00000000B0100038606', '00000000B0100039962',
- '00000000B0100040803', '00000000B0100042548', '00000000B0100042876', '00000000B0100042995', '00000000B0200768556',
- '00000000B0200785961', '00000000B0200792781', '00000000B0200792953', '00000000B0200792954', '00000000B0200792955',
- '00000000B0200792956', '00000000B0200794363', '00000000B0200795379', '00000000B0200797029', '00000000B0200797510',
- '00000000B0200797511', '00000000B0200797512', '00000000B0200797775', '00000000B0200803628', '00000000B0200803704',
- '00000000B0200808335', '00000000B0200808336', '00000000B0200808337', '00000000B0200808761', '00000000B0200808954',
- '00000000B0200808968', '00000000B0200809497', '00000000B0200811192', '00000000B0200811962', '00000000B0200813022', '00000000B0200814018', '00000000B0200814029', '00000000B0200814032', '00000000B0200814033', '00000000B0200815411', '00000000B0200815423', '00000000B0200815424', '00000000B0200815433', '00000000B0200815445', '00000000B0200815455', '00000000B0200815468', '00000000B0200815481', '00000000B0200815494', '00000000B0200815795', '00000000B0200819088', '00000000B0200820569', '00000000B0200821098', '00000000B0200822273', '00000000B0200822451', '00000000B0200822572', '00000000B0200823686', '00000000B0200824323', '00000000B0200824324', '00000000B0200824325', '00000000B0200824326', '00000000B0200824327', '00000000B0200824328', '00000000B0200824329', '00000000B0200824330', '00000000B0200824331', '00000000B0200824643', '00000000B0200824645', '00000000B0200824646', '00000000B0200824647', '00000000B0200824649', '00000000B0200824665', '00000000B0200824676', '00000000B0200824685', '00000000B0200824699', '00000000B0200824713', '00000000B0200824726', '00000000B0200824731', '00000000B0200824732', '00000000B0200824733', '00000000B0200824743', '00000000B0200825461', '00000000B0200825477', '00000000B0200825495', '00000000B0200825505', '00000000B0200825520', '00000000B0200825529', '00000000B0200829537', '00000000B0200829953', '00000000B0200831417', '00000000B0200831702', '00000000B0200831819', '00000000B0200831824', '00000000B0200833112', '00000000B0200833328', '00000000B0200833586', '00000000B0200834414', '00000000B0200834415', '00000000B0200834894', '00000000B0200836735', '00000000B0200837375', '00000000B0200837381', '00000000B0200837890', '00000000B0200837892', '00000000B0200838650', '00000000B0200838655', '00000000B0200839378', '00000000B0200839382', '00000000B0200839919', '00000000B0200839922', '00000000B0200840306', '00000000B0200841613', '00000000B0200845745', '00000000B0200845746', '00000000B0200845747', '00000000B0200845748', '00000000B0200846005', '00000000B0200846017', '00000000B0200846024', '00000000B0200846034', '00000000B0200846045', '00000000B0200846057', '00000000B0200846065', '00000000B0200846077', '00000000B0200846087', '00000000B0200847020', '00000000B0200851548', '00000000B0200852213', '00000000B0200852230', '00000000B0200852231', '00000000B0200852232', '00000000B0200852244', '00000000B0200852862', '00000000B0200852868', '00000000B0200853529', '00000000B0200853534', '00000000B0200854139', '00000000B0200854332', '00000000B0200854333', '00000000B0200854340', '00000000B0200854343', '00000000B0200855966', '00000000B0200855978', '00000000B0200859188', '00000000B0200860301', '00000000B0200860618', '00000000B0200861230', '00000000B0200861325', '00000000B0200861397', '00000000B0200861402', '00000000B0200862221', '00000000B0200864515', '00000000B0200864516', '00000000B0200864522', '00000000B0200864532', '00000000B0200864851', '00000000B0200865129', '00000000B0200867040', '00000000B0200868429', '00000000B0200868430', '00000000B0200868453', '00000000B0200868454', '00000000B0200868455', '00000000B0200868458', '00000000B0200868473', '00000000B0200870129', '00000000B0200870132', '00000000B0200870137', '00000000B0200870301', '00000000B0200870326', '00000000B0200872171', '00000000B0200872172', '00000000B0200872546', '00000000B0200872547', '00000000B0200873740', '00000000B0200873746', '00000000B0200874141', '00000000B0200874941', '00000000B0200874948', '00000000B0200874952', '00000000B0200875069', '00000000B0200875070', '00000000B0200875072', '00000000B0200875073', '00000000B0200875074', '00000000B0200879523', '00000000B0200880594', '00000000B0200880986', '00000000B0200880996', '00000000B0200881000', '00000000B0200881001', '00000000B0200881002', '00000000B0200881003', '00000000B0200881004', '00000000B0200881005', '00000000B0200881013', '00000000B0200881014', '00000000B0200881015', '00000000B0200881016', '00000000B0200881017', '00000000B0200881019', '00000000B0200881027', '00000000B0200881389', '00000000B0200881541', '00000000B0200882065', '00000000B0200882627', '00000000B0200883125', '00000000B0200883140', '00000000B0200883145', '00000000B0200883149', '00000000B0200883278', '00000000B0200884018', '00000000B0200884019', '00000000B0200884848', '00000000B0200885446', '00000000B0200885880', '00000000B0200891094', '00000000B0200891265', '00000000B0200892398', '00000000B0200892494', '00000000B0200892642', '00000000B0200892648', '00000000B0200896025', '00000000B0200896527', '00000000B0200896530', '00000000B0200897133', '00000000B0200897662', '00000000B0200897791', '00000000B0200897796', '00000000B0200897968', '00000000B0200898295', '00000000B0200898296', '00000000B0200898414', '00000000B0200898480', '00000000B0200898577', '00000000B0200899479', '00000000B0200899480', '00000000B0200899945', '00000000B0200900323', '00000000B0200900369', '00000000B0200900714', '00000000B0200900718', '00000000B0200900958', '00000000B0200901275', '00000000B0200901371', '00000000B0200903770', '00000000B0200903771', '00000000B0200903938', '00000000B0200904094', '00000000B0200904438', '00000000B0200904451', '00000000B0200904619', '00000000B0200904636', '00000000B0200904637', '00000000B0200904638', '00000000B0200904641', '00000000B0200904643', '00000000B0200904644', '00000000B0200904647', '00000000B0200904648', '00000000B0200905189', '00000000B0200905193', '00000000B0200905194', '00000000B0200905685', '00000000B0200905873', '00000000B0200909322', '00000000B0200909323', '00000000B0200911734', '00000000B0200912462', '00000000B0200912463', '00000000B0200912466', '00000000B0200912470', '00000000B0200912951', '00000000B0200913120', '00000000B0200913218', '00000000B0200913813', '00000000B0200913816', '00000000B0200913818', '00000000B0200916112', '00000000B0200916407', '00000000B0200916567', '00000000B0200916572', '00000000B0200917623', '00000000B0200917629', '00000000B0200917733', '00000000B0200918430', '00000000B0200919625', '00000000B0200919631', '00000000B0200919813', '00000000B0200919826', '00000000B0200921150', '00000000B0200921387', '00000000B0200921678', '00000000B0200922482', '00000000B0200922489', '00000000B0200923111', '00000000B0200923112', '00000000B0200923114', '00000000B0200923117', '00000000B0200923118', '00000000B0200928538', '00000000B0200929326', '00000000B0200929338', '00000000B0200929342', '00000000B0200929957', '00000000B0200932552', '00000000B0200933333', '00000000B0200933964', '00000000B0200933966', '00000000B0200934066', '00000000B0200934076', '00000000B0200934077', '00000000B0200934079', '00000000B0200934323', '00000000B0200934517', '00000000B0200934518', '00000000B0200934519', '00000000B0200934797', '00000000B0200934800', '00000000B0200934995', '00000000B0200935263', '00000000B0200935264', '00000000B0200935270', '00000000B0200936159', '00000000B0200936864', '00000000B0200937705', '00000000B0200937849', '00000000B0200938022', '00000000B0200938023', '00000000B0200938024', '00000000B0200939028', '00000000B0200939034', '00000000B0200939443', '00000000B0200939447', '00000000B0200939611', '00000000B0200939612', '00000000B0200940208', '00000000B0200941852', '00000000B0200941853', '00000000B0200941855', '00000000B0200941871', '00000000B0200941875', '00000000B0200941880', '00000000B0200941890', '00000000B0200941903', '00000000B0200946156', '00000000B0200947556', '00000000B0200947558', '00000000B0200948118', '00000000B0200948529', '00000000B0200948802', '00000000B0200948902', '00000000B0200949210', '00000000B0200949218', '00000000B0200949228', '00000000B0200949235', '00000000B0200949242', '00000000B0200949250', '00000000B0200949258', '00000000B0200949265', '00000000B0200949272', '00000000B0200950590', '00000000B0200950642', '00000000B0200950721', '00000000B0200950755', '00000000B0200950784', '00000000B0200950800', '00000000B0200952329', '00000000B0200952630', '00000000B0200952633', '00000000B0200952812', '00000000B0200952813', '00000000B0200952814', '00000000B0200953227', '00000000B0200953757', '00000000B0200953766', '00000000B0200953785', '00000000B0200953800', '00000000B0200953810', '00000000B0200953822', '00000000B0200954380', '00000000B0200954381', '00000000B0200954386', '00000000B0200954389', '00000000B0200954392', '00000000B0200957053', '00000000B0200957220', '00000000B0200957230', '00000000B0200957233', '00000000B0200957238', '00000000B0200957380', '00000000B0200957892', '00000000B0200957898', '00000000B0200958650', '00000000B0200958778', '00000000B0200958781', '00000000B0200958782', '00000000B0200958784', '00000000B0200958786', '00000000B0200958787', '00000000B0200958788', '00000000B0200958797', '00000000B0200958798', '00000000B0200961895', '00000000B0200964986', '00000000B0200965399', '00000000B0200965433', '00000000B0200965747', '00000000B0200965901', '00000000B0200965912', '00000000B0200966708', '00000000B0200966716', '00000000B0200966720', '00000000B0200966895', '00000000B0200967988', '00000000B0200968336', '00000000B0200968341', '00000000B0200968758', '00000000B0200968772', '00000000B0200968900', '00000000B0200969469', '00000000B0200971516', '00000000B0200971527', '00000000B0200971537', '00000000B0200971547', '00000000B0200971557', '00000000B0200971566', '00000000B0200971567', '00000000B0200971751', '00000000B0200971757', '00000000B0200971758', '00000000B0200971762', '00000000B0200972006', '00000000B0200972062', '00000000B0200972304', '00000000B0200972344', '00000000B0200972419', '00000000B0200972440', '00000000B0200972513', '00000000B0200972516', '00000000B0200972525', '00000000B0200972558', '00000000B0200972564', '00000000B0200972573', '00000000B0200975796', '00000000B0200975798', '00000000B0200977523', '00000000B0200977601', '00000000B0200977606', '00000000B0200977779', '00000000B0200977808', '00000000B0200978023', '00000000B0200978026', '00000000B0200978027', '00000000B0200979508', '00000000B0200979509', '00000000B0200979510'
- ]
- # ncfs tested
- # done 00000000B0100036464
- # weird 00000000B0100037087
- # weird 00000000B0100037088
- # ignore 00000000B0100037090 00000000B0100037181 00000000B0100037399 00000000B0100037400
- # todo 00000000B0100037475 00000000B0100037936 00000000B0100038604
- invoice_ncfs = ["00000000B0100036464", "00000000B0100037087", "00000000B0100037088", "00000000B0100037090", "00000000B0100037181", "00000000B0100037399", "00000000B0100037400", "00000000B0100037475", "00000000B0100037936", "00000000B0100038604"]
- # 2. filter which invoices are repeated
- filters = {
- "ncf": ["in", invoice_ncfs],
- "status": "Paid"
- }
- # ypos_2reimport = set([inv["ypos_invoice_import"] for inv in sale_invoices])
- sale_invoices = frappe.get_list("Sales Invoice", filters, ["name", "ncf", "ypos_invoice_import", "posting_date", "grand_total", "status"])
- invoice_ypos = {}
- ncf_reimport = []
- ncf_ignore = []
- ypos_reimport = []
- ypos_ignore = []
- # build dict with {ypos invoice import: [invoices...]}
- for inv in sale_invoices:
- if inv["ypos_invoice_import"] not in invoice_ypos:
- invoice_ypos[inv["ypos_invoice_import"]] = [inv]
- else:
- invoice_ypos[inv["ypos_invoice_import"]].append(inv)
- for k, v in invoice_ypos.items():
- # add ypos_import case which only have two invoices (duplicated) with the same date and the same amount
- if len(v) == 2 and v[0]["posting_date"] == v[1]["posting_date"] and v[0]["grand_total"] == v[1]["grand_total"]:
- ypos_reimport.append(k)
- ncf_reimport.append(v[0]["ncf"])
- continue
- # other wise ignore them
- ypos_ignore.append(k)
- ncf_ignore.append(v[0]["ncf"])
- # removing duplicates
- ncf_reimport = list(set(ncf_reimport))
- ncf_ignore = list(set(ncf_ignore))
- ypos_reimport = list(set(ypos_reimport))
- ypos_ignore = list(set(ypos_ignore))
- # TODO: search invoices by ypos_invoice_import and assert if they are qualified to be reimported or not
- # in both ypos_reimport and ypos_ignore
- ypos_reimport = [
- '8370 - BR San Isidro - H/67227-66971',
- '8370 - BR San Isidro - H/71321-71055',
- 'BR Lincoln - H/121437-121143',
- '8365 - BR Village PC - H/62388-62328',
- 'BR Lincoln - H/136833-136476',
- 'BR Tiradentes - H/156613-154739',
- 'BR Tiradentes - H/143906-142211',
- '8368 - BR Galeria 360 - H/117926-117704',
- '8368 - BR Galeria 360 - H/107801-107585',
- 'BR Lincoln - H/129889-129544',
- 'BR Betancourt - H/142787-141847',
- '8357 - BR Bolivar - H/47016-46693',
- '8368 - BR Galeria 360 - H/118514-118292',
- 'BR Tiradentes - H/151569-149762',
- 'BR Tiradentes - H/162444-160528',
- 'BR Lincoln - H/130121-129776',
- 'BR Betancourt - H/136103-135197',
- 'BR Lincoln - H/121427-121133',
- '8368 - BR Galeria 360 - H/118771-118549',
- 'BR Lincoln - H/120496-120204',
- 'BR Lincoln - H/144530-144164',
- 'BR Lincoln - H/144522-144156',
- '8370 - BR San Isidro - H/67904-67648',
- 'BR Tiradentes - H/164230-162297',
- '8357 - BR Bolivar - H/54543-54202',
- '8365 - BR Village PC - H/70356-70278',
- '8359 - BR Trinitaria STG - H/77012-76832',
- '8368 - BR Galeria 360 - H/118630-118408',
- 'BR Betancourt - H/125364-124521',
- 'BR Lincoln - H/118102-117815',
- 'BR Lincoln - H/121396-121102',
- 'BR Tiradentes - H/151565-149758',
- 'BR Tiradentes - H/151567-149760',
- 'BR Tiradentes - H/161295-159385',
- 'BR Betancourt - H/138314-137400',
- '8356 - BR Nunez - H/92760-92330',
- 'BR Lincoln - H/128091-127751',
- '8370 - BR San Isidro - H/64022-63771',
- 'BR Betancourt - H/134089-133192',
- 'BR Lincoln - H/143584-143219',
- '8365 - BR Village PC - H/70683-70604',
- 'BR Tiradentes - H/155656-153803',
- 'BR Tiradentes - H/151561-149754',
- '8357 - BR Bolivar - H/46072-45750',
- 'BR Lincoln - H/121057-120764',
- '8370 - BR San Isidro - H/66214-65958',
- 'BR Lincoln - H/129886-129541',
- 'BR Betancourt - H/142791-141851',
- 'BR Tiradentes - H/164234-162301',
- '8370 - BR San Isidro - H/59967-59742',
- 'BR Betancourt - H/130404-129538',
- '8368 - BR Galeria 360 - H/120675-120451',
- '8365 - BR Village PC - H/66774-66705',
- '8370 - BR San Isidro - H/58968-58745',
- 'BR Tiradentes - H/156617-154742',
- '8370 - BR San Isidro - H/68579-68322',
- 'BR Tiradentes - H/154213-152372',
- '8370 - BR San Isidro - H/62803-62556',
- 'BR Tiradentes - H/155109-153257',
- '8357 - BR Bolivar - H/44355-44038',
- 'BR Lincoln - H/119051-118761',
- '8359 - BR Trinitaria STG - H/77013-76833',
- 'BR Lincoln - H/120509-120217',
- '8368 - BR Galeria 360 - H/120205-119981',
- 'BR Betancourt - H/147222-146262',
- '8365 - BR Village PC - H/71657-71578',
- 'BR Lincoln - H/135179-134827',
- 'BR Lincoln - H/121393-121099',
- '8368 - BR Galeria 360 - H/120170-119946',
- 'BR Lincoln - H/121395-121101',
- '8370 - BR San Isidro - H/59618-59393',
- 'BR Tiradentes - H/152907-151083',
- 'BR Betancourt - H/143955-143012',
- '8365 - BR Village PC - H/68738-68666',
- '8370 - BR San Isidro - H/59604-59379',
- '8357 - BR Bolivar - H/47979-47652',
- 'BR Betancourt - H/139213-138293',
- 'BR Lincoln - H/131756-131409',
- '8370 - BR San Isidro - H/64146-63895',
- 'BR Betancourt - H/126955-126104',
- 'BR Betancourt - H/148828-147861',
- 'BR Tiradentes - H/151571-149764',
- '8357 - BR Bolivar - H/48152-47825',
- '8370 - BR San Isidro - H/64151-63900',
- 'BR Tiradentes - H/145288-143576',
- '8370 - BR San Isidro - H/69029-68769',
- 'BR Betancourt - H/134090-133193',
- '8370 - BR San Isidro - H/71599-71333',
- 'BR Lincoln - H/134346-133995',
- 'BR Lincoln - H/121485-121191',
- 'BR Betancourt - H/138481-137565',
- '8359 - BR Trinitaria STG - H/81425-81238',
- 'BR Betancourt - H/129859-128996',
- '8365 - BR Village PC - H/66487-66419',
- 'BR Lincoln - H/121465-121171',
- 'BR Tiradentes - H/162448-160532',
- '8370 - BR San Isidro - H/71344-71078',
- '8356 - BR Nunez - H/83218-82835',
- '8357 - BR Bolivar - H/50953-50621',
- '8370 - BR San Isidro - H/61600-61374',
- '8365 - BR Village PC - H/69643-69568',
- 'BR Lincoln - H/144387-144021',
- '8365 - BR Village PC - H/61621-61562',
- 'BR Betancourt - H/139034-138116',
- '8356 - BR Nunez - H/88886-88478',
- '8370 - BR San Isidro - H/60087-59861',
- '8357 - BR Bolivar - H/49669-49337',
- 'BR Betancourt - H/134088-133191',
- '8370 - BR San Isidro - H/66146-65890',
- 'BR Tiradentes - H/151585-149778',
- '8359 - BR Trinitaria STG - H/77492-77312',
- '8365 - BR Village PC - H/71551-71472',
- '8357 - BR Bolivar - H/48996-48665',
- '8368 - BR Galeria 360 - H/120495-120271',
- 'BR Tiradentes - H/151568-149761',
- 'BR Lincoln - H/144532-144166',
- '8370 - BR San Isidro - H/69314-69054',
- '8365 - BR Village PC - H/64312-64248',
- '8370 - BR San Isidro - H/64015-63764',
- 'BR Lincoln - H/143043-142679',
- '8368 - BR Galeria 360 - H/117961-117739',
- '8370 - BR San Isidro - H/68467-68210',
- 'BR Tiradentes - H/158918-157027',
- 'BR Betancourt - H/134102-133205',
- 'BR Tiradentes - H/144618-142915',
- '8368 - BR Galeria 360 - H/118652-118430',
- '8368 - BR Galeria 360 - H/118777-118555',
- 'BR Lincoln - H/126629-126292',
- '8370 - BR San Isidro - H/59404-59179',
- 'BR Tiradentes - H/163574-161646',
- 'BR Betancourt - H/139971-139047',
- 'BR Betancourt - H/130401-129535',
- '8370 - BR San Isidro - H/71307-71041',
- '8365 - BR Village PC - H/76945-76858',
- '8370 - BR San Isidro - H/61895-61651',
- '8365 - BR Village PC - H/76947-76860',
- 'BR Tiradentes - H/155117-153265',
- '8356 - BR Nunez - H/92766-92336',
- '8370 - BR San Isidro - H/68578-68321',
- 'BR Tiradentes - H/158561-156672',
- 'BR Lincoln - H/135165-134813',
- 'BR Tiradentes - H/151581-149774',
- 'BR Lincoln - H/134962-134610',
- 'BR Lincoln - H/144526-144160',
- 'BR Lincoln - H/121056-120763',
- '8365 - BR Village PC - H/74799-74717',
- 'BR Lincoln - H/136582-136226',
- 'BR Betancourt - H/140546-139620',
- '8370 - BR San Isidro - H/70875-70610',
- 'BR Betancourt - H/129855-128992',
- '8356 - BR Nunez - H/88860-88452',
- 'BR Tiradentes - H/158917-157026',
- '8368 - BR Galeria 360 - H/117845-117623',
- '8357 - BR Bolivar - H/50785-50453',
- 'BR Tiradentes - H/163535-161609',
- '8356 - BR Nunez - H/92558-92131',
- 'BR Lincoln - H/122301-122005',
- '8357 - BR Bolivar - H/49715-49383',
- 'BR Betancourt - H/146772-145816',
- 'BR Tiradentes - H/151587-149780',
- '8370 - BR San Isidro - H/68581-68324',
- 'BR Lincoln - H/144528-144162',
- 'BR Lincoln - H/122272-121976',
- '8356 - BR Nunez - H/92535-92109',
- '8359 - BR Trinitaria STG - H/81441-81254',
- 'BR Tiradentes - H/160033-158131',
- 'BR Lincoln - H/121052-120759',
- 'BR Tiradentes - H/145810-144094',
- 'BR Lincoln - H/121451-121157',
- 'BR Lincoln - H/130119-129774',
- '8365 - BR Village PC - H/68880-68807',
- '8368 - BR Galeria 360 - H/118725-118503',
- '8357 - BR Bolivar - H/55030-54689',
- 'BR Tiradentes - H/163596-161668',
- 'BR Tiradentes - H/155840-153987',
- 'BR Betancourt - H/139035-138117',
- 'BR Betancourt - H/137031-136122',
- 'BR Lincoln - H/138396-138039',
- 'BR Lincoln - H/121479-121185',
- 'BR Tiradentes - H/149501-147722',
- '8365 - BR Village PC - H/76946-76859',
- '8365 - BR Village PC - H/69644-69569',
- '8357 - BR Bolivar - H/49279-48948',
- 'BR Lincoln - H/121054-120761',
- 'BR Tiradentes - H/156620-154745',
- 'BR Lincoln - H/128090-127750',
- 'BR Betancourt - H/141941-141007',
- 'BR Betancourt - H/146087-145139',
- '8365 - BR Village PC - H/68743-68671',
- 'BR Lincoln - H/121399-121105',
- '8356 - BR Nunez - H/88880-88472',
- '8370 - BR San Isidro - H/69028-68768',
- '8356 - BR Nunez - H/92767-92337',
- '8368 - BR Galeria 360 - H/105934-105720',
- 'BR Betancourt - H/129121-128260',
- 'BR Tiradentes - H/155113-153261',
- '8370 - BR San Isidro - H/70179-69914',
- '8370 - BR San Isidro - H/67228-66972',
- '8368 - BR Galeria 360 - H/117793-117571',
- 'BR Tiradentes - H/163584-161656',
- 'BR Lincoln - H/142890-142526',
- 'BR Lincoln - H/144531-144165',
- 'BR Tiradentes - H/157339-155461',
- '8368 - BR Galeria 360 - H/120283-120059',
- 'BR Lincoln - H/128114-127774',
- 'BR Lincoln - H/141452-141090',
- 'BR Lincoln - H/122254-121958',
- 'BR Betancourt - H/147986-147022',
- 'BR Lincoln - H/119040-118750',
- '8370 - BR San Isidro - H/64780-64528',
- 'BR Lincoln - H/144525-144159',
- '8370 - BR San Isidro - H/68832-68573',
- 'BR Betancourt - H/139966-139042',
- '8370 - BR San Isidro - H/65398-65143',
- '8357 - BR Bolivar - H/50062-49730',
- '8368 - BR Galeria 360 - H/118270-118048',
- '8359 - BR Trinitaria STG - H/81424-81237',
- 'BR Lincoln - H/144543-144177',
- 'BR Tiradentes - H/158919-157028',
- '8370 - BR San Isidro - H/69789-69526',
- 'BR Tiradentes - H/154357-152514',
- '8368 - BR Galeria 360 - H/120288-120064',
- '8365 - BR Village PC - H/72381-72302',
- 'BR Tiradentes - H/160039-158137',
- '8370 - BR San Isidro - H/69317-69057',
- 'BR Betancourt - H/142775-141835',
- '8357 - BR Bolivar - H/54079-53738',
- '8370 - BR San Isidro - H/69790-69527',
- 'BR Tiradentes - H/154933-153082',
- '8370 - BR San Isidro - H/71297-71031',
- 'BR Lincoln - H/142895-142531',
- '8370 - BR San Isidro - H/69031-68771',
- 'BR Tiradentes - H/152762-150939',
- '8370 - BR San Isidro - H/62797-62550',
- 'BR Tiradentes - H/161296-159386',
- '8368 - BR Galeria 360 - H/105909-105695',
- '8357 - BR Bolivar - H/55019-54678',
- 'BR Lincoln - H/121059-120766',
- '8356 - BR Nunez - H/88876-88468',
- 'BR Lincoln - H/121058-120765',
- '8370 - BR San Isidro - H/69796-69533',
- '8370 - BR San Isidro - H/71289-71023',
- '8356 - BR Nunez - H/88912-88504',
- 'BR Lincoln - H/122316-122020',
- 'BR Tiradentes - H/140958-139309',
- 'BR Lincoln - H/128136-127796',
- '8370 - BR San Isidro - H/69518-69257',
- '8368 - BR Galeria 360 - H/118787-118565',
- 'BR Lincoln - H/120575-120283',
- '8359 - BR Trinitaria STG - H/80675-80488',
- '8357 - BR Bolivar - H/54509-54168',
- '8368 - BR Galeria 360 - H/118737-118515',
- 'BR Tiradentes - H/151583-149776',
- '8370 - BR San Isidro - H/68568-68311',
- '8370 - BR San Isidro - H/60092-59866',
- 'BR Betancourt - H/139939-139015',
- '8370 - BR San Isidro - H/58967-58744',
- 'BR Tiradentes - H/161297-159387',
- 'BR Tiradentes - H/163526-161600',
- '8356 - BR Nunez - H/92772-92341',
- '8370 - BR San Isidro - H/64150-63899',
- '8370 - BR San Isidro - H/65837-65582',
- 'BR Tiradentes - H/157347-155469',
- 'BR Lincoln - H/121397-121103',
- 'BR Tiradentes - H/151570-149763',
- 'BR Lincoln - H/121486-121192',
- 'BR Tiradentes - H/158715-156825',
- 'BR Lincoln - H/142692-142328',
- 'BR Tiradentes - H/158049-156162',
- '8368 - BR Galeria 360 - H/118006-117784',
- 'BR Lincoln - H/120560-120268',
- '8359 - BR Trinitaria STG - H/83624-83437',
- 'BR Betancourt - H/140550-139624',
- 'BR Tiradentes - H/155110-153258',
- '8356 - BR Nunez - H/92525-92099',
- '8357 - BR Bolivar - H/48157-47830',
- 'BR Lincoln - H/120547-120255',
- '8359 - BR Trinitaria STG - H/92746-92544',
- 'BR Tiradentes - H/162929-161010',
- 'BR Lincoln - H/142876-142512',
- '8368 - BR Galeria 360 - H/120465-120241',
- '8356 - BR Nunez - H/92514-92088',
- 'BR Betancourt - H/139744-138822',
- '8368 - BR Galeria 360 - H/118765-118543',
- 'BR Lincoln - H/134345-133994',
- 'BR Lincoln - H/128116-127776',
- '8357 - BR Bolivar - H/50476-50144',
- '8370 - BR San Isidro - H/68465-68208',
- 'BR Lincoln - H/128120-127780',
- '8356 - BR Nunez - H/92547-92120',
- '8365 - BR Village PC - H/70782-70703',
- '8356 - BR Nunez - H/88857-88449',
- 'BR Tiradentes - H/155945-154087',
- '8370 - BR San Isidro - H/61384-61158',
- '8365 - BR Village PC - H/62923-62860',
- '8359 - BR Trinitaria STG - H/81431-81244',
- '8365 - BR Village PC - H/68747-68675',
- 'BR Lincoln - H/121055-120762',
- 'BR Lincoln - H/144542-144176',
- 'BR Tiradentes - H/153594-151760',
- 'BR Lincoln - H/120520-120228',
- 'BR Lincoln - H/121484-121190',
- 'BR Lincoln - H/119055-118765',
- 'BR Lincoln - H/133515-133166',
- 'BR Betancourt - H/139958-139034',
- 'BR Betancourt - H/134752-133853',
- 'BR Lincoln - H/121497-121203',
- 'BR Betancourt - H/135460-134559',
- 'BR Lincoln - H/120589-120297',
- 'BR Betancourt - H/139375-138454',
- 'BR Tiradentes - H/163556-161629',
- 'BR Lincoln - H/121415-121121',
- '8357 - BR Bolivar - H/50066-49734',
- 'BR Tiradentes - H/140227-138584',
- '8370 - BR San Isidro - H/70597-70332',
- 'BR Betancourt - H/144135-143192',
- 'BR Tiradentes - H/145294-143582',
- '8370 - BR San Isidro - H/69030-68770',
- 'BR Lincoln - H/140717-140356',
- '8370 - BR San Isidro - H/70978-70713',
- 'BR Tiradentes - H/154362-152519',
- '8368 - BR Galeria 360 - H/107800-107584',
- '8365 - BR Village PC - H/74010-73929',
- '8357 - BR Bolivar - H/47344-47020',
- 'BR Tiradentes - H/151119-149317',
- 'BR Lincoln - H/122291-121995',
- '8356 - BR Nunez - H/88858-88450',
- '8357 - BR Bolivar - H/54864-54523',
- 'BR Lincoln - H/121053-120760',
- 'BR Betancourt - H/133356-132466',
- '8357 - BR Bolivar - H/50948-50616',
- '8370 - BR San Isidro - H/64147-63896',
- 'BR Lincoln - H/134968-134616',
- 'BR Betancourt - H/136856-135947',
- 'BR Betancourt - H/141063-140136',
- 'BR Tiradentes - H/162436-160520',
- '8365 - BR Village PC - H/64736-64672',
- '8370 - BR San Isidro - H/71351-71085',
- 'BR Lincoln - H/121060-120767',
- 'BR Lincoln - H/128115-127775',
- '8359 - BR Trinitaria STG - H/90105-89907',
- 'BR Lincoln - H/140719-140358',
- '8359 - BR Trinitaria STG - H/87173-86985',
- 'BR Lincoln - H/129894-129549',
- 'BR Betancourt - H/134070-133173',
- 'BR Tiradentes - H/158048-156161',
- '8357 - BR Bolivar - H/48079-47752',
- 'BR Tiradentes - H/151595-149788',
- '8368 - BR Galeria 360 - H/118554-118332',
- '8368 - BR Galeria 360 - H/117990-117768',
- 'BR Lincoln - H/142887-142523',
- 'BR Lincoln - H/143590-143225',
- '8365 - BR Village PC - H/71545-71466',
- 'BR Betancourt - H/139960-139036',
- '8370 - BR San Isidro - H/64149-63898',
- 'BR Lincoln - H/119054-118764',
- 'BR Lincoln - H/120534-120242',
- 'BR Tiradentes - H/152910-151086',
- 'BR Tiradentes - H/154561-152715',
- 'BR Betancourt - H/136309-135403',
- 'BR Tiradentes - H/164227-162294',
- 'BR Betancourt - H/136312-135406',
- 'BR Betancourt - H/138213-137299',
- 'BR Betancourt - H/139964-139040',
- '8370 - BR San Isidro - H/64026-63775',
- 'BR Betancourt - H/146090-145142',
- '8359 - BR Trinitaria STG - H/92744-92542',
- '8370 - BR San Isidro - H/71314-71048',
- 'BR Tiradentes - H/158043-156156',
- 'BR Betancourt - H/146767-145811',
- 'BR Betancourt - H/144136-143193',
- '8370 - BR San Isidro - H/71337-71071',
- 'BR Lincoln - H/122327-122031',
- '8356 - BR Nunez - H/75534-75183',
- 'BR Tiradentes - H/162631-160714',
- '8357 - BR Bolivar - H/44747-44430',
- '8368 - BR Galeria 360 - H/120676-120452',
- '8368 - BR Galeria 360 - H/118728-118506',
- 'BR Tiradentes - H/154932-153081',
- '8370 - BR San Isidro - H/63203-62956',
- 'BR Lincoln - H/120508-120216',
- '8370 - BR San Isidro - H/58966-58743',
- 'BR Betancourt - H/140551-139625',
- 'BR Tiradentes - H/151582-149775',
- '8370 - BR San Isidro - H/66312-66056',
- '8368 - BR Galeria 360 - H/118213-117991',
- 'BR Lincoln - H/137641-137284',
- '8368 - BR Galeria 360 - H/120672-120448',
- 'BR Tiradentes - H/151580-149773'
- ]
- # 3. execute script for duplicated invoices
- imports = ypos_reimport[200:300]
- for ypos_import in imports:
- invoice_import = frappe.get_doc("YPOS Invoice Import", ypos_import)
- invoice_import.reimport_invoice()
- invoice_import.import_invoice()
- error_ypos = ['BR Lincoln - H/122327-122031',
- '8356 - BR Nunez - H/75534-75183',
- 'BR Tiradentes - H/162631-160714',
- '8357 - BR Bolivar - H/44747-44430',
- '8368 - BR Galeria 360 - H/120676-120452',
- '8368 - BR Galeria 360 - H/118728-118506',
- 'BR Tiradentes - H/154932-153081',
- '8370 - BR San Isidro - H/63203-62956',
- 'BR Lincoln - H/120508-120216',
- '8370 - BR San Isidro - H/58966-58743',
- 'BR Betancourt - H/140551-139625',
- 'BR Tiradentes - H/151582-149775',
- '8370 - BR San Isidro - H/66312-66056',
- '8368 - BR Galeria 360 - H/118213-117991',
- 'BR Lincoln - H/137641-137284',
- '8368 - BR Galeria 360 - H/120672-120448',
- 'BR Tiradentes - H/151580-149773']
- filters = {
- "ypos_invoice_import": ["in", error_ypos],
- "status": "Paid"
- }
- sale_invoices = frappe.get_list("Sales Invoice", filters, ["name", "ncf", "ypos_invoice_import", "posting_date", "grand_total", "status"])
- ypos_invoices = {}
- for invoice in sale_invoices:
- if invoice["ypos_invoice_import"] not in ypos_invoices:
- ypos_invoices[invoice["ypos_invoice_import"]] = [invoice]
- else:
- ypos_invoices[invoice["ypos_invoice_import"]].append(invoice)
- single_invoice_ypos = []
- double_invoice_ypos = []
- invoices2cancel = []
- for k, v in ypos_invoices.items():
- if (
- len(v) == 2
- and v[0]["ncf"] == v[1]["ncf"]
- and v[0]["posting_date"] == v[1]["posting_date"]
- and v[0]["grand_total"] == v[1]["grand_total"]
- ):
- double_invoice_ypos.append(k)
- invoices2cancel.append(v[1]["name"])
- else:
- single_invoice_ypos.append(k)
- single_invoice_ypos = set(single_invoice_ypos)
- double_invoice_ypos = set(double_invoice_ypos)
- invoices2cancel = set(invoices2cancel)
- double_invoice_ypos = {
- '8356 - BR Nunez - H/75534-75183',
- '8356 - BR Nunez - H/88858-88450',
- '8357 - BR Bolivar - H/44747-44430',
- '8357 - BR Bolivar - H/50948-50616',
- '8357 - BR Bolivar - H/54079-53738',
- '8357 - BR Bolivar - H/54509-54168',
- '8357 - BR Bolivar - H/54864-54523',
- '8359 - BR Trinitaria STG - H/80675-80488',
- '8365 - BR Village PC - H/64736-64672',
- '8368 - BR Galeria 360 - H/118737-118515',
- '8368 - BR Galeria 360 - H/120672-120448',
- '8370 - BR San Isidro - H/58966-58743',
- '8370 - BR San Isidro - H/60092-59866',
- '8370 - BR San Isidro - H/63203-62956',
- '8370 - BR San Isidro - H/64026-63775',
- '8370 - BR San Isidro - H/64147-63896',
- '8370 - BR San Isidro - H/64149-63898',
- '8370 - BR San Isidro - H/68568-68311',
- '8370 - BR San Isidro - H/71351-71085',
- 'BR Betancourt - H/133356-132466',
- 'BR Betancourt - H/141063-140136',
- 'BR Lincoln - H/119054-118764',
- 'BR Lincoln - H/120508-120216',
- 'BR Lincoln - H/120534-120242',
- 'BR Lincoln - H/121053-120760',
- 'BR Lincoln - H/121060-120767',
- 'BR Lincoln - H/122291-121995',
- 'BR Lincoln - H/122327-122031',
- 'BR Lincoln - H/128120-127780',
- 'BR Lincoln - H/134968-134616',
- 'BR Lincoln - H/137641-137284',
- 'BR Tiradentes - H/151580-149773',
- 'BR Tiradentes - H/151583-149776',
- 'BR Tiradentes - H/161297-159387',
- 'BR Tiradentes - H/162436-160520'
- }
- for name in invoices2cancel:
- invoice = frappe.get_doc("Sales Invoice", name)
- invoice.cancel()
- still_duplicated = ['BR Tiradentes - H/145294-143582', 'BR Betancourt - H/135460-134559']
Add Comment
Please, Sign In to add comment