We had our STC fixed asset data on another Sage Fixed Asset license along with their WSH company fixed asset data (we had two locations...WSH and STC). We sold the WSH location, so WSH kept their Sage Fixed Asset system/license. Since we needed our STC fixed asset data that was on their system, we bought a new license for our STC data. Our IT person imported the data that was within an Excel file pulled from their WSH system, but it appears 7 fields of important information was either left out of the field selection or not mapped or something not correctly done during import. I have the Excel file from their WSH system with all our STC fixed asset data showing everything we need, including the 7 fields that are now missing after importing data into this new STC licensed system we're using.
I'm not sure if I'm not "viewing" the data properly or maybe I'm missing a setting, but can someone help to verify what I'm thinking is accurate (i.e. they didn't correctly map the 7 fields during import) and help me with what I need to do next? Can I delete this company + data and re-import again from the Excel file ensuring all data is mapped?
When I first went into this new STC system I had to change "My Views" and select the 7 fields that were missing to see them since these columns of data weren't showing, but now that they show all their data shows "zeros" for all the dollar value fields, "NO" for Depr Method, and "00 yrs 00 mos" for Est Life.
The 7 fields missing after importing into the new system are the following:
- In Svc Date (shows blank except for 2 of the 450 items)
- Acquired Value (shows as $0.00)
- Current Accum (shows as $0.00)
- Current YTD (shows as $0.00)
- NBV (shows as $0.00)
- Depr Method (shows "NO" for most, but then "MA200" for the two items that had In Svc Dates listed)
- Est Life (shows "00 yrs 00 mos," but then it shows "07 yrs 00 mos" for the two items that had In Svc Dates listed)
