[CollectingWarehouse]

I have read a bunch of interesting posts, but can’t find what I need…

I have created a report that tells me quantity sold for the last 90 days in a certain location. I’d like to refer to the results of that report in a custom item field. How can I refer to a report column result from a custom item field?

If I should be creating the result in the field instead, please help me determine the cleanest formula for that. It’s quantity sold (items and kits separately), filtered by location, and for the previous 90 days. And then, obviously, I will be able to create variations of this with other time periods or locations.

Thank you to anyone who is able to help!
This is a cached copy. Click here to see the original post.

[cdelacruz]

Hello,

Have you tried using a saved search instead of a report? Please see SuiteAnswers Article: Creating Custom Fields with Values Derived from Summary Search Results (Answer ID: 31727) for details.

[CollectingWarehouse]

Thank you, I’ll look for that article.

[CTorgerson]

CollectingWarehouse – Just realize that doing it that way means that fields like that are not available in reports and searches:

…because its values are not stored, this kind of field is not available in search results, including lists based on saved searches… (from the SuiteAnswers Article)

So if you want to report on those values in any way, you’ll have to come up with another solution (i.e. Scripting, etc.).

[CollectingWarehouse]

Thank you. That means the saved search method above won’t actually work for me. I need the results to be available in saved searches.

[CTorgerson]

You would need to create a scripted solution then, and either have it run as a User Event when orders are created or as a Scheduled Script that periodically runs.

[CollectingWarehouse]

Thank you for your help. If I run the report as a scheduled script, can I refer to the results of the report through scripting?

[CollectingWarehouse]

I wouldn’t mind learning to do this myself, but I’m not sure how involved it is.

If there is an experienced Netsuite coder who wants to help, I’m willing to pay for the work. Ideally, I would hire someone to create the necessary process and also show me how to duplicate that same process myself for future needs.

[johnmellis]

I can probably give you some insight into where to start and help you learn through it. Feel free to shoot me an email, john@johnmellis.com

[Author]

Posts