Skip to main content

Hello, we are receiving the following error trying to close out some of our sales orders. Can you explain what the attached error indicates or what we can do to resolve? 

 

HI Leann,

It means none of the sales order lines are ready for billing per the selection criteria.

For example, when you define a sales order, you indicate whether the sales order is invoiced on shipping or on installation (in case of STSI installs).

Also in the sales billing batch, in the upper left of the criteria you have options what you might be billing, Perhaps try ALL instead of Ship:

 

Finally, if you are running a scheduled batch job and this is where you get the message executing a scheduled job, please review the criteria in the batch job and check if there are any records matching the parameters in the batch job? Important is invoice_subtype (S = Ship, etc.)

 

 


Another possibility, there was an issue during a previous billing run and the records are flagged as already in billing process.  You would have to review at the database level in the order_line table to see if bill_locked dates are applied or not.  If this was not released, they would not be picked up for billing.

 


Another possibility, there was an issue during a previous billing run and the records are flagged as already in billing process.  You would have to review at the database level in the order_line table to see if bill_locked dates are applied or not.  If this was not released, they would not be picked up for billing.

 

This could be the case. We’ve seen this before and had to unlock the records for billing by updating the bill_locked_by and bill_locked_at values to NULL on the order_line record for the specific records.  I’d suggest opening a support case so that we can review this.


Reply