In CustCreditLimit class need to check the salesqty to be not more than as given in custom table

In CustCreditLimit class need to check the salesqty to be not more than as given in custom table:



static void main(Args _args)
{
    INC_Customercredit      customerCredit;
    SalesLine               salesLineQty,salesLinesum;

while select salesLineQty
                group by salesLineQty.ItemGroupId,salesLineQty.CustAccount
                where salesLineQty.SalesId          == salestableloc.SalesId
    {
        select customerCredit
                where customerCredit.CustAccount    == salesLineQty.CustAccount
                &&    customerCredit.ItemGroupId    == salesLineQty.ItemGroupId;

        select sum(SalesQty) from salesLinesum
                where salesLinesum.SalesId          == salestableloc.SalesId
                &&    salesLinesum.ItemGroupId      == salesLineQty.ItemGroupId;

        if(customerCredit.SalesQty < salesLinesum.SalesQty)
        {
            throw error("custom table qty is less.");
        }
       
    }
}