Open Forum

Expand all | Collapse all

Mass updating the Item current cost

  • 1.  Mass updating the Item current cost

    Posted 24 days ago
    #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
    ------------------------------
    GPUG Summit - Post


  • 2.  RE: Mass updating the Item current cost

    GPUG ALL STAR
    Posted 24 days ago
    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
    ------------------------------

    GPUG Summit - Post


  • 3.  RE: Mass updating the Item current cost

    Posted 24 days ago
    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
    ------------------------------

    GPUG Summit - Post


  • 4.  RE: Mass updating the Item current cost

    GOLD CONTRIBUTOR
    Posted 7 days ago
    Edited by Chase Landorf 7 days ago
      |   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)

    GPUG Summit - Post


  • 5.  RE: Mass updating the Item current cost

    Posted 4 days ago
    Thank you, Chase, I will grab it and review in times of need!

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

    GPUG Summit - Post


  • 6.  RE: Mass updating the Item current cost

    Posted 6 days ago
    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
    ------------------------------

    GPUG Summit - Post


  • 7.  RE: Mass updating the Item current cost

    Posted 2 days ago
    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
    ------------------------------

    GPUG Summit - Post


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