Error CS1061 in Custom Code BPM

Epicor ERP 10
1

Hi. I am trying to setup a BPM to email users when a shipment is made. Below is the code that I have, however, I am getting a CS1061 error when I Check Syntax. If I remove the Plant table and join, the syntax runs fine.

The Plant table and Plant field are both legitimate tables/fields. Can anyone help me and tell me what I am doing wrong with the Plant table? Any and all help would be greatly appreciated!

Below is the code that I have:

var rows = (from a in Db.TFShipDtl 
             join b in Db.TFShipHead on 
                  new {a.Company, a.PackNum} equals 
                  new {b.Company, b.PackNum}
             join c in Db.Plant on 
                  new {b.Company, b.ToPlant} equals 
                  new {c.Company, c.Plant}
             join d in Db.ShipVia on 
                  new {b.ShipViaCode} equals 
                  new {d.ShipViaCode}
                where 
                   b.Shipped == true
  select new {a.TFOrdNum, a.TFOrdLine,a.OurStockShippedQty, a.PartNum, a.LineDesc, b.TrackingNumber, b.ShipDate, b.PackNum,  d.Description, d.TrackingNumPlaceHolder, d.TrackingURL} );

image
image962Ă—76 3.53 KB

Thanks!

Laura

2

The variable names need to match.
Change it to:

join c in Db.Plant on 
    new {b.Company, plant = b.ToPlant} equals 
    new {c.Company, plant = c.Plant}
4 Likes
3

I think in the EF table Db.Plant the field is named Plant1

3 Likes
4

Confirmed with other posts here …

We really need better “intellisense” in the Kinetic code editors

2 Likes
5

Yep the other one like this I always run into is FOB.FOB

1 Like