RDD Calculated Fields - INVCHEAD CustEmailAddress

[askulte (Andris Skulte)]

Does anyone know what field the InvcHead.Calc_CustEmailAddress is coming from (on the report styles)? Maybe @Rich? Thanks for the help!

Where does the calculation take place in a calculated field in a RDD?

Hi Guys I’ve created a copy of the OrderAck RDD for a custom SSRS report and I’ve ran into an issue adding in a custom calculated field. I can add single fields that are in the table (e.g. OrderComment in OrderDtl) however I would like to add a calculated field that takes two decimal columns and performs a calculation on them (so the calculated field would be the results from column1 - column2). I’ve had a look at the OrderHed DataSource for the RDD and it has a calculated field called BillTo…

[Doug.C (Doug Crabtree)]

I believe the logic is:

1. Pick the address of the primary billing contact on the customer record.
2. Use the customer e-mail address if no billing contact is available.

[ckoch (Chris Koch)]

Looking at the decompiled code in <server root>\Assemblies\Erp.Internal.AR.ARInvForm.dll, here is the relevant section, under DoInvcHeadCalculations():

this.CustEMailAddress = this.Customer.EMailAddress;
if (!this.InvcHead.SoldToInvoiceAddress)
{
    Customer bCustomer = Customer.FindFirstByPrimaryKey(this.Db, base.Session.CompanyID, this.InvcHead.SoldToCustNum);
    if (bCustomer != null)
    {
        this.CustContactName = "";
        CustCnt custCnt = this.FindFirstCustCnt(base.Session.CompanyID, bCustomer.CustNum, bCustomer.PrimBCon);
        if (!this.webOrder && custCnt != null)
        {
            this.CustContactName = custCnt.Name;
            this.CustFax = custCnt.FaxNum;
            this.CustPhone = custCnt.PhoneNum;
            this.CustEMailAddress = custCnt.EMailAddress;
        }
    }
}
else if (this.InvcHead.BillConNum != 0)
{
    CustCnt custCnt2 = this.FindFirstCustCnt2(base.Session.CompanyID, this.InvcHead.CustNum, this.InvcHead.BillConNum);
    if (custCnt2 != null)
    {
        this.CustContactName = custCnt2.Name;
        this.CustFax = custCnt2.FaxNum;
        this.CustPhone = custCnt2.PhoneNum;
        this.CustEMailAddress = custCnt2.EMailAddress;
    }
    else
    {
        this.CustContactName = "";
    }
}
else
{
    this.CustContactName = "";
}

I’m not the sharpest with C#, so someone correct me if I’m wrong… but if I’m reading this correctly the logic is:

1. Start with the customer email address
2. If there is no SoldTo Invoice Address but there is a SoldTo Customer (this doesn’t make sense to me), use the email of the primary billing contact on the SoldTo Customer
3. Otherwise, if there is a Billing Contact, use the email address of the Billing Contact (Attn field of an order/shipment?)

Edit: this is in 10.2.500.0

[Jonathan]

By default it will use the Bill To customer email address.

If “Print Sold To Address” is marked it will look for the primary billing contact of the Sold To Customer.

If not it will check if the primary billing contact number is populated and use it.

[askulte (Andris Skulte)]

Thanks @ckoch and @Jonathan. Neat idea to decompile the DLL. It’s amazing what a little digging can find out when it’s not documented.