Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
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.