How to fetch IRN for invoices after migrating to ERPNext

Frz · October 4, 2023, 8:59am

@Smit_Vora
Hi
we are migrating from our legacy software to ERPNext
but wanted to check how to update the IRN & E-way bill numbers for invoices already made
it would be a tedious affair if we have to manually update them
Regards
Frz

snv · October 4, 2023, 12:13pm

Hi,

You can update the IRN and e-Waybill No. while importing your old Sales Invoices using Data Import Tool, since these fields are present in the Sales Invoice.

However, if you’re looking to print these e-Waybills / e-Invoices in ERPNext, you may need to import e-Waybill Logs and e-Invoice Logs as appropriate.

Frz · October 5, 2023, 9:52am

import e-Waybill Logs and e-Invoice Logs as appropriate…
so this would be possible with India compliance?
Thanks

snv · October 9, 2023, 2:06pm

If you have all the data, it should be possible.

For instance, we wrote this patch to migrate the erstwhile E Invoice Request Log to e-Invoice Log in the early days of India Compliance:

github.com

resilient-tech/india-compliance/blob/9c987b676e6515de823a2259d520c8d66512a161/india_compliance/patches/post_install/update_e_invoice_fields_and_logs.py#L138


      
                          doc.signed_einvoice,
                          doc.signed_qr_code,
                      ]
                  )
          
          
    frappe.db.bulk_insert(
                  "e-Invoice Log", fields=fields, values=values, ignore_duplicates=True
              )
          
          

          
def migrate_e_invoice_request_log():
              if not frappe.db.table_exists("E Invoice Request Log"):
                  return
          
          
    if frappe.db.exists(
                  "Integration Request",
                  {"integration_request_service": "Migrated from e-Invoice Request Log"},
              ):
                  return
          
          
    # Using db.get_values instead of get_all to avoid retrieving meta,

Frz · October 12, 2023, 6:18am

Thank you