Discussions
adding item quantity to production variances by item report
My client has modified the production variances report to break out each item based on this help article:
What the client has asked to add to this report (or come up with a different way to accomplish the result) are columns that contain the information used to calculate the production quantity variance and production price variance for each item: actual quantity, actual unit cost, standard quantity, and standard unit cost.
I have been unable to find the appropriate fields in the report customization to add, nor have I been able to find the requested fields in saved searches and/or SuiteAnalytics. This approach assumes that we can pull the desired data from fields that are already populated somewhere and we just have to find the right relationship/join to pull into the search results as needed.