sales order with reference to a custom object

[Former Member]

Hi all experts, I have a question.

I want to create a sales order with reference to a complete custom object created in the CRM system. The custom object has a unique number assigned to it. How can I use the reference of this custom object in my sales order?

In other words, can I use a field in the sales order which will be storing this custom object number? If yes, which field can be used? If no, how else can this be achieved? Thanks in advance.

[stephenjohannes · Accepted solution]

Animesh,

You have two options: Use the external reference number field on the Sales order if it is not be being used, however if you capture the customer's PO number you are probably aleady using that field. Otherwise I would do what you said and create a new Z-field via the EEWB and store your external reference number there.

If the custom object number was 10 digits alpha numeric, you could possibly create a custom partner function, but I really don't recommend it. The z-field will give you better performance for reporting, and future processing. I would put the z-field field in the CUSTOMER_H segment of the document.

Take care,

Stephen