web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Price Level by Address

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Richard Wheeler Profile Picture
    75,850 Moderator on at

    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.

  • RyanBarrus Profile Picture
    on at

    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?

  • Verified answer
    Richard Wheeler Profile Picture
    75,850 Moderator on at

    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
    on at

    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.

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans