web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Assigning a site to al...
Microsoft Dynamics GP (Archived)

Assigning a site to all items

(0) ShareShare
ReportReport
Posted on by Jason Chung 1,110

Hi again,

I've got a barcode system that can transfer items from site to site, but I get error messages when trying to transfer to a site that is not assigned to that item.

I know that I can use the Item Site Assignments window to assign all items to my different sites, but my question is: Does anyone know of the impact this will have on my system? I've got over 15 000 items and 5 different sites (5 X 15 000 = 75 000 item/site assignment combinations)

Other than taking a little database space, I have no clue if this action will slow down my other processes or multiply data entry time due to added site selections when users work on a daily bases.

Thanks,

Jason

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Dennis Sisnarine Profile Picture
    Dennis Sisnarine 155 on at

    Jason,

    We are using 10 sites in GP and 18,000 Items, Other than the extra space in the IV00102 Table you would not have Performance drop.

    I have created Macro for Adding Item numbers in Bulk, one of the steps is to assign the item to all the sites.

    Almost allways, If I don't, I will have to do it when I do a Transfer to another Site.

    For Data Entry you should set the default Site for the Items In the Item Quantities Window.

  • Jason Chung Profile Picture
    Jason Chung 1,110 on at

    Alrighty then!

    Thanks for the info Dennis!

  • GPDavid Profile Picture
    GPDavid 2,250 on at

    Jason,

    Do you use Material Requirements Planning module?  Since this considers inventory on an item-site basis, I've seen unnecessary assignments create performance issues with MRP regeneration.

    David

  • Jason Chung Profile Picture
    Jason Chung 1,110 on at

    David,

    An excellent point. We do use MRP and this will certainly have an impact of performance. In this case, I will have to review the strategy and probably we will decide on item classes or something around those lines.

    Thanks again for the input,

    Jason

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans