Skip to main content
Solved

Populating customer information changed to already created orders.


Forum|alt.badge.img

Is there a way in Acumatica to update all SO’s and Invoices already created when information for a customer gets updated?

Best answer by kokjietan

  1. Create a Generic inquiry with a criteria to compare the field on Sales Order/Invoices vs field on Customers
  2. Add additional filters based on whether the SO/INV is updateable (eg. don’t amend closed SOs/invoices)
  3. Create a business event to trigger on field changes
  4. Under the business event, subscribe an import scenario to update the above SO/Invoices

That being said, it does run the risk of importing while users are amending the SO/Invoices, so you may want to run it on a schedule or trigger instead. 

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

3 replies

meganfriesen37
Captain II
Forum|alt.badge.img+11

We’ve done a customization in our own system to do something similar to update our projects.  You may only want to update current orders and keep the actual history for historical orders that were previously shipped out and billed.

For the Sales Order, the quick/easy way to do this is on the Addresses tab - select the override checkboxes and then unselect and that should refresh the address with the new addresses/contacts, but this is more of a “one at a time” thing. (This works on invoices and stuff too if you need to regenerate with an updated address).


Forum|alt.badge.img
  • Author
  • Freshman II
  • 40 replies
  • March 25, 2024

Thank you,

Correct we wouldn’t want to change anything on completed/closed orders. 

Yes, we are doing as you mentioned, but some of our customers place orders in the future and that can get labor intensive when you have several Sales Order to update. 


Forum|alt.badge.img
  • Semi-Pro II
  • 81 replies
  • Answer
  • March 27, 2024
  1. Create a Generic inquiry with a criteria to compare the field on Sales Order/Invoices vs field on Customers
  2. Add additional filters based on whether the SO/INV is updateable (eg. don’t amend closed SOs/invoices)
  3. Create a business event to trigger on field changes
  4. Under the business event, subscribe an import scenario to update the above SO/Invoices

That being said, it does run the risk of importing while users are amending the SO/Invoices, so you may want to run it on a schedule or trigger instead. 


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