Open Forum

Expand all | Collapse all

Mass updating the Item current cost

  • 1.  Mass updating the Item current cost

    Posted May 24, 2019 03:15 PM
    #Accounting

    Hoping for guidance here from you experts.....

    I would like to mass update the Item Current cost (IV00101-currcost) via a SQL script but unsure if this would be ok or other tables need to be updated as well. We are on GP 2015 R2 and do not have MFG.

    Current cost is the price of the item from our 1 supplier that we usually update one by one done manually. This year we received over 400 items with cost increases from our supplier. Looking for a simple way to update.

    Thanking you all in advance.



    ------------------------------
    Felix Cartagena
    IT Manager
    Pinnacle textile
    King of prussia PA
    ------------------------------


  • 2.  RE: Mass updating the Item current cost

    GPUG ALL STAR
    Posted May 24, 2019 03:25 PM
    Hello Felix.
    Do you have SmartConnect software in your system?
    The reason I ask is that we have SmartConnect and we use this when we receive requests for updating costs for hundreds of inventory items.
    If you use SQL for this then you can update the IV00101,  IV00103, and IV00108 tables to get started.
    I hope this helps.
    Steve

    ------------------------------
    Steve Burney
    Senior Systems Architect
    Nissan Trading Corporation, Americas
    Lebanon, TN United States
    steve.burney@us.nitco.co

    Chairman, Nashville (TN) GPUG Chapter
    GPUG Ruby Award 2018
    GPUG All Star 2017
    Twitter @SteveBurney

    GP2016 R2
    MRCU14
    ------------------------------



  • 3.  RE: Mass updating the Item current cost

    Posted May 24, 2019 03:33 PM
    No we do not have this software. What does this software do?

    I am planning on writing a SQL script and I meant to include IV00103 and IV00108 to update the vendor record as well.

    Thank you



    ------------------------------
    Felix Cartagena
    IT Manager
    Pinnacle textile
    King of prussia PA
    ------------------------------



  • 4.  RE: Mass updating the Item current cost

    TOP CONTRIBUTOR
    Posted Jun 10, 2019 11:21 AM
    Edited by Chase Landorf Jun 10, 2019 11:23 AM
      |   view attached
    @Felix Cartagena, I have run two mass price list updates. The main tables that I have needed to hit, are the IV00101 ​and IV00105. I was able to retrieve the specific items and run the calculations. Then move it to an excel sheet, and run a concatenates function on the item number and dex row ID. Then run it in the target database IV00105. It takes about 10 to 17 seconds to run 15,000+ items, without any issues. But it doesn't run automatically because we run it once a year. I have attached what I use. You can modify it to run on the current cost fields on the tables you are looking at.

    ------------------------------
    Chase Landorf
    Director of I.T.
    Ideal Deals, LLC dba Ideal Aluminum Products
    Saint Augustine FL
    ------------------------------

    Attachment(s)



  • 5.  RE: Mass updating the Item current cost

    Posted Jun 13, 2019 04:04 PM
    Thank you, Chase, I will grab it and review in times of need!

    ------------------------------
    Felix Cartagena
    IT Manager
    Pinnacle textile
    King of prussia PA
    ------------------------------



  • 6.  RE: Mass updating the Item current cost

    Posted Jun 11, 2019 11:15 AM
    This product works great at the user level if your looking to do mass updates in GP, you also can use it to import transactions via excel.

    https://www.titaniumgp.com/

    Thanks,
    Kevin

    ------------------------------
    Kevin
    ------------------------------



  • 7.  RE: Mass updating the Item current cost

    Posted Jun 14, 2019 05:29 PM
    We use SmartConnect for all of our annual price increases which allows us to import and update cost and list. SmartConnect is powerful and we probably don't even use it for 1/2 of what it'll do. We also use it for mass inventory transfers if we have a mobile inventory site that needs to all be transferred back in to the main location. When used it can really save a lot of data entry.

    Good luck!

    ------------------------------
    Jeremy Freeman
    Petroleum Solutions Inc.
    San Antonio TX
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role