You will not be able to find an exact match. One LedgerJournalTrans record
can create multiple LedgerTrans records. It depends on the account type.
For example, a vendor invoice and assuming 10% tax:
Credit Vendor ABC01 for $100 excluding tax
Debit Expense 100102 for $100 excluding tax
When you post this you will most likely see in LedgerTrans
Vendors Control Account - $110 ( $100 + $10 tax)
Expense Account 100102 for $100
Tax Account xxx for $10
Depending upon posting profiles you may also see transactions created in
LedgerTrans to go in and out of various accounts. Another example is if
automatic allocations/splits have been set up against the expense account
(maybe a %age for each Department dimension) then again you will see many
transactions in LedgerTrans - one per department.
In this example you will also find an entry in VendTrans (for the $110) and
an entry is VendTransOpen as the invoice is unpaid. The only thing in
common to them all is voucher number.
SO as you can see there is no exact relationship besides a given voucher
number in LedgerJournalTrans generating an unknown number of transactions in
LedgerTrans.
Regards
Steve
_____
From: Anil Ozay [mailto:[EMAIL PROTECTED]
Sent: Friday, 21 May 2004 3:48 PM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Relation with LedgerJournalTrans and
LedgerTrans
Thanks Steve. You are right but i can't find relational record. For ex :
LedgerJournalTrans :
JournalNum LineNum Voucher AmountCurCredit
----------------- ------------- -----------------
--------------------------
000040_JN 1 000029_VC 100
000040_JN 2 000029_VC 50
000040_JN 3 000029_VC 100
LedgerTrans :
JournalNum Voucher AmountCur
----------------- ----------------- -------------------
000040_JN 000029_VC 100
000040_JN 000029_VC 50
000040_JN 000029_VC 100
000040_JN 000029_VC 100
000040_JN 000029_VC 50
000040_JN 000029_VC 100
How can i find the LedgerTrans record of LedgerJournalTrans record which
has LineNum 3? No field in LedgerTrans about relation, for ex refrecid
or linenum..
_____
From: Steve Wright [mailto:[EMAIL PROTECTED]
Sent: Friday, May 21, 2004 3:37 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [development-axapta] Relation with LedgerJournalTrans and
LedgerTrans
Hi Anil
LedgerJournalTrans is the table that holds most journal entries. When
you
post a journal ledgertrans records are created from LedgerJournalTrans.
You can link the 2 via JournalNum or Voucher. One journal line
(ledgerjournaltrans) will create a minimum of 2 Ledgertrans records -
one
debit, one credit.
S
_____
From: Anil Ozay [mailto:[EMAIL PROTECTED]
Sent: Thursday, 20 May 2004 11:18 PM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Relation with LedgerJournalTrans and
LedgerTrans
Hi all.. Do you know what is the relation with LedgerJournalTrans and
LedgerTrans? I want to catch LedgerTrans record from LedgerJournalTrans,
but i can't find 1-1 relation.
Thanks...
Anil Ozay
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=129rmjfml/M=295196.4901138.6071305.3001176/D=gr
<http://rd.yahoo.com/SIG=129rmjfml/M=295196.4901138.6071305.3001176/D=gr>
oups
/S=1705006764:HM/EXP=1085155748/A=2128215/R=0/SIG=10se96mf6/*http://comp
<http://comp>
anio
n.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group>
s/S=
:HM/A=2128215/rand=153004687>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
<http://groups.yahoo.com/group/development-axapta/>
<http://groups.yahoo.com/group/development-axapta/
<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/ <http://docs.yahoo.com/info/terms/> > .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://rd.yahoo.com/SIG=129bfdsko/M=295196.4901138.6071305.3001176/D=gr
<http://rd.yahoo.com/SIG=129bfdsko/M=295196.4901138.6071305.3001176/D=gr>
oups/S=1705006764:HM/EXP=1085209787/A=2128215/R=0/SIG=10se96mf6/*http:/c
ompanion.yahoo.com>
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group>
s/S=:HM/A=2128215/rand=192997239>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
<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/
<http://docs.yahoo.com/info/terms/> > .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/SIG=12988dulu/M=295196.4901138.6071305.3001176/D=groups
/S=1705006764:HM/EXP=1085212689/A=2128215/R=0/SIG=10se96mf6/*http://companio
n.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=550213716>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
<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.
