• From: India, Kochi
  • Registered: 01/19/2018
  • Posts: 6

Topic: Thousands of sales order need to be converted to invoice

hi, we had an local event for which we used frontaccounting, however due to suppliers not providing actual invoices initially, we opted to bill using salesorder , now we have around 5,000 sales orders to be converted to invoice. which is a huge task considering we have to convert each one by one,

IS THERE ANY WAY TO CONVERT MULTIPLE SALES ORDERS TO SINGLE DELIVER ? as we can have multiple delivery notes to invoice ?

Look forward for any of your help

Regads

Roshan

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,093

Re: Thousands of sales order need to be converted to invoice

Check for an sql method to auto convert. Take an sql backup, then convert one sales order to a delivery, now take another sql backup, compare the 2 sql backups and see what INSERT, UPDATE differences exist and check what info was passed on (each order may have different line items) and then prepare the new sql statements in an excel / sql query and run it in one shot. Take backup before any changes.

Post a bounty offer in the Job board if you are not upto doing it yourself.

apmuthu's Website