Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Automatically populate item/location fields

Status
Not open for further replies.
sheyenne

sheyenne

Technical User
Dec 13, 2012
1
US
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.

 
Sort by date Sort by votes
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:

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:
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

prog_0927
  • Question
Item Master and Location Limits?
Replies
2
Views
83
NEmacGuy
NEmacGuy
prog_0927
  • Locked
  • Question
Default Item Location Missing on File
Replies
2
Views
396
prog_0927
prog_0927
JD5241
  • Locked
  • Question
Identifying Items With Different Prices by Location 1
Replies
2
Views
323
JD5241
JD5241
nsiegmundt
  • Locked
  • Question
How to edit the "search_desc" field for an item inside of macola (table imitmidx_sql)
Replies
1
Views
401
dgillz
dgillz
J G PM
  • Locked
  • Question
Macola Line Item Comments
Replies
2
Views
316
J G PM
J G PM

Part and Inventory Search

Sponsor

Back
Top