Tuesday, September 23, 2025

How to update column Based on joins in sql

 How to update column Based on joins in sql :-


UPDATE GeneralJournalAccountEntry

SET IS_ConsolidationMainAccount = '',

 IS_ConsolidateAccountName = ''

FROM GeneralJournalAccountEntry AS GJAE

 JOIN GeneralJournalEntry AS GJE

    ON GJE.RecId = GJAE.GeneralJournalEntry

WHERE GJE.SubledgerVoucherDataAreaId = 'VN06'

and GJE.ACCOUNTINGDATE > '2025-01-01'

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to Control Edit Access for Sales Tax Fields in PR Lines Through Configuration in D365 Finance & Operations

 To provide a configuration-driven approach for controlling edit access to the Item Sales Tax Group and Sales Tax Group fields on Purchase...

  • Trace parser
    In this blog, I'm explaining how to Use the trace parser tool in D365FO. Any application at some point faces slow performance issues. It...
  • Posting Pending Vendor Invoice In d365 fo X++
      As per the standard when a pending vendor invoice is created and posted, it will not populate the data to description field in the vendtra...
  • How to find country region code in D365 fo X++
     How to find the country region code in D365 for X++ LogisticsAddressCountryRegion::findByISOCode(SysCountryRegionCode::countryInfo(curext()...