while select forUpdate tmp
{
ttsbegin;
select firstonly generalJournalEntry where generalJournalEntry.recid == tmp.GeneralJournalEntry
join fiscalCalendarPeriod where fiscalCalendarPeriod.RecId == generalJournalEntry.FiscalCalendarPeriod;
select firstonly vendInvoiceJour where tmp.Voucher == vendInvoiceJour.LedgerVoucher
&& vendInvoiceJour.InvoiceAccount == tmp.AccountNum
&& vendInvoiceJour.InvoiceDate == tmp.TransDate;
tmp.PeriodName = fiscalCalendarPeriod.Name;
tmp.PurchId = vendInvoiceJour.PurchId;
tmp.update();
ttscommit;
}
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156