Question

External supplier Invoice in batch process => unpack error

  • 27 May 2023
  • 7 replies
  • 155 views

Userlevel 2
Badge +7
  • Sidekick (Partner)
  • 15 replies

I try to integrate using a batch this STDSIN, IFS cloud 22R2

H;10001365;Facture-A115-2705231;050123;SUPPEXT;050123;050123;A115;;EUR;IBO;I;;;;FR371;;;;;;;;;;;120;;;;;;FR;;;;;;;;FRS71

I;10001365;Facture-A115-2705231;1;100;;20;;SUPPEXT;;A115;;;;10;;;;;;20;;;;;;;;FR

No Issue when doing it online the supplier Invoice is created:

 

But Unfortunately when using a batch the same STDSIN remain unpacked, the line H and I are on the same row.

 


 

H;10001365;Facture-2705233;050123;SUPPEXT;050123;050123;A115;;EUR;IBO;I;;;;FR371;;;;;;;;;;;120;;;;;;FR;;;;;;;;FRS71I;10001365;Facture-2705233;1;100;;20;;SUPPEXT;;A115;;;;10;;;;;;20;;;;;;;;FR

Line H in Blue and line I in yellow are on the same row…

 


7 replies

Userlevel 2
Badge +7

Bellow the setup:
 

 

 

Userlevel 7
Badge +21

Hi @Ivi 

from which file template did you copy your template, from STDSIN1, STDSIN2 or STDSIN3?

Userlevel 7
Badge +21

If you use a copy from STDSIN1 then you need at least the record type IDs H, I, P, T to import your CSV file to IFS.

H = Header

I = Line Information

P = Posting Information

T = Taxes

For each supplier invoice you have only one H and n times I, P, T in the CSV file.

Userlevel 2
Badge +7

Hi,

It is an STDSIN1, 

I integrate the following TXT using the online process with no issues.

H;10001365;Facture-A115-2705231;050123;SUPPEXT;050123;050123;A115;;EUR;IBO;I;;;;FR371;;;;;;;;;;;120;;;;;;FR;;;;;;;;FRS71

I;10001365;Facture-A115-2705231;1;100;;20;;SUPPEXT;;A115;;;;10;;;;;;20;;;;;;;;FR
 

Userlevel 7
Badge +21

OK, that means you can generate a supplier invoice?

Userlevel 2
Badge +7

Same STDSIN, I use the external file assistant.

When I integrate the STDSIN1 TXT using the Online process no pbm I have the supplier Invoice Header and line properly created.
 

When I integrate the STDSIN1 TXT unsing the batch process I have an unpack error
 

 

Line H in Blue and line I in yellow are on the same row…
H;10001365;Facture-2705233;050123;SUPPEXT;050123;050123;A115;;EUR;IBO;I;;;;FR371;;;;;;;;;;;120;;;;;;FR;;;;;;;;FRS71I;10001365;Facture-2705233;1;100;;20;;SUPPEXT;;A115;;;;10;;;;;;20;;;;;;;;FR

Userlevel 5
Badge +11

Hi,

I experienced some time ago an issue with the output direction which was caused by and conversion error during copying the file from one system to another. I am not a technician so I try to explain from what i understood was the problem.

The Problem was that the output file was stored and copied from UNIX Server (where IFS wrote the file to) to a WINDOWS Server (where the user copied the file to). They “spoke” slightly different languages. So a CR (Carriage Return) (Zeilenumbruch) at the end of each line was changed to a LF (Linefeed) in the file. That change stopped the import in third party software since a CR was expected and and LF delivered as line seperator.

Maybe it is here the other way around - that you copy a file from a windows machine to a unix server? Looking at your screenshot, it looks like that the H and I lines are not seperated… (maybe because of the wrong EOL “sign”. If you run the assitant you most probably import the file from a local folder on your machine?

You can check this by opening the file in an editor and show all the usually non visible characters like End of Line (EOF). Then you can compare if they are using the same End of line characters.

Kind Regards

Ralph

Reply