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!
Formula - Rate of Sale
I posted about this in the summer but I am hoping that now with the new NS version this might be possible.
I would like to write a formula and place it in a custom item field. This formula would show the rate of sale of an item for the past 30 days. So, the formula would have to calculate how many times an item appears on a sales order in a 30 day period and then divide that number by 30. My only problem has been filtering to the sales order level in the formula. Now that there is a search join from item to transactions I am hoping its possible - I'm just not sure how to do it. Does