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!
Tricky Formula - Sequential Compiling By Day of Month
Hi All,
We have a use case where goods owned by our clients come into our warehouse, we store them, and then ship them out to wherever when needed. We want to charge our clients for storage on a per-item per-day basis. The charge will be calculated daily, but billed monthly so I need a saved search to collect all of the data.
Each item has a unique daily storage rate and I have a several custom records setup to manage all of the items, the in and out movements of those items.
Ok... So, to charge storage per-item per-day I need the number of items on hand as of each day in a given month.