Add "Ship-to Code" to sales line

Mike_Heffner

I am trying to add "Ship-to Code", from the Sales Header table, to the Sales Line Page. I added a field control with the following Properties.

SourceExpr:
SalesHeader."Ship-to Code"

TableRelation:
"Sales Header" WHERE (No.=FIELD(Document No.),Document Type=FIELD(Document Type))

I have tried several other iterations of the TableRelation and none of them worked. The field always appears blank. I have verified that the Sales Headers do in fact have data in the Ship-to Code.

Can someone tell me what I am doing wrong? I am sure it is something simple, but I don't see it.

Alex_Chow

Are you trying to create a flowfield? Or a regular field?

Savatage

For a flowfield you would create a new field in the sales line table
called:"Ship-To Code"
type: code
size:10

View The properties

FieldClass: Flowfield
CalcFormula: Lookup("Sales Header"."Ship-to Code" WHERE (Document Type=FIELD(Document Type),No.=FIELD(Document No.)))

For a regular field you would still create a new field as above.
But would add code on the Oninsert trigger of the sales line table.
if SalesHeader.GET("Document Type","No.")
then "Ship-to Code" := Salesheader."Ship-to Code"
else "Ship-to Code" := '';
PS if you want the fields to transfer over to the posted tables
you need to create the same fields with the same names,size & ID Number in the Sales Invoice Line table.

Something like that.... 8)

Alex_Chow

By the way, you'll get an error if you try to lookup to a lookup table.

Mike_Heffner

I used the flow field technique. It worked well.

Thank you for your help!!

Savatage

if you have a lot of sales lines you could effect performance - hence the other option amongst other reasons. But if you can't get to the code due to license limitations then the flowfield is the way to go for you. Unless you want to get your partner to make the change for you.