Fixed Asset Import Macro - Change Macro Order

(0) Share

Report

Posted on by Community Member

We have a client that wants to add a suffix to their fixed asset and have that suffix be a different class ID. When the macro runs it put in the Class ID, then the asset id which then autofills the form and changes the class id to what it was for suffix 1, then it changes the suffix to suffix 2 but the class ID stays what it was for suffix 1.

I was hoping to find to a configuration file to change how the Macro is built, but that file doesn't seem to exist. I then tried to decompile the fixed assets .dll file to find the code in there, but that was a bit above my head. Does anyone know a way to alter the fixed assets import macro to change the order so that the class id is put in after the asset id to avoid this error?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

L Vail 65,271 on at

Like (0)

Report

Hi,

Where did you get the macro you are running? You can change the Account Group, but I'd first need to see the macro. I don't think I understand exactly how you are importing the assets.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

It's the macro that is generated by the Fixed Asset Import Export utility. I want to change the order of the Macro being created.

Was this reply helpful? Yes No
Verified answer

L Vail 65,271 on at

Like (0)

Report

Hi,

There is a way to do this, but you will need to do it yourself. Take the Macro that the system creates and change the location of the Asset Class ID lines. At the end of the day you'll be using the mail-merge feature of Word to create your own macro. The macro starts:

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'

MenuSelect title View entry Redisplay

# *****

# ***** GENERAL (Begin)

# *****

MoveTo field 'Asset Class ID'

TypeTo field 'Asset Class ID','FURN'

MoveTo field 'Asset ID'

TypeTo field 'Asset ID','6000ATM'

MoveTo field 'Asset ID Suffix CMB'

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

You will need to change this to read:

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'

MenuSelect title View entry Redisplay

# *****

# ***** GENERAL (Begin)

# *****

MoveTo field 'Asset ID'

TypeTo field 'Asset ID','6000ATM'

MoveTo field 'Asset ID Suffix CMB'

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

MoveTo field 'Asset Class ID'

TypeTo field 'Asset Class ID','FURN'

The next thing is that you will need to do is to use your source as a list for the mail-merge and replace each one of the hard coded 'type to' fields with a field from your source. I would use Excel instead of a .csv file.

I am not able right now to type the details, but I'll be happy to discuss it with you on the phone. I know David Musgrave has done a detailed article on how to do the mail-merge concept, but it isn't specifically about Fixed assets. My phone is 972-814-8550. If you are really interested in doing this, please give me a call.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I ended up changing the macoro and using mail merge, I was hoping to avoid that for ease of use for the client.

Thank you for your time!

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Thanks!

The Mail-merge macro to the rescue once again!

Kind regards,

Leslie

Was this reply helpful? Yes No
Ken Hubbard on at

Like (0)

Report

There is not a means to change the way that the Asset Import utility creates the Macro. You could edit the Macro after the fact and switch the lines around so that the edit to the Class ID field is after the Asset ID field, but that would probably be just as much work as hand keying each of the assets in the first place.

Have you considered using Integration Manager with the Econnect adapter to bring these in?

Thank you,
Ken Hubbard

Microsoft Dynamics Support

Was this reply helpful? Yes No