Hi Anil,
Each transaction in the ledgerjournalTrans and LedgerTrans are related to each other by transdate and voucher and whereas the case of relation of one line of voucher to its transaction is concerned i think there is no relation other then voucher and transdate. thats why whenever you see the voucher from any of the line in ledgerjournaltrans, Ledgertrans table show all the lines of the same voucher number and transdate. If you want to designate a particular ledgertrans with ledgerjournaltrans by mean of line number may be you can create another field called linenum in the table. I hope it helps.
This is what i know. If you get to know anything about the relation within linnum also then please let me know.
Regards
Amit
Anil Ozay <[EMAIL PROTECTED]> wrote: Hi.. This problem generally occurs when sql server system rights
changed. For ex, if you use "bmssa" user to connect to sql server, and
if owner of many tables in AXDB is "dmo", you can't select records. So
this message occurs. You should change the owners of tables.
Regards
Anil
_____
From: mchiat [mailto:[EMAIL PROTECTED]
Sent: Friday, May 21, 2004 5:22 AM
To: [EMAIL PROTECTED]
Subject: [development-axapta] SQL error when log into Axapta - Invalid
Object Name 'SQLSYSTEMVARIABLES'
Hi all,
Could anyone of you help me to resolve the problem? When i want to
log into axapta the following SQL error occurs
SQL has reported the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server] Invalid Object
name `SQLSYSTEMVARIABLES'
You may refer to the error log file for further details.
Retry the operation?
If i click 'Yes' the same message box will keep on emerging. However
if i click 'No' the following message will appear:
Cannot select a record in ().
The SQL database has issued an error.
If i proceed the following message will appear:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object
name `SQLSYSTEMVARIABLES'. [SELECT VALUE FROM SQLSYSTEMVARIABLES
WHERE PARM = `SYSVARID']
If i continue the system will ask me to enter System Variables:
One or more SQL system variables are unknown.
System variable STR
Permitted values Text
New value
After i enter the New Value as VARCHAR(%u)the system will
automatically exit and if i want to log into Axapta again the same
SQL error will appear.
May i know what is happening? Is there anyway to resolve the
problem?
Hope you all can reply to me as soon as possible. Thank you in
advance.
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://rd.yahoo.com/SIG=129t3vmva/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705006764:HM/EXP=1085209839/A=2128215/R=0/SIG=10se96mf6/*http:/c
ompanion.yahoo.com>
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=504037943>
_____
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]
be>
* 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 SponsorADVERTISEMENT
---------------------------------
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.
---------------------------------
Do you Yahoo!?
Yahoo! Domains - Claim yours for only $14.70/year
[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.
