Question

Multiple Tax to External Supplier Invoices

  • 11 October 2021
  • 5 replies
  • 401 views
D
Rank
Userlevel 3
Badge +4

Hi All,

I’m looking for an External supplier invoice template where the multiple tax lines will be automatically created or a solution to import the supplier invoice without tax and no error message (import of XML file -> SUPPEXT).

In supplier basic data we defined the multiple taxes in Supplier/Address/Delivery Tax information.

Our External Supplier Invoice Parameters:

 

We tried to import the supplier invoice without taxes or just zero taxes but always get following error message:

Is there someone that can help me out.

Thank you and best Regards,

Linda

This topic has been closed for comments

5 replies

A
Rank
Userlevel 3
Badge +6

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. 

T
Rank
Userlevel 7
Badge +18

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

D
Rank
Userlevel 3
Badge +4

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

J
Rank
Userlevel 1
Badge +1

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

J
Rank
Userlevel 1
Badge +1

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

Terms & ConditionsCookie settings