I am performing an Asynchronous integration of third party system with business central.I have written a code unit that is exposed as web service which will be used by the 3rd party system
i am syncing the following entities:
1. Product with Product variants and product identifiers
2. Sales order header with sales line.
3. sales shipment header with sales shipment line
4. sales invoice header with sales invoice line.
In my scenario i have multiple jobs which executes multiple time in a day that find the set of record which are changed after the given date-time. Then sync only the records which were changed.
Now the problem i am facing is that in business central most of the tables doesn't have modified date time field, which can be used to filter the records that are modified recently.
Can anyone tell me how i can filter the records from any table that are modified recently?
One of the possible solution is to extend each table add a new field modified date-time. Extend the onmodify() trigger and set the current date-time on it.
But my client doesn't prefer to extend all of these tables just for a very basic field.
The other solution i have identified is to use the change log feature.But i believe this will slow down the system due to large numbers of records.