Tax Amount not added to Invoice amount for FBDI import in case supplier is tax inclusive
we are trying to import invoices through FBDI. Supplier is set up to be tax inclusive with 'Set Invoice Values as Tax Inclusive' =YES.
On the FBDI, we put CALCULATE TAX DURING IMPORT=Y and ADD TAX TO INVOICE AMOUNT=Y since we want calculated tax amount to be added to Invoice Amount and also to Line Amount.
What we load:
Expected result in Payables should be (let's say tax is 20%)
LINE AMOUNT=120 (inclusive of tax)
LINE AMOUNT=100 (inclusive of tax 16.67)
Is there a way to achieve this through FBDI import? I think problem is that it is not possible to add Tax Amount to Line