Customers Categories

1

In Have Seen Many Topics On forum Asking for Multiple Selling Prices For Each Inventory Item and Experienced Forum Members Saying Not Possible to Include As It increase the Pricing entries Dramatically.
So, I have A Simple And easy Solution for this Problem which Gives Multiple Selling Prices Per Item And There is Not a Big Change in Pricing Entries:-
The Solution:-
If We Add Categories in Customers Master Data-
Like This

  1. Wholesale Customer
  2. Retail Customer
    Whenever We Create a New Customer, We Will Assign it to One of the above categories according to his Status.
    And
    In Inventory Masters There Must Ba Fields for Indicating Price For Each category of Customer.
    Like This-
    Inventory Item A
Customer Category Price
Cash Sale Rs 500
Retail Customer Rs 525
Wholesale Customer Rs 480
  • Wholesale Price is used when Sale Is made To A Wholesale Customer ( Customers Whose Category is Selected as Wholesale Customer ).
  • Retail Price is used when Sale Is made To A Retail Customer ( Customers Whose Category is Selected as Retail Customer ).
  • Cash Sale Price is used When We Do Not Select Any Customer While Making Sale ( Like Sale By Use of Receipt Tab ).

So, This Will Solve the Issue Of Multiple Sale Prices For a Single Inventory Item &

It will Not Increase the Price Entries to Millions @Tut.
Example- Let’s Have A Company With 2000 Customers Which Is divided into 3 Categories and There is 5000 Inventory Items.
So,

Current pricing Entries (Without Customer Categories) New Pricing Entries ( With Customer Categories )
5000*1 = 5000 5000*3 + 5000*1 = 20000

Conclusion:- With Implementation of Customer Categories Pricing Entries Will Just Increase By No of Categories +1 * No Of Inventory Items Only.
It Needs 9 Customer Categories And 100k Inventory Items to Have 1 million Pricing Entries.
This Will Solve The Multiple Times Demanded Feature Without Increasing Complexity of The Software.

Note:-

If Price Is Manually Inserted By the User While Making Sale. Then, The Price Recorded in Master Data Should Not Override The Price Inserted Manually.
This Will Prevent the Above Described Assumption.
But In Fixed Price Shops, there is very Less Chances of Negotiation with Customers

1 Like
2

what you have suggested is your requirement. but majority of users need customer-wise price list, not category based price list. if you search the forum there have already been many discussions related to customer price lists and also inventory prices when the customer currency is different.

3

It is Still Possible @sharpdrivetek
As , List is Created For customers grouped under Their Respective Categories

4

no. what I meant was different business fix price list based on different concepts. they are not always based on the customer type. one business might give different discount rates from a master price list while another business would workout a unique price list for individual items for every customer. so the suggestion of categorizing customers and creating price list for these categories is a bad idea in my opinion. a suggestion should be beneficial to every type of business requirement.

1 Like
5

@Omnipotent.inc Customer Category is a brilliant concept. It would be ideal for businesses that offer membership tiers for their customers, such as Gold, Platinum, and Standard. But the ability to enter a unique price list for Customers would be a preferable alternative for the reasons @sharpdrivetek cited.

6

This topic is a duplicate. It is now closed.