Query TISS Errors duplicate Items

Data Integrity Checks
Summary:	A TISS28 item exists twice
Related:	TISS28
Firmness:	hard check
Timing:	always
App:	TISS28.mdb
Coding:	query TISS_Errors_duplicate_Items
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	not entered
Backlogged:	true

• Cargo

• SMW

"TISS28.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. 

• Categories:  

• form:

Causes and solutions

If any records are listed, delete the form (see #How to resolve and delete a duplicate Tiss form during import) and then re-scan.

That link didn't resolve... what is it that is actually done here?

• SMW

• Cargo

• Categories

Could fix these one by one, but usually it's quickest to just re-scan.

is it really true that a re-scan is quicker than Deleting a duplicate record from the TISS pre-import file?

• SMW

• Cargo

• Categories

Log

2019-02-11 - updated to check the last 90 days of TISS items rather than all since 2016