Go Back > Forum > Baan Quick Support: Functional & Technical > Distribution, Transportation & Warehousing

User login

Frontpage Sponsor


As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
Handover everything to System Integrator from drawing BP till implementation of ERP
Hire more inhouse skilled & capable IT Resource to work directly with SI
Rely on SI Architects/Consultants
Total votes: 4

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 29th November 2012, 18:05
Joy Conner's Avatar
Joy Conner Joy Conner is offline
Join Date: Aug 2001
Posts: 375
Joy Conner is on a distinguished road
Baan: IVc4 - DB: MS SQL - OS: Windows Server 2008 & 2008 R2
error 100 duplicate record in tdsls050
Baan: Baan IVc4

Recently this error has occurred 3 times in our production environment. While I have modified program tdsls4101 using Qkey, changes are not recent and the latest change does not appear to be the problem.

I have been able to replicate the error in our test environment using this scenario:
1. Create order header.
2. Add sales line, save and exit.
3. Add ship to address on order header, save and exit.

The error is more likely to appear when I complete the process quickly. If there is a delay, the process inserts 2 records into tdsls050, the second record having a different time.

The primary key to table tdsls050 is sales order #, date, & time.

Has anyone had this problem and discovered a solution?

Thanks in advance for your assistance.

Joy Conner
Reply With Quote
Sponsored Links

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
zoom to session and find record automatically timb25 Tools Development 11 25th April 2012 22:21
Record Type Value Question GabrielVA Finance, Invoicing and Integration 4 13th September 2010 15:17
I want set NO current record simona AFS/DDC/OLE: Function servers 1 10th October 2009 06:03
How to delete record in scheme? yurong Tools Administration & Installation 4 30th December 2004 23:35

All times are GMT +2. The time now is 08:21.

©2001-2018 - -