[solved] 4.03, N. American Release, Customer Ship-To

MW59
MW59 Member Posts: 85
Hello...

Does anyone know if there's user functionality that permits one to declare a Customer Ship-To Code to default and validate on Sales Order headers or is that a Programming change?

Thanks,
mw
I despise animal testing. They get all nervous and give the wrong answers.

Comments

  • ara3n
    ara3n Member Posts: 9,258
    It's a programming change. It's very small and would take less then 20 min.

    Basically create a new field in customer table called default ship-to code. Set the relationship to ship-to address table


    Then in sales header.
    in the following trigger
    Sell-to Customer No. - OnValidate()


    change this code to

    //start modification
    //VALIDATE("Ship-to Code",'');

    GetCust("Sell-to Customer No.");
    VALIDATE("Ship-to Code",Cust."Default Ship-to Code");
    //end modification
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • MW59
    MW59 Member Posts: 85
    Cool! ... thanks very much, ara3n.

    I suspected it wasn't standard, but decided I should check. There's so much to know.

    mw
    I despise animal testing. They get all nervous and give the wrong answers.
  • ara3n
    ara3n Member Posts: 9,258
    This is one of those things that is nice to have. I don't know why navision didn't added as standard feature. My guess, they sell it as a separate granuale ship-to address.

    On the other side, kine would say that it would require hundreds of hours of testing and programming in order to get this into Navision spX
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Miklos_Hollender
    Miklos_Hollender Member Posts: 1,629
    I think because the default address is the one on the customer card. Why does anyone need a second default?
  • ara3n
    ara3n Member Posts: 9,258
    it's not in world wide and not in US.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • DenSter
    DenSter Member Posts: 8,307
    It's not a matter of 'a second default', it's a matter of having one 'Default shipping address'. There are many companies that have a main warehouse where they want their orders to be shipped to, with a different physical address than the main office, or that have their mail delivered to a PO box. It would be nice to have the option to use ship-tos and mark one of them as the default one.
  • MW59
    MW59 Member Posts: 85
    DenSter wrote:
    It would be nice to have the option to use ship-tos and mark one of them as the default one.
    Exactly! The customer I'm implementing is departing an aged application called FACTS that facilitated precisely that.

    mw
    I despise animal testing. They get all nervous and give the wrong answers.
  • DenSter
    DenSter Member Posts: 8,307
    MW, this is a very easy modification. Your solution center should be able to do it within a few hours.
  • ara3n
    ara3n Member Posts: 9,258
    I like my solution better Denster.
    It's one line of code in sales header, and one new field in customer table.

    :mrgreen: :oops:
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n