Discussion:
one to one Relation between LedgerTrans and LedgerJournalTrans
(too old to reply)
arshad
2009-08-02 06:05:01 UTC
Permalink
Dear All ,

Please any one can replay is any 1 to 1 relation between
LedgerTrans and LedgerJournalTrans , if it is there how it
is related or not how i can get related information from
LedgerJournalTrans . Becuase i am searching for solution
for four days , it is urgent for our customer

Please Help me.

Thanks
Willy
2009-08-02 20:05:01 UTC
Permalink
Hi there,

Sorry, no 1:1 relation.
One record in table LedgerJournalTrans can have multiple related records in
table LedgerTrans.
The relation, as stated in the AOT:

LedgerTrans.TransDate=LedgerJournalTrans.TransDate
&& LedgerTrans.Voucher==LedgerJournalTrans.Voucher


Greetingz,

Willy (blog at http://dynamics-ax-live.blogspot.com)
Post by arshad
Dear All ,
Please any one can replay is any 1 to 1 relation between
LedgerTrans and LedgerJournalTrans , if it is there how it
is related or not how i can get related information from
LedgerJournalTrans . Becuase i am searching for solution
for four days , it is urgent for our customer
Please Help me.
Thanks
arshad
2009-08-03 05:01:01 UTC
Permalink
Hi Thanks for rour replay ,

This relation not enough for me , because each lines i have seperate
information.
Or we can generate Ledger Account Statement from LedgerJournalTrans
any coments would be appreciated.

Best Regards

Arshad
Post by Willy
Hi there,
Sorry, no 1:1 relation.
One record in table LedgerJournalTrans can have multiple related records in
table LedgerTrans.
LedgerTrans.TransDate=LedgerJournalTrans.TransDate
&& LedgerTrans.Voucher==LedgerJournalTrans.Voucher
Greetingz,
Willy (blog at http://dynamics-ax-live.blogspot.com)
Post by arshad
Dear All ,
Please any one can replay is any 1 to 1 relation between
LedgerTrans and LedgerJournalTrans , if it is there how it
is related or not how i can get related information from
LedgerJournalTrans . Becuase i am searching for solution
for four days , it is urgent for our customer
Please Help me.
Thanks
Alan Flanders
2009-08-04 14:51:01 UTC
Permalink
Hi,

Whatever informaiton you want from LedgerJournalTrans needs to be passed to
LedgerTrans durring the posting. If you have created new fields on
LedgerJournalTrans, then you also need to add them to LedgerTrans and then
make sure the new fields are populated in the posting routines.

In the beginning I also struggled with the concept that lines from
LedgerTrans do not map to lines in LedgerJournalTrans. Another concept which
was difficult was that there is no 1:1 mapping between VendTrans to
LedgerTrans to LedgerJournalTrans. The only way to create this type of
mapping would be to add your own fields and modify the posting routines.
However, you do this at your own risk. I have opted instead to implement the
solution outlined above.

Alan
Post by arshad
Hi Thanks for rour replay ,
This relation not enough for me , because each lines i have seperate
information.
Or we can generate Ledger Account Statement from LedgerJournalTrans
any coments would be appreciated.
Best Regards
Arshad
Post by Willy
Hi there,
Sorry, no 1:1 relation.
One record in table LedgerJournalTrans can have multiple related records in
table LedgerTrans.
LedgerTrans.TransDate=LedgerJournalTrans.TransDate
&& LedgerTrans.Voucher==LedgerJournalTrans.Voucher
Greetingz,
Willy (blog at http://dynamics-ax-live.blogspot.com)
Post by arshad
Dear All ,
Please any one can replay is any 1 to 1 relation between
LedgerTrans and LedgerJournalTrans , if it is there how it
is related or not how i can get related information from
LedgerJournalTrans . Becuase i am searching for solution
for four days , it is urgent for our customer
Please Help me.
Thanks
arshad
2009-08-05 10:42:04 UTC
Permalink
Hi Alan ,

Ok , Thanks for your replay.

Best Regards
Arshad
Post by Alan Flanders
Hi,
Whatever informaiton you want from LedgerJournalTrans needs to be passed to
LedgerTrans durring the posting. If you have created new fields on
LedgerJournalTrans, then you also need to add them to LedgerTrans and then
make sure the new fields are populated in the posting routines.
In the beginning I also struggled with the concept that lines from
LedgerTrans do not map to lines in LedgerJournalTrans. Another concept which
was difficult was that there is no 1:1 mapping between VendTrans to
LedgerTrans to LedgerJournalTrans. The only way to create this type of
mapping would be to add your own fields and modify the posting routines.
However, you do this at your own risk. I have opted instead to implement the
solution outlined above.
Alan
Post by arshad
Hi Thanks for rour replay ,
This relation not enough for me , because each lines i have seperate
information.
Or we can generate Ledger Account Statement from LedgerJournalTrans
any coments would be appreciated.
Best Regards
Arshad
Post by Willy
Hi there,
Sorry, no 1:1 relation.
One record in table LedgerJournalTrans can have multiple related records in
table LedgerTrans.
LedgerTrans.TransDate=LedgerJournalTrans.TransDate
&& LedgerTrans.Voucher==LedgerJournalTrans.Voucher
Greetingz,
Willy (blog at http://dynamics-ax-live.blogspot.com)
Post by arshad
Dear All ,
Please any one can replay is any 1 to 1 relation between
LedgerTrans and LedgerJournalTrans , if it is there how it
is related or not how i can get related information from
LedgerJournalTrans . Becuase i am searching for solution
for four days , it is urgent for our customer
Please Help me.
Thanks
arshad
2009-08-10 11:41:01 UTC
Permalink
Hi Alan

Please can you guide me where i want to change to do this.

Best regards

Arshad
Post by Alan Flanders
Hi,
Whatever informaiton you want from LedgerJournalTrans needs to be passed to
LedgerTrans durring the posting. If you have created new fields on
LedgerJournalTrans, then you also need to add them to LedgerTrans and then
make sure the new fields are populated in the posting routines.
In the beginning I also struggled with the concept that lines from
LedgerTrans do not map to lines in LedgerJournalTrans. Another concept which
was difficult was that there is no 1:1 mapping between VendTrans to
LedgerTrans to LedgerJournalTrans. The only way to create this type of
mapping would be to add your own fields and modify the posting routines.
However, you do this at your own risk. I have opted instead to implement the
solution outlined above.
Alan
Post by arshad
Hi Thanks for rour replay ,
This relation not enough for me , because each lines i have seperate
information.
Or we can generate Ledger Account Statement from LedgerJournalTrans
any coments would be appreciated.
Best Regards
Arshad
Post by Willy
Hi there,
Sorry, no 1:1 relation.
One record in table LedgerJournalTrans can have multiple related records in
table LedgerTrans.
LedgerTrans.TransDate=LedgerJournalTrans.TransDate
&& LedgerTrans.Voucher==LedgerJournalTrans.Voucher
Greetingz,
Willy (blog at http://dynamics-ax-live.blogspot.com)
Post by arshad
Dear All ,
Please any one can replay is any 1 to 1 relation between
LedgerTrans and LedgerJournalTrans , if it is there how it
is related or not how i can get related information from
LedgerJournalTrans . Becuase i am searching for solution
for four days , it is urgent for our customer
Please Help me.
Thanks
yassine dinari
2010-08-12 14:06:44 UTC
Permalink
i 'm facing the same problem here , i added a new field(matricule) to ledgerjournaltrans and when i valid a ledgerjournaltrans it should be saved in ledgertrans , the thing which is not happeing.i did not get how to modify the posting routines..
please help me for this problem.
thanks.
Post by arshad
Dear All ,
Please any one can replay is any 1 to 1 relation between
LedgerTrans and LedgerJournalTrans , if it is there how it
is related or not how i can get related information from
LedgerJournalTrans . Becuase i am searching for solution
for four days , it is urgent for our customer
Please Help me.
Thanks
Post by Willy
Hi there,
Sorry, no 1:1 relation.
One record in table LedgerJournalTrans can have multiple related records in
table LedgerTrans.
LedgerTrans.TransDate=LedgerJournalTrans.TransDate
&& LedgerTrans.Voucher==LedgerJournalTrans.Voucher
Greetingz,
Willy (blog at http://dynamics-ax-live.blogspot.com)
Post by arshad
Hi Thanks for rour replay ,
This relation not enough for me , because each lines i have seperate
information.
Or we can generate Ledger Account Statement from LedgerJournalTrans
any coments would be appreciated.
Best Regards
Arshad
Post by Alan Flanders
Hi,
Whatever informaiton you want from LedgerJournalTrans needs to be passed to
LedgerTrans durring the posting. If you have created new fields on
LedgerJournalTrans, then you also need to add them to LedgerTrans and then
make sure the new fields are populated in the posting routines.
In the beginning I also struggled with the concept that lines from
LedgerTrans do not map to lines in LedgerJournalTrans. Another concept which
was difficult was that there is no 1:1 mapping between VendTrans to
LedgerTrans to LedgerJournalTrans. The only way to create this type of
mapping would be to add your own fields and modify the posting routines.
However, you do this at your own risk. I have opted instead to implement the
solution outlined above.
Alan
Post by arshad
Hi Alan ,
Ok , Thanks for your replay.
Best Regards
Arshad
Post by arshad
Hi Alan
Please can you guide me where i want to change to do this.
Best regards
Arshad
Submitted via EggHeadCafe - Software Developer Portal of Choice
Assemblies in Folder Debug Build Checker
http://www.eggheadcafe.com/tutorials/aspnet/d7de5fe1-6155-4e81-96e1-9806fd69d760/assemblies-in-folder-debug-build-checker.aspx
Loading...