I have a sales order that prints ‘ffsfsdggs’ for the Calc_LineDesc as seen in the below image. I am sure that the field name is Calc_LineDesc. I changed the report field from a long complicated multiple if’s to ‘=Fields!Calc_LineDesc.Value’.
I have also included the Report Data Definition below.
Please help!!!
Thanks,
Richard
That is usually the line description on the sales order. Alternately, if the customer has a customer part number and is setup to print their part number/description, it may be the Customer Part Description there.
If you’re using configurator (the basic one, don’t know if it’s the same for CPQ/KBMax) it will use the user-inaccessible configurator description and not the sales order description. Super annoying if sales ever needs to add a little non-configurable detail.
We use the configurator, and we want descriptions to match descriptions, so I got rid of the calc_whateverdesc fields in reporting. Had to update RDD’s too because they excluded LineDesc. Don’t forget to check other reports too, quote and job IIRC.
It looks like the calculation is in Erp.Internal.OM.SalesOrderAck.dll, in the SalesOrderAck.DoDetailCalculations() method.
LineDesc starts out assigned to the corresponding PartLangDesc.Description if there is a PartLangDesc entry for this part number and the language selected for the report, otherwise it starts assigned to the part description from the OrderDtl line.
The next time LineDesc is assigned… if this OrderDtl line has something in the XPartNum field, and there’s a corresponding CustXPrt entry, which has its own PartDescription, and if the customer’s Customer.CustPartOpts field is either ‘M’ or ‘O’, then LineDesc is assigned to that CustXPrt.PartDescription.
OMG!!!
Chris, you are amazing. I found it in the erp.partlangdesc table. I did not even know this table existed.
Thank you 1 million times!
You are the best!
Richard
LangNameID PartNum Description Company
enu XXXXX ffsfsdggs REP
