Object reference not set to an instance of an object

@aaghaei We could not able to know till debug and check the

values of the above code. However, I have added nullable types for the fields to handle the null exceptions. Can you please try with the below code and verify?

    if (fixedDemand != null && Base.FixedDemand != null && Base.FixedDemand.Any())
                {
                    PXResult<POFixedDemand> matchingDemand = Base.FixedDemand.Select()
                        .Where(r => r.Record.RefNoteID == fixedDemand?.RefNoteID &&
                                    r.Record.FixedSource == fixedDemand?.FixedSource &&
                                    r.Record.SiteID == fixedDemand?.SiteID &&
                                    r.Record.PlanType == fixedDemand?.PlanType &&
                                    r.Record.PlanID == fixedDemand?.PlanID &&
                                    r.Record.RecordID == fixedDemand?.RecordID)
                        .FirstOrDefault();
                }

@darylbowman thanks for the comment and @Naveen Boga thanks for the suggestion. the “fixedDemand” which is the current row of POFixedDemand is not null neither the Base.FixedDemand view it has elements. Any ways still I get the previous error. 

Yes @Naveen Boga , but I can’t see the values inside the linq when tracing for r.Record.DataField. the fixedDemand and also the Base.FixedDemand they both have values.

Let me step back and expain why I have ended up here. I have a few custom fields and Field Selecting event in PO505000 that reads some values from SOLine, FSSODet and FSAppointmentDet depending on the record type and displays. SOLine and FSSODet required field can be accessed in one select so I get them without any issues. The Appointment lines do not have direct link so I get the Service Order line first then loop through the Appointment items to find the record I want. It works all fine but only when user tried to filter those fields gets an error that “Insufficient stack to continue executing the program safely. This can happen from having too many functions on the call stack or function on the stack using too much stack space.”

This is the loop code that I am trying to convert it to a linq select as I provided in my post.

POFixedDemand matchingDemand;
FSSODetFSSODetSplit fsDetSplit = null;

foreach (PXResult<POFixedDemand> demand in Base.FixedDemand.Select())
{
	matchingDemand = (POFixedDemand)demand;

	if (matchingDemand.RefNoteID == fixedDemand.RefNoteID && matchingDemand.FixedSource == fixedDemand.FixedSource && matchingDemand.SiteID == fixedDemand.SiteID && matchingDemand.PlanType == fixedDemand.PlanType && matchingDemand.PlanID == fixedDemand.PlanID && matchingDemand.RecordID == fixedDemand.RecordID)
	{
		fsDetSplit = PXResult.Unwrap<FSSODetFSSODetSplit>(demand);
		break;
	}
}

In the above loop I only need the first record that matchs the condition as you can say from the code.

Hi @vardan22 

Thank you for the response. Yes the graph uses the FieldScope but if you look into the method the whole POFixedDemand TABLE and some fields from other tables are included. So I do not have problem with reading and displaying values from the extension I have added to POFixedDemand. The fields get and display the values exactly I need in the UI. The problem surfaces only when I want to filter in my original code. 

Thank you for sharing your solution with the community @aaghaei!