Distribution, Manufacturing, and Internet Modules

[jasonitspyder]

Hi,

I'm wondering if there's a way I can add a UDF for ProductLineDesc in CI_Item and then have the data source point to the ProductLineDesc in IM_ProductLine?

The reason is that I need this info to do UPS/Fedex custom invoices. I have a view setup for UPS and Fedex to do queries:

SO_SalesOrderHeader -> SO_SalesOrderDetail -> CI_Item

If I link one more table, which is IM_ProductLine just to get the ProductLineDesc, one query will take about 15-20 seconds more.

Please share any ideas you may have. Thanks.

[BigLouie]

I would think you could. Have you tried it?

[connex]

It works fine to add the PL description to CI_Item as a sourced UDF.  I am surprised that it would increase your query time to add the product line table. Usually this table has but a few records and doesn't add much time to a query.

[jasonitspyder]

Yes, it does increase my query time. I was very surprised too.

Just to make sure, when I create the UDF, I should pick the "Business object" instead of "Manual entry" -> "Datasource" right?

[connex]

Yes.Doesn't it take less time to try than to post to the community?

[TomTarget]

"I have a view setup for UPS and Fedex to do queries: "

We are talking Crystal here aren't we?  I ask because use of "view" suggests Explorer to me which I didn't think was impacted by custom office links as mentioned later.

What version of MAS are we talking? 

[jasonitspyder]

Thanks so much for your time. I'm just afraid what I do would be irreversible, so want to make sure before I proceed.

I am running SQL 2000 server, with a linked server to my MAS 200, version 4.4 PU4. That's how I can have views.

I have one more question. When I tried to add an UDF in CI_Item, MAS error out on "CI_Item" in use. I have tried to following but no luck:

1) Stopped MAS server. Stopped my SQL 2000 server (which has a linked server to my MAS database)

2) Started MAS server again, and made sure I'm the only one using MAS. (In Master Console, I'm the only user)

3) On my workstation, I only have the launcher (MAS 200 Desktop) and User-Defined Field and Table Maintenance open. No other MAS windows related to CI_Item

I was able to add UDF's to other tables, i.e. SO_SalesOrderDetail successfully. But when I want to touch the CI_Item, MAS says it's in use.

I also noticed that if I pick another company ("ABC"), it would tell me: "CI_Item" is in use in the following companies: ABC. If I pick another company, it would tell me "CI_Item" in the other company is in use. So I'm thinking maybe I'm locking out myself, but I made sure I only have the Launcher and User-Defined Field and Table Maintenance open.

Please help me on this. Thanks again.

[connex]

That's pretty weird that it follows you company to company. Strike my last comment.   It doesn't sound like an open file issue, but I might still try rebooting your server.

[BigLouie]

Do you have any customizations relative to inventory?

[jasonitspyder]

Good point, will try restarting the server tonight.

Customizations - I have some UI customizations on Inventory Management -> Item Maintenance.

No customizations in "Common Information"

Under CI_Item, I do have some UDF's, but they are pretty straight forward (3 numeric UDF to store product dimensions)