Hi,
Below is the code where I have to update the sales order payment for those sales orders whose status is not invoiced and not canceled.
update_recordset salesTable
setting Payment = _TermId
where salesTable.CustAccount == CustTablePaymId.AccountNum
&& ((salesTable.SalesStatus != SalesStatus::Invoiced) !! (salesTable.SalesStatus != SalesStatus::Canceled));
This code is still updating invoiced sales orders.
Hi Lakshmi, Can you try below code (changing !! with && AND operator).
update_recordset salesTable setting Payment = _TermId where salesTable.CustAccount == CustTablePaymId.AccountNum && salesTable.SalesStatus != SalesStatus::Invoiced && salesTable.SalesStatus != SalesStatus::Canceled;
André Arnaud de Cal...
291,996
Super User 2025 Season 1
Martin Dráb
230,853
Most Valuable Professional
nmaenpaa
101,156