I am facing an error in numbering sequence.
Scenario :- I have created a snapshot from tenant screen in acumatica ( settings only snapshot).
But when I restored this snapshot the numbering sequence gets reset to starting and the numbering sequence which was there in the instance while creating snapshot is been reset.
Eg:- suppose I am using Bill of Material and my numbering sequence as :- Starting Number - BOM000001 to End Number - BOM999999
and Last Number - BOM000037
So, When I create a snapshot from settings only and when I restored this on new tenant or instance it reset my last number to BOM000000 and when I create Bill of material it creates duplicate.
I have created CD field as my primary key in DAC and Database table.
Then also getting same issue. Is there any way in acumatica to resolve this and also is there any function in acumatica as OnImport and if then how can we use and where we can use it.??
Please suggest a solution for this.??