×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Automatically populate item/location fields

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.

RE: Automatically populate item/location fields

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: www.gainfocus.biz/exceladdin.html

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close