By using this website, you agree to our Terms of Use (click here)
Hi, any ideas how to find the date order status gets marked complete? My ultimate goal is to find orders that are marked completed today().
MedVet -
I believe the only way to find this out is to turn on Field Level Auditing. This is from help.acumatica.com 2020R1:
If you do decide to turn it on be careful and do not audit every field it will consume a lot of DB space.
John
Setup an import scenario that updates a custom field “complete date”. You schedule it to run every 15 minutes. It updated all records that are complete.
@medvet I'd warn you against using Field Level Auditing. Personally, it never seems to behave as expected and you will spend a lot of time dealing with false positives.
I'd recommend the advice from @ryanxbyte. Adding a date field to Sales Orders and adding an import scenario are a pretty straight forward customization using Acumatica's built in tools.
Online Members
