03/03/2021 - v3.5.19.6

Added to Packages Dashboard an Editable Field Drop-Down

Added to Packages Dashboard an Editable field drop-down. To create a drop-down for an editable field:

1. Identify an editable field on a Packages Dashboard report. In this example Fabrication Labor Factor MCA is editable, but it is a text box.

   Open

   

    

2. Locate the editable field Under Admin > Company > Fields.

3. In the Possible Values column, enter the drop-down options separated by a semi-colon. In this example, 0.30;0.50;0.70.

   Open

   

    

   1. Note: The default value (0.30) was included and each value includes 2 decimal places since the report will display Decimal and Precision = 2.

       

4. On the Packages Dashboard the Possible Values will display.

Added Date-Time Tracking Status Log Properties and Hours Field Expression Function

To enhance data metrics based on tracking status changes, new Tracking Status Log Properties and an Hours Field Expression function have been added.

Tracking Status Log Properties

Added the following Tracking Status Log properties:

• Part - STRATUS.Part.TrackingStatusLogDT

• Assembly - STRATUS.Assembly.TrackingStatusLogDT

• Package - STRATUS.Package.TrackingStatusLogDT

In the example below, the existing STRATUS.Part.TrackingStatusLog property displays a semi-colon delimited list of Tracking Status changes. These are now directly linked to the date-time changes in the STRATUS.Part.TrackingStatusLogDT property. Note: Duplicate tracking status changes made in sequence to the same status are filtered out of the report output.

Hours Field Expression Function

The Hours Field Expression function (HoursInTrackingStatus) calculates the time an item has been in a tracking status. Below are 2 examples of how the STRATUS.Part.TrackingStatusLog and the HoursInTrackingStatus function can be used in a Field Expression.

1. Calculate how long an item has been in a tracking status. For example:

   1. The field expression below uses the new HoursInTrackingStatus function and says look at the part tracking log and then match up the part tracking status date-time for the part, and then calculate the time the part has been in the Issued tracking status.

   2. HoursInTrackingStatus({STRATUS.Part.TrackingStatusLog},{STRATUS.Part.TrackingStatusLogDT},'Issued')

      1. Note: In this example, if Issued is the current tracking status, the clock is still running, meaning the HoursInTrackingStatus function will return the time since the status change was made to the present time.

      2. Also Note: The value returned is hours. It may make more sense to convert to days by dividing by 24.0, or, in the case you want to report working days, you could multiply that result by 5/7.

2. Calculate how long it took to move from one tracking status to another. For example:

   1. The field expression below uses the new HoursInTrackingStatus function and says look at the assembly tracking log and then match up the assembly tracking status date-time for Packaged and then provide the amount of time it took for the tracking status to change to Shipped, and use Eastern Standard Time.

   2. HoursInTrackingStatus({STRATUS.Assembly.TrackingStatusLog},STRATUS.Assembly.TrackingStatusLogDT},'Packaged','Shipped','Eastern Standard Time')

      1. Note: Eastern Standard Time is the specific way a time zone is referenced by Microsoft. For a list of other time zones, refer to this external article List of Timezone IDs. The time zone is needed to handle the case where the clock is still running, meaning the assembly has not reached the Shipped status in this example.

      2. Is Total - The field’s Is Total checkbox should be checked when the report used by the field needs to drill into the part level to total hours.

Report Average and Sum Hours

Tracking Status hours can be displayed in a report using the new Aggregate Report Field options (Average or Sum). See the Added Aggregate Report Column to Include Average section for more information. The Aggregate column replaced the previous Total Values column. Report Fields that had Total Values set to Yes have been converted to use the new Sum option.

Example - Assembly Report to Track Times

Example - Package Report to Track Times

Added Aggregate Report Column to Include Average

Note: Under Admin > Company > Report > Report Fields, this addition has replaced the Total Values column with the Aggregate column. As a result, if you had previously set Total Values to Yes, it has been converted to Sum. The new Aggregate column adds the ability to Average totals.

Added the Ability To Not Use An Incrementor In Piece Numbers

Added the ability under Admin > Company > Naming and Numbering > Numbering Rules > Item Number Format to set the incrementor to None. With None selected the Item Number will not be inserted into the piece tag when using the Renumber All Item Numbers option in the Viewers.

Container Updates

Updated Containers to Display Part’s BOM Description

Updated the Containers Assign to display the part’s BOM Description. The part's item number is appended in parenthesis to the end of the BOM description.

Added to Containers Tracking, Options to Capture Image and Add Attachments

Added to Containers Tracking, options to Capture Image and Add Attachments.

Added Link to Container from Filter

Add a link to the Container from the from Models > Viewer > Filters > Container filter.

Fixed a Spool Checker Issue

Fixed an Assemblies > Viewer > Spool Checker issue where in some cases checking or unchecking the Locked checkbox did not save.

Fixed Packages Dashboard Import CSV “Do Not Use Package Number“

Fixed a Packages Dashboard Import CSV issue to not require a Package Number when the Do Not Use Package Number setting is checked under Admin > Company > Naming and Numbering > Naming Conventions.

Removed from Containers Hours and Cost Type

Removed Hours and Cost Type fields from Containers > Tracking as they cannot be guaranteed to be associated with a single project/model/package.