[Sara Flaws]

We have a custom CRM product that sends orders into GP.  If an item on an order is drop shipping, our CRM is programmed so that the checkbox for Drop Ship is checked on the order automatically when the order is created. The box I’m referring to is found on the sales transaction entry screen, Line Items, under the D.

Once the order is created in our CRM, we can see that on the sales transaction entry screen everything looks fine in GP (box has a check mark). However, the drop ship process that we expect to happen is not working.  It’s not selecting the Drop Ship Items account from the item account maintenance set up.  Instead, it’s selecting the Inventory account. 

If we open the order coming from CRM and uncheck the Drop Ship box and then recheck the box, it then does pull from the Drop Ship Items account.  There is something we are missing in the process that isn’t triggering the drop ship box process to work. 

The purchasing side of things is functioning as it should, creating a drop ship purchase order which is creating an entry to the Drop Ship Items account. 

We end up with a drop ship GL account that never gets its offsetting entry so the balance just keeps growing.

Our CRM programmers are looking for help with this drop ship box process to figure out what they are missing in their programming.  Can anyone be of any help, or point us in a direction?

Thank you,

——————————
Sara Flaws
Accounting Clerk III
ADO Products LLC
Plymouth MN
——————————

[Kristen Hosman]

Hi Sara.

I to seem to have issues with DS working properly so I’m going to follow your post to see if anyone else responds.  

——————————
Kristen Hosman
Accounting Manager
PlatinumCode
Pine CO
——————————
——————————————-

[Beat Bucher]

Hi Sara,
How does your CRM process ‘enable’ the DS checkbox ? I’m wondering if it’s just setting the flag in the SOP10200 table for the DROPSHIP field to be set to 1, or if there is another process going on..
Checking this box isn’t just switching the flag from 0 to 1, there is way more that goes on behind the scene when  you do this, and your CRM process may well be missing some of them. Does it use eConnect to create the SOP document ?
Thanks for providing some more details to understand what’s happening in your system.

——————————
Beat Bucher
Business Analyst, Dynamics GP MVP
Ultra-Electronics Forensic Technology Inc.
Montreal QC/Canada
+1-514-489-4267
@GP_Beat http://dyngpbeat.wordpress.com/
Montreal QC GPUG Chapter Leader
GP2013R2 / MR2012 CU14
——————————
——————————————-