1. Web Reports Gen2 Report Creation
  2. Convert Report to Gen2

Convert Report to Gen2

Now let’s convert the above report to WebReport Gen2.

If we pick up the Web Report Gen1 Categories and map them to Web Report Gen2, the following is what we will get:

Note about Importing Gen1 WebReports into Gen2

Note: It is possible to download a Gen1 webreport to get a .wr report definition file downloaded and then to attempt uploading it into Gen2. However, you will not get a working report via this process. Many reports will simply not import and will fail with a "500 Error". A few simple reports might import without such an error; however, the categories and filters will be empty and will not execute. At best, you might get the field layouts. Even in this scenario, you will have to change all the fields to use the appropriate Gen2 categories and fields. So, in short, this mechanism may at best give you a basic starting point for just the field layout, and in most cases will not work at all.
Gen1 Categories Gen1 Categories Mapped to Gen2
SimpleInventory
  • inventory
  • facility (inner)
  • inventory_status (inner)
  • inventory_attribute (left outer)
  • batch_number (left Outer Join)

Inventoryitem

  • item
  • company (inner)
  • putaway_type (left outer)
  • item_characterstics (left outer)
  • lpn_type (left outer)
  • item_metrics (left outer)
  • item_struct (left outer)
  • item_hierarchy_defn ( one for each hierarchy level) (left outer)
  • item_group_defn (left Outer)
  • property_prompt_mode ( left outer)
  • harmonized_tariff ( left outer)
  • uom (left outer)
Container
  • Container
  • container_status (inner)
  • facility (inner)
  • company (inner)
  • lpn_type (left outer)
  • pallet (left outer)
  • pallet_status (left outer)
  • audit_status (left outer)
ContainerCurrLocation
  • Location
  • Facility (inner)
  • item_assignment_type (inner)
  • location_type (inner)
  • company ( dedicated company on location) (inner)
  • inventory_lock (left outer)
  • location_size_type (left outer)
  • mhe_system (left outer)
  • mhe_type (left outer)
  • item ( on dedicated item at location) (left outer)
InventoryLocation
  • location
  • company (for dedicated company on location) (left outer join)
  • company (for destrination company on location) (left outer join)
  • facility (inner join)
  • item_assignment_type (inner join)
  • location_type (inner join)
  • inventory_lock (left outer join)
  • location_size_type (left outer join)
  • mhe_system (left outer join)
  • mhe_type (left outer join)
  • item ( for dedicated item on location) (left outer join)
  • task_zone (left outer join)
  • replenishment_zone (left outer join)