Open Forum

Expand all | Collapse all

Inventory Integration

  • 1.  Inventory Integration

    GOLD CONTRIBUTOR
    Posted 5 days ago
    A department of our company started using an outside vendor to track the inventory for their department.  At the end of the fiscal year I need a way to import the on hand inventory into GP for some year end reporting that we do.  We do have smartconnect, but I have not used it for inventory type stuff at all.  Is there a clean way to do this or do i need to be importing inventory transactions throughout the year to accomplish this?

    ------------------------------
    Andy Berntson
    Fargo Public Schools
    Fargo ND
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Inventory Integration

    GPUG ALL STAR
    Posted 4 days ago
    @Andy Berntson

    THis is not a question that is easily answered on a thread.

    I would highly recommend you pull in your GP Partner to help you plan this one.​

    ------------------------------

    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Inventory Integration

    TOP CONTRIBUTOR
    Posted 4 days ago
    Hi Andy,

    If you are just adjusting the inventory levels, you can probably do it with a macro & Replicator.  You can check it out at my website: www.Rnoldz.com

    If the items are serial number or lot tracked it does get a bit more complicated, but it is still do able.

    If you have any questions or problems, please give me a yell!

    Good luck & have fun!

    ------------------------------
    John Arnold
    Senior Software Engineer
    US Digital
    Vancouver WA
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: Inventory Integration

    TOP CONTRIBUTOR
    Posted 4 days ago
    It depends on how often you need accurate inventory.  If you only need it once per year, you can probably get away with a yearly inventory adjustment to true things up.  If you need more accurate information as the year progresses, you need to be syncing up the inventory on an ongoing basis.

    The bigger issue here, IMHO, is that you have a rogue division which implemented something which worked for their needs but affected things on a larger scope.

    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise Idaho GPUG Chapter Leader
    ------------------------------

    Conference-GPUG_200x200


  • 5.  RE: Inventory Integration

    TOP CONTRIBUTOR
    Posted 3 days ago
    Andy,

    SmartConnect can certainly be used for Inventory as well.  If you only truly need the inventory at year end, we would just do Inventory Adjustments at year end.  You shouldn't have to bring it in all year long unless you want to see it updated for another reason.  This is all of course assuming that LIFO/FIFO/Cost/etc is not a concern for the items in GP.

    If you still have your SmartConnect Training Manual, take a look at Exercise 18 as that goes through Inventory Adjustments.

    Let us know if we can be of assistance.

    ------------------------------
    Nicole Albertson
    Product Manager
    eOne Solutions
    ------------------------------

    Conference-GPUG_200x200


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