Friday, October 18, 2013

Job to fetch sales orders with lot of lines

A quick job to fetch sales orders with lot of lines.

static void salesTableFetch(Args _args)
{
    SalesLine     salesLine;    
    ; 
   
    while select count(recId), SalesId from salesLine
        group by SalesId

    {
        if (salesLine.RecId > 100)
        {
            info(salesLine.salesId);
        }
    }
}

No comments:

Post a Comment