Skip to main content
Solved

SO Pricing and Discount Fields

  • December 15, 2022
  • 5 replies
  • 197 views

Forum|alt.badge.img

I thought I would throw this out to see if anyone operates similarly and has a solution. 

A brief overview on our Pricing Model:

We have a “National Price” list for all customers. However, generally speaking each customer has unique pricing based on T&Cs. So for example, we may pitch product A to a customer at the National Price of $100. However, the customer will say, you know we really need the price at $90 to consider you for placement. So we agree that their adjusted Gross Price will be $90. Then we have normal pricing discounts off of that $90. It may be a $5 OI discount on top of the $10 everyday discount that we already provided. So the actual price would be $90 less the OI of $5 for a Net of $85.

I would like to show gross sales at the full $100, then one discount listed at $10 (the adjust Gross discount) and then finally a $5 OI discount on all orders. So Gross sales would show $100 but Net would show $85.

The issue I am seeing is there is currently in ACU there is only one discount line available. So we have to choose between showing Gross of $100 and discounts of $15 OR Gross of $90 and discount of $5. Is there a way to have multiple discounts coming off of the $100 gross in separate discount “sections” on the SO/Invoice?  I am sure this is not available out of the box but is it a customizable solution?

 

Let me know your thoughts. 

 

Thank you!

Best answer by Kandy Beatty

byates wrote:
kandybeatty49 wrote:

HI @byates 

Have you thought about doing customer price worksheets? 

Then you could do the line discounts

 

HI @kandybeatty49,

 

We are using the Sales Prices in the Receivable Module to manage the customer list prices (“adj gross”), I have always seen the “Create Price Worksheet” but never experimented with it and not sure what it’s purpose is. I will read up on it now and see if it provides any value. Thank you for the suggestion!

HI @byates 

My second screen shot did not come through but here is a sample:

 

View original
Did this topic help you find an answer to your question?

5 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2209 replies
  • December 19, 2022

HI @byates 

Have you thought about doing customer price worksheets? 

Then you could do the line discounts

 


Forum|alt.badge.img
  • Author
  • 74 replies
  • December 20, 2022
kandybeatty49 wrote:

HI @byates 

Have you thought about doing customer price worksheets? 

Then you could do the line discounts

 

HI @kandybeatty49,

 

We are using the Sales Prices in the Receivable Module to manage the customer list prices (“adj gross”), I have always seen the “Create Price Worksheet” but never experimented with it and not sure what it’s purpose is. I will read up on it now and see if it provides any value. Thank you for the suggestion!


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2209 replies
  • Answer
  • December 20, 2022
byates wrote:
kandybeatty49 wrote:

HI @byates 

Have you thought about doing customer price worksheets? 

Then you could do the line discounts

 

HI @kandybeatty49,

 

We are using the Sales Prices in the Receivable Module to manage the customer list prices (“adj gross”), I have always seen the “Create Price Worksheet” but never experimented with it and not sure what it’s purpose is. I will read up on it now and see if it provides any value. Thank you for the suggestion!

HI @byates 

My second screen shot did not come through but here is a sample:

 


Forum|alt.badge.img
  • Author
  • 74 replies
  • December 27, 2022

Thanks for the information. I still think the fundamental issue is that I need two discounts active at the same time at the line level. Based on what I have been reading this will have to be a customization as I can’t find an answer.


Forum|alt.badge.img
  • Jr Varsity II
  • 48 replies
  • June 5, 2023

@byates If you need to capture multiple discounts or adjustments, there is a product called Rockton Pricing Management that allows you to do this.  In addition to tracking multiple discounts and adjustments, it allows you to post each to a specific GL account which can be displayed on the transaction in Acumatica.  These discounts could also be added to the invoice report.  If interested, you can find more information in the Acumatica Marketplace


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings