Hi Business NXT team, We are currently working on retrieving data from the "generalLedgerTransaction" endpoint. While it's functioning well for a full data load, we're facing challenges when trying to implement a synchronization option in our query. We were thinking of working with either the "changedDateTime" or "changedDate" fields. In other systems, we typically see a primary key, often referred to as an "ID," that we can use to identify and delete previous data for records that have been updated. In Business NXT, we've encountered the "voucherJournalNo" and "voucherNo" fields, but these fields frequently contain multiple records with the same number. Initially, we considered deleting all records associated with a particular "voucherJournalNo." However, we've observed that the "changedDate" and "changedDateTime" values can vary for different records sharing the same "voucherJournalNo" or "voucherNo." Is there another reliable method to identify which records/lines we need to delete or something else that you can recommend us, so that we are able to keep an up to date table from the generalLedgerTransaction? I hope our request is clear. Thanks in advance for your time.
... View more