[n.tiwari@manduka.com]

Hi,

I am trying to add a custom transaction column field (MD Discount) on a Sales Order form which should have a formula as below:

{custitem106} – {rate}

where {custitem106} is a custom Inventory Item field.

and rate is the standard transaction column field for rate.

I am not storing the value as the custom field uses the formula.

Also, the type of this field is free text.

I get the below error when I check a Sales Order. Can anyone please help to fix this error?

I tried to modify the formula as below:

{item.custitem106} – {rate}

This gives me the error: ERROR: Field 'item.custitem106' Not Found

I also tried the below modification:

{createdfrom.custitem106} – {rate}

This also gives me similar error: ERROR: Field 'createdfrom.custitem106' Not Found

ERROR: Field 'custitem106' Not Found

Attached is the error on the SO form under the Item sublist on the right.

Attached Files
This is a cached copy. Click here to see the original post.

[al3xicon]

I believe this is due to the fact that you're not storing the value – fields without "Store Value" checked cannot be used in saved searches.

[n.tiwari@manduka.com]

Hi al3xicon,

I am not trying to do a search. I am just trying to display the field's value on the Sales Order form.

The field is using a formula which calculates the difference between the Item's field of "Direct List Price" and the standard Rate field.

This field is applied for only Sales Order form.

[al3xicon]

I see, my apologies – so I think the problem is likely that you're trying to access an item field within a transaction column field formula. The scope is going to be fields available to you on the transaction, so to get to item fields you will need to join. Something like {item.custitem106} is probably what you need.

[n.tiwari@manduka.com]

Yeah, I forgot to mention that I tried to modify the formula as below:

{item.custitem106} – {rate}

This gives me the error: ERROR: Field 'item.custitem106' Not Found

I also tried the below modification:

{createdfrom.custitem106} – {rate}

This also gives me similar error: ERROR: Field 'createdfrom.custitem106' Not Found

[torin@aminian.com]

You're going to have to source the custom field from the item record into a custom transaction column field by itself first. Do so by choosing item as the source list and then choose the desired custom field. After this field is created, use this new custom column field ID in the formula. You can then simply hide the original custom column field on the transaction record and leave the custom field with the formula. Let me know if this makes sense.

[n.tiwari@manduka.com]

Thank you Tori. That helped!

[Author]

Posts