— The Forums are now read-only —
— All new activity now takes place 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.
By using this website, you agree to our Terms of Use (click here)
