There are two reasons that you may see a pending invoice error.
There are purchase orders with zero duration.
There's an apostrophe in the invoice number field, for example St Anne's123.
Error message
Object: Hounslow
Procedure: Function: PendingInvoiceCreateRecordsForClient
Number: Parameters:
Description: @idClient: [clientID] @idPeriod: [periodID] @vcInvoiceNumber: [invoicenumber]
Zero duraction
You may receive a pending invoice error when the pending invoice generates for a client that have purchase orders with a duration value of zero.
To fix this error, your Local Authority needs to amend the purchase orders with zero per week durations to actually have a duration value.
Apostrophe in the invoice number
You can also receive this error where there's an apostrophe in the invoice number.
To fix this, simply remove the apostrophe and run the period again.