Automatically populate item/location fields

[sheyenne]

We recently added a second location to our operation. We are running on Macola Progression 7.6.300c-SQL, with Flexibility module. I essentially want to copy select fields within the existing item/location record into the new item/location record. I am aware of the add/delete process but that sets all fields to zero for the new location. I would then need to manually enter relevant field information. If this could be automated, I would be able to just copy the fields that are the same and leave the others blank. The main fields I would like to copy over are primary vendor, order multiple, standard cost, and last cost. I am interested in a solution that will allow me to create the new item/location record and have it populated with those fields based on the field value that is in the existing location.

If such solution exists, please point me in the right direction. Thanks.

 

[dgillz]

I would use the mass add item location feature then run a SQL update query to copy over the desired field values. The following will update location DA from location ND:

UPDATE iminvloc_sql
SET iminvloc_sql.price=iminvloc_sql_1.price, iminvloc_sql.last_cost=iminvloc_sql_1.last_cost, iminvloc_sql.std_cost=iminvloc_sql_1.std_cost
FROM iminvloc_sql 
       LEFT OUTER JOIN iminvloc_sql AS iminvloc_sql_1 ON iminvloc_sql.item_no = iminvloc_sql_1.item_no
WHERE iminvloc_sql.loc = 'DA' and iminvloc_sql_1.loc = 'ND'

Just expand on this approach for all of the fields you desire to be copied.

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

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