Payables Import changing item and tax amount in distributions
I am trying to import invoices with multiple lines with some lines that have taxes already calculated. In order to get them to import I am following the use case below:
Column Line 1 Line 2 Line 3 Line 4
Line Type ITEM ITEM TAX TAX
Amount 100 50 10 5
Line Group 1 2 1 2
Prorate Y Y Y Y
Tax Regime A A
Tax B B
Tax Status C C
Tax Rate D D
But it is creating distributions like below:
Line 1 Dist 1 Item 95
Line 1 Dist 2 Recoverable Tax 15
Line 2 Dist 1 Item 47
Line 2 Dist 2 Recoverable Tax 3
How do I get the import to keep the amounts in the distributions as entered in the interface table and not change them?