Fixed Asset Import Error

(0) Share

Report

Posted on by Kelvin Hew

195

I'm trying to import fixed asset General information to GP2013 using "Asset Import/Export" windows.

I've done few FA migration for other companies previously, and I'm still using the same template for this migration job.

Problem now appear once I start the process by selecting <Continue> in "Asset Import / Export".

A message showing:

" Field not found in dictionary. (Line #5)"

I tried using the type "Tab" and "Comma" but no luck on that.

Appreciate your help.

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (0)

Olaf Laos 1,890 on at

Like (0)

Report

RE: Fixed Asset Import Error

Has the Asset General Information window been modified or customised from the standard version at all?

I believe the import is based on running a macro - and perhaps what it expects to work with as standard isn't what is actually there?

Was this reply helpful? Yes No
Kelvin Hew 195 on at

Like (0)

Report

RE: Fixed Asset Import Error

Previously we also thought that the customization might have interfere the data import process. We tried to off all the customization and do another round of import and the result is still the same.

Yes, you're right, and the import is running on macro mode.

We also tried doing the manual data entry into the Asset General and Asset Book by using the available data, GP able to save the data without any message prompt.

Was this reply helpful? Yes No
Olaf Laos 1,890 on at

Like (0)

Report

RE: Fixed Asset Import Error

So perhaps use a Dynamics user that has security set to use the standard version of the Fixed Asset window and then for that session, "disable" the customisation via Tools > Customise > Customisation Status - and then run the import macro.

Was this reply helpful? Yes No
Kelvin Hew 195 on at

Like (0)

Report

RE: Fixed Asset Import Error

We have tried what you suggested, but we still getting the same error message.

Was this reply helpful? Yes No
Theresa Gulbranson 800 on at

Like (0)

Report

RE: Fixed Asset Import Error

I've also experienced problems with the Book import using this utility. I don't think the macro that's created is updated for GP 2013. Any ideas how the macro is created in this process?

Kelvin, have you reviewed the macro to see if all fields exist? The macro I'm looking at for the Book import mentions a Redisplay field, but that field is not on the window.

Was this reply helpful? Yes No
Kelvin Hew 195 on at

Like (0)

Report

RE: Fixed Asset Import Error

Hi Theresa, we are currently liaise with Microsoft support to tackle this problem. They, too suggesting to remove the "Redisplay field" manually in macro file and run. However, the same error message pop out.

When we open the macro file back for checking, the "Redisplay field" is appear back again.

Below shows the actual lines stored in the macro file.

------------------------------------------------------------------------------------------------

OpenForm dictionary 'Fixed Assets' form 'FA_General_Maintenance'

NewActiveWin dictionary 'Fixed Assets' form 'FA_General_Maintenance' window 'FA_General_Maintenance'

MoveTo field 'Clear Button'

ClickHit field 'Clear Button'

MoveTo field '(L) Redisplay'

ClickHit field '(L) Redisplay'

# *****

# ***** GENERAL (Begin)

# *****

MoveTo field 'Asset ID'

TypeTo field 'Asset ID','B-01-03-1'

MoveTo field 'Asset ID Suffix CMB' sitem

NatTypeTo field 'Asset ID Suffix CMB','1'

MoveTo field 'Asset Description'

TypeTo field 'Asset Description','I-STATE 1 ANALYZER'

MoveTo field 'Asset Class ID'

TypeTo field 'Asset Class ID','B-01'

MoveTo field 'Asset Type' item 1

ClickHit field 'Asset Type' item 1

MoveTo field 'Property Type' item 1

ClickHit field 'Property Type' item 1

MoveTo field 'Account Group ID'

TypeTo field 'Account Group ID','B-01'

MoveTo field 'Acquisition Date'

TypeTo field 'Acquisition Date','09/01/2008'

MoveTo field 'Currency ID'

TypeTo field 'Currency ID','MYR'

MoveTo field 'Acquisition Cost'

TypeTo field 'Acquisition Cost','8888'

MoveTo field 'Physical Location ID'

TypeTo field 'Physical Location ID','1090'

MoveTo field 'Asset Label'

TypeTo field 'Asset Label','B-01-03-1-1'

MoveTo field 'Location ID'

TypeTo field 'Location ID','B-01-03'

MoveTo field 'Asset Quantity'

TypeTo field 'Asset Quantity','1'

MoveTo field 'Date Added'

TypeTo field 'Date Added','09/01/2008'

MoveTo field 'Save Button'

ClickHit field 'Save Button'

# *****

# ***** GENERAL (End)

# *****

----------------------------------------------------------------------------------

We are still pending from Microsoft support feedback on this matter.

Was this reply helpful? Yes No
Heather Roggeveen 9,146 on at

Like (0)

Report

RE: Fixed Asset Import Error

Hi

I have just been trying to do assets using this tool for a new client - first time on 2013 for this. I am experiencing the same issue. I can however offer further diagnosis.

You need to remove the references to the redisplay field at the start of the macro.

The other issue is that there should be two additional lines at the end of each record:

MoveTo field 'Clear Button'

ClickHit field 'Clear Button'

I found it easy enough to do a "find and replace" by opening the macro in Word and using Ctrl H. I used the 'ClickHit field 'Save Button'' as my find reference. I then replaced it with:

ClickHit field 'Save Button'

MoveTo field 'Clear Button'

ClickHit field 'Clear Button'

In order to do that replace (because it is three lines) I needed to copy the full text and then for the replace option in Word, choose the "More" button, "Special" and "Clipboard Contents".

This worked fine for the General tab, however is not so easy for the Book tab - there are two references to the Save Button. I have given up for now and may resort to using Integration Manager instead. I have read many a post that says it is quicker and with better error messaging. I have never bothered in the past because I find this macro really easy to use and have done it many times.

Regards

Heather

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Fixed Asset Import Error

One of our client is having this issue a week ago and I can confirm that the problem is actually on the macro generated by the system. The temporary resolution is the same as what Heather Roggeveen's suggested. In addition to Heather's suggestion, you need to run the edited macro from Tools-->Macro-->Play. I you run the macro from Asset Import / Export window, it will recreate and overwirite the edited macro and you will get the same error message.

Was this reply helpful? Yes No
Kelvin Hew 195 on at

Like (1)

Report

RE: Fixed Asset Import Error

Microsoft support has replied to us and David Musgrave has also provide us the following workaround solution for this matter:-

1. Prepare the import file as normal.

2. Go to Tools >> Utilities >> Fixed Assets >> Asset Import /Export.

3. Choose a location to save the Macro to that you can easily access.

4. Do not select the “Run Macro after creation” option.

5. In the “Enter or select pathname of file to import or export” select the import file prepared in step 1.

6. Click continue.

7. Open the macro file created in step 6 and remove lines 5 and 6:

“MoveTo field '(L) Redisplay'

ClickHit field '(L) Redisplay'”

8. Save the macro. Be sure to append .mac to the end of the file name if the file type is not set Right click the macro and choose properties.

9. Set the macro to read only so it will not be overwritten in the next step.

10. Click OK.

11. In GP open the Asset General window (Cards>Fixed Assets>General).

12. Select view and click ‘Redisplay’ if there is a checkmark next to it.

13. In the Asset General Window, click on Tools >> Macro >> Play.

14. Navigate to the Macro you just saved, and click 'Open'.

Cheers guys.

Was this reply helpful? Yes No
CristianGuerrero 5 on at

Like (0)

Report

RE: Fixed Asset Import Error

thanks, are present m the same error and run this helps

Was this reply helpful? Yes No