Open Forum

 View Only
  • 1.  Duplicate item creation in multiple companies

    SILVER CONTRIBUTOR
    Posted Jul 28, 2022 01:21 PM
    Hi all,

    Is there a way to create an item in multiple companies at once?  Instead of recreate it for each company.

    I saw some posts here about a trigger or a sql script, but is it the only way to do it?

    Thank you.

    ------------------------------
    Martin St-Pierre
    Humanware Technologies
    Drummondville QC
    ------------------------------


  • 2.  RE: Duplicate item creation in multiple companies

    SILVER CONTRIBUTOR
    Posted Jul 28, 2022 01:43 PM
    Hi Martin, 

    Depending on how much time, effort, cost and how often this needs to occur, but I might suggest two options: 

    While I love triggers there are definitely a lot of downsides to using triggers (performance, actually firing, upgrades, etc.).  I hope you find the right solution for what you are trying to accomplish. 

    Thanks!

    ------------------------------
    Jamie Evenson
    CEO
    Najaxa Software
    Fargo, ND
    ------------------------------



  • 3.  RE: Duplicate item creation in multiple companies

    SILVER CONTRIBUTOR
    Posted Jul 28, 2022 01:51 PM
    Super,

    Thank you Jamie for your reply.  I will take a look at the 2 solutions you suggest.

    ------------------------------
    Martin St-Pierre
    Humanware Technologies
    Drummondville QC
    ------------------------------



  • 4.  RE: Duplicate item creation in multiple companies

    Posted Jul 29, 2022 04:08 AM
    Another option is to have customization on Item Maintenance window, whenever new items will get created in one company, it will automatically get replicated to other Dynamics GP companies databases, this will not need any manual process and also no sql trigger will be involve.


    ------------------------------
    dexteritydeveloper
    dexteritydeveloper@gmail.com
    https://keptonworking.blogspot.com/
    ------------------------------



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