Open Forum

Like what you see? Discover the benefits of the NAVUG Community. Learn More

Sale Item by Ship to Address

  • 1.  Sale Item by Ship to Address

    Posted 02-13-2018 04:01 PM
    We have a customer with, multiple ship to addresses, that we need to allocate discounted pricing according to their specific "ship to addresses".  Does anyone have any ideas on how to do that, besides creating special item numbers for the discounted pricing?

    We are using NAV 2013 RTC.

    Katy TX

  • 2.  RE: Sale Item by Ship to Address

    Posted 02-13-2018 04:34 PM
    ​I think instead of setting up different ship-to addresses, you might be able to create different sell-to customer cards for each ship-to, set up the pricing/discounting for each, and make sure each sell-to has a bill-to customer set on the Invoice tab of the customer card.

    You should try this first in a test environment to make sure you are getting your desired results.  This may also affect some sales reports that will report by sell-to and not bill-to.

    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA

    NAVUG Board of Advisors, Programming
    NAVUG Programming Committee
    NAVUG Membership Committee

  • 3.  RE: Sale Item by Ship to Address

    Posted 02-14-2018 12:25 AM
    I agree with Lewis that you would need to add separate customers for each ship-to address so you can setup different sales prices for each of these and if those customers you like to bill-to one customer than specify bill-to Customer. This way your ledger entries are still combined in one place to the Bill-to customer

    Naveen Jain
    Director of IT
    Symbex Companies
    Santa Fe Springs CA

  • 4.  RE: Sale Item by Ship to Address

    Posted 02-14-2018 03:31 PM
    The suggested way is the only Standard NAV way that I can think of. Otherwise it'd be a mod, and I don't think it's worth it.

    I go with @Lewis Rosenberg and @Naveen Jain!​​​​

    Val Gameiro
    Senior NAV Analyst
    BPL Plasma Inc.
    Austin, Texas
    NAVUG Austin Chapter Leader