Open Forum

Expand all | Collapse all

Stock Count Upload

  • 1.  Stock Count Upload

    GOLD CONTRIBUTOR
    Posted 11 days ago
    Is there a way to upload a stock count into GP without keying in each individual line?  We will end up with an excel spreadsheet that will have item number and quantity and i'm looking for a way to prevent duplicate data entry.

    ------------------------------
    Andy Berntson
    Fargo Public Schools
    Fargo ND
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Stock Count Upload

    Posted 10 days ago
    Hi Andy,

    We've been doing the count in a protected excel with an sql query and macro to upload to GP.  It's not optimal in terms of security, but it beats entering it manually.
    Following the thread to see if there's a more legitimate way of doing it.

    Thanks!

    ------------------------------
    Marie Ringuet
    Stingray Group Inc.
    Montreal QC
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Stock Count Upload

    TOP CONTRIBUTOR
    Posted 6 days ago
    Hello @Andy Berntson.

    We have done this for a number of customers, right from Excel (using macros). Not rocket science since there is only one table to deal with.  If you need this, I can talk to my developer and see if we can share something like that.

    Hope it helps!​​

    ------------------------------
    Thomas Garcia
    ICON Business Consulting, LLC | Miami FL
    ICON, SRL | Santiago, Dominican Republic
    954-804-2140
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Stock Count Upload

    GPUG ALL STAR
    Posted 3 days ago
    Have SmartConnect by chance @Andy Berntson? We built a nifty solution that I'd be willing so share that uses as SSRS report that we export to Excel>> Complete the count in Excel>> then load back into GP via SmartConnect.​

    As already mentioned, it's "technically" not overly difficult to setup as the stock count process is confined to just a few tables.

    ------------------------------
    Kyle Malone, CPA, CPA
    GP Admin - CGB Enterprises, Inc.
    Lead Consultant/Blogger - https://alacarteGP.com
    Chapter Leader - Louisiana (New Orleans)
    Solugence | Find the software that FITS your business + integrates with GP. Find Software Smarter. https://solugence.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


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