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

Notifications

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) / integration manager
Microsoft Dynamics GP (Archived)

integration manager

(0) ShareShare
ReportReport
Posted on by Bobby Aultman 45

Hello.  I have been using Microsoft GP for many years but have recently added Integration manager to the mix.

 

Most tasks for inventory are fine, however, i'm experiencing challenges reagarding sales order integrations.

My online store, Volusion, exports all sales data into an excel file.

Using integration manager (version 10) to attempt to import the sales results in a sales order for every single item number instead of a single sales order with the qty and models associated with each individual sale.

Basically, if i have 5 orders to import with 10 items each, Integration Manager and GP are creating 50 individual orders, one for each item.....

 

I'm a noob at Integration Manager and suspect maybe i need some custom VBA to auto-increment the sales so Integration manager treats 1 sale as just that instead of breaking it up by line items.

Any advice would be greatly appreciated...I can send a copy of the excel export if it helps, but my columns and rows are below for reference.

 

 

Order OrderId customerid Customer_notes ITEM NUMBER QTY unit price
1 5171 8 MAR021 2B04UTSGZONEROCK 2 4500
1 5171 8 MAR021 BatteryDoor 2 150
1 5171 8 MAR021 2B04LGVX9900 11 600
1 5171 8 MAR021 COSMETIC 11 200
1 5171 8 MAR021 FULLTEST 11 500
1 5166 18 SCO008 2B04LGVN250 1 500
1 5166 18 SCO008 BatteryDoor 1 150
1 5166 18 SCO008 COSMETIC 1 200
1 5166 18 SCO008 FULLTEST 1 500
1 5166 18 SCO008 ESNCHECK 1 50
1 5166 18 SCO008 2B04LGVX9600 1 2500
1 5166 18 SCO008 BatteryDoor 1 150
1 5166 18 SCO008 COSMETIC 1 200
1 5166 18 SCO008 FULLTEST 1 500
1 5166 18 SCO008 ESNCHECK 1 50
1 5168 43 AXC001 2B10SAMSGHT229 2 200
1 5168 43 AXC001 2B10SAMSGHT239 1 200
1 5168 43 AXC001 2B10SAMSGHT459 3 800
1 5168 43 AXC001 2B10SAMSGHT469 1 2300
1 5168 43 AXC001 2B10SAMSGHT139 3 200
1 5168 43 AXC001 2B10SAMSGHT559 1 200
1 5168 43 AXC001 2B01SONERIZ750 1 1300

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Dan Liebl Profile Picture
    Dan Liebl 7,320 on at

    Go into your detail source of the integration properties and group by the orderid.  That should get you back to 5 orders.

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

  • Bobby Aultman Profile Picture
    Bobby Aultman 45 on at

    that worked great...however, it seems to be now modifying the order of the items...Instead of importing exactly as on the spreadsheet it's taking the grouped order number and sorting automatically alpha numerically each item.  I'll try some troubleshooting to see if i can remedy.

    Thanks again!

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at

    You may have to add a line sequence number on the source file if it is possible and then do the group by on the sequence.  Otherwise, I am not sure how to change the sort of the items.   I have not had to sort the data like that before.  Let us know if you figure it out.

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

  • Bobby Aultman Profile Picture
    Bobby Aultman 45 on at

    Resolved.  With a bit of searching, i found multiple links with others that have had the same opportunity.  Remedying the problem consisted of accessing the Microsoft.Dynamics.GP.IntegrationManager.ini file and changing the "TRUE" value to "FALSE" for the field named "UseOptimizedFiltering=False".  A quick change and reboot and the final product is exactly what we needed.  Thanks again!

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans