Re: [Axapta-Knowledge-Village] Axapta query

Sat, 07 Jan 2006 10:16:22 -0800

Try this buddy:
   
    InventDim inventDim;
    InventSum inventSum;
    InventQty inventQty;
    ;
    while select sum(postedQty), sum(received), sum(deducted), sum(registered),
        sum(picked), sum(reservPhysical)
            from InventSum group by itemId
                join InventDim
                    where inventSum.inventDimId == inventDim.inventDimId &&
                        inventSum.itemId == '1000'   &&
                        inventDim.inventLocationId == '123'
                     
    {
        inventQty = inventSum.PostedQty+inventSum.Received+inventSum.Deducted-
                    inventSum.Picked-inventSum.ReservPhysical;
    }
    info(strfmt('%1', inventQty));
 
Varden Morris
Senior Developer
WellPoint Systems Inc.
Microsoft Gold Certified Partner
Suite 2000, 500 - 4th Ave SW
Calgary, Alberta, Canada
T2P 2V6
 
(403) 444-5848 direct
(403) 444-3900 main
(403) 615-1604 cell
www.wellpoint.ca

fhfaulknor <[EMAIL PROTECTED]> wrote:
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 = ?








Yahoo! DSL Something to write home about. Just $16.99/mo. or less

Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.


YAHOO! GROUPS LINKS



Reply via email to