--- In development-axapta@yahoogroups.com, "Ramazan GÝRGÝN" <[EMAIL PROTECTED]> wrote: > Hi all, > > I want to insrt data from other application directly SQL database. But while inserting data i need next recid from Axapta. How can i take next recid from axapta in other application .??? > > Thanks in advance
Microsoft recommends using the Business Connector (COM or .NET version) to integrate with Dynamics. You can mess up table relationships that depend on non-duplicate recids by directly inserting into Dynamics tables. Getting the next recid from SystemSequences may not work since the table and values are probably cached. You could try inserting your data into a staging table and accessing that table with X++ from Dynamics to import the data (a pull strategy). Using the Business Connector is the best way (for a push strategy).