From time to time users of our Google Sheets invoicing add-on may experience the issue of the spreadsheet ceasing to generate an order ID when trying to create a new invoice. Not to worry, there's a simple action to get the function working and continue creating invoices on the existing spreadsheet.
Fill out your invoice cells (payer email, invoice ID, item label, item amount)
Click on the Payable Order ID cell of the last successfully generated order ID, and drag the blue dot in the bottom right corner of the cell down to generate a Payable ID
That's it!
Video Tutorial