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

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) / Changing the "Seg...
Microsoft Dynamics GP (Archived)

Changing the "Segment ID For Sites" in the Inventory Control Setup file

(0) ShareShare
ReportReport
Posted on by Peter Longchamp 20

We have a GP2010 installation where we have only 1 site and the inventory control setup screen has "Segment 1" listed as the "Segment ID For Sites". Our chart of accounts has 3 segments and none of them are currently used for sites. The screen does not allow this value to be changed.

The problem is that we are planning to open a second site and want to use the Professional Services Tools Library to renumber our chart of account so segment 2 is used for the site.

Has anyone had any experience (luck?) changing the "Segment ID For Sites" to a different value? I suppose I could track down the value in the tables but have no idea where/how the value is used and if I would break something if I changed it via SQL.

Peter Longchamp

*This post is locked for comments

I have the same question (0)
  • Tim W Profile Picture
    Tim W 2,925 on at

    Hi Peter, I was reading your post and it reminded me of a huge problem caused when this feature was misunderstood at a client in the not to distant past;. Let me answer your question first though.

    You can change this value by updating the IV40100 table and setting ACSGFLOC to whatever segment is your inventory segment.  It's an integer field so if you were to query your database you will have a value of 1 for that field.  You will not need to do this at all if you are not using segment substitution however.  This value is only used to tell GP when to overwrite a segment value on transaction posting.  I assume GP never wrote any extended validation code because it does not really matter what is selected here until the first substitution is made (if ever). 

    If you leave the segment value blank on the site setup card (segment substitution is a little more of an advanced feature and I've only seen it used in companies with a deep IV management reporting need) then it does not matter what this value is on the setup window.

    Segment substitution lets GP overwrite the segment you chose with a value you assign on the SItes Setup window.  If you had site 1 set to segment value 100 and site 2 set to segment value 200 you could then assign items to a generic inventory account 1300-000-00 and GP will plug the segment value you set into the transaction depending on site used so that the user is not burdened with that update.  Assuming segment 2 and site 2 then the IV account will transform to 1300-200-00 on posting saving a manual step.

    What I saw last year was an implementation done by a company with a single segment COA.  In their case Segment 1 (their only segment) was chosen during the setup and someone mistakenly added a COGS account to the site setup window.  After a month or so they finally ran a revenue report and found that for any transaction posted against that site Revenue, COGS, IV. IV offset were all transformed into the COGS account by the substitution feature.  Ouch.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
talty09 Profile Picture

talty09 2

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#3
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans