#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 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.
