Item Workbook – Inventory Location Data


Using the new Analytic Workbooks, for an Item workbook can you still access Inventory Location data? I am not seeing the usual join/fields anywhere.


Intermediate Asked on October 24, 2019 in SuiteAnalytics.
Add Comment
1 Answer(s)
Best answer

In the Dataset:

Under Item, scroll down to Locations (note the ‘s’). From there you should find all the standards including:

Location    (use to get location name)

Quantity Available/On hand/On Order/ Etc.

In results, the column headers will look like “Locations: Location”, “Locations: Quantity Available”, Etc.

Beginner Answered on November 4, 2019.

~Sorry I am not seeing this in my account. I only see Location but not the Locations you specify.~

Edit : under further inspection, I see this option available in one of my accounts but not the original one I was querying.

Edit2:  Appears to be due to the ADVANCED ITEM LOCATION CONFIGURATION  setting being enabled

on November 4, 2019.

Interesting. We don’t use that setting. Nice catch though.

on November 4, 2019.

@dbarnett did you end up finding a solution given that setting is enabled? Trying to do the same thing and having the same problem as you.

on December 13, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor