Here is the query using C#, I give 2 ways, using LINQ and Late Bound;
//Using LINQ private void RetrieveOrganizationFiscalYear() { _service = new XrmContext(); XrmContext xrmContext = new XrmContext(); var OrganizationSettings = from os in xrmContext.OrganizationSet select new Organization { FiscalCalendarStart = os.FiscalCalendarStart, }; DateTime dtStartFiscalYear = OrganizationSettings.First().FiscalCalendarStart.Value; //this is the date of start fiscal year } //Using Late Bound private void RetrieveOrganizationFiscalYearLateBound(IOrganizationService _service) { //Retrieve organization Entity enOrganization = new Entity("organization"); EntityCollection ecOrganizations = new EntityCollection(); DateTime dtStartFiscal = new DateTime(); QueryExpression qx = new QueryExpression(); qx.EntityName = "organization"; qx.ColumnSet.AllColumns = true; ecOrganizations = _service.RetrieveMultiple(qx); if (ecOrganizations.Entities.Count > 0) { enOrganization = ecOrganizations.Entities[0]; dtStartFiscal = enOrganization.GetAttributeValue<DateTime>("fiscalcalendarstart"); //this is the date of start fiscal year } }
You can see this post as well:
https://community.dynamics.com/crm/f/117/t/160719
Hope this helps!
Thanks.
No comments:
Post a Comment
My Name is..