Bethany,
I would start by taking each of the fields called out in the formula and then look at field explorer in crystal and make sure all those fields are in your data set. For example, take INVCDTL.PartNum_PartsPerContainer and look under the invcdtl table in the database fields and expand it to make sure that field is listed. If it is, move on to the next field until you come across the field that is missing. Which then means you’ll have to add it to your RDD or perhaps change the name on the formula.
This one seems like a good suspect to me
INVCDTL.PackLine_Number01
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, November 23, 2015 12:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 10 - Crystal Reports error - Field name is not known
I am working on correcting errors with our Crystal Reports forms so they work in Epicor 10.0.700.4. I have "updated" the Report Data Definitions for all of our customized forms. The customized AR Form is giving me the following error from the Crystal Reports Windows Forms Viewer when it tries to print preview the Invoice Form:
This field name is not known.
Details: erroKind
Error in formula LineContainerCnt:
'Shared NumberVar LineContainerCnt;
'
This field name is not known.
When I look at the formulas in Formula Workshop - Formula Editor (in Crystal Reports), I see a formula for LineContainerCnt. The formula is:
Shared numberVar LineContainerCnt;
If {INVCDTL.PartNum_PartsPerContainer} <> 0
Then(
If RecordNumber = 1
Then LineContainerCnt := RoundUp(({INVCDTL.Calc_OurJobShippedQty} + {INVCDTL.Calc_OurStockShippedQty}) / {INVCDTL.PartNum_PartsPerContainer},0)
Else If {INVCDTL.InvoiceNum} = Previous({INVCDTL.InvoiceNum}) and {INVCDTL.InvoiceLine} = Previous({INVCDTL.InvoiceLine})
Then LineContainerCnt := LineContainerCnt
Else If {INVCDTL.InvoiceNum} = Previous({INVCDTL.InvoiceNum}) and {INVCDTL.InvoiceLine} <> Previous({INVCDTL.InvoiceLine})
Then LineContainerCnt := LineContainerCnt + RoundUp(({INVCDTL.Calc_OurJobShippedQty} + {INVCDTL.Calc_OurStockShippedQty}) / {INVCDTL.PartNum_PartsPerContainer},0)
Else If {INVCDTL.InvoiceNum} <> Previous({INVCDTL.InvoiceNum})
Then LineContainerCnt := RoundUp(({INVCDTL.Calc_OurJobShippedQty} + {INVCDTL.Calc_OurStockShippedQty}) / {INVCDTL.PartNum_PartsPerContainer},0)
Else LineContainerCnt := 0)
Else LineContainerCnt := {INVCDTL.PackLine_Number01} + LineContainerCnt
Any help with pointing me in the right direction would be greatly appreciated! TIA!
Bethany Rye
Epicor Business Analyst
PTI Engineered Plastics