Skip to main content
Answer

Cannot Use LastModifiedDateTime Field as Filter in Export Scenario

  • May 19, 2025
  • 1 reply
  • 58 views

Hi everyone,

I'm trying to create an export scenario on the Customer Payments screen (AR302000), and I’d like to filter the exported records based on the LastModifiedDateTime field.

Since this field is not active by default, I made it available using a customization project. Now, the field is visible and selectable in the Source Field of the export scenario.

However, I’m facing an issue:
Even though I can select LastModifiedDateTime as a source field, I cannot select values for Value 1 or Value 2 in the filter condition – those inputs are disabled, making it impossible to define a date range or comparison.

What I observed:

  • Built-in date fields (like DocDate) work fine and allow date inputs.

  • These native fields are of type datetime2, whereas LastModifiedDateTime appears to be of type datetime.

Best answer by darylbowman

I don’t believe the native data type has anything to do with it, but rather that the field schema for audit fields is not designed to allow updates. I’m guessing Acumatica uses this schema to determine how to display them, and that’s why they are disabled.

1 reply

darylbowman
Captain II
Forum|alt.badge.img+15
  • Answer
  • May 19, 2025

I don’t believe the native data type has anything to do with it, but rather that the field schema for audit fields is not designed to allow updates. I’m guessing Acumatica uses this schema to determine how to display them, and that’s why they are disabled.