ZX_TAX_MULTIALLOC_TO_SAMELN Error during Payables Invoice Import

If there are multiple tax lines entered in the ap_invoice_lines_interface table with different tax regime information, and there are multiple item lines, then the following columns must be populated correctly in the ap_invoice_lines_interface table.

line_number
line_type_lookup_code
amount
line_group_number
prorate_across_flag
tax_regime_code
tax
tax_status_code
tax_rate_code
dist_code_combination_id

Column	Item_line 1	Item_line 2	Tax_line 1	Tax_line 2
line_number	1	2	3	4
line_type_lookup_code	ITEM	ITEM	TAX	TAX
amount	10	5	3	2
line_group_number	1	2	1	2
prorate_across_flag	null	null	Y	Y
tax_regime_code	null	null	P	A
tax	null	null	Q	B
tax_status_code	null	null	R	C
tax_rate_code	null	null	S	D
dist_code_combination_id	1234	12345	null	null

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) .