EDI requirement-Copy Information to sales order and invoice -EDI X12

[former_member476626]

Hello,

We have EDI X12 messges from customers. 850 PO is coming with REF**ZZ** 230 segment . This 230 we want to copy it in our sales order which 850 message will create and we want to pass this 230 value from sales order to Invoice. From invoice 810 message outbound from invoice should carry 230 back to customer.

We do not want to copy 230 via text in our sales order since that would involve config of text determination.

Q1) In which segment of ORDERS Idoc message can we populate the above REF segment value 230 and where will that 230 value in Sale order be copied so that it is copied to delivery and invoice ?

Q2) In which segment of INVOIC Message idoc type from SAP, should we include 230 and which EDI segment should we map it to ?

regards

Sonu

[former_member476626]

Hello Ryan,

230 indicates company code for the customer. SO they want this value back in 810 invoice message. This 230 comes in 850 PO from them. So where to copy 230 from 850 in sales orders so that it is available in invoice and then in outbound 810 from invoice too

rgds

sonu

[Ryan-Crosby]

Hi Sachin,

Where you would place that value depends - what is the meaning of 230? Of course another option is to pass the purchase order number back in your invoice (which would be customary) if this value only has meaning from their end. There is no value in carrying it through order to cash in your system if it plays no role in the business process.

Regards,

Ryan Crosby

[maulik]

What exactly is 230 segment in X12?

A general approach if there is no place holder:

- Figure out if it's header or detail data.

- If it's not a standard field, Extend the IDOC [850 & 860 & 810] and move 230 to that segment.

- If Sales order does not have a place holder, create a Z-Table and stick it in there.

- During outbound 810, go and verify if there is a Z-table entry for that Sales Order, retrieve it and stick it in.

- The code for this extended outbound can be embedded in user-exits or enhancement spots.

- Z-Table key should be Sales Order & Customer PO & PO Date. Add Sales order item if 230 segment is at detail level.

No two customers will have the same X12. There will be differences.