Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
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.
0