Solved

'Customer Group' Concept

  • 15 June 2023
  • 3 replies
  • 132 views

We are trying to create a concept of a Customer Group assignment. These groups would link many items/prices with many customers. We want these customer groups to be eligible for agreed upon pricing for a list of items where the total purchase qty would be added together to meet the agreed upon purchase quantities.

Additionally, customers in this group may designated some of their distributors or their customers to also be able to purchase these same items directly at the same prices and be included in the total qty purchased reporting. 

 

If any partners have ran into the same issue with their customers, or if you have any suggestions on how to do this in Acumatica, please comment!

icon

Best answer by meganfriesen37 19 June 2023, 23:01

View original

3 replies

Userlevel 7
Badge +10

Have you looked into Customer Price Classes?
Check out the documentation here:
Customer Price Classes - Form Reference

Sales Prices - General Information

Yes, but I don’t think price lists can solve the issue because customers can buy the same product at two different prices.

The pricing we need is for customers that are somewhat “children” to another customer. For example, Company A has Company B, C, and D use the same designs, vendors, and materials as them to make their product. So Company A is buying 10,000 units of product from the vendor but not directly - through their affiliates, Company B, C and D. Essentially the 3 “children” companies are buying product on behalf of Company A with Company A’s agreed contract pricing. However, they are just affiliates, not parent/children companies. We also are needing to find a way to report how much is purchased by and on behalf of Company A. 

Can this only be done through customization? 

sorry if this explanation is complex, I’m new at all this technical stuff!

Userlevel 7
Badge +10

I’m not totally sure what you mean that “Customers can buy the same product at 2 different prices”

Take a look at the Automatic Price Selection flowchart here: https://help.acumatica.com/(W(5))/Help?ScreenId=ShowWiki&pageid=e0863703-06d1-415e-8e5a-c736fc4a965f

From your example above, if Companies A, B, C, and D are part of “Price Class A” and all buy Part X for $10 each but Company E buys Part X at $12 each, then Customer Price classes should work.

  • Company A, B, C, D would be part of “Price Class A” and this pricing would apply to them (plus any other companies in the price class)
  • Company E could either be picking up customer specific pricing, price class pricing (for a different class), or just the default item price

If Companies A, B, C, D buy Part X at $10 if they purchase less than 100 units, and they purchase it for $8 if they purchase 100 or more units, customer price classes will work, but you just need to add the quantity break points. More info here: Volume Specific Pricing.  This can still work together with the price class.

If Company “B” can buy the same item at various quantities but is only sometimes eligible to get the “Price Class A” pricing of $10, and other times have to pay the default price of $12, I think you’d maybe have to have 2 “Locations” of company B (since you can have different price classes by location)

There isn’t a report out of the box that I can see that would report on sales by Price Class, but you could likely customize an existing report to add this filter.  There is a Sales Profitability by Customer Class and it seems like it would be fairly straightforward to change Customer Class to Customer Price Class as the filter.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved