Sunday, 17 April 2016

In Fiscal Year - FetchXML Query

The following example shows a FetchXML expression that finds all accounts created in fiscal year 2013.
  1. <fetch>
  2. <entity name="account">
  3. <attribute name="name"/>
  4. <filter type="and">
  5. <condition attribute="createdon" operator="in-fiscal-year" value="2013"/>
  6. </filter>
  7. </entity>
  8. </fetch>
To create In Fiscal Year FetchXML query:
  • In condition attribute set operator keyword to in-fiscal-year.
    <condition attribute="createdon" operator="in-fiscal-year" value="2013"/>
- See more at: 

1 comment:

  1. CALFRE handles oracle fusion financials online training and its modules maintaining classroom based training with the self-paced videos. An expert having ten plus years of self-experience handles the training period through online and explains each and every point perfectly. We recently launched our institute in the USA and getting the best reputation over there.

    Oracle fusion Financials Training in hyderabad

    Oracle Fusion Financials online Training in hyderabad