We operate a wholesale business where all of our customers are assigned a discount level off of our list price. Some customers also have customer specific prices on a few items that we have negotiated. This was a simple structure to manage in quickbooks using pricing rules but seems to be very complex to set up in acumatica. Wondering if anyone else has come up with a good way to make this work in acumatica.
Our challenges:
- Utilizing Sales price worksheets we can set up a worksheet for each discount level using customer price classes. We can also set up a customer specific worksheet for the special pricing some customers receive. Both of these function perfectly. Our problem is that we add items on a daily basis and using the above method we will have to manually create a new price worksheet for every new item we create.
- Utilizing Discount codes we can set up a discount code for each discount level and assign those to our customers however these discounts apply to everything including any customer specific pricing a customer might have meaning that it often will end up pricing products below our cost in these scenarios.
Has anyone else come up with a workaround for this?
Quickbooks has similar functionality but on the customer specific price list it has a checkbox for “Exclusive” which means when this pricing is used do not combine any other price rules. It seems like this could be replicated on the sales price worksheet by adding this checkbox which will then tell the system not to apply any discount codes on top of the customer specific pricing.