Whether you practice cycle counting, physical inventory or both, the key to immaculate inventory is accurate counts – and accurate data entry.
Part 3 of our Immaculate Inventory Management in QAD series (Watch Part 1 here and Part 2 here) shows how you can gain ease and accuracy of inventory maintenance in QAD — and achieve measurable results. In this 20-minute interactive webinar, you’ll discover how you can easily …
• Greatly improve inventory accuracy whether cycle counting or tag counting
• Get real-time access to QAD data
• Massively update inventory counts quickly and easily
• Give responsibility and control of forecast entry and maintenance to your sales force
Is it possible for the cycle count Data Loader to be configured to accept the initial count out of tolerance discrepancy vs. giving the hard-stop?
Yes. In the demonstrated generic version, discrepancy tolerance check can be avoided by recording count results with count type “R” (recount). The Loader also can be configured not to check discrepancy tolerance at all.
When adding an item to a request, how are the items validated if you don’t need a QAD login?
We do connect to the QAD database to validate that the item exists if it is an inventory item and we also check that the supplier exists against the QAD tables.
Is the upload limited to a certain number of lines?
By default, the number of lines that can be uploaded into QAD at once is limited to 20,000. But this can be decreased or increased to suit your needs. The maximum number of lines that can be uploaded at once is limited to the maximum number of lines in an Excel spreadsheet.
Are the count reports acceptable for outside auditors?
Both the Cycle Count and Physical Count Data Loaders generate inventory transactions in QAD. Count transactions store information about count date and time, counted quantity and cost, its location and ID of the person who entered count results into QAD. These transactions can be extracted at auditor’s request using either the standard QAD transaction history reports or custom reports.
Join our mailing list to stay informed about our webinars