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

Notifications

Announcements

No record found.

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:
I have the same question (0)
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at

    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

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 592 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 305 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans