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, whereasLastModifiedDateTimeappears to be of typedatetime.