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
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
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):
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]
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
Thanks Andrea, your information is very detailed.
Julia
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:
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
#1
Martin Dráb
601
Most Valuable Professional
#2
Abhilash Warrier
416
#3
Adis
384
Super User 2025 Season 1
Share
Report
All responses (
Answers (
