Discussions
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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.