I'm trying to get the quantity on hand for an item in a particular
wharehouse. I have the equivalent SQL query, but unable to convert it
to Axapta query.
This is the SQL query:
SELECT
SUM(postedQty + received - deducted + registered - picked -
reservPhysical)
FROM InventSum iSum INNER JOIN InventDim iDim
ON iSum.inventDimId = iDim.inventDimId
WHERE iSum.itemId = ?
AND iDim.inventLocationId = ?
AND iSum.dataareaid = ?
AND iDim.dataareaid = ?
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
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/
