Dynamics Community Forum Thread Details

While select forupdate - Infinite Loop while trying to settle a project invoice more than 200 Lines

Hi,

We have MS Dynamics AX 2012 R3, We are trying to settle a project invoice that contains more than 200 lines.

Unfortunately, while trying to settle the invoice the system is hanging. We tried to debug the code then we found that the code is looping into a specific method.

Class\CustVoucher\updateProjTransPosting

This method contains a while loop that 'select for update' and 'insert' new records into 'projTransPosting' table. If we tried to settle any other invoice that contains a fewer number of lines, it is working normally.

I tried the following URL by using "RecordInsertList" but unfortunately I still have the same issue.

https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/289490/infinite-loop/1046427#1046427

Class\CustVoucher\updateProjTransPosting

    while select forupdate projTransPostingOrig
        where projTransPostingOrig.Voucher == _voucherNo &&
              projTransPostingOrig.PaymentStatus == ProjPaymentStatus::ExpectedPayment
    {

        // Check to see if the partial payment needs to be done
        if (_partialPayment)
        {
            // Copy the row to be inserted
            ProjTransPostingInsert.data(projTransPostingOrig);

            // Copy the original amount and qty
            originalQty    = projTransPostingOrig.Qty;
            originalAmount = projTransPostingOrig.AmountMst;

            // get percentage of partial payment
            partialAmount = Currency::amount(originalAmount * _percentagePayment);
            partialQty = decRound(originalQty * _percentagePayment, 2);

            // insert new record
            ProjTransPostingInsert.AmountMst     = originalAmount - partialAmount;
            ProjTransPostingInsert.Qty           = originalQty - partialQty;
            ProjTransPostingInsert.PaymentStatus = ProjPaymentStatus::ExpectedPayment;

projTransPostingInsert.insert();

            // We need to edit the existing record to reflect the partial payment
            projTransPostingOrig.AmountMst = partialAmount;
            projTransPostingOrig.Qty = partialQty;
        }

        projTransPostingOrig.PaymentStatus = _paymentStatus;
        projTransPostingOrig.PaymentDate = _paymentDate;
        projTransPostingOrig.update();

}

Quick Links