project QadFinancials > class BCreditorBalance > method UpdateCBalanceAndCHistAssignCHist

Description

This method is a submethod of UpdateCBalanceAndHist.
It will update the balance of the CHist records following the current period.


Parameters


iiYearPeriodinputintegerYear Period
idCHistBalanceLCinputdecimalBalance value with Local Currency for CHist
idCHistBalanceTCinputdecimalBalance value with Transaction Currency for CHist
idCHistBalanceCCinputdecimalBalance value with Consistent Currency for CHist
iiProjectinputintegerProject ID
iiCostCentreinputintegerCost Center ID
iiDivisioninputintegerSub Account ID
iiJournalinputintegerDaybook ID
iiGLinputintegerGL ID
oiReturnStatusoutputintegerReturn status of the method.


Internal usage


QadFinancials
method BCreditorBalance.UpdateCBalanceAndCHist


program code (program6/bcreditorbalance.p)

/* ========================================================================== */
    /* This method uses the Query-result from the UpdateCBalanceAndCHist method.  */
    /* This temp-table holds all CHist records for this company/creditor/currency */
    /* with a starting period >= parameter YearPeriod                             */
    /* ========================================================================== */
    for each tCHist where
             tCHist.CHistYearPeriodFrom > iiYearPeriod and
             tCHist.GL_ID               = iiGL         and
             tCHist.Journal_ID          = iiJournal    and
             tCHist.Division_ID         = iiDivision   and
             tCHist.Project_ID          = iiProject    and
             tCHist.CostCentre_ID       = iiCostCentre :
        
        /* ================== */
        /* Update the balance */
        /* ================== */
        assign tCHist.CHistBalanceLC = tCHist.CHistBalanceLC + idCHistBalanceLC
               tCHist.CHistBalanceTC = tCHist.CHistBalanceTC + idCHistBalanceTC
               tCHist.CHistBalanceCC = tCHist.CHistBalanceCC + idCHistBalanceCC
               tCHist.tc_Status      = 'C':U.
        
    end. /* for each tCHist where */