Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

How is Site Segment Substitution supposed to work for various distribution types

(0) ShareShare
ReportReport
Posted on by 5

Hi!

We're on GP 18 R2 with Binary Stream's MEM.

We have been adding functionality to a manual e-connect based integration process we have to incorporate the MEM versions of the e-connect sprocs into the call.

The distributions for a particular invoice are shown below (from sql)

Segment setup is [Entity (mem)] - [Location (and Site)] - [doesn't matter] - [natural account] - [doesn't matter]

0827.Capture.PNG

Everything is as expected in the distributions as compared to our previous import with one primary exception...

In the 'before' state the distribution on the first line, going to 150-196-00-21241-000, was instead going to 150-000-00-21241-000

The important thing to note is the second segment which is our location and 'site' in gp.

Site segment substitution is changing the default '000' segment for the sales records(41003, 43001) to the expected '196' and is leaving the AR record (Account 11201) with the default '000'.

However, the Tax record (account 21241) is being substituted to '196'. My (potentially incorrect) understanding was that site substitution should not have occurred for this balance sheet account.

How is site substitution "choosing" which accounts to substitute the site segment for and which to not since the AR record did not substitute and the Tax record did i am unsure?

Any insights about the "decision" process GP is making would be helpful.

Thanks much!

Categories:
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at
    RE: How is Site Segment Substitution supposed to work for various distribution types

    Hi,

    If you open the MEM user contextual Help file in GP, and search for eConnect, it should return quite a few information about the use of MEM with eConnect.

    However, the Help file is quite outdated as it appear to be referencing up to GP 2013 only. You may want to open support call with Binary Stream or your partner, since as a paying customer you're entitled to free support.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Product updates

Dynamics 365 release plans