Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Sales Order ShipTo address being ignored in BOI call

  • 1.  Sales Order ShipTo address being ignored in BOI call

    Posted 05-03-2023 12:27

    I have a C# dotNet 4.8 web application providing API services into Sage 100, working fine at multiple sites.  At one customer, the Sales Order BOI seems to ignore the ShipToAddress fields on the sales order.  Avatax and Scanforce are installed on this site as well, but from the UI you can enter a custom shipto address successfully.  No errors are returned, it just creates the order with the bill to info in the shipto fields (or the primary shipto info if the customer has one).

    Anyone seen this before or have an idea on what could be wrong?



    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    ------------------------------


  • 2.  RE: Sales Order ShipTo address being ignored in BOI call

    Posted 05-04-2023 07:20

    I haven't seen that specifically, but does it only happen during SO creation? Are you able to change the ShipToAddress via API for existing SOs?



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------



  • 3.  RE: Sales Order ShipTo address being ignored in BOI call

    Posted 10-05-2023 14:40

    Change for existing SOs doesn't work either...



    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    ------------------------------

    Original Message


  • 4.  RE: Sales Order ShipTo address being ignored in BOI call

    Posted 10-05-2023 14:52

    What version?



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------

    Original Message


  • 5.  RE: Sales Order ShipTo address being ignored in BOI call

    Posted 10-05-2023 15:41

    2021



    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    ------------------------------

    Original Message


  • 6.  RE: Sales Order ShipTo address being ignored in BOI call

    Posted 10-05-2023 15:49

    Are you just using a SetValue for those fields? What happens if you try SetValueNoValidate to bypass any validation routines?



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------

    Original Message


  • 7.  RE: Sales Order ShipTo address being ignored in BOI call

    Posted 10-05-2023 15:51

    Or is it being just overwritten on Order Write?



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------

    Original Message


  • 8.  RE: Sales Order ShipTo address being ignored in BOI call

    Posted 10-05-2023 16:10

    How would I tell?



    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    ------------------------------

    Original Message


  • 9.  RE: Sales Order ShipTo address being ignored in BOI call

    Posted 10-05-2023 16:17

    Ha, good question. I'd guess if you SetValueNoValidate and the field is still created with the wrong data, then something else is short-circuiting it and you get to play the rename Links files game. My money would be on AvaTax...



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------

    Original Message


  • 10.  RE: Sales Order ShipTo address being ignored in BOI call

    Posted 10-09-2023 16:56

    SetValueNoValidate did not help.  Now to arrange a time to get everyone out so we can test the links trick...



    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    ------------------------------

    Original Message


  • 11.  RE: Sales Order ShipTo address being ignored in BOI call

    Posted 10-05-2023 14:17

    Coming back around to this:  the site where it is not accepting the shipto address info on sales orders and instead uses the default shipto info has Avatax installed, though this is in a test company where no account number is filled in for the Avatax setup.  Any ideas?  Address validation in the Avatax setup screen is NOT checked..



    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    ------------------------------



  • 12.  RE: Sales Order ShipTo address being ignored in BOI call

    Posted 12-07-2023 16:29
      |   view attached

    Got the customer's data on the dev server and found that the ShipTo Address fields are all in SO_SalesOrderDetail as well as the header file!!!  Is this something Avatax does?  Or Scanforce?  Or is this one customer's data dictionary just hosed?



    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    ------------------------------

    Original Message


  • 13.  RE: Sales Order ShipTo address being ignored in BOI call

    Posted 12-08-2023 09:24

    LM | Setup | AvaTax Configuration

    There is an option to enable Ship To Address by Line.



    ------------------------------
    Bob Pfahnl
    Manager - Silicon Valley
    DSD Business Systems
    ------------------------------

    Original Message


  • 14.  RE: Sales Order ShipTo address being ignored in BOI call

    Posted 12-08-2023 09:40

    I just checked with an avatax customer and they also have those ShipTo fields in Detail.



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------

    Original Message


Related Content