I am creating a report to sum up all materials in a quote by material part number and quote line. Each line can have several levels of nested sub-assemblies requiring the nest for this report. I am trying to reconcile the material costs on the Quote Worksheet against the QuoteMtl table where I am pulling all my materials from. All my quote lines reconcile except two. I resolved the first one as one material line had a material burden cost. The other is out about $90 with material totaling over $245,000. Does anyone know of any hidden costs that are in the quote worksheet total? Also, my total matches that in the printed worksheet report, but the worksheet tab is higher by $90. Any ideas would be appreciated.
Ugh, the Worksheet is a blackbox of calculated fields. I’m not sure anyone has been able to figure out the formulas.
Have you looked at the Quote Analysis Export process?
No, I haven’t looked Quote Analysis Export. I just opened it and I will need to find out how to run it. Thanks