Tax Amount not added to Invoice amount for FBDI import in case supplier is tax inclusive
Hi everyone,
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:
INVOICE AMOUNT=100
LINE AMOUNT=100
Expected result in Payables should be (let's say tax is 20%)
INVOICE AMOUNT=120
LINE AMOUNT=120 (inclusive of tax)
Actual result
INVOICE AMOUNT=100
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
Tagged:
0