Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Absolute beginner here and may be a silly question but,
I am trying to build a chart with ParentStockItem -> Stock Items -> Serial Lot Numbers -> Lot Locations. I would like the values of available and on hand to be shown in the chart. I have gotten to the point where I am getting all the correct data in the chart except for when I expand into the lot locations I get repeated numbers as if the Serial Lots and Locations are not connected. I am sure this is a coding error and if someone could help me fix it that would be awesome.
check your joins and associations with facts and locations