Multiple Tax to External Supplier Invoices

Hi

Does your import go via the External File Template process?

If so you might want to look at using the STDSIN1 template which allows you to have multiple tax rows in the invoice data. 

Hi, 

I tested this long ago.  

Your getting the ? tax code because I assume you have no tax in your file.  

Using external supplier invoice and a template (any form of template) - your data must support multiple tax rows.  The following is a sample using an older IFS template, Note the tax lines section.  You need to report the row numbers in the tax.  The tax is then also connected to an invoice line.  You can see the tax lines 1 and 2.   

Compare this to STDSIN1.  

H;163142VAT;10008153;2010-12-16;EXTINV;2010-12-16;2010-12-23;0;EUR;1;;;;1;;;;;;;;;;;;;;;;;;;;;;;;;;;
I;10008153;1;MGV;100;100;30;30;;;
T;10008153;1;1;;20;20;MGV;
T;10008153;1;2;;10;10;MGS;
P;10008153;1;6;4000;;;;;;;;;;;-100;-100;;;;;

I would believe you could also start with other templates like STDSIN2, The important part is that your data / template includes records for both (or more) tax codes.  

This is another example with different invoice lines and postings. 

Assume the invoice has tax and no tax.  In this you can see that the tax lines are connected to the taxable invoice line (1). The no tax invoice line was line (0). 

The posting lines are connected to invoice line 0 AND invoice line 1

H;163142VAT;35137152;2004-12-16;EXTINV;2004-12-16;2004-12-23;57;EUR;1;;;;1;;;;;;;;;;;;;;;;;;;;;;;;;;;
I;35137152;0;N;223.01;223.01;;;;;
I;35137152;1;1;100;100;30;30;;;
T;35137152;1;1;;20;20;MGV;
T;35137152;1;2;;10;10;MGS;
P;35137152;0;1;41101;1010;1000;;;;;;;;;-213.51;-213.51;;;;;
P;35137152;0;2;44101;1010;1000;;;;;;;;;-5.23;-5.23;;;;;
P;35137152;0;3;45401;1010;1000;;;;;;;;;-4.27;-4.27;;;;;
P;35137152;0;4;51101;2010;1000;;;;;;;;;112.41;112.41;;;;;
P;35137152;0;5;13103;1010;1000;;;;;;;;;-112.41;-112.41;;;;;
P;35137152;1;6;13103;1010;1000;;;;;;;;;-100;-100;;;;;

Best regards, 

Thomas

Hi,

thanks for your resopnse.

So we do not use STDSIN1 template. We have an external scan program (Kofax - Readsoft).

The invoices will be uploaded by SUPPEXT automatically from a transfer folder. And we are looking for a  correct XML invoice format for multiple tax or not tax, because the tax comes from the purchase orders.

Best regards,

Linda

Dear Linda, 

I am struggling with the same issue. 

I have build up e.g. two rows for one invoice:

-<InvoiceRow>

<RowSubIdentifier>1</RowSubIdentifier>

<RowNormalProposedAccountIdentifier>44016</RowNormalProposedAccountIdentifier>

<RowAccountDimensionText>1001;;;;;</RowAccountDimensionText>

<RowVatRatePercent>19,00</RowVatRatePercent>

<RowVatAmount AmountCurrencyIdentifier="EUR">75,49</RowVatAmount>

<RowVatExcludedAmount AmountCurrencyIdentifier="EUR"/>

<RowAmount AmountCurrencyIdentifier="EUR">397,30</RowAmount>

</InvoiceRow>

-<InvoiceRow>

<RowSubIdentifier>2</RowSubIdentifier>

<RowNormalProposedAccountIdentifier>46108</RowNormalProposedAccountIdentifier>

<RowAccountDimensionText>0021;;;;;</RowAccountDimensionText>

<RowVatRatePercent>7,00</RowVatRatePercent>

<RowVatAmount AmountCurrencyIdentifier="EUR">28,00</RowVatAmount>

<RowVatExcludedAmount AmountCurrencyIdentifier="EUR"/>

<RowAmount AmountCurrencyIdentifier="EUR">400,00</RowAmount>

</InvoiceRow>

There is an overal section in IFS to tag the possibility for more tax keys. Have not found yet. 

Hope this helps.

Best, 

Juko

Dear Lina, 

there is an option in _External Supplier Invoice Tax Codes_

This enables all suppliers. 

I have tagged the information in the interface with two different kind of position rows and with two different kind of tax codes. 

Altough, IFS is not taking the standard tax code from your supplier, you can handover the tax code in the XML. If you do not tag in the XML your tax code option, IFS will take the standard tax code from your supplier. 

Hope that helps. 

Best, 

Juko