Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Last Update fields via ODBC
I need to constantly refresh the data I bring over to a MS Access for all primary tables, ie. Customers, entity, contacts, transactions etc etc. This takes a couple of hours to refresh every time.
I can get only those which are new by checking max ID
I can only find a "Last Modified Date" on the customers table.
Transaction also has a last modified date. For transaction lines, I can check if any new lines came in, delete all details and bring back in again... work around.
for entity, I can get the CUSTOMER changes based off the customer ID but not all other changes, ie. contacts.
0