As everybody knows we have 4.2 billion recids per company to deal with. 2 billions above zero and 2 billions below. After these recids are used Axapta actually stops...
The problem is that we are using more recids than we use. We waste a lot of recids, because we draw a number of recids from SystemSequences every time we are going to insert some records. I have seen a lot of installations were the recids was used, because they had imported and delete a lot of records.
What you have to do is to run the
AOT/Classes/SysRecidRepair
But only use the version 3.0 Sp2 - sp3 and in version 2.5 SP4. The class will free up unused recids and reorganize your recids.
Med venlig hilsen / Best regards
Kim Truelsen
Escalation Engineer
Microsoft Business Solutions Axapta
EMEA Global Technical Support Center
Direct / mobile: +45 4489 0100 / +45 29499958
E-mail: [EMAIL PROTECTED] <BLOCKED::mailto:[EMAIL PROTECTED]>
Online support at: www.microsoft.com/support <BLOCKED::http://www.microsoft.com/support>
MBS Partnersource at: www.microsoft.com/BusinessSolutions/PartnerSource/default.mspx <BLOCKED::http://www.microsoft.com/BusinessSolutions/PartnerSource/default.mspx>
Security Updates at: www.microsoft.com/protect <BLOCKED::http://www.microsoft.com/protect>
Microsoft Denmark <BLOCKED::http://www.microsoft.dk/>
Tuborg Boulevard 12
DK-2900 Hellerup
Phone:+45 4489 0100 / Fax: +45 4468 5510
________________________________
If you have any feedback about my work, please let either myself or my manager Kenneth Stubban know at [EMAIL PROTECTED] <BLOCKED::mailto:[EMAIL PROTECTED]> or telephone +45 4498 0750
Note: This email may contain confidential information. If you are not named on the addressee list, please take no action in relation to this email, do not open any attachment and please contact the sender (details above) immediately.
________________________________
From: Tomasz Dudek [mailto:[EMAIL PROTECTED]
Sent: 2. juni 2004 12:14
To: [EMAIL PROTECTED]
Subject: [development-axapta] Negative RedIds & Custtable
RecId can be negative. OK. It is consequence of integer type of RecId. But
after 2147483647 negative numbers integer has 0! What will be done with
them? would it insert RecId = 0 ?
Next problem: After '0' value integer has positive values. There would be
inserted RecId, who exists in this table. What will be happen, if there are
relations on "unique" Recid's?
Best regards.
Tomasz Dudek
Integris
[EMAIL PROTECTED]
----- Original Message -----
From: "Unger, Denis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 02, 2004 9:28 AM
Subject: AW: [development-axapta] Negative RedIds & Custtable
A valid RecId in Axapta can also be negative. With table.recid != 0 you can
check a valid record.
Denis Unger
-----Urspr�ngliche Nachricht-----
Von: �zg�r Gen� [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 1. Juni 2004 23:34
An: [EMAIL PROTECTED]
Cc: Ugur S. Taskin; Volkan Acar
Betreff: [development-axapta] Negative RedIds & Custtable
Hi everyone, I have two questions that I need your help.
1 - in our ERP project we have two companies. In the first company, all
recIds in all tables are positive but in the other company some recIds in
the table are negative. Do any of u know why that could happen? Is it
normal? Most of our code that includes if (table.recId!=0) statement fails
so we rearranged these codes. I will be very glad if any of u have any
exprience on such an issue.
2- My other problem is that; in custtable account num can collabse with each
other in these companies. A customer information can be changed with another
customer information with a different accountnum. I have written this to
partner source but maybe any of you may have a problem with custtable
accountnum before.
thanks a lot.
�zg�r
Lead Developer, Veripark
[Non-text portions of this message have been removed]
Yahoo! Groups Links
Yahoo! Groups Links
Yahoo! Groups Sponsor
ADVERTISEMENT
click here <http://rd.yahoo.com/SIG=1291kfl4s/M=295196.4901138.6071305.3001176/D=groups/S=1705006764:HM/EXP=1086259050/A=2128215/R=0/SIG=10se96mf6/*http:/companion.yahoo.com>
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=897756411>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
