INP004 error - no invoice tax jurisdiction rows

Issue/Symptom/Question

When running the Complete Invoice Processing for the job, I get the following error:

Error text:  

  • INP004  Function summarize_tax_line_item()
  • pr ###### seq ### has no invoice_tax_juris rows.

Applies To

Billing & Accounts Receivable > Automated Invoice Processing > Adjust Invoice Amounts

Billing & Accounts Receivable > Automated Invoice Processing > Complete Invoice Processing

Project Management > Owner Contract Information > Contract Information / Cost Plus Line Items

Resolution/Fix/Answer

You will not be able to correct this error when it occurs - you will need to set up a ticket and submit it to Penta Support, including the cycle and through date of the process with the error.

However, for future reference, here is the underlying cause, and the correct setup to avoid the error:

The issue with this error, was that the User's manual tax adjustment made to the invoice line item was marked as a job distribution instead of a tax distribution... causing an extra (taxable) row in the work table for the tax line created by the adjustment.   
The entry was an adjustment subtracting a penny from the amount Penta calculated (because of rounding), but was marked as a JOB distribution rather than a TAX distribution type.  This caused Penta to create a second row in the work table for a tax line (created for the job distribution automatically) but there was no tax jurisdiction row created offsetting the penny.  

So, to avoid this type of automatic additional tax calculation, the initial adjustment will need to be made to a tax row (with a Cost Plus contract Line Item Type Code = T), rather than a job cost row. Â