Digging deep into the reasons for variances can be a time-consuming task for your accounting staff—even more so when done AFTER closing work orders. In this webinar where we demonstrate that it can be easier than you think to identify, verify and minimize production variances in QAD. Olena Stepovyk will show you how you can …
• Download completed work orders details from QAD to a fully-functional Excel worksheet
• Review and verify cost variances and close work orders
• Simplify your process and quickly weed out the invalid variances before you close!
• And, more!
You’ll also be interested in these supplementary videos:
Can this tool be used in report only mode—without allowing work order closing?
Yes.
What effect does this tool have if the field “Post variances at SFC” in 36.9.11 Work Order Accounting Control is set to “YES?”
This tool does not post the variances, it only reports accumulated variances and allows you to close discrete or cumulative work orders by assigning status “C” (Closed). The value in the control field “Post variances at SFC” does not have any effect on the tool or vice versa.
Is this a finance function or production function?
We see it as both. Finance is mainly responsible for posting variances. But, production also wants to be able to see the variances and look into causes. This tool allows you to be proactive before closing – to fix any variances that might be due to inaccurate posting, for example.
We run 16.21 every night in batch. To use this tool, would we have to take that out of batch and have a planner or cost accountant process the work orders?
No. The 16.21 menu does not perform the function of closing the work order—it accumulates the variances. You would use this tool to see what variances will be posted when running 16.21 so that you could proactively analyze variances and make any necessary adjustments before you close work orders.
Can this be used to re-open work orders or can you reopen a work order with this function if you see that not all the components have been issued?
Not through this tool. We do have other tools that can help you do this or we could work with you to modify this tool to include that functionality.
When you say it will be ready for trial, does that mean the Excel add-in will be available as demo?
This tool will be available as a fully functioning trial that can be used with your QAD data in October 2018.
Will this work with backflushing if there are changes in componeent quantities even though you don’t open/close a work order
Yes, this will work with backflushing.
Is this available for SE2008?
Yes it will work with QAD SE2008.
Unabridged Webinar Re-play
Join our mailing list to stay informed about our webinars