You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Tax Amount not added to Invoice amount for FBDI import in case supplier is tax inclusive

Question
1
Views
0
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!