Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / eConnect sales ordewrs...
Finance | Project Operations, Human Resources, ...
Suggested answer

eConnect sales ordewrs integration filter

(0) ShareShare
ReportReport
Posted on by xverci101 58

Hi everybody,

I've an integration that works fine, but as a new requirement we need the integration to not include sales orders with the bachnumb of 'webapp' as these orders come from a custom application and will be processed manually.

pastedimage1590616677921v1.png

1.- The picture is not good but the filter expression is as follows:

And    Batchid\BatchID       is not equal         'webapp' 

2.- I've alse tried the following, but no success:

And      BatchID\Batch Source       is not equal         'webapp'

So far the filter fails and I'm stuck, there is no real help out there anymore, we are running Dynamics GP 2013 and CRM 2011

Really appreciate your urgent help

Categories:
Microsoft Dynamics GP
  • Suggested answer
    Andrea Melroe Profile Picture
    Andrea Melroe 3,437 on at
    RE: eConnect sales ordewrs integration filter

    Hi,

    It looks like you are using the CRM adapter to bring the data into GP, and you are trying to exclude the webapp batches from coming through via mapping in CRM. Honestly, here in GP support we generally assist with setting up the web services to connect GP to the tool.

    Since the connection seems to be working between CRM and GP, have you considered posting this forum on the CRM Community forums as well in case someone there has further insight around the mapping itself?

    https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum

    I’m not a CRM expert by any means, so please take this suggestion with a grain of salt: Have you tried to remove the single quotes around the batch name? Again, I’m not a CRM expert but I do know that for some user interfaces (like GP) will read that quote as part of the batch name itself. This would cause the product to think the batch was called ‘webapp’ instead of webapp.

    I’m hoping others in the community have additional suggestions for you!

    Thank you for using Dynamics Communities,

    Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 601 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 416

#3
Adis Profile Picture

Adis 384 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans