Coming Soon: On April 2nd, all Suggestion Boxes will be migrating to The Network, Trimble's online user community. Your posts, votes, comments, and user accounts will transfer. This site will become read-only after the migration, and this banner will have a link to the new location for Vista suggestions.

Copy Records Across Companies

Copy Records Across Companies - Copy Record/Paste Record work great within a company but when copying over setups from one company to another the ability to copy the GL Journals, HR Codes, Classes, Crafts, etc. would be a huge time saver

  • Robert Lackner
  • Nov 19 2019
Company NorthStar Group Services, Inc.
Job Title / Role VP of IT
I need it... Yesterday...Come on already
  • Attach files
  • Kevin Halme commented
    November 19, 2019 15:22

    Robert,

     

    This can be done in SQL fairly easily. For example, for GL Journals you can use the script below. This example copies the journals from company 1 to company 2.

    INSERT INTO GLJR (GLCo, Jrnl, Description, Rev, RevJrnl, Notes)
    SELECT 2 AS GLCo, Jrnl, Description, Rev, RevJrnl, Notes FROM GLJR WHERE GLCo = 1

     

    Kevin Halme | Constructive Tech Solutions | www.consttech.solutions

Dear Viewpoint Suggestion Box contributor;

We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs. Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.

© 2023 Trimble Inc. All Rights Reserved. Viewpoint®, Vista™, Spectrum®, ProContractor™, Jobpac Connect™, Viewpoint Team™, Viewpoint Analytics™, Viewpoint Field View™, Viewpoint Estimating™, Viewpoint For Projects™, Viewpoint HR Management™, Viewpoint Field Management™, Viewpoint Financial Controls™, Vista Field Service™, Spectrum Service Tech™, ViewpointOne™, ProjectSight® and Trimble Construction One™ are trademarks or registered trademarks of Trimble Inc. or its affiliates in the United States and other countries. Other names and brands may be claimed as the property of others.