Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

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

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
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans