I'm trying to identify inactive accounts based on the last activity date so that I can update the status to inactive.
I was hoping to do this using two VI jobs. The first would export all accounts with an activity date prior to let's say 1/1/2000. I would then update the status on this exported file then run a second VI job to re-import the accounts.
Could anyone help me determine what file I need to use to find the activity date? I've looked through all of the G/L file layouts, but I haven't been able to find a specific reference to this data item.
Thanks in advance,
Ed
I was hoping to do this using two VI jobs. The first would export all accounts with an activity date prior to let's say 1/1/2000. I would then update the status on this exported file then run a second VI job to re-import the accounts.
Could anyone help me determine what file I need to use to find the activity date? I've looked through all of the G/L file layouts, but I haven't been able to find a specific reference to this data item.
Thanks in advance,
Ed