web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Update_recordset not u...

Finance | Project Operations, Human Resources, ...

Answered

Update_recordset not updating as per the where condition

(0) Share

Report

Report

Posted on by Lakshmi Community

30

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.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report
RE: Update_recordset not updating as per the where condition

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;

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 650 Super User 2025 Season 2

#2

Martin Dráb 582 Most Valuable Professional

#3

CU05031448-0 526

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans