DTW - Defined Tax Amount in AP Invoice import not showing

[Private_Member_370152]

DocNum

ItemCode

ItemCode

ItemDescription

Price

Quantity

VatGroup

ProjectCode

DocNum	ItemCode	ItemCode	ItemDescription	Price	Quantity	VatGroup	ProjectCode	TaxTotal
DocNum	ItemCode	ItemCode	Dscription	Price	Quantity	VatGroup	Project	VatSum
1	6-1650	TELEPHONE CHARGES	A/C : 13472012	699.08	1	TX7		48.93

TaxTotal


DocNum
ItemCode
ItemCode
Dscription
Price
Quantity
VatGroup
Project
VatSum


1
6-1650
TELEPHONE CHARGES
A/C : 13472012
699.08
1
TX7

48.93

[Private_Member_370152]

Hi,

(So sorry there was some problem with my original post)

I'm trying to do an import using Data Transfer Workbench for AP
Invoice.

I'm trying to key in my own tax value of $48.93.

Note that the actual tax value should be 699.08 x 0.07 =
48.9356, which is rounded off to 48.94

These are my templates:

OPCH

PCH1

However, when I import it in, my tax value is 49.94 instead of
48.93. It is still taking the tax value based on my tax group "TX7".

Could anyone help to identify what is wrong?

Thanks.

Ivan

[KennedyT21]

Hi Ivan

Try With Tax Type

Description: Tax Type

Type: enum

Valid Values: tt_Yes,tt_No,tt_UseTax

Regards

Kennedy

[Private_Member_370152]

Hi Kennedy,

I've tried tt_Yes and tt_No but result is the same

As for tt_UseTax, they gave an error.

Ivan

[KennedyT21]

Hi Ivan,

Try to dtw without Passing the Tax amount.

Regards

Kennedy

[Private_Member_370152]

Hi Kennedy,

Actually I need the Tax amount.

Cos the tax amount I want input into the system is different from the system calculated tax amount.

Ivan

[KennedyT21]

How It Is possible, Am Not sure that we can change the tax amount from the system calculated.

Regards

Kennedy

[Private_Member_370152]

Hi Kennedy,

I know in SAP screen I can change the tax amount, by keying in the "Tax Amount (LC)" column below.

It will change my tax amount.

However I don't know how to do this in DTW.

Ivan