Hi Experts
Does anyone have a xml file example for an external supplier invoice and an example of an file which can be imported through the external supplier invoice assitant and which has Posting line information?
Best Regards
Sophal
Solved
external supplier invoice with posting information
Best answer by Thomas Peterson
Hi,
This is an ugly example using a standard template. I typically use this style for interfaces.
H;10049;422400;2016-1-04;EXTINV;2016-1-04;2016-1-04;0;USD;1;;;;1;;A12345;;;;;;;;;;;;;;;;;;;;;;;;;
I;422400;0;N;223.01;223.01;;;;;
P;422400;0;1;5000;100;;;;;;;;;;-223.01;-223.01;;;;;
H;10049;422401;2016-1-04;EXTINV;2016-1-04;2016-1-04;0;USD;1;;;;1;;A12345;;;;;;;;;;;;;;;;;;;;;;;;;
I;422401;0;N;223.01;223.01;;;;;
P;422401;0;1;5000;100;;;;;;;;;;-223.01;-223.01;;;;;
H;10049;422402;2016-1-04;EXTINV;2016-1-04;2016-1-04;0;USD;1;;;;1;;A12345;;;;;;;;;;;;;;;;;;;;;;;;;
I;422402;0;N;223.01;223.01;;;;;
P;422402;0;1;5000;100;;;;;;;;;;-223.01;-223.01;;;;;
H;10049;422403;2016-1-04;EXTINV;2016-1-04;2016-1-04;0;USD;1;;;;1;;A12345;;;;;;;;;;;;;;;;;;;;;;;;;
I;422403;0;N;223.01;223.01;;;;;
P;422403;0;1;5000;100;;;;;;;;;;-223.01;-223.01;;;;;
Hi
Typically, external file assistant supports common files like text and CSV.
Before IFS Cloud, the XML was dropped into an inbox. and a different IFS process would pick that up and rout the message into the external invoice process. It does not use the external file assistance. Coud is different but similar.
Sorry, I checked and don’t have a sample XML with code string information. My samples were for testing line level matching to PO lines with parts.
I have external invoice samples with posting lines that are CSV / Text type examples that would be loaded via the external file / external supplier invoice assistant, just not the XML.
Best regards,
Hi
Typically, external file assistant supports common files like text and CSV.
Before IFS Cloud, the XML was dropped into an inbox. and a different IFS process would pick that up and rout the message into the external invoice process. It does not use the external file assistance. Coud is different but similar.
Sorry, I checked and don’t have a sample XML with code string information. My samples were for testing line level matching to PO lines with parts.
I have external invoice samples with posting lines that are CSV / Text type examples that would be loaded via the external file / external supplier invoice assistant, just not the XML.
Best regards,
Hi Thomas
Yes a CSV would be great. Thats even better for my current customer case.
Best Regards
Sophal
Hi,
This is an ugly example using a standard template. I typically use this style for interfaces.
H;10049;422400;2016-1-04;EXTINV;2016-1-04;2016-1-04;0;USD;1;;;;1;;A12345;;;;;;;;;;;;;;;;;;;;;;;;;
I;422400;0;N;223.01;223.01;;;;;
P;422400;0;1;5000;100;;;;;;;;;;-223.01;-223.01;;;;;
H;10049;422401;2016-1-04;EXTINV;2016-1-04;2016-1-04;0;USD;1;;;;1;;A12345;;;;;;;;;;;;;;;;;;;;;;;;;
I;422401;0;N;223.01;223.01;;;;;
P;422401;0;1;5000;100;;;;;;;;;;-223.01;-223.01;;;;;
H;10049;422402;2016-1-04;EXTINV;2016-1-04;2016-1-04;0;USD;1;;;;1;;A12345;;;;;;;;;;;;;;;;;;;;;;;;;
I;422402;0;N;223.01;223.01;;;;;
P;422402;0;1;5000;100;;;;;;;;;;-223.01;-223.01;;;;;
H;10049;422403;2016-1-04;EXTINV;2016-1-04;2016-1-04;0;USD;1;;;;1;;A12345;;;;;;;;;;;;;;;;;;;;;;;;;
I;422403;0;N;223.01;223.01;;;;;
P;422403;0;1;5000;100;;;;;;;;;;-223.01;-223.01;;;;;
Sorry, I rarely ever use a STD type template. I copy a template and then adjust for my needs.
This is an example where I limited the number of attributes.
| COMPANY | IDENTITY | INVOICE_NO | INVOICE_DATE | CURRENCY | VAT_CURR_AMOUNT | GROSS_CURR_AMOUNT | PO_REFERENCE | Account | Cost center | Location | Product | Cur_AMT |
| XYZ | 9418 | TEST2 | 8/8/2018 | USD | 0 | 100 | 501200 | 1002 | TXLUB | 100 |
Hi,
Send me an email, and I’ll reply with a few examples. I have a ton, but trying to find a good sample is not as easy.
Hi,
Send me an email, and I’ll reply with a few examples. I have a ton, but trying to find a good sample is not as easy.
Hi Thomas
I dont have your email adress yet. can you send me your contacts to sophal.nhek@bytics.com?
Thank you so much for your support.
Best Regards
Sophal
Hi,
Send me an email, and I’ll reply with a few examples. I have a ton, but trying to find a good sample is not as easy.
Hello Thomas,
WOuldnt you mind to send me as well some example for xml file to import via External supplier invoice assistant please ? truc_son.pham@spie.com
Many thanks
kind regards
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.