Open Forum

Is there anyone who has had the issue of GP 2015, not printing the correct ship to address on the order sheet and packing slip? The correct address is on the picking slip, just not the others. I have created an SQL script to roll down the ship to header to the line items. Yes it is a fix, but I would like to know the reason why it did this in the first place.

------------------------------
Chase Landorf
Inventory Control & Accounting
Ideal Deals, LLC dba Ideal Aluminum Products
Saint Augustine FL
------------------------------

Chase,
It's possible that it's due to a ship to address change at the header level after the lines have already been entered.  If you do change the header after lines exist, GP will ask if you want to roll the change down to the lines.  If you say No, then you'll see what you're seeing.
Thanks
Windi

------------------------------
Windi Epperson
President/GP Senior Consultant
Advanced Integrators, Inc.
Norman OK
405-946-1774 Ext 102
------------------------------

Original Message:
Sent: 07-27-2017 11:15 AM
From: Chase Landorf
Subject: Header address and ship to address do not match

Is there anyone who has had the issue of GP 2015, not printing the correct ship to address on the order sheet and packing slip? The correct address is on the picking slip, just not the others. I have created an SQL script to roll down the ship to header to the line items. Yes it is a fix, but I would like to know the reason why it did this in the first place.

------------------------------
Chase Landorf
Inventory Control & Accounting
Ideal Deals, LLC dba Ideal Aluminum Products
Saint Augustine FL
------------------------------

Hi Chase,
I recall a long time ago (GP 7 or 8) that the shipto address in the SOP module wasn't pulled from the same place on the picklist report & the Sales order report.. However, as Windi suggested, do you have someone that updated the header in the Sales Order and then just rolled down the update to all the line items ?
Also, do you use any sort of integration process for your sales order ? that may explain the strange behavior...

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

Original Message:
Sent: 07-27-2017 11:15 AM
From: Chase Landorf
Subject: Header address and ship to address do not match

Is there anyone who has had the issue of GP 2015, not printing the correct ship to address on the order sheet and packing slip? The correct address is on the picking slip, just not the others. I have created an SQL script to roll down the ship to header to the line items. Yes it is a fix, but I would like to know the reason why it did this in the first place.

------------------------------
Chase Landorf
Inventory Control & Accounting
Ideal Deals, LLC dba Ideal Aluminum Products
Saint Augustine FL
------------------------------

​We've had that same issue before too. It happened when the header address changed after line items had been entered but the user did not click to roll down the changes to all line items. Besides running a script, if you don't have a lot of line items, you can also change it directly from the line item. You can also update shipping methods this way.

------------------------------
Aleiha Hanson
Database Admin
Royal Basket Trucks, Inc
Darien WI
------------------------------

Original Message:
Sent: 07-27-2017 11:15 AM
From: Chase Landorf
Subject: Header address and ship to address do not match

Is there anyone who has had the issue of GP 2015, not printing the correct ship to address on the order sheet and packing slip? The correct address is on the picking slip, just not the others. I have created an SQL script to roll down the ship to header to the line items. Yes it is a fix, but I would like to know the reason why it did this in the first place.

------------------------------
Chase Landorf
Inventory Control & Accounting
Ideal Deals, LLC dba Ideal Aluminum Products
Saint Augustine FL
------------------------------

Anyone know how to update an address on a SOP line item that's drop ship from a vendor?  We don't always have the ship to address immediately but want to get the vendor PO off asap so that part of the order isn't delayed.  When we have the ship to address, we enter it at the header, roll it down to the lines, but you can't roll an address down to drop ship lines.  We have AvaTax calculating sales tax so not having addresses causes issues for our customer service team.

We're on GP2015, if that matters.



------------------------------
Kristy James
Financial Controller
Dairyland Electrical Industries, Inc
Stoughton
------------------------------

Original Message:
Sent: Jul 27, 2017 11:15 AM
From: Chase Landorf
Subject: Header address and ship to address do not match

Is there anyone who has had the issue of GP 2015, not printing the correct ship to address on the order sheet and packing slip? The correct address is on the picking slip, just not the others. I have created an SQL script to roll down the ship to header to the line items. Yes it is a fix, but I would like to know the reason why it did this in the first place.

------------------------------
Chase Landorf
Inventory Control & Accounting
Ideal Deals, LLC dba Ideal Aluminum Products
Saint Augustine FL
------------------------------

Hi @Kristy James or @Kristy James

At issue is the Commitments you have turned on in Purchase Orders, once a line item is listed as committed, it really can't be changed.

Let me ask you on the drop-ships PO's how are you updating the vendor to what customer address to ship these to after you do know the address?  If we can figure that out we might be able to assist with more targeted suggestions on how to do this where you don't encounter this error.

That or you can turn off commitments by unchecking THIS box when entering these particular types of Drop-Ship POs:


​​

------------------------------
Jo deRuiter
🌟 GPUG AllStar 2019
💫Granite Award Winner 2018,2019
Atlanta Chapter Leader
Credential Council Co-Chair
Aisling Dynamics Consulting, LLC
ERP Practice Manager
jo.deruiter@aislingdynamics.com
9518674366
Alpharetta, GA
aislingdynamics.com
------------------------------

Original Message:
Sent: Feb 16, 2021 04:44 PM
From: Kristy James
Subject: Header address and ship to address do not match

Anyone know how to update an address on a SOP line item that's drop ship from a vendor?  We don't always have the ship to address immediately but want to get the vendor PO off asap so that part of the order isn't delayed.  When we have the ship to address, we enter it at the header, roll it down to the lines, but you can't roll an address down to drop ship lines.  We have AvaTax calculating sales tax so not having addresses causes issues for our customer service team.

We're on GP2015, if that matters.



------------------------------
Kristy James
Financial Controller
Dairyland Electrical Industries, Inc
Stoughton

Original Message:
Sent: Jul 27, 2017 11:15 AM
From: Chase Landorf
Subject: Header address and ship to address do not match

Is there anyone who has had the issue of GP 2015, not printing the correct ship to address on the order sheet and packing slip? The correct address is on the picking slip, just not the others. I have created an SQL script to roll down the ship to header to the line items. Yes it is a fix, but I would like to know the reason why it did this in the first place.

------------------------------
Chase Landorf
Inventory Control & Accounting
Ideal Deals, LLC dba Ideal Aluminum Products
Saint Augustine FL
------------------------------

Thanks for the reply @Jo deRuiter!  When the SOP address issue arises, we are sending 2 POs to our vendor: 1st one without a ship-to address, so they can start production, and a 2nd manually updated pdf that includes the ship-to address.  If we can wait to create the vendor PO until we have the address, we do, but sometimes our vendors have longer lead times due to volume so we want to get their process moving as promptly as possible.

What happens if we uncheck that box?  Does the vendor PO still connect to the SOP document?  And if not, can it be reconnected?  We do occasionally have to chase from customer order to vendor order, if there's an issue with the vendors product/lost in shipment/etc. so it is very helpful to have the pieces connected.

------------------------------
Kristy James
Financial Controller
Dairyland Electrical Industries, Inc
Stoughton
------------------------------

Original Message:
Sent: Feb 17, 2021 07:24 AM
From: Jo deRuiter
Subject: Header address and ship to address do not match

Hi @Kristy James or @Kristy James

At issue is the Commitments you have turned on in Purchase Orders, once a line item is listed as committed, it really can't be changed.

Let me ask you on the drop-ships PO's how are you updating the vendor to what customer address to ship these to after you do know the address?  If we can figure that out we might be able to assist with more targeted suggestions on how to do this where you don't encounter this error.

That or you can turn off commitments by unchecking THIS box when entering these particular types of Drop-Ship POs:


​​

------------------------------
Jo deRuiter
🌟 GPUG AllStar 2019
💫Granite Award Winner 2018,2019
Atlanta Chapter Leader
Credential Council Co-Chair
Aisling Dynamics Consulting, LLC
ERP Practice Manager
jo.deruiter@aislingdynamics.com
9518674366
Alpharetta, GA
aislingdynamics.com

Original Message:
Sent: Feb 16, 2021 04:44 PM
From: Kristy James
Subject: Header address and ship to address do not match

Anyone know how to update an address on a SOP line item that's drop ship from a vendor?  We don't always have the ship to address immediately but want to get the vendor PO off asap so that part of the order isn't delayed.  When we have the ship to address, we enter it at the header, roll it down to the lines, but you can't roll an address down to drop ship lines.  We have AvaTax calculating sales tax so not having addresses causes issues for our customer service team.

We're on GP2015, if that matters.



------------------------------
Kristy James
Financial Controller
Dairyland Electrical Industries, Inc
Stoughton

Original Message:
Sent: Jul 27, 2017 11:15 AM
From: Chase Landorf
Subject: Header address and ship to address do not match

Is there anyone who has had the issue of GP 2015, not printing the correct ship to address on the order sheet and packing slip? The correct address is on the picking slip, just not the others. I have created an SQL script to roll down the ship to header to the line items. Yes it is a fix, but I would like to know the reason why it did this in the first place.

------------------------------
Chase Landorf
Inventory Control & Accounting
Ideal Deals, LLC dba Ideal Aluminum Products
Saint Augustine FL
------------------------------

Original Message:
Sent: 2/17/2021 6:09:00 PM
From: Kristy James
Subject: RE: Header address and ship to address do not match

Thanks for the reply @Jo deRuiter!  When the SOP address issue arises, we are sending 2 POs to our vendor: 1st one without a ship-to address, so they can start production, and a 2nd manually updated pdf that includes the ship-to address.  If we can wait to create the vendor PO until we have the address, we do, but sometimes our vendors have longer lead times due to volume so we want to get their process moving as promptly as possible.

What happens if we uncheck that box?  Does the vendor PO still connect to the SOP document?  And if not, can it be reconnected?  We do occasionally have to chase from customer order to vendor order, if there's an issue with the vendors product/lost in shipment/etc. so it is very helpful to have the pieces connected.

------------------------------
Kristy James
Financial Controller
Dairyland Electrical Industries, Inc
Stoughton
------------------------------

Original Message:
Sent: Feb 17, 2021 07:24 AM
From: Jo deRuiter
Subject: Header address and ship to address do not match

Hi @Kristy James or @Kristy James

At issue is the Commitments you have turned on in Purchase Orders, once a line item is listed as committed, it really can't be changed.

Let me ask you on the drop-ships PO's how are you updating the vendor to what customer address to ship these to after you do know the address?  If we can figure that out we might be able to assist with more targeted suggestions on how to do this where you don't encounter this error.

That or you can turn off commitments by unchecking THIS box when entering these particular types of Drop-Ship POs:


​​

------------------------------
Jo deRuiter
🌟 GPUG AllStar 2019
💫Granite Award Winner 2018,2019
Atlanta Chapter Leader
Credential Council Co-Chair
Aisling Dynamics Consulting, LLC
ERP Practice Manager
jo.deruiter@aislingdynamics.com
9518674366
Alpharetta, GA
aislingdynamics.com

Original Message:
Sent: Feb 16, 2021 04:44 PM
From: Kristy James
Subject: Header address and ship to address do not match

Anyone know how to update an address on a SOP line item that's drop ship from a vendor?  We don't always have the ship to address immediately but want to get the vendor PO off asap so that part of the order isn't delayed.  When we have the ship to address, we enter it at the header, roll it down to the lines, but you can't roll an address down to drop ship lines.  We have AvaTax calculating sales tax so not having addresses causes issues for our customer service team.

We're on GP2015, if that matters.



------------------------------
Kristy James
Financial Controller
Dairyland Electrical Industries, Inc
Stoughton

Original Message:
Sent: Jul 27, 2017 11:15 AM
From: Chase Landorf
Subject: Header address and ship to address do not match

Is there anyone who has had the issue of GP 2015, not printing the correct ship to address on the order sheet and packing slip? The correct address is on the picking slip, just not the others. I have created an SQL script to roll down the ship to header to the line items. Yes it is a fix, but I would like to know the reason why it did this in the first place.

------------------------------
Chase Landorf
Inventory Control & Accounting
Ideal Deals, LLC dba Ideal Aluminum Products
Saint Augustine FL
------------------------------

@Kristy James or @Kristy James

Not using the commitment (unchecking it) did not seem to affect my ability to receive/invoice from the vendor nor transfer the SOP document to invoice.​

Commitments are usually about other than the SOP to POP link, so do check within your organization to find out why the Commitments are turned on.  If there seems to be no reason why then I would recommend creating or updating your Test Company and turning OFF PO Commitments and running through a few tests of not only the Drop Ship PO's but other types of PO's as well.

If it all works correctly in the Test Company, then you can turn them off in Live.

Commitments are usually used for budgeting and other ​Purchasing authorizations and have, really, nothing to do with Sales or how the POP system works.

BUT, before doing anything check organization-wide to see why they were turned on in the first place before turning them off.

------------------------------
Jo deRuiter
🌟 GPUG AllStar 2019
💫Granite Award Winner 2018,2019
Atlanta Chapter Leader
Credential Council Co-Chair
Aisling Dynamics Consulting, LLC
ERP Practice Manager
jo.deruiter@aislingdynamics.com
9518674366
Alpharetta, GA
aislingdynamics.com
------------------------------

Original Message:
Sent: Feb 17, 2021 06:08 PM
From: Kristy James
Subject: Header address and ship to address do not match

Thanks for the reply @Jo deRuiter!  When the SOP address issue arises, we are sending 2 POs to our vendor: 1st one without a ship-to address, so they can start production, and a 2nd manually updated pdf that includes the ship-to address.  If we can wait to create the vendor PO until we have the address, we do, but sometimes our vendors have longer lead times due to volume so we want to get their process moving as promptly as possible.

What happens if we uncheck that box?  Does the vendor PO still connect to the SOP document?  And if not, can it be reconnected?  We do occasionally have to chase from customer order to vendor order, if there's an issue with the vendors product/lost in shipment/etc. so it is very helpful to have the pieces connected.

------------------------------
Kristy James
Financial Controller
Dairyland Electrical Industries, Inc
Stoughton

Original Message:
Sent: Feb 17, 2021 07:24 AM
From: Jo deRuiter
Subject: Header address and ship to address do not match

Hi @Kristy James or @Kristy James

At issue is the Commitments you have turned on in Purchase Orders, once a line item is listed as committed, it really can't be changed.

Let me ask you on the drop-ships PO's how are you updating the vendor to what customer address to ship these to after you do know the address?  If we can figure that out we might be able to assist with more targeted suggestions on how to do this where you don't encounter this error.

That or you can turn off commitments by unchecking THIS box when entering these particular types of Drop-Ship POs:


​​

------------------------------
Jo deRuiter
🌟 GPUG AllStar 2019
💫Granite Award Winner 2018,2019
Atlanta Chapter Leader
Credential Council Co-Chair
Aisling Dynamics Consulting, LLC
ERP Practice Manager
jo.deruiter@aislingdynamics.com
9518674366
Alpharetta, GA
aislingdynamics.com

Original Message:
Sent: Feb 16, 2021 04:44 PM
From: Kristy James
Subject: Header address and ship to address do not match

Anyone know how to update an address on a SOP line item that's drop ship from a vendor?  We don't always have the ship to address immediately but want to get the vendor PO off asap so that part of the order isn't delayed.  When we have the ship to address, we enter it at the header, roll it down to the lines, but you can't roll an address down to drop ship lines.  We have AvaTax calculating sales tax so not having addresses causes issues for our customer service team.

We're on GP2015, if that matters.



------------------------------
Kristy James
Financial Controller
Dairyland Electrical Industries, Inc
Stoughton

Original Message:
Sent: Jul 27, 2017 11:15 AM
From: Chase Landorf
Subject: Header address and ship to address do not match

Is there anyone who has had the issue of GP 2015, not printing the correct ship to address on the order sheet and packing slip? The correct address is on the picking slip, just not the others. I have created an SQL script to roll down the ship to header to the line items. Yes it is a fix, but I would like to know the reason why it did this in the first place.

------------------------------
Chase Landorf
Inventory Control & Accounting
Ideal Deals, LLC dba Ideal Aluminum Products
Saint Augustine FL
------------------------------