volker99
22nd June 2007, 18:20
We want to add a second text field ( item text tiitm001.txta) to our edi invoice message. The result is a second edi order line. The first line begins without the record type (SA6).

What's the trouble??:(

An example is ...
;"F8100706220011";"4306236008534";"IVK";55;73612;10;"";"";"SA";"EAN-Nr. 1000";"TFT-Bildschirm";"1000";1;0;1;"PCE";250;"PCE";070622;250;0;1;250;0;;;;;"";"VAT";"16";;;0;0;0;0;0;0;1;1;1;"";"";"";;;"item text tiitm001.txta"
"SA6";"F8100706220011";"4306236008534";"IVK";55;73612;;;;;;;;;;;;;;;;;;;;"order pos. tdsls041.txta";" 2. row";;;;;;;;;;;;;;;;;;;;;;;"SA6_END"

Juergen
26th June 2007, 18:00
not easy to say from the distance what caused the trouble, but it seems that you placed the new field in a wrong position inside the edi conversion setup, so there is now a mismatch with reading and writing the edi records.

Do you placed the new field within the field processing sequence of the SA6 record?

Regards,
Juergen

volker99
26th June 2007, 19:01
The conversion setup for the new text field in the trading invoice:

Table Field : tiitm001.txta
Seq No. : 0
Seq : 335
Level : 7
Start Pos. : 49
Index : 0
Length : 70
...

It's no problem to add a "normal" field. Only the text field gives me a lot of trouble.

Juergen
27th June 2007, 10:13
So that means it works if you add a "normal" field (e.g. Itemgroup = tiitm001.citg) to the same position in the conversion setup?

Please check also if solution 158337 is installed on your system.
From library tdslsdll4282 - Generate Sales Invoice
|* SOL 158337, John Skowronski, 2002-05-29
|* Added select of sales item master (tiitm001) on every EDI orderline.
|* This allows the item text to be used when the item is related to a
|* project. (Df 124691).

Regards,
Juergen

volker99
27th June 2007, 11:22
The solution is installed and it works with fields like itemgroup or similar. It seems that only the text fields confused the message line. :((

Juergen
27th June 2007, 14:52
Hi Volker,

I have done some tests and added tiitm001.txta to our set-up.
The result is the same as on your systems. The SA6 record is not written correctly.

But with some modifications it works now.

Please test.
Conversion set-up for field tiitm001.txta
Table Field : tiitm001.txta
Seq No. : 0
Seq : 342
Level : 7
Start Pos. : 49
Index : 0
Length : 70
Write record :yes (!!)

Please remove the "Write record" command from the before field tdsls041.txta (Seq No 341) !!

Sometimes the EDI Set-up is a little bit tricky.

Regards,
Juergen

volker99
28th June 2007, 11:23
Hi Juergen,

yes, it's very tricky.

I have done some tests with your conversion set-up. Invoices without position text (tdsls041.txta) are ok, but messages with position text and item text have the same result as before. I seems that more than one text segment are not possible.

Thank you for your help up to now.

Regards,
Volker

PrinceUK
29th June 2007, 14:34
Hi

We use EDI Document 855 Single File for Order Acknowledgement Out.

We have got it so that it will produce tiitm001.txts, tipcs021.txta (if it is a project and there is data) and tdsls041.txta (if there is any). It works without any problem. These are set with successive Sequence, the same Level, and the same Start Pos. They are all set to Write Record=Yes.


Hope this helps