ID299 - Duplicate Serial Number Created in Equipment File (Regardless of Model) Overview & Sample: – CEO Juice

Alert to check for duplicate serial numbers on equipment records, regardless of the model on the equipment record.

Jump to a specific section by clicking a link

Overview

Overview

To ensure all your ACTIVE equipment records have unique serial numbers, this alert will let you know when there are duplicates, regardless of the make/model. (e-automate will not allow a duplicate serial number to be entered for the same model, but will let you enter a duplicate if the host model is different.)

You can have the alert check for duplicates on just host models or all equipment records. If your company is not using the serial numbers from inventory for creating accessory equipment records and instead is using the host serial number as the accessory serial number, you'll want the alert to only trigger for the host models.

The alert can also check just active equipment records or all records if you want to check inactive equipment records for duplicates.

NOTE: This alert reports the contract number for the serialized items, and it is likely that it will repeat for any duplicate serial numbers that are on multiple active contracts.

Run Schedule: Weekly on Mondays

Type of Output: Email

* * *

Sample

Sample

* * *

Variables

Variables

Variable W: ALL or HOST - Enter either ALL or HOST. ALL will check all equipment records for duplicates regardless of the model type. HOST will only check equipment records where the model is marked as a host and ignore all others.

Variable X: ACTIVE or ALL - Enter either ACTIVE or ALL. ACTIVE will only check active equipment records for duplicates. ALL will check all equipment records, both active and inactive.

Variable Y: Branch Filter - Enter the branch numbers to trigger on, separate multiples with commas. Leave blank to trigger on all brances.

* * *

Alert Functionality

Alert Functionality

1. The alert can trigger for all equipment records or only those where the model on the equipment record is marked as a host. When variable W is set to ALL, the alert will trigger for both Host and Accessory; when the variable is set to HOST, it will only trigger when the Host option is checked on the model record.

2. The alert can trigger for just active equipment records or all equipment records, regardless of whether the record is active or not. When variable X is set to ACTIVE, it will only trigger when the Active box on the equipment record is checked. When variable X is set to ALL, it will trigger on all equipment records, both active and inactive.

3. The branch used to filter the records in variable Z is the branch on the equipment record.

* * *

Best Practices & Tips

Best Practices & Tips

None at this time.

* * *

Related Alerts

Related Alerts

None at this time.

* * *

Overview

Sample

Variables

Alert Functionality

Best Practices & Tips

Related Alerts

0 Comments