17 September 2013

How to generate RECID through SQL Server database in AX

Insert the data in AX from other sql server database through SP.

ALTER procedure [dbo].[SP_GetAXRecID](@axRecid bigint output)
as
begin
update [Server].Databse.dbo.systemsequences
set @axRecid = nextVal = nextVal + 1
from [Server].Databse.dbo.systemsequences where
dataareaid = 'dat' and name = 'SEQNO'
end

No comments:

Post a Comment

Give me the commetns and solutions

Merge Dimensions (MainAccountId and LedgerDimensions) defaultDimension in D365 F&O and X++

 public DimensionDynamicAccount getLedgerDimension(container _conData, TransDate _transDate = today()) {     int                            ...