Skip to main content
Question

STDCIN1 Multiple invoices import

  • 21 July 2024
  • 3 replies
  • 36 views

Hello, 

I have a question about invoices import using STDCIN1.

The template works fine when I import a single invoice including when it have multiple lines

But when I try to import multiple invoices i get imports errors.

 

Any thoughts why ?

 

Best regards

3 replies

Userlevel 7
Badge +18

Hi, 

If the below does not solve, include any error messages, I’ve loaded invoices many many times.

Are you using the Standard (IFS) template or a copy? 

The standard template should work as is.  If you made a copy of the template (depending on how the copy was created) you should make sure the settings are similar to the image.  One time 20 years ago, a coworker manually made a new template and the setting blocked loading a second invoice. 

The data needs to look something like the below. This is just a sample so you can see how multiple invoices should look for that template. 

The below does not have the tax records, it’s an example of the structure for a file with multiple invoices. 

H;1057;0003498384;2005-5-16;EXTINV;2005-5-16;2005-5-16;0;USD;1;;;;1;;;;;;;;;;;;;;;;;;;;;;;;;;;
I;0003498384;0;N4;250.00;250.00;;;;;
P;0003498384;0;1;5000;;;;;;;;;;;-250.00;-250.00;;;;;
H;1057;0003498385;2005-5-16;EXTINV;2005-5-16;2005-5-16;0;USD;1;;;;1;;;;;;;;;;;;;;;;;;;;;;;;;;;
I;0003498385;0;N4;223.01;223.01;;;;;
P;0003498385;0;1;5000;;;;;;;;;;;-223.01;-223.01;;;;;
H;1057;0003498386;2005-5-16;EXTINV;2005-5-16;2005-5-16;0;USD;1;;;;1;;;;;;;;;;;;;;;;;;;;;;;;;;;
I;0003498386;0;N4;800.00;800.00;;;;;
P;0003498386;0;1;5000;;;;;;;;;;;-800.00;-800.00;;;;;
H;1057;0003498387;2005-5-16;EXTINV;2005-5-16;2005-5-16;0;USD;1;;;;1;;;;;;;;;;;;;;;;;;;;;;;;;;;
I;0003498387;0;N4;223.01;223.01;;;;;
P;0003498387;0;1;5000;;;;;;;;;;;-223.01;-223.01;;;;;
H;1057;0003498388;2005-5-16;EXTINV;2005-5-16;2005-5-16;0;USD;1;;;;1;;;;;;;;;;;;;;;;;;;;;;;;;;;
I;0003498388;0;N4;223.01;223.01;;;;;
P;0003498388;0;1;5000;;;;;;;;;;;-223.01;-223.01;;;;;

Userlevel 3
Badge +9

Hello, 

 

I could import the invoices when lines respect the H I P order 

 

My question is, can we have all the H lines followed by the all the I and all the P ? 

 

Best regards

Userlevel 7
Badge +18

Hi, 

No. 

 

You must follow the format.    IFS is expected a corresponding I record after the H record. 

Best regards, 

Thomas

Reply