Work or School accounts now enabled in community!
On May 12 Work or School Accounts were enabled in Community, along with Microsoft accounts (MSA). This allows seamless navigation between Community, Dynamics 365 applications, and Azure Active Directory enabled sites while logged into your Work or School account.
Read more | Managing Accounts
Dynamics 365 2019 release wave 2 plan Discover the latest updates to Dynamics 365.Release Plan | Weekly Deployment Notes
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants.Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements.
ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
We have a custemer on
- Xal version: 381.351 (Build #351) for SQL- SQl server 2008- OS: Windows Xp.
The custemer have upgraded and running the xal 381 for a couple of mounths.But he have problems with transid number setting in table StockTrans.
They become aware of the problem when they tried to invoiced some orders they an error message "Illegal reference between stocktable and stocktrans".
We have noticed that diffrent users or even different sessions seam to follow diffent numberseries when setting next number on TransId.
Example: User 1 Create a salestrans and get 10027 on transid, after that user 2 Create a salestrans and get 10058 after that user 1 Create a salestrans and get 10029.
And sometimes the numbers seams to make jump. For example go from 10029 to 10070.
This results that transactions on diffrent articels get the same transId number,leading to error and instability in the system.
We have tried to do the following:
- 1: Checked the systemtable XALSEQ field SEQNO that gives the next number for TransId.
- 2: Tried to run this code: // Start: INTRODUCE StockTrans[TransIdIdx,0] LAST StockTrans SET &TransIdMax= StockTrans.TransId
#IF.SQL SET SqlWrap::AlterXalSeq(&TransIdMax+1) #ENDIF // End In purpose to set a new value on next TransId number.
- 3: checked the value that diffent user get from this code: // Start. SET TransId = #DB_File(FileId2Name(StockTrans.FileId),SEQ) + 1 // End.
The resultat is that diffrent user get different &TransId number.
- 4: We can confirm the problem on our local installaition.
What could this depend on?What else can we check? Any ideas? Is it a bug in kenel 3.81?
Plaese we have critical problem in the custemer system.
Regards: Björn Claeson
I am not application programmer, but as fat as the kernel goes, TransIds are derived from The RecIDs that the kernel requests 10 at a time.
Therefore different XAL sessions have 10 RecIDs available at a time with no garantee that all 10 taken will be used.
This is normal behaviour and has been as long as XAL has been running on SQL platforms.
I do not think that it is a good idea to interfere with this mechanism.
Thanks a lot for the information.
Its explain and help us a lot.
We will check if its something else who causing the problem.
Business Applications communities