get the customer opening balance using X++

CEU/Accounts receivable/Reports/Status/customer balance list. 
 

static void Job28(Args _args) 

{ 

    Query                       q; 

    QueryBuildDataSource        qbds; 

    QueryRun                    qr; 

    QueryHavingFilter           qhf; 

    CustTable                   custTable; 

    CustTransOpen               custTransOpen; 

    ; 

    q = new Query(); 

    q.allowCrossCompany(true); 

    qbds = q.addDataSource(tableNum(CustTable)); 

    qbds.addGroupByField(fieldNum(CustTable, DataAreaId)); 

    qbds.addGroupByField(fieldNum(CustTable, AccountNum)); 

    qbds = qbds.addDataSource(tableNum(CustTransOpen)); 

    qbds.relations(true); 

    qbds.addSelectionField(fieldNum(CustTransOpen, AmountMST), SelectionField::Sum); 

    qbds.orderMode(OrderMode::GroupBy); 

    qhf = q.addHavingFilter(qbds, fieldStr(custTransOpen, AmountMST), AggregateFunction::Sum); 

    qhf.value('> 5000'); 

    qr = new QueryRun(q); 

    while (qr.next()) 

    { 

        custTable = qr.get(tableNum(CustTable)); 

        custTransOpen = qr.get(tableNum(custTransOpen)); 

        //info(strFmt("Company: %1, Account number: %2,  Open balance: %3", custTable.dataAreaId, custTable.AccountNum, custTransOpen.AmountMST)); 

        info(strFmt("Customer no: %1, Cutomer Name: %2, Customer invoice no:%3 Open balance: %4,Cutomer Total Balance: %5", custTable.AccountNum, custTable.name(),custTable.InvoiceAccount,custTransOpen.AmountMST,custTable.openBalanceMST()));//custTransOpen.AmountMST,custTable.openBalanceCur())); 

    } 

}