Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 1st August 2016, 15:59
jatin_sanghi jatin_sanghi is offline
Senior Member
 
Join Date: Jul 2004
Posts: 117
jatin_sanghi is on a distinguished road
Baan: ERPLN6.1 - DB: Oracle 9.2.0.1 - OS: windows2003
EDI file conversion to ERPLN format
Baan: ERP LN 6.1 FP10 (Infor ERP 10.4)
C/S: Both

Hello,


We are trying to set up EDI processing for our customer in ERPLN 10.4 environment. The customer is sending us the requirement in EDI file EANCOM D.96A – 008 standard format (attached with the incident).

We looked into the ERPLN system to map this file using EDI conversion setup, but we are not sure if LN could handle the file in its original format. Does ERPLN need to have the file converted to some other format before this can be imported through LN EDI? If so, where can I find some sample format that needs to be used?

Please look into this and suggest any help.

Thanks,
Jatin
Attached Files
File Type: txt ORDERSEDI_sample.txt (1.2 KB, 23 views)
Reply With Quote
  #2  
Old 1st August 2016, 17:15
Juergen's Avatar
Juergen Juergen is offline
Guru
 
Join Date: Aug 2001
Location: Germany
Posts: 566
Juergen is on a distinguished road
Baan: IVc4, ERP LN - DB: Oracle - OS: Linux, Unix
Hello Jatin,

ERPLN is using an own internal EDI format called BEMIS (Baan Electronic Message Interchange System).
Conversion of the internal standard to an external EDI standard (like VDA, EDIFACT,etc.) and vice versa must be performed by an external EDI Translator.

For a first starting point to use Baan/ERPLN EDI please refer to http://edi.baan.com/
Here you will find a lot of ducuments

Regards,
Juergen
Reply With Quote
Sponsored Links
  #3  
Old 1st August 2016, 17:29
jatin_sanghi jatin_sanghi is offline
Senior Member
 
Join Date: Jul 2004
Posts: 117
jatin_sanghi is on a distinguished road
Baan: ERPLN6.1 - DB: Oracle 9.2.0.1 - OS: windows2003
Sample Incoming ORD001 File

Hello Juergen,

Thanks for your response on this. I found documents that give good insight on the file setup for Orders IN / OUT.

Is it possible, if you have a sample file for Incoming ORD001 that I could refer and you could share that with me.

I just need to understand the format difference based on Conversion setups that was imported through 'default.edi' file.

Thanks,
Jatin
Reply With Quote
  #4  
Old 2nd August 2016, 08:21
Juergen's Avatar
Juergen Juergen is offline
Guru
 
Join Date: Aug 2001
Location: Germany
Posts: 566
Juergen is on a distinguished road
Baan: IVc4, ERP LN - DB: Oracle - OS: Linux, Unix
Hello Jatin,

normally don't have a problem to share an example file here but in that case make not sense because we don't use the standard ERPLN EDI formats.

Coming from our BaanIV EDI history we are using our own EDI conversion set-ups (similar to the BaanIV EDI formats) with a lower number of levels and a different structure in the EDI conversion definitions.
Maybe someone else which is using the standard EDI set-up can share an example here.

Regards,
Juergen
Reply With Quote
  #5  
Old 2nd August 2016, 21:20
benito's Avatar
benito benito is offline
Guru
 
Join Date: Jan 2002
Location: Eastern US
Posts: 514
benito is on a distinguished road
Baan: ERPLn 10.2.1 / BaanIVc4 - DB: Oracle11/Informix - OS: Unix/Linux
hi jatin, attached is a sample ord001.txt file. you need to look at your mapping information and customize if needed. most importantly, you need a translator to translate your ORDERSEDI_sample.txt to the BEMIS standard.
Attached Files
File Type: txt ord001.txt (717 Bytes, 16 views)
Reply With Quote
  #6  
Old 2nd August 2016, 22:16
jatin_sanghi jatin_sanghi is offline
Senior Member
 
Join Date: Jul 2004
Posts: 117
jatin_sanghi is on a distinguished road
Baan: ERPLN6.1 - DB: Oracle 9.2.0.1 - OS: windows2003
Got some success

Thanks Benito / Juergen,

With the sample file shared, I have had some level of success. I tried my set with reduced fields and was able to have data populated in 'saved messages'.

Will try further to go all the way.

Thanks Again,
Jatin
Reply With Quote
  #7  
Old 3rd August 2016, 16:43
benito's Avatar
benito benito is offline
Guru
 
Join Date: Jan 2002
Location: Eastern US
Posts: 514
benito is on a distinguished road
Baan: ERPLn 10.2.1 / BaanIVc4 - DB: Oracle11/Informix - OS: Unix/Linux
you're welcome jatin! hope you're doing well....so is saikat
Reply With Quote
  #8  
Old 3rd August 2016, 17:16
jatin_sanghi jatin_sanghi is offline
Senior Member
 
Join Date: Jul 2004
Posts: 117
jatin_sanghi is on a distinguished road
Baan: ERPLN6.1 - DB: Oracle 9.2.0.1 - OS: windows2003
Item conversion in EDI

Benito,

I'm doing well and thanks for asking..

I'm trying to figure out how could we handle the conversion of item codes in the incoming ORD001 file from EAN code to our internal item codes. I do not see any conversion tables for item codes, but there is something called Item Code IDs. How could they be used for conversion purposes?

Please suggest.

Thanks,
Jatin
Reply With Quote
  #9  
Old 3rd August 2016, 17:25
jatin_sanghi jatin_sanghi is offline
Senior Member
 
Join Date: Jul 2004
Posts: 117
jatin_sanghi is on a distinguished road
Baan: ERPLN6.1 - DB: Oracle 9.2.0.1 - OS: windows2003
Item code conversion

I think I got it...it has to be handled using the item code system and then linking BP items to ERPLN items in alternative items.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Programming Question mr_suleyman Tools Development 37 11th November 2016 08:14
Undocumented Functions & Variables george7a Tools Development 81 30th September 2015 11:35
Audit file structure baan_user Tools Development 8 4th May 2007 14:32
How to print Postcript in landscape orientation heliopaixao Tools Administration & Installation 8 28th July 2006 13:39
seq.open berthe Miscellaneous 4 12th May 2005 10:20


All times are GMT +2. The time now is 08:52.


©2001-2017 - Baanboard.com - Baanforums.com