Hi all;
I prepare a report that gives transfers to a inventlocation between date1 and
date2.
When i add a join at the and of the select (below in red) it doesn't return any
value.
With out red line it gives me sum of all transfers in inventtrans.
But i want to devide them according to their "journalnameid" field on
inventjournaltable.
Any idea?
real fason_Giris(Inventlocationid ambar, transdate d1,transdate d2)
{
inventDim id;
inventtrans it;
inventTransposting itp;
inventjournaltable ijt;
;
id.InventLocationId = ambar;
select sum(qty) from it index hint TransIdIdx group by itemid where
it.ItemId == this.ItemId &&
it.TransType == inventtranstype::InventTransfer
&&
(it.StatusReceipt == StatusReceipt::Received ||
it.StatusReceipt == StatusReceipt::Purchased) &&
it.Direction == inventDirection::Receipt //
stok giri�i
join id where
it.inventDimId == id.inventDimId
&& id.InventLocationId == ambar
join itp index hint ItemTypeDateIdx where
itp.ItemId == it.ItemId &&
itp.InventTransId == it.InventTransId &&
itp.InventTransPostingType ==
InventTransPostingType::Physical &&
itp.Voucher == it.VoucherPhysical
&&
itp.TransDate >= d1 &&
itp.TransDate <= d2
join ijt where ijt.JournalId == it.TransRefId;
return it.Qty;
}
[Non-text portions of this message have been removed]
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:
http://docs.yahoo.com/info/terms/
