Skip to main content
Solved

Adjusting Unit Price on Sales Order after Shipping but before Invoicing


Forum|alt.badge.img+1

Hi All,

 

We are the option of adjusting the Unit Price for a Sales Order after a Shipment was created and/or completed. In Sales Order status language in the Status of Shipping/Back Order/Complete.

The Invoice won’t be created yet. And the goal is to have the Order and Invoice match up in case of Error on original Price Entry and it going through Approval without being caught.

 

I tried Workflow Adjustments and Graph Extension on the SOOrderEntry Graph but wasn’t able to Enable the Unit Price field. I tried both Cury Unit Price and Unit Price.

 

Any ideas on how to achieve this or is this something that Acumatica just doesn’t allow due to being too risky/invasive?

Best answer by Naveen Boga

Hi @krausef77  It is possible, I just created a new customization package and attached here.

Also, please find the screenshots for reference.

 

When Sales Order is created - Unit Price is 500

 

After Shipment is confirmed, I changed Unit Price to 888

 

 

After Preparing the Invoice, the Unit Price carried from Sales Order to Invoice.

 

 

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

8 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • Answer
  • April 18, 2023

Hi @krausef77  It is possible, I just created a new customization package and attached here.

Also, please find the screenshots for reference.

 

When Sales Order is created - Unit Price is 500

 

After Shipment is confirmed, I changed Unit Price to 888

 

 

After Preparing the Invoice, the Unit Price carried from Sales Order to Invoice.

 

 


Forum|alt.badge.img+1
  • Author
  • Semi-Pro I
  • 177 replies
  • April 18, 2023
Naveen Boga wrote:

Hi @krausef77  It is possible, I just created a new customization package and attached here.

Also, please find the screenshots for reference.

 

When Sales Order is created - Unit Price is 500

 

After Shipment is confirmed, I changed Unit Price to 888

 

 

After Preparing the Invoice, the Unit Price carried from Sales Order to Invoice.

 

 

Thank you so much! I had a condition in my Graph Extension that was relying on the Status rather than just utilizing the combo of Graph Extension and Workflow Engine.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • April 18, 2023

Awesome :)  

I’m glad that I helped you with this :) @krausef77 


Forum|alt.badge.img
  • Jr Varsity II
  • 39 replies
  • May 12, 2023

@Naveen Boga  Hi Naveen, is this customization usable to all?  I tried publishing in my demo instance and it failed, maybe it’s just meant for training/teaching?

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • May 13, 2023

Hi @dgross  The above issue is related to namespace, where the created DAC is not able to access.

Please add right namespace to fix this issue.

OR

If you can share this package, I can fix this and share it with you.


Forum|alt.badge.img
  • Jr Varsity II
  • 39 replies
  • May 13, 2023

@Naveen Boga OK, here it is...thanks in advance.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • May 15, 2023

Hi @dgross  I’m able to publish the package successfully.

And UNIT PRICE field is gets enabled even for the COMPLETED status. Please find the screenshots for reference.

 

 

 

 

 


xkylewrightx
Semi-Pro I
Forum|alt.badge.img
  • Semi-Pro I
  • 77 replies
  • September 25, 2024

@Naveen Boga Thank you so much for this, it is working for us. I was wondering if there is any way you can help us by adding SOOrder.CustomerOrderNbr to this customization to operate in the same way? Really appreciate your help


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