Skip to main content
Solved

Negative Unit Price on Sales Order no longer allowed?


chris49
Varsity II
Forum|alt.badge.img

We are currently in the process of upgrading our Acumatica instance from 22.120.0019 to 23.109.0023.

During the testing of our API integration, we have noticed that we are no longer able to push through a Sales Order that has a negative value in the Unit Price field, and we are presented with the following error:

 

Incorrect value. The value to be entered must be greater than or equal to 0.

 

I tried to capture a SO manually, to check if the same issue exists, and indeed it does:

If I attempt to save the SO, it changes the value to 0.00

 

Question:

Is this ability now completely removed, or is there a configuration setting relating to this that I can change to allow the negative value?

PS. I searched through the release notes for 22R2 & 23R1, but I couldn’t find something specific to this.

Best answer by PatrickSchlenker90

Hi @dwan 

   FYI - in 2023R1 Update 17 this behavior was changed back…

 

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

10 replies

dcomerford
Captain I
Forum|alt.badge.img+15
  • Captain I
  • 596 replies
  • September 6, 2023

We have just had a customer that was upgraded report the same issue


Robert Sternberg
Captain II
Forum|alt.badge.img+8

The new MO (Mixed Order) order type will allow for this condition, I believe this is the cause of the issue you are experiencing using the SO order type. 


Forum|alt.badge.img+2
  • Acumatica Employee
  • 38 replies
  • September 6, 2023

There were some changes made with SO lines functionality in 23R1 version.

On the Details tab of the SO301000 form:

If in sales order line Qty. field is positive this is not allowed to set line Unit Price or Ext.Price field as negative and gives error message: " The value cannot be less than zero."

If in sales order line Qty. field is negative  this is not allowed to set line Ext.Price field as positive, give error message: " The value cannot be greater than zero."

 

This was changed to avoid confusion with Unit Price and Ext.Price because it should correspond to the line quantity. 

 

To be able to support same workflow as customer had before in 22r2 there are 2 ways:

 

1. Uncheck Require Shipment for an item:

 

 

And put negative qty and Ext Cost

 

2. Leave Require Shipment as is:

 

 

And Qty = 0 and Ext Price negative


 


Hannah Barnes
Captain II
Forum|alt.badge.img+4

To add to Sheri’s Best Answer, below is further information for users.
 

Notes about the options:

Option 1 is the only option for most of these cases, because it is the only option where the Non-Stock Discount Item is carried through to the Invoice.

However, customers can face the following limitation when using Option 1:

  1. Non-stock item does not appear on the Shipment.
    1. Because a Shipment report does not put 0.00 or negative lines on the Shipment report.
        • Before, they were using positive quantities for these lines, so they WERE on the Shipment report.
    1. How do they resolve this?
        • Shipment report can be customized.
        • Use the Sales Order report instead, since it already includes all lines.
    1. Why can’t they use Option 2 and select the Require Shipment flag? 
      • Because in Option 2, the line does not appear on the Invoice, which they need.

Dana Moffat
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Moderator
  • 551 replies
  • September 20, 2023

I would like to meet with commenters on this post please.

 

Dana


  • Freshman I
  • 3 replies
  • June 7, 2024

This change is completely illogical..I can not see any reason why this was changed. There was never a confusion between unit price and extended price. 


PatrickSchlenker90
Jr Varsity II
Forum|alt.badge.img+1

Hi @dwan 

   FYI - in 2023R1 Update 17 this behavior was changed back…

 


kyoung14
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 42 replies
  • June 19, 2024

This appears to still be issue in 23.208.0026.  Anyone know what release of 23R2 they fixed?


Dana Moffat
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Moderator
  • 551 replies
  • June 19, 2024

23R2 Update 10


kyoung14
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 42 replies
  • June 19, 2024

@Dana Moffat - thank you!  I just found that too.  Unfortunately this client has a lot of customizations in general and are in the middle of their busy season so they have no appetite for even a minor upgrade.  This particular scenario is rare for them and I gave them the workaround of negative qty, 0 unit price and then type in negative Ext Price and that works for them.


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