Utility Of RecId

schabot

Is it possible to load data into standard axapta table (ie:InventTable, CRM Tables,...) directly in sql server (with a procedure or else) ?
May i manually generate the recid in the table or is it necessary to do that inside Axapta application to keep data integrity ?

Application should be re-indexed after recid being modified ?

Thanks in advance.
Regards.

CaHor

You may use a COM call to get the required recid!

AndyPeng

Hi,
I think It is possible,but dangerous, all recid is stored in table SysSearchRef, but if you change it directly, I am not comment to do so.
I comment you to import your data for excel. I imported more than 10000 records from excel when I implemented our axapta system. it is perfect!!!

Mariusz_Kopacki

Next RecId value is stored in SystemSequences table - on a per company basis. Just use appropriate, incremented values during the SQL import.