Cadara_Ramirez

Untitled

Dec 7th, 2021 (edited)
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 32.41 KB | None | 0 0
  1. import pandas as pd
  2. import frappe
  3. # 1. reimport_invoice js
  4.     # 1.1. reimport_invoice py    
  5.         # 1.1.1. cancel_sales_invoices
  6.         # 1.1.2. change_import_status
  7.  
  8. # 1. get all invoices from the doc
  9. # file_location = "C:/Users/Soporte/Downloads/Revision Facturas Duplicadas.xlsx"
  10. # file = pd.read_excel(file_location, sheet_name="Sheet1")
  11. # invoice_ncfs = [row[1] for row in file.values.tolist()[1:]]
  12. invoice_ncfs = [
  13.     '00000000B0100036464', '00000000B0100037087', '00000000B0100037088', '00000000B0100037089', '00000000B0100037090',
  14.     '00000000B0100037181', '00000000B0100037196', '00000000B0100037197', '00000000B0100037198', '00000000B0100037199',
  15.     '00000000B0100037200', '00000000B0100037399', '00000000B0100037400', '00000000B0100037401', '00000000B0100037475',
  16.     '00000000B0100037689', '00000000B0100037936', '00000000B0100038604', '00000000B0100038606', '00000000B0100039962',
  17.     '00000000B0100040803', '00000000B0100042548', '00000000B0100042876', '00000000B0100042995', '00000000B0200768556',
  18.     '00000000B0200785961', '00000000B0200792781', '00000000B0200792953', '00000000B0200792954', '00000000B0200792955',
  19.     '00000000B0200792956', '00000000B0200794363', '00000000B0200795379', '00000000B0200797029', '00000000B0200797510',
  20.     '00000000B0200797511', '00000000B0200797512', '00000000B0200797775', '00000000B0200803628', '00000000B0200803704',
  21.     '00000000B0200808335', '00000000B0200808336', '00000000B0200808337', '00000000B0200808761', '00000000B0200808954',
  22.     '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'
  23. ]
  24.  
  25. # ncfs tested
  26. # done 00000000B0100036464
  27. # weird 00000000B0100037087
  28. # weird 00000000B0100037088
  29. # ignore 00000000B0100037090 00000000B0100037181 00000000B0100037399 00000000B0100037400
  30. # todo 00000000B0100037475 00000000B0100037936 00000000B0100038604
  31.  
  32. invoice_ncfs = ["00000000B0100036464", "00000000B0100037087", "00000000B0100037088", "00000000B0100037090", "00000000B0100037181", "00000000B0100037399", "00000000B0100037400", "00000000B0100037475", "00000000B0100037936", "00000000B0100038604"]
  33.  
  34. # 2. filter which invoices are repeated
  35. filters = {
  36.     "ncf": ["in", invoice_ncfs],
  37.     "status": "Paid"
  38. }
  39. # ypos_2reimport = set([inv["ypos_invoice_import"] for inv in sale_invoices])
  40. sale_invoices = frappe.get_list("Sales Invoice", filters, ["name", "ncf", "ypos_invoice_import", "posting_date", "grand_total", "status"])
  41. invoice_ypos = {}
  42. ncf_reimport = []
  43. ncf_ignore = []
  44. ypos_reimport = []
  45. ypos_ignore = []
  46.  
  47. # build dict with {ypos invoice import: [invoices...]}
  48. for inv in sale_invoices:
  49.     if inv["ypos_invoice_import"] not in invoice_ypos:
  50.         invoice_ypos[inv["ypos_invoice_import"]] = [inv]
  51.     else:
  52.         invoice_ypos[inv["ypos_invoice_import"]].append(inv)
  53.  
  54. for k, v in invoice_ypos.items():
  55.     # add ypos_import case which only have two invoices (duplicated) with the same date and the same amount
  56.     if len(v) == 2 and v[0]["posting_date"] == v[1]["posting_date"] and v[0]["grand_total"] == v[1]["grand_total"]:
  57.         ypos_reimport.append(k)
  58.         ncf_reimport.append(v[0]["ncf"])
  59.         continue
  60.     # other wise ignore them
  61.     ypos_ignore.append(k)
  62.     ncf_ignore.append(v[0]["ncf"])
  63.  
  64. # removing duplicates
  65. ncf_reimport = list(set(ncf_reimport))
  66. ncf_ignore = list(set(ncf_ignore))
  67. ypos_reimport = list(set(ypos_reimport))
  68. ypos_ignore = list(set(ypos_ignore))
  69.  
  70. # TODO: search invoices by ypos_invoice_import and assert if they are qualified to be reimported or not
  71. # in both ypos_reimport and ypos_ignore
  72.  
  73. ypos_reimport = [
  74.     '8370 - BR San Isidro - H/67227-66971',
  75.     '8370 - BR San Isidro - H/71321-71055',
  76.     'BR Lincoln - H/121437-121143',
  77.     '8365 - BR Village PC - H/62388-62328',
  78.     'BR Lincoln - H/136833-136476',
  79.     'BR Tiradentes - H/156613-154739',
  80.     'BR Tiradentes - H/143906-142211',
  81.     '8368 - BR Galeria 360 - H/117926-117704',
  82.     '8368 - BR Galeria 360 - H/107801-107585',
  83.     'BR Lincoln - H/129889-129544',
  84.     'BR Betancourt - H/142787-141847',
  85.     '8357 - BR Bolivar - H/47016-46693',
  86.     '8368 - BR Galeria 360 - H/118514-118292',
  87.     'BR Tiradentes - H/151569-149762',
  88.     'BR Tiradentes - H/162444-160528',
  89.     'BR Lincoln - H/130121-129776',
  90.     'BR Betancourt - H/136103-135197',
  91.     'BR Lincoln - H/121427-121133',
  92.     '8368 - BR Galeria 360 - H/118771-118549',
  93.     'BR Lincoln - H/120496-120204',
  94.     'BR Lincoln - H/144530-144164',
  95.     'BR Lincoln - H/144522-144156',
  96.     '8370 - BR San Isidro - H/67904-67648',
  97.     'BR Tiradentes - H/164230-162297',
  98.     '8357 - BR Bolivar - H/54543-54202',
  99.     '8365 - BR Village PC - H/70356-70278',
  100.     '8359 - BR Trinitaria STG - H/77012-76832',
  101.     '8368 - BR Galeria 360 - H/118630-118408',
  102.     'BR Betancourt - H/125364-124521',
  103.     'BR Lincoln - H/118102-117815',
  104.     'BR Lincoln - H/121396-121102',
  105.     'BR Tiradentes - H/151565-149758',
  106.     'BR Tiradentes - H/151567-149760',
  107.     'BR Tiradentes - H/161295-159385',
  108.     'BR Betancourt - H/138314-137400',
  109.     '8356 - BR Nunez - H/92760-92330',
  110.     'BR Lincoln - H/128091-127751',
  111.     '8370 - BR San Isidro - H/64022-63771',
  112.     'BR Betancourt - H/134089-133192',
  113.     'BR Lincoln - H/143584-143219',
  114.     '8365 - BR Village PC - H/70683-70604',
  115.     'BR Tiradentes - H/155656-153803',
  116.     'BR Tiradentes - H/151561-149754',
  117.     '8357 - BR Bolivar - H/46072-45750',
  118.     'BR Lincoln - H/121057-120764',
  119.     '8370 - BR San Isidro - H/66214-65958',
  120.     'BR Lincoln - H/129886-129541',
  121.     'BR Betancourt - H/142791-141851',
  122.     'BR Tiradentes - H/164234-162301',
  123.     '8370 - BR San Isidro - H/59967-59742',
  124.     'BR Betancourt - H/130404-129538',
  125.     '8368 - BR Galeria 360 - H/120675-120451',
  126.     '8365 - BR Village PC - H/66774-66705',
  127.     '8370 - BR San Isidro - H/58968-58745',
  128.     'BR Tiradentes - H/156617-154742',
  129.     '8370 - BR San Isidro - H/68579-68322',
  130.     'BR Tiradentes - H/154213-152372',
  131.     '8370 - BR San Isidro - H/62803-62556',
  132.     'BR Tiradentes - H/155109-153257',
  133.     '8357 - BR Bolivar - H/44355-44038',
  134.     'BR Lincoln - H/119051-118761',
  135.     '8359 - BR Trinitaria STG - H/77013-76833',
  136.     'BR Lincoln - H/120509-120217',
  137.     '8368 - BR Galeria 360 - H/120205-119981',
  138.     'BR Betancourt - H/147222-146262',
  139.     '8365 - BR Village PC - H/71657-71578',
  140.     'BR Lincoln - H/135179-134827',
  141.     'BR Lincoln - H/121393-121099',
  142.     '8368 - BR Galeria 360 - H/120170-119946',
  143.     'BR Lincoln - H/121395-121101',
  144.     '8370 - BR San Isidro - H/59618-59393',
  145.     'BR Tiradentes - H/152907-151083',
  146.     'BR Betancourt - H/143955-143012',
  147.     '8365 - BR Village PC - H/68738-68666',
  148.     '8370 - BR San Isidro - H/59604-59379',
  149.     '8357 - BR Bolivar - H/47979-47652',
  150.     'BR Betancourt - H/139213-138293',
  151.     'BR Lincoln - H/131756-131409',
  152.     '8370 - BR San Isidro - H/64146-63895',
  153.     'BR Betancourt - H/126955-126104',
  154.     'BR Betancourt - H/148828-147861',
  155.     'BR Tiradentes - H/151571-149764',
  156.     '8357 - BR Bolivar - H/48152-47825',
  157.     '8370 - BR San Isidro - H/64151-63900',
  158.     'BR Tiradentes - H/145288-143576',
  159.     '8370 - BR San Isidro - H/69029-68769',
  160.     'BR Betancourt - H/134090-133193',
  161.     '8370 - BR San Isidro - H/71599-71333',
  162.     'BR Lincoln - H/134346-133995',
  163.     'BR Lincoln - H/121485-121191',
  164.     'BR Betancourt - H/138481-137565',
  165.     '8359 - BR Trinitaria STG - H/81425-81238',
  166.     'BR Betancourt - H/129859-128996',
  167.     '8365 - BR Village PC - H/66487-66419',
  168.     'BR Lincoln - H/121465-121171',
  169.     'BR Tiradentes - H/162448-160532',
  170.     '8370 - BR San Isidro - H/71344-71078',
  171.     '8356 - BR Nunez - H/83218-82835',
  172.     '8357 - BR Bolivar - H/50953-50621',
  173.     '8370 - BR San Isidro - H/61600-61374',
  174.     '8365 - BR Village PC - H/69643-69568',
  175.     'BR Lincoln - H/144387-144021',
  176.     '8365 - BR Village PC - H/61621-61562',
  177.     'BR Betancourt - H/139034-138116',
  178.     '8356 - BR Nunez - H/88886-88478',
  179.     '8370 - BR San Isidro - H/60087-59861',
  180.     '8357 - BR Bolivar - H/49669-49337',
  181.     'BR Betancourt - H/134088-133191',
  182.     '8370 - BR San Isidro - H/66146-65890',
  183.     'BR Tiradentes - H/151585-149778',
  184.     '8359 - BR Trinitaria STG - H/77492-77312',
  185.     '8365 - BR Village PC - H/71551-71472',
  186.     '8357 - BR Bolivar - H/48996-48665',
  187.     '8368 - BR Galeria 360 - H/120495-120271',
  188.     'BR Tiradentes - H/151568-149761',
  189.     'BR Lincoln - H/144532-144166',
  190.     '8370 - BR San Isidro - H/69314-69054',
  191.     '8365 - BR Village PC - H/64312-64248',
  192.     '8370 - BR San Isidro - H/64015-63764',
  193.     'BR Lincoln - H/143043-142679',
  194.     '8368 - BR Galeria 360 - H/117961-117739',
  195.     '8370 - BR San Isidro - H/68467-68210',
  196.     'BR Tiradentes - H/158918-157027',
  197.     'BR Betancourt - H/134102-133205',
  198.     'BR Tiradentes - H/144618-142915',
  199.     '8368 - BR Galeria 360 - H/118652-118430',
  200.     '8368 - BR Galeria 360 - H/118777-118555',
  201.     'BR Lincoln - H/126629-126292',
  202.     '8370 - BR San Isidro - H/59404-59179',
  203.     'BR Tiradentes - H/163574-161646',
  204.     'BR Betancourt - H/139971-139047',
  205.     'BR Betancourt - H/130401-129535',
  206.     '8370 - BR San Isidro - H/71307-71041',
  207.     '8365 - BR Village PC - H/76945-76858',
  208.     '8370 - BR San Isidro - H/61895-61651',
  209.     '8365 - BR Village PC - H/76947-76860',
  210.     'BR Tiradentes - H/155117-153265',
  211.     '8356 - BR Nunez - H/92766-92336',
  212.     '8370 - BR San Isidro - H/68578-68321',
  213.     'BR Tiradentes - H/158561-156672',
  214.     'BR Lincoln - H/135165-134813',
  215.     'BR Tiradentes - H/151581-149774',
  216.     'BR Lincoln - H/134962-134610',
  217.     'BR Lincoln - H/144526-144160',
  218.     'BR Lincoln - H/121056-120763',
  219.     '8365 - BR Village PC - H/74799-74717',
  220.     'BR Lincoln - H/136582-136226',
  221.     'BR Betancourt - H/140546-139620',
  222.     '8370 - BR San Isidro - H/70875-70610',
  223.     'BR Betancourt - H/129855-128992',
  224.     '8356 - BR Nunez - H/88860-88452',
  225.     'BR Tiradentes - H/158917-157026',
  226.     '8368 - BR Galeria 360 - H/117845-117623',
  227.     '8357 - BR Bolivar - H/50785-50453',
  228.     'BR Tiradentes - H/163535-161609',
  229.     '8356 - BR Nunez - H/92558-92131',
  230.     'BR Lincoln - H/122301-122005',
  231.     '8357 - BR Bolivar - H/49715-49383',
  232.     'BR Betancourt - H/146772-145816',
  233.     'BR Tiradentes - H/151587-149780',
  234.     '8370 - BR San Isidro - H/68581-68324',
  235.     'BR Lincoln - H/144528-144162',
  236.     'BR Lincoln - H/122272-121976',
  237.     '8356 - BR Nunez - H/92535-92109',
  238.     '8359 - BR Trinitaria STG - H/81441-81254',
  239.     'BR Tiradentes - H/160033-158131',
  240.     'BR Lincoln - H/121052-120759',
  241.     'BR Tiradentes - H/145810-144094',
  242.     'BR Lincoln - H/121451-121157',
  243.     'BR Lincoln - H/130119-129774',
  244.     '8365 - BR Village PC - H/68880-68807',
  245.     '8368 - BR Galeria 360 - H/118725-118503',
  246.     '8357 - BR Bolivar - H/55030-54689',
  247.     'BR Tiradentes - H/163596-161668',
  248.     'BR Tiradentes - H/155840-153987',
  249.     'BR Betancourt - H/139035-138117',
  250.     'BR Betancourt - H/137031-136122',
  251.     'BR Lincoln - H/138396-138039',
  252.     'BR Lincoln - H/121479-121185',
  253.     'BR Tiradentes - H/149501-147722',
  254.     '8365 - BR Village PC - H/76946-76859',
  255.     '8365 - BR Village PC - H/69644-69569',
  256.     '8357 - BR Bolivar - H/49279-48948',
  257.     'BR Lincoln - H/121054-120761',
  258.     'BR Tiradentes - H/156620-154745',
  259.     'BR Lincoln - H/128090-127750',
  260.     'BR Betancourt - H/141941-141007',
  261.     'BR Betancourt - H/146087-145139',
  262.     '8365 - BR Village PC - H/68743-68671',
  263.     'BR Lincoln - H/121399-121105',
  264.     '8356 - BR Nunez - H/88880-88472',
  265.     '8370 - BR San Isidro - H/69028-68768',
  266.     '8356 - BR Nunez - H/92767-92337',
  267.     '8368 - BR Galeria 360 - H/105934-105720',
  268.     'BR Betancourt - H/129121-128260',
  269.     'BR Tiradentes - H/155113-153261',
  270.     '8370 - BR San Isidro - H/70179-69914',
  271.     '8370 - BR San Isidro - H/67228-66972',
  272.     '8368 - BR Galeria 360 - H/117793-117571',
  273.     'BR Tiradentes - H/163584-161656',
  274.     'BR Lincoln - H/142890-142526',
  275.     'BR Lincoln - H/144531-144165',
  276.     'BR Tiradentes - H/157339-155461',
  277.     '8368 - BR Galeria 360 - H/120283-120059',
  278.     'BR Lincoln - H/128114-127774',
  279.     'BR Lincoln - H/141452-141090',
  280.     'BR Lincoln - H/122254-121958',
  281.     'BR Betancourt - H/147986-147022',
  282.     'BR Lincoln - H/119040-118750',
  283.     '8370 - BR San Isidro - H/64780-64528',
  284.     'BR Lincoln - H/144525-144159',
  285.     '8370 - BR San Isidro - H/68832-68573',
  286.     'BR Betancourt - H/139966-139042',
  287.     '8370 - BR San Isidro - H/65398-65143',
  288.     '8357 - BR Bolivar - H/50062-49730',
  289.     '8368 - BR Galeria 360 - H/118270-118048',
  290.     '8359 - BR Trinitaria STG - H/81424-81237',
  291.     'BR Lincoln - H/144543-144177',
  292.     'BR Tiradentes - H/158919-157028',
  293.     '8370 - BR San Isidro - H/69789-69526',
  294.     'BR Tiradentes - H/154357-152514',
  295.     '8368 - BR Galeria 360 - H/120288-120064',
  296.     '8365 - BR Village PC - H/72381-72302',
  297.     'BR Tiradentes - H/160039-158137',
  298.     '8370 - BR San Isidro - H/69317-69057',
  299.     'BR Betancourt - H/142775-141835',
  300.     '8357 - BR Bolivar - H/54079-53738',
  301.     '8370 - BR San Isidro - H/69790-69527',
  302.     'BR Tiradentes - H/154933-153082',
  303.     '8370 - BR San Isidro - H/71297-71031',
  304.     'BR Lincoln - H/142895-142531',
  305.     '8370 - BR San Isidro - H/69031-68771',
  306.     'BR Tiradentes - H/152762-150939',
  307.     '8370 - BR San Isidro - H/62797-62550',
  308.     'BR Tiradentes - H/161296-159386',
  309.     '8368 - BR Galeria 360 - H/105909-105695',
  310.     '8357 - BR Bolivar - H/55019-54678',
  311.     'BR Lincoln - H/121059-120766',
  312.     '8356 - BR Nunez - H/88876-88468',
  313.     'BR Lincoln - H/121058-120765',
  314.     '8370 - BR San Isidro - H/69796-69533',
  315.     '8370 - BR San Isidro - H/71289-71023',
  316.     '8356 - BR Nunez - H/88912-88504',
  317.     'BR Lincoln - H/122316-122020',
  318.     'BR Tiradentes - H/140958-139309',
  319.     'BR Lincoln - H/128136-127796',
  320.     '8370 - BR San Isidro - H/69518-69257',
  321.     '8368 - BR Galeria 360 - H/118787-118565',
  322.     'BR Lincoln - H/120575-120283',
  323.     '8359 - BR Trinitaria STG - H/80675-80488',
  324.     '8357 - BR Bolivar - H/54509-54168',
  325.     '8368 - BR Galeria 360 - H/118737-118515',
  326.     'BR Tiradentes - H/151583-149776',
  327.     '8370 - BR San Isidro - H/68568-68311',
  328.     '8370 - BR San Isidro - H/60092-59866',
  329.     'BR Betancourt - H/139939-139015',
  330.     '8370 - BR San Isidro - H/58967-58744',
  331.     'BR Tiradentes - H/161297-159387',
  332.     'BR Tiradentes - H/163526-161600',
  333.     '8356 - BR Nunez - H/92772-92341',
  334.     '8370 - BR San Isidro - H/64150-63899',
  335.     '8370 - BR San Isidro - H/65837-65582',
  336.     'BR Tiradentes - H/157347-155469',
  337.     'BR Lincoln - H/121397-121103',
  338.     'BR Tiradentes - H/151570-149763',
  339.     'BR Lincoln - H/121486-121192',
  340.     'BR Tiradentes - H/158715-156825',
  341.     'BR Lincoln - H/142692-142328',
  342.     'BR Tiradentes - H/158049-156162',
  343.     '8368 - BR Galeria 360 - H/118006-117784',
  344.     'BR Lincoln - H/120560-120268',
  345.     '8359 - BR Trinitaria STG - H/83624-83437',
  346.     'BR Betancourt - H/140550-139624',
  347.     'BR Tiradentes - H/155110-153258',
  348.     '8356 - BR Nunez - H/92525-92099',
  349.     '8357 - BR Bolivar - H/48157-47830',
  350.     'BR Lincoln - H/120547-120255',
  351.     '8359 - BR Trinitaria STG - H/92746-92544',
  352.     'BR Tiradentes - H/162929-161010',
  353.     'BR Lincoln - H/142876-142512',
  354.     '8368 - BR Galeria 360 - H/120465-120241',
  355.     '8356 - BR Nunez - H/92514-92088',
  356.     'BR Betancourt - H/139744-138822',
  357.     '8368 - BR Galeria 360 - H/118765-118543',
  358.     'BR Lincoln - H/134345-133994',
  359.     'BR Lincoln - H/128116-127776',
  360.     '8357 - BR Bolivar - H/50476-50144',
  361.     '8370 - BR San Isidro - H/68465-68208',
  362.     'BR Lincoln - H/128120-127780',
  363.     '8356 - BR Nunez - H/92547-92120',
  364.     '8365 - BR Village PC - H/70782-70703',
  365.     '8356 - BR Nunez - H/88857-88449',
  366.     'BR Tiradentes - H/155945-154087',
  367.     '8370 - BR San Isidro - H/61384-61158',
  368.     '8365 - BR Village PC - H/62923-62860',
  369.     '8359 - BR Trinitaria STG - H/81431-81244',
  370.     '8365 - BR Village PC - H/68747-68675',
  371.     'BR Lincoln - H/121055-120762',
  372.     'BR Lincoln - H/144542-144176',
  373.     'BR Tiradentes - H/153594-151760',
  374.     'BR Lincoln - H/120520-120228',
  375.     'BR Lincoln - H/121484-121190',
  376.     'BR Lincoln - H/119055-118765',
  377.     'BR Lincoln - H/133515-133166',
  378.     'BR Betancourt - H/139958-139034',
  379.     'BR Betancourt - H/134752-133853',
  380.     'BR Lincoln - H/121497-121203',
  381.     'BR Betancourt - H/135460-134559',
  382.     'BR Lincoln - H/120589-120297',
  383.     'BR Betancourt - H/139375-138454',
  384.     'BR Tiradentes - H/163556-161629',
  385.     'BR Lincoln - H/121415-121121',
  386.     '8357 - BR Bolivar - H/50066-49734',
  387.     'BR Tiradentes - H/140227-138584',
  388.     '8370 - BR San Isidro - H/70597-70332',
  389.     'BR Betancourt - H/144135-143192',
  390.     'BR Tiradentes - H/145294-143582',
  391.     '8370 - BR San Isidro - H/69030-68770',
  392.     'BR Lincoln - H/140717-140356',
  393.     '8370 - BR San Isidro - H/70978-70713',
  394.     'BR Tiradentes - H/154362-152519',
  395.     '8368 - BR Galeria 360 - H/107800-107584',
  396.     '8365 - BR Village PC - H/74010-73929',
  397.     '8357 - BR Bolivar - H/47344-47020',
  398.     'BR Tiradentes - H/151119-149317',
  399.     'BR Lincoln - H/122291-121995',
  400.     '8356 - BR Nunez - H/88858-88450',
  401.     '8357 - BR Bolivar - H/54864-54523',
  402.     'BR Lincoln - H/121053-120760',
  403.     'BR Betancourt - H/133356-132466',
  404.     '8357 - BR Bolivar - H/50948-50616',
  405.     '8370 - BR San Isidro - H/64147-63896',
  406.     'BR Lincoln - H/134968-134616',
  407.     'BR Betancourt - H/136856-135947',
  408.     'BR Betancourt - H/141063-140136',
  409.     'BR Tiradentes - H/162436-160520',
  410.     '8365 - BR Village PC - H/64736-64672',
  411.     '8370 - BR San Isidro - H/71351-71085',
  412.     'BR Lincoln - H/121060-120767',
  413.     'BR Lincoln - H/128115-127775',
  414.     '8359 - BR Trinitaria STG - H/90105-89907',
  415.     'BR Lincoln - H/140719-140358',
  416.     '8359 - BR Trinitaria STG - H/87173-86985',
  417.     'BR Lincoln - H/129894-129549',
  418.     'BR Betancourt - H/134070-133173',
  419.     'BR Tiradentes - H/158048-156161',
  420.     '8357 - BR Bolivar - H/48079-47752',
  421.     'BR Tiradentes - H/151595-149788',
  422.     '8368 - BR Galeria 360 - H/118554-118332',
  423.     '8368 - BR Galeria 360 - H/117990-117768',
  424.     'BR Lincoln - H/142887-142523',
  425.     'BR Lincoln - H/143590-143225',
  426.     '8365 - BR Village PC - H/71545-71466',
  427.     'BR Betancourt - H/139960-139036',
  428.     '8370 - BR San Isidro - H/64149-63898',
  429.     'BR Lincoln - H/119054-118764',
  430.     'BR Lincoln - H/120534-120242',
  431.     'BR Tiradentes - H/152910-151086',
  432.     'BR Tiradentes - H/154561-152715',
  433.     'BR Betancourt - H/136309-135403',
  434.     'BR Tiradentes - H/164227-162294',
  435.     'BR Betancourt - H/136312-135406',
  436.     'BR Betancourt - H/138213-137299',
  437.     'BR Betancourt - H/139964-139040',
  438.     '8370 - BR San Isidro - H/64026-63775',
  439.     'BR Betancourt - H/146090-145142',
  440.     '8359 - BR Trinitaria STG - H/92744-92542',
  441.     '8370 - BR San Isidro - H/71314-71048',
  442.     'BR Tiradentes - H/158043-156156',
  443.     'BR Betancourt - H/146767-145811',
  444.     'BR Betancourt - H/144136-143193',
  445.     '8370 - BR San Isidro - H/71337-71071',
  446.     'BR Lincoln - H/122327-122031',
  447.     '8356 - BR Nunez - H/75534-75183',
  448.     'BR Tiradentes - H/162631-160714',
  449.     '8357 - BR Bolivar - H/44747-44430',
  450.     '8368 - BR Galeria 360 - H/120676-120452',
  451.     '8368 - BR Galeria 360 - H/118728-118506',
  452.     'BR Tiradentes - H/154932-153081',
  453.     '8370 - BR San Isidro - H/63203-62956',
  454.     'BR Lincoln - H/120508-120216',
  455.     '8370 - BR San Isidro - H/58966-58743',
  456.     'BR Betancourt - H/140551-139625',
  457.     'BR Tiradentes - H/151582-149775',
  458.     '8370 - BR San Isidro - H/66312-66056',
  459.     '8368 - BR Galeria 360 - H/118213-117991',
  460.     'BR Lincoln - H/137641-137284',
  461.     '8368 - BR Galeria 360 - H/120672-120448',
  462.     'BR Tiradentes - H/151580-149773'
  463.  ]
  464.  
  465. # 3. execute script for duplicated invoices
  466. imports = ypos_reimport[200:300]
  467. for ypos_import in imports:
  468.     invoice_import = frappe.get_doc("YPOS Invoice Import", ypos_import)
  469.     invoice_import.reimport_invoice()
  470.     invoice_import.import_invoice()
  471.  
  472.  
  473. error_ypos = ['BR Lincoln - H/122327-122031',
  474.  '8356 - BR Nunez - H/75534-75183',
  475.  'BR Tiradentes - H/162631-160714',
  476.  '8357 - BR Bolivar - H/44747-44430',
  477.  '8368 - BR Galeria 360 - H/120676-120452',
  478.  '8368 - BR Galeria 360 - H/118728-118506',
  479.  'BR Tiradentes - H/154932-153081',
  480.  '8370 - BR San Isidro - H/63203-62956',
  481.  'BR Lincoln - H/120508-120216',
  482.  '8370 - BR San Isidro - H/58966-58743',
  483.  'BR Betancourt - H/140551-139625',
  484.  'BR Tiradentes - H/151582-149775',
  485.  '8370 - BR San Isidro - H/66312-66056',
  486.  '8368 - BR Galeria 360 - H/118213-117991',
  487.  'BR Lincoln - H/137641-137284',
  488.  '8368 - BR Galeria 360 - H/120672-120448',
  489.  'BR Tiradentes - H/151580-149773']
  490.  
  491. filters = {
  492.     "ypos_invoice_import": ["in", error_ypos],
  493.     "status": "Paid"
  494. }
  495. sale_invoices = frappe.get_list("Sales Invoice", filters, ["name", "ncf", "ypos_invoice_import", "posting_date", "grand_total", "status"])
  496. ypos_invoices = {}
  497. for invoice in sale_invoices:
  498.     if invoice["ypos_invoice_import"] not in ypos_invoices:
  499.         ypos_invoices[invoice["ypos_invoice_import"]] = [invoice]
  500.     else:
  501.         ypos_invoices[invoice["ypos_invoice_import"]].append(invoice)
  502.  
  503. single_invoice_ypos = []
  504. double_invoice_ypos = []
  505. invoices2cancel = []
  506.  
  507. for k, v in ypos_invoices.items():
  508.     if (
  509.         len(v) == 2
  510.         and v[0]["ncf"] == v[1]["ncf"]
  511.         and v[0]["posting_date"] == v[1]["posting_date"]
  512.         and v[0]["grand_total"] == v[1]["grand_total"]
  513.     ):
  514.         double_invoice_ypos.append(k)
  515.         invoices2cancel.append(v[1]["name"])
  516.     else:
  517.         single_invoice_ypos.append(k)
  518.  
  519. single_invoice_ypos = set(single_invoice_ypos)
  520. double_invoice_ypos = set(double_invoice_ypos)
  521. invoices2cancel = set(invoices2cancel)
  522.  
  523. double_invoice_ypos = {
  524.     '8356 - BR Nunez - H/75534-75183',
  525.     '8356 - BR Nunez - H/88858-88450',
  526.     '8357 - BR Bolivar - H/44747-44430',
  527.     '8357 - BR Bolivar - H/50948-50616',
  528.     '8357 - BR Bolivar - H/54079-53738',
  529.     '8357 - BR Bolivar - H/54509-54168',
  530.     '8357 - BR Bolivar - H/54864-54523',
  531.     '8359 - BR Trinitaria STG - H/80675-80488',
  532.     '8365 - BR Village PC - H/64736-64672',
  533.     '8368 - BR Galeria 360 - H/118737-118515',
  534.     '8368 - BR Galeria 360 - H/120672-120448',
  535.     '8370 - BR San Isidro - H/58966-58743',
  536.     '8370 - BR San Isidro - H/60092-59866',
  537.     '8370 - BR San Isidro - H/63203-62956',
  538.     '8370 - BR San Isidro - H/64026-63775',
  539.     '8370 - BR San Isidro - H/64147-63896',
  540.     '8370 - BR San Isidro - H/64149-63898',
  541.     '8370 - BR San Isidro - H/68568-68311',
  542.     '8370 - BR San Isidro - H/71351-71085',
  543.     'BR Betancourt - H/133356-132466',
  544.     'BR Betancourt - H/141063-140136',
  545.     'BR Lincoln - H/119054-118764',
  546.     'BR Lincoln - H/120508-120216',
  547.     'BR Lincoln - H/120534-120242',
  548.     'BR Lincoln - H/121053-120760',
  549.     'BR Lincoln - H/121060-120767',
  550.     'BR Lincoln - H/122291-121995',
  551.     'BR Lincoln - H/122327-122031',
  552.     'BR Lincoln - H/128120-127780',
  553.     'BR Lincoln - H/134968-134616',
  554.     'BR Lincoln - H/137641-137284',
  555.     'BR Tiradentes - H/151580-149773',
  556.     'BR Tiradentes - H/151583-149776',
  557.     'BR Tiradentes - H/161297-159387',
  558.     'BR Tiradentes - H/162436-160520'
  559.  }
  560.  
  561. for name in invoices2cancel:
  562.     invoice = frappe.get_doc("Sales Invoice", name)
  563.     invoice.cancel()
  564.  
  565. still_duplicated = ['BR Tiradentes - H/145294-143582', 'BR Betancourt - H/135460-134559']
  566.  
Add Comment
Please, Sign In to add comment