RE: Item Workbook – Inventory Location Data

Answered

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.

Thanks

dbarnett Beginner Asked on October 24, 2019 in SuiteAnalytics.
Add Comment
1 Answers
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.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.