Dear all,
I have question about xSession class and field ledgerBalancesVariant.
1. how to know what number of ledgerBalancesVariant in
LedgerBalancesTrans and LedgerBalancesDimTrans will a record in
LedgerTrans will refer to?
2. Is it possible to find out the ledgerBalancesVariant from who
modified record of LedgerTrans?
below is the detail:
As we know, every record in LedgerTrans table are inserted to in
LedgerBalancesTrans and LedgerBalancesDimTrans by accumulatived by
different way of grouping.
in LedgerBalancesTrans table is grouped by: COA(accountnum),
transdate, voucher, ledgerBalancesVariant
and in LedgerBalancesDimTrans is grouped by: COA(accountnum),
transdate, voucher, ledgerBalancesVariant, dimension(dimension,
dimension2_, dimension3_)
Cause of 'undocumented feature' in my program, I have to
change(update) value(amountMST & amountCUR) in some record of
LedgerTrans. And as mentioned above, this also cause value change of
field debitMST/creditMST in LedgerBalancesTrans and
LedgerBalancesDimTrans.
I have difficulity cause of I don't know what is the value
ledgerBalancesVariant of record in LedgerTrans refer to in
LedgerBalancesTrans and LedgerBalancesDimTrans.
My Question, how to know what number of ledgerBalancesVariant will a
record in LedgerTrans will have?
Is it possible to find out the ledgerBalancesVariant from who modified
record of LedgerTrans?
AFAIK, ledgerBalancesVariant is the taken from xSession.sessionId().
and the sessionId is unique per PC.
maybe the solution just ignore ledgerBalancesVariant :)
SELECT FIRSTONLY FORUPDATE ledgerBalancesTrans
ORDER BY ledgerBalancesVariant desc
WHERE ledgerBalancesTrans.accountNum == ledgerTrans.accountNum
&& ledgerBalancesTrans.transDate == ledgerTrans.transDate;
regards,
nazrvl
--
T I M E
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/kGEolB/TM
--------------------------------------------------------------------~->
Sharing the knowledge on Axapta.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
