Look in the AOT\Macros section it contains the macro InventDimJoin. The rest of the line are parameters which are used in the macro using %1, %2 ... and so on ...
HTH
Carsten F. Frandsen
MIKIA IT-Solutions
________________________________
Fra: paulinavk [mailto:[EMAIL PROTECTED]
Sendt: l� 19-06-2004 08:57
Til: [EMAIL PROTECTED]
Emne: [development-axapta] join code in the inventSumFinancial class
Hi, Can anyone tell me what the last line
#inventDimjoin
(inventTrans.InventDimId,inventDim,InventDimCriteria,InventDimParm,dim
IdIdx);
of the following select statement does. I am trying to reproduce a
report and I cannot get it to reconcile to the Invent value report.
THanks
Paulina
select forcePlaceholders forceSelectOrder forceNestedLoop tableId
from inventTransPosting
index hint ItemTypeDateIdx
where inventTransPosting.itemId ==
itemId &&
inventTransPosting.configId ==
configId &&
inventTransPosting.inventTransPostingType ==
InventTransPostingType::Financial &&
inventTransPosting.transDate > perDate
join sum(costAmountPosted),sum(qty) from inventTrans
index hint TransIdIdx
where inventTrans.voucher ==
inventTransPosting.voucher &&
inventTrans.dateFinancial ==
inventTransPosting.transDate &&
inventTrans.inventTransId ==
inventTransPosting.inventTransId &&
inventTrans.packingSlipReturned ==
NoYes::No
#inventDimjoin
(inventTrans.InventDimId,inventDim,InventDimCriteria,InventDimParm,dim
IdIdx);
Yahoo! Groups Links
[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.
