Open Forum

Expand all | Collapse all

Header address and ship to address do not match

  • 1.  Header address and ship to address do not match

    TOP CONTRIBUTOR
    Posted Jul 27, 2017 11:15 AM
    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
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Header address and ship to address do not match

    GPUG ALL STAR
    Posted Jul 28, 2017 09:34 AM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Header address and ship to address do not match

    GPUG ALL STAR
    Posted Jul 31, 2017 11:17 AM
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Header address and ship to address do not match

    GPUG ALL STAR
    Posted Jul 31, 2017 11:41 AM
    ​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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Header address and ship to address do not match

    Posted 15 days ago
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Header address and ship to address do not match

    GPUG ALL STAR
    Posted 14 days ago
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 7.  RE: Header address and ship to address do not match

    Posted 14 days ago
    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
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 8.  RE: Header address and ship to address do not match

    GPUG ALL STAR
    Posted 13 days ago

    @Kristy James

     

    I will test out the Commitment issue and let you know!

     

    Please Remember to email support.desk@aislingdynamics.com
    for any support issues or questions not related to a particular project

    Thanks!!

    Kindest Regards,

    Jo deRuiter

    Business Applications Practice Manager

     at 

    Aisling Dynamics

    Phone: (770) 728-8083 Ext 1

    Mobile: (770) 906-4504

    Email: jo.deruiter@aislingdynamics.com

    HTTPS://WWW.AISLINGDYNAMICS.COM/

    FOR IMMEDIATE ASSISTANCE WITH SUPPORT ISSUES
    PLEASE EMAIL:
    SUPPORT.DESK@AISLINGDYNAMICS.COM

    OR CLICK THE LINK TO THE RIGHT

    Schedule a Meeting with Me

    Review Aisling Dynamics on Google

    This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. This message contains confidential information and is intended only for the individuals named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

     




    Academy - Online Interactive Learning from Experts


  • 9.  RE: Header address and ship to address do not match

    GPUG ALL STAR
    Posted 13 days ago
    @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
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role