Invalid Liability - Liability account is invalid

Payables Import Program

Check Liability account  setup in AP System Parameters.

select AP.ACCTS_PAY_CODE_COMBINATION_ID
from AP_SYSTEM_PARAMETERS_ALL AP
where org_id = &org_id 

OR

The liability account is setup in Payables however the value in the system tables is -1.

• Responsibility: Payables
• Navigation: Setup > Option > Financials
• Setup the first field :  Liability
• The Liability account is well setup

SQL statement returns the value -1.

solution

If the statement reruns 0 rows then configure liability account 

If the statement reruns -1

1. Change Liability field to temporary value
• Responsibility: Payables
• Navigation: Setup > Option > Financials
• Setup the first field : Liability with a different value 
• Save
2. Change Liability field to correct value
• Responsibility: Payables
• Navigation: Setup > Option > Financials
• Setup the first field : Liability with the correct value 
• Save

  

Run the SQL again and ensure a row is returned with the correct value.

To process  current data in in AP_INVOICES_INTERFACE table you may need to update ACCTS_PAY_CODE_COMBINATION_ID to the right value insteadof the currrent one (-1) .