baanware
26th May 2010, 15:43
Hi,

Is it possible to concatenate two fields from a sales order EDI (input) file into one single concatenated field?

The actual issue is to utilize two different input-fields and merge them into a single field - the Customer Order Reference field (tdsls400.corn). The input fields are positioned as fields 4 and 51 in level 2 of the header import.

If both fields are filled (not empty) a separator character should separate the two input fields in the single target field. In other words if field 4 is "ABC" and field 51 is "DEF" tdsls400.corn should be filled as follows: "ABC/DEF".

Is this possible to obtain this using standard EDI facilities?

Thanks!

avpatil
27th May 2010, 16:50
And why you can acheive this by doing this in the external translator (Assuminh you are ding external EDI). The external translator can combine them easily in the file that Baan reads.

Arvind

baanware
28th May 2010, 09:08
Hi Arvind,

Thanks for your reply.

We will indeed to combine the two fields in an external EDI tool ...unless it can be achieved directly in the Baan EDI module. What I was trying to find out was whether it it possible to do in Baan (without customizations of the standard package).

Best regards
Soeren Lildal