Personalization, Customization and Productivity Tools

[ppark001]

MAS200 4.4  Windows 7

I am using SO_SalesOrderWrk for a Sales Order form and I don't want to link to CI_Item.   I don't see Volume (from the Ci_item file) in SO_SalesOrderWrk.  Do I have to link?

Thanks,

P.Park

[thebottomline]

Add a UDF in the SO_SalesOrderDetail which pulls the data from the CI_Item Table.  Then add UDF in the SO_SalesOrderWrk that pulls the value from the detail UDF.  Don't forget to add this field to any Crystal forms using the work file.

[ppark001]

I went to Custom Office

1) User defined field and table maintenance.

2) Choose Sales Order Detail

3) Added a field named Volume

4) I have a choice "Source for UDF"  Manual or Business Object

5) I chose Business Object

6) Then I chose from the drop down SO_SalesOrderDetail_Bus

7) Date Source:  I choose "Item" 

(There is no choice for CI_Item....So is "Item" correct?  

Also, adding is "Manual" seems to do the same thing.

Lastly, I noticed when I add it, it does not populate the UDF Volume field in the Wrk file with data..only new Sales Order Detail lines are populated?  Is this typical?

Thanks so much,

P.Park

[thebottomline · Accepted solution]

Step 7 - from data source, there should be one called ItemCode.

Step 8 - chose Volume.

Manual entry will allow you to put what ever value you want so choose business object.

And yes, it will only populate from here forward.

You may be able to populate existing lines with Visual Integrator but doing this in SO detail is very difficult.