Question on how Oracle sends data to Vertex engine.

Hi,

When we create a single line invoice in AR, it creates 3 lines in ra_customer_trx_lines_All, one for each State/County/City tax with line_type as 'TAX'. This is fine.

When I check the same invoice in Vertex schema, I see three lines. Two lines with positive gross amounts and one with negative gross amount. netting to positive balance on Invoice.

This is causing us some TOTAL mismatch issues with Vertex and Oracle, when credit invoices.

The question is, Why Oracle is creating 3 lines in Vertex, instead of just one.

Iworked with Vertex tech support on this and he says, Oracle is supposed to send only one line.