Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Inventory Count - Tracking Metrics
Hello there,
My team has a process for inventory cycle counts primarily in Google Sheets. The final step is to upload a item adjustment for the variance. I'm calculating IRA (formula below) in Google Sheets.
IRA = [ 1-the sum of the absolute variance / # the sum of the total inventory ] x 100
Source: https://www.netsuite.com/portal/resource/articles/inventory-management/using-inventory-control-software-for-cycle-counting.shtml
I'm wondering about uploading the IRA into Netsuite to be able to begin collecting the IRA by location so that over the course of the year I can record the accuracy.
I was wondering if anyone had a recommended object/table to upload the IRA metric to for saving it , or if this is something I should figure out in Google Sheets as well.