How to edit LedgerJournalTrans posted line custom field in x++?

(0) Share

Report

Posted on by Rana Anees

1,813

Hii,

We have a custom field for PurchID in our LedgerJournalTrans table and displayed on LedgerJournalTransVendPaym Form. This customization is working ok.

This customization is up to LedgerJournalTrans level only.

Now we want to update PurchID for already posted payment journals. I can do it from SQL update statement successfully, but need to do it in a form on button click in x++;

When I try to update from Form button click in x++ it gives following error.

"Cannot edit a record in Journal lines (LedgerJournalTrans). Journal batch number: VVX-002658, VPJ-000234.

The SQL database has issued an error."

        while select forupdate ledgerJournalTrans where ledgerJournalTrans.JournalNum == journalNum && ledgerJournalTrans.Voucher == voucher
        {
            if(ledgerJournalTrans)
            {
            ttsbegin;
                ledgerJournalTrans.PurchId = purchId;
                ledgerJournalTrans.PurchNote = poNote;
                ledgerJournalTrans.update();
            ttscommit;
            }
        }

Please guide, how to update ledgerJournalTrans line custom field only.

Thanks,

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Chaitanya Golla 17,225 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Please try the following code.

while select ledgerJournalTrans where ledgerJournalTrans.JournalNum == journalNum && ledgerJournalTrans.Voucher == voucher

{

ledgerJournalTrans.reread();

ttsbegin;

ledgerJournalTrans.selectforupdate(true);

ledgerJournalTrans.PurchId = purchId;

ledgerJournalTrans.PurchNote = poNote;

ledgerJournalTrans.update();

ttscommit;

}

Thanks,

Chaitanya Golla

Was this reply helpful? Yes No