How to fix error "Populate either tax_rate_id or tax_rate_code to create a valid tax line"?
Hi,
Autoinvoice Import Program out file showed three invoices with error:
“The system cannot calculate the taxable basis for the imported tax line because the tax rate is 0 but the tax amount is not 0. Please change either the tax rate or the tax amount”
Customer said that source system has sent these invoices with incorrect tax code M0 and we were asked to update it to M255 so we did using this update:
Update AR.RA_INTERFACE_LINES_ALL Set VAT_TAX_ID = 12073, TAX_STATUS_CODE = 'M255', TAX_RATE_CODE = 'M255' where interface_line_attribute1 in(6780656, 6780658, 10056385);
After this update we got error with TAX lines: