Lanham EDI Inbound 850 Fixed Value

gogojlwc

Dear All,

Does anyone know how to write a fixed value into a field?

For example,
When I receive a 850 and it does not include any shipment information and account number, can I write a fixed value into shipment field?
I want to write my customer's shipping account# into below table's field.(the information is not in 850 file.)

Table: Sales Header Field: Shipping account


Thanks

Savatage

Under trading partner
Customer store setup (EDI Cust. Cross References)
Then you can assign all incoming blank orders to a designated account?

If you have to assign matches (as below)
EDI Sell-To Code-> Nav Sell-To Code
EDI Ship-To Code->Nav Ship-To Code

then your edi ship-to code would be blank and your nav-ship to code would be assigned a value

or are you looking to set the 850 N1 - to be conditional?
Is this 850 for 1 customer and it's always blank then look at the 850 elements.
leave the Nav table name blank & there is a column called "Fixed Value" where you can enter a value.

We don't know your entire situation so it's hard to pinpoint one solution

gogojlwc

Thanks Harry,

My question is that when I am doing a 850 mapping, can I add a fixed value to a filed even though the original 850 file does not have this value?

For example, when a customer's 850 file does not include SCAC code, I want to assign a code to this customer to the SCAC field.
or, when a customer's 850 file does not include their shipping account code, I want to assign a code to this customer to the shipping account code when I process this order and set the shipment type as third party(this setting requires the third party shipping account#).
How can I do that?


Thanks

Savatage wrote:

Under trading partner
Customer store setup (EDI Cust. Cross References)
Then you can assign all incoming blank orders to a designated account?

If you have to assign matches (as below)
EDI Sell-To Code-> Nav Sell-To Code
EDI Ship-To Code->Nav Ship-To Code

then your edi ship-to code would be blank and your nav-ship to code would be assigned a value

or are you looking to set the 850 N1 - to be conditional?
Is this 850 for 1 customer and it's always blank then look at the 850 elements.
leave the Nav table name blank & there is a column called "Fixed Value" where you can enter a value.

We don't know your entire situation so it's hard to pinpoint one solution

Savatage

My confusion starts when you say "When a customer 850 doesn't include.."

Which says to me that it's not always the case.
If it's NOT always the case then a fixed value is not the answer - you need it to be flexable.
As I stated before (on my E-Ship version) I can have a trading partner with many ship-to's.
I can assign them using the EDI Cust Cross Reference Table.
I can assign a Blank to point toward any address I'd like.

If you want to automatically assign "Shipping_Payment_Type" to Freight Collect. You can set that on the customer card. You can assign that customer's UPs Account No using Customer->e-ship->Shipping Accounts.

If i'm not following I'm sorry. also do you have the mapping guide?
https://docs.google.com/open?id=0BwY098 ... khmaEVfXzg

Savatage

We also added a custom field to the "EDI Cust Cross References" table and to get that on the sales header we modified CU#14000361 - "EDI Create Sales Order".

You can get your Nav partner to help with that if needed.

gogojlwc

Sorry for the misunderstanding.
It is just an example and I do have mapping guide.

Which I want is to assing a fixed vaule to a field when I translate 850 into a sale order.

I do not know how to do that when I create a 850 mapping.

Thanks

Savatage wrote:

My confusion starts when you say "When a customer 850 doesn't include.."

Which says to me that it's not always the case.
If it's NOT always the case then a fixed value is not the answer - you need it to be flexable.
As I stated before (on my E-Ship version) I can have a trading partner with many ship-to's.
I can assign them using the EDI Cust Cross Reference Table.
I can assign a Blank to point toward any address I'd like.

If you want to automatically assign "Shipping_Payment_Type" to Freight Collect. You can set that on the customer card. You can assign that customer's UPs Account No using Customer->e-ship->Shipping Accounts.

If i'm not following I'm sorry. also do you have the mapping guide?
https://docs.google.com/open?id=0BwY098 ... khmaEVfXzg