Add the carrier description/name on a sales order

[Former Member]

On sales order in Tax tab when a carrier is selected, it´s only shown the field with carrier cod without his description/name.

How can I add the carrier description/name on a sales order?

[former_member583013 · Accepted solution]

Do you want to add the Carrier name just for viewing on the screen on for PLD?

I think what you see on the screen is still the Carrier Name. If you still want you can add a User field and create a formatted search to Pull the name from the Shipping Table TrnspName from OSHP table

Suda

[Former Member · Accepted solution]

Hi Suda, thanks for reply...

Yes, i´d like to show this field on PLD. The field is set with the carrier code, but I need that be shown the carrier description/name, not the code...

I´ve thought to make a formatted search...but...How to execute a SQL instruction on a field that is shown in a form if the record wasn´t have been commited on the database?

Is it possible to add a variable in the SQL instruction that receive the field value thas is set on the form?

[Former Member · Accepted solution]

Pns = Business Partners

[former_member583013 · Accepted solution]

Marcio,

This should be simple.

Save this SQL Code and attach it to the Transport Name User field / any other field where you want the shipping name.

SELECT T0.[TrnspName\] FROM [dbo\].[OSHP\] T0 WHERE T0.[TrnspCode\] = $[ORDR.TrnspCode\]

When I use $[ORDR.TrnspCode\] it refers to a field value on the form. I am presuming this is the field you are using. If your TrnspCode is in a different field. From the View Menu click System Information. This will enable you see the table and field information on the Status Bar

Use this information instead of $[ORDR.TrnspCode\]

Suda