Hi All

I have linked to the pervasive database and can see all tables. But I would like to change some data through the ODBC connection. In particular I would like to change the date of a transaction ie DDate as someone imported the information and whilst the period was correct, they double-clicked the excel bottom right corner and Excel incremented the Year of the posting. so instead of 5 transactions being for 2018, it got spread 2018, 2019, 2020, 2021, 2022.

Is the DDate a field that can be changed without effecting other tables, or can the change only happen through doing a front-end journal entry

Kind Regards