Transaction Number in G/L Entry

cbasilis

Hi. We have a issue with the transaction number on the G/L entry Table. We taught a client how to use the Data Migration, and they create a Data Migration with the G/L Entry table and insert all the historical data on this table, with a transaction number inserted by the customer. The problem is that we have a out of sequence with the transaction number of this table.
We can I do, to resolve these problem...Any Idea????

Thank for the help.

Carlos

DaveT

Hi Carlos,

Welcome to Mibuso !

It's a bad idea to migrate directly into tables such as the G/L entry. Normally I would migrate into a journal and post the journal as there are a number of issues tables that direct migration may miss. Is it too late to delete the migrated data and re-import via a journal.

cbasilis

Thank Dave for the answer.

Well, we are going to start again, and insert all the G/L entry using the journals.
Thank for everything.

Carlos