Automatically populate item/location fields
Automatically populate item/location fields
(OP)
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.
If such solution exists, please point me in the right direction. Thanks.
Talk To Other Members
RE: Automatically populate item/location fields
CODE
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: www.gainfocus.biz/exceladdin.html