Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Price Level by Address
Microsoft Dynamics GP (Archived)

Price Level by Address

(0) ShareShare
ReportReport
Posted on by RyanBarrus

What is the standard practice for building price lists for individual customers with multiple addresses? Some customers want to have a separate freight surcharge depending on the location, other customers want the freight difference built into the actual price of the item.

Currently our database consists of some customers with multiple addresses, and other customers are split into multiple customer numbers with a single ship to address for each number. In the case where customers are split into various customer numbers each of those numbers can be assigned a price level with individualized prices. My first guess is that this is not recommended for reasons such as reporting from SOP30200. How then would you build different price levels for the various addresses? 

 

As we manually enter sales information it isn't a major issue; however, as we implement EDI the problem becomes more obvious.

*This post is locked for comments

  • RyanBarrus Profile Picture
    RyanBarrus on at
    RE: Price Level by Address

    That is a great idea for a customization and I can see how that would work. I am new to GP and so when I see things like this that don't work in our system I don't know if it can't work (without customization) or if we just aren't using the software correctly. Maybe this is a case where customization is the only option for GP, and the answer to my question of what similar companies do is that or use an alternative ERP.

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Price Level by Address

    If you look at the customer address screen you will not find a field equivalent to the price level field that exists on the customer card. However, there are two user defined fields on the address card.  If you were to populate one of those fields with the same price level values you use on customer cards you should be able to accomplish what you need. Now a customization could be created on the SOP transaction screen to capture that value and substitute this value for the price level on the customer card. If I were a Dexterity programmer that is what I would use to create this customization. This way the algorithm that calculates the sell price does not change only the source of the price level value changes.

  • RyanBarrus Profile Picture
    RyanBarrus on at
    RE: Price Level by Address

    Thank you for the response! I am certain there are other companies that sell to customers in varying locations that require changes in price to the same items...

    So do most of these companies split single customers into various customer numbers depending on their pricing needs? Or do they accomplish the pricing difference by freight surcharges?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at
    RE: Price Level by Address

    Without some customization this would not be possible in GP. Price Levels are customer specific not customer address specific. I suppose depending on how you price your items and perhaps using U/M in a non-standard way you may be able to come up with something.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans