Integration Manager - Fixed Assets

(0) Share

Report

Posted on by Julia_Gallegos

Hi,

Is it possible to create an integration multicurrency? I need to craete a fixed asset integration but we have assets in different currencies. Is for Dynamics GP 2015.

Thanks

Julia Gallegos

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Andrea Melroe 3,437 on at

Like (2)

Report
Copy link

Link copied!
Hi Julia,

This is Andrea, and I’ll assist you with your question today.

First, I want to quickly talk about Multicurrency in conjunction with Fixed Assets overall:

Originating currencies can recorded in Fixed Assets in two places:

When entering the originating acquisition cost of the asset in the Asset General window (so when first entering the asset).

When retiring the asset.

As such, you can report on originating currency information when an asset is first ‘added’ to the system and/or when it is ‘retired’.

With that being said, all transactions done in Fixed Assets are done in functional currency only. It’s not possible to depreciate in originating currency if that’s what you’re looking to do.

Now, on to your question on Integration Manager and originating currency assets:

Currently, it is not possible to integrate an originating currency asset into GP via Integration Manager. Integration Manager uses eConnect adapters for Fixed Assets, and eConnect is stored procedure based. The taCreateAssetID stored procedure used to create a new asset automatically assigns the functional currency from the MC40000 table to be the currency id used for the new asset. There is also no logic built into the procedure to ‘look at’ the exchange tables should the currency id ‘not’ be the functional currency.

eConnect does not rely on dexterity code or any front-end functionality of the Microsoft Dynamics GP product. Instead, it inserts/updates data directly in appropriate tables using the eConnect stored procedures. There is business logic built into eConnect, but it is not exactly the same as updating a transaction on the front end. As such, there are some areas on eConnect that behave differently, and this is one of them.

While you can’t use Integration Manager to bring ‘originating currency’ assets into GP, you CAN use the Asset Import/Export Utility in GP (Microsoft Dynamics GP >> Tools >> Utilities >> Fixed Assets >> Asset Import/Export) to accomplish that!

I’ve attached our Fixed Assets pdf to this communication. Chapter 7 (starting on page 63) talks about how to use the utility to import assets.

I hope this helps!

Andrea Melroe | Microsoft Support

0574.FixedAssets.pdf

Was this reply helpful? Yes No
Julia_Gallegos on at

Like (0)

Report
Copy link

Link copied!

Thanks Andrea, your information is very detailed.

Julia

Was this reply helpful? Yes No
Julia_Gallegos on at

Like (0)

Report
Copy link

Link copied!

Andrea,

To use the import utility do I need one txt file per asset window? Do I need to identify the file with some special name?

thanks

Julia

Was this reply helpful? Yes No
Suggested answer

Andrea Melroe 3,437 on at

Like (1)

Report
Copy link

Link copied!
Hi Julia,

First, you’re very welcome and I’m glad the information above was helpful!

To answer your question, yes, I recommend you have a separate file for ‘each’ window you want to import into. The ‘name’ of the file doesn’t really matter. I’d recommend you use something simple that allows you to easily identify what the file is for.

You’ll want to bring the Asset General in first, then bring in the Asset Book if you are not relying on GP to create that record for you (via Auto Add Book Info box in Asset General window).

If you plan to bring in unique Asset Book information (information that would not be automatically created for you in GP when auto add book info is marked), then you’ll want to import the Asset Book information next.

If you are planning to import the Asset Book information, then make sure the Auto Add Book Info box is unmarked in all the following windows prior to when you import the Asset General data (as these settings drive whether that box is marked in the Asset General window):

Fixed Assets Company Setup (Microsoft Dynamics GP >> Tools >> Setup >> Fixed Assets >> Company).

Book Setup (Microsoft Dynamics GP >> Tools >> Setup >> Fixed Assets >> Book) – check any books you are integrating for.

Book Class Setup (Microsoft Dynamics GP >> Tools >> Setup >> Fixed Assets >> Book Class) – check any book/class combinations you are integrating for.

I’m attaching an excel file for you here. You can use this file as a guide for the files you create to test your import. Simply copy and paste the header line into a new excel file depending on which window you’re importing into. Then, fill in the data (according to how it should be mapped) appropriately and test your import (I recommend doing that in a test company first).

Additionally, here’s an article that covers the most common problems/questions users have when importing with the Import/Export Utility in FA:

GP Import for asset information fails for Fixed Asset Management in Microsoft Dynamics GP

Good luck!

Andrea Melroe | Microsoft Support

[View:/cfs-file/__key/communityserver-discussions-components-files/32/AssetImportTemplateHeaderWithExamples.xls:320:240]

Was this reply helpful? Yes No
Julia_Gallegos on at

Like (0)

Report
Copy link

Link copied!

Thanks Andrea,

I have GP2015 and the process to generate the macro has some errors, I need to modify the macro to correct it...

- Delete line 5: MenuSelect title View entry Redisplay

- Copy these lines after the instruction save for each asset:

MoveTo field 'Clear Button'

ClickHit field 'Clear Button'

With these changes the macro works.

Regards

Julia

Was this reply helpful? Yes No