IMINVLOC File

[dmrVA]

What populates this file, field Product Category?
It is not viewable or up-datable on the screens.
I do not see where you tie the product category to anything and the material cost type is tied correctly to the location.

Thanks
Donna

 

[dgillz]

This comes from the item master product category. I am not sure why this field is not available to the screen designer.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[dmrVA]

When I do a crystal report using the IMINVLOC file, part#, location, product category for a few parts it pulls over incorrect infomation (the category is incorrect). I just cannot figure out where the tie is. In the item master the category is correct. Strange....

Thanks

 

[dgillz]

Donna,

Are you saying the imitmidx_sql.prod_cat <> iminvloc_sql.prod_cat?

I have sql script to fix this. Are you still on Pervasive?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[dmrVA]

The report uses the IMINVLOC_SQL file and I am selecting prod_cat. I have not added the IMITMIDX_SQL file to the report. That is why I am so confused.

We don't key in the Prod Cat when we load the inventory location, so where is this field getting populated from??

Yes, we are still on Prevasive.

Thanks

 

[dgillz]

When you add a new item location record, it reads the prod_cat from the item master (imitmidx_sql) table. The first time you create a new item master, it automatically creates an item location using the same prod_cat.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[dmrVA]

Well there is something wrong, because what is in the Inventory Master as product category does not match what comes up in the inventory location...unless they were put in wrong and the programming does not recognize a change.

I just changed the report to look at the Inventory MAster prod category...guess a but in this old Pervasion version.

Thanks for your help.

 

[dgillz]

This script should work with Pervasive. It will set the iminvloc_sql.prod_cat equal to the imitmidx_sql.prod_cat. Please run a file validation report on the imtmidx_sql first to make sure all product categories are good and there are no nulls.

UPDATE     iminvloc_sql
SET iminvloc_sql.prod_cat=imitmidx_sql.prod_cat
FROM         imitmidx_sql INNER JOIN
                      iminvloc_sql ON imitmidx_sql.item_no = iminvloc_sql.item_no

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html