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!
Custom records with complex parent/"foreign key" search
Hi all -
I've created a custom record for the purposes of logging, daily, the on-hand quantities of all of our SKUs in each of 3 locations. The record is very simple, called Item Inventory History, and has the following fields:
[LIST]
[*]Date
[*]Item (list/record, is parent)
[*]Location (list/record)
[*]On Hand Count
[/LIST] I wrote a scheduled script to create the log records nightly based off of a simple saved search; of course, I can only use so much governance, so the scheduled script needs to be able to pick up from where it left off and run until it's done.