Open Forum

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

1.  Sale Item by Ship to Address

Posted 8 days ago
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.

------------------------------
Xan
Katy TX
------------------------------


2.  RE: Sale Item by Ship to Address

TOP CONTRIBUTOR
Posted 8 days ago
​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

GOLD CONTRIBUTOR
Posted 7 days ago
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

TOP CONTRIBUTOR
Posted 7 days ago
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
------------------------------