1. Have JCA run a report that identifies the double-equipment entry (usually the B2W Comparison Report in their company's Job Cost folder). Or you can run it yourself using this BI Report: \\PRD-SA21-901\_BIReports\_All Companies\Job Costing\All Sage Companies to B2W comparison . Just run the report with the appropriate date range (and the rest as defaults) and then use the Equip Usage Tab to find the Company (there is a slicer for that) and the FLs of interest (use the header drop-down to select the FLs).

2. Locate the folder that was imported, with the equipment you'd like to alter the time on.

3. Unzip the folder, and open the Equipment spreadsheet.

4. Verify the FLs of interest are in this in this spreadsheet.

5. Select an empty column(quite often V works) and type (or copy and paste) =-U2 Copy this until the end of the data in U2.

6. Copy the new data into Column U, and paste just the values. Right click the 2nd row of column U, and select the 2nd option under Paste. 

7. Repeat for Column 'W'

8. Ensure that any columns you used to alter the data are set to zero again.

9. Close the Equipment spreadsheet

10. Right click on the unzipped folder, and re-zip it.

11. Import that folder, and select "Equipment only" while importing (period end date doesn't matter since it is not used during equip imports, but good practice to set to correct end date).

12. Re-run the report that you first ran in Step 1 and verify that the fix was successful (may need to sub-total by Asset_No).