Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Item Currency and eConnect

Posted on by 1,075

What are the requirement for currency setup to integrate inventory items using eConnect?
We don't have Multicurrency registered. We do have Functional currency set up.
I've noticed that if item is created just by filling an Item Maintenance card there is a record added for IV00105 table before a record is added to IV00101 table. Is it a normal behaviour or is there a way to avoid it?

GP 2013 R2.

*This post is locked for comments

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Item Currency and eConnect

    As mentioned above - not familiar with eConnect - but is there a way to 'force the size' of the data?  Can you format that field to by 2 decimal?

    What happens in GP if you import 5 decimals into the 2 decimal space - do you get errors or rejected?

  • Galina Profile Picture
    Galina 1,075 on at
    RE: Item Currency and eConnect

    The is no error, actually, just the issue.

    When the item is created using eConnect destination adapter currency decimals will be set to 5, and our USD currency is using 2. I suspect it's because the record in IV00105 table not being created properly during the process if Multicurrency is not registered.

    When using IM adapter everything works as it should.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Item Currency and eConnect

    Galina, you noted you do not have Multicurrency enabled.  What is the error or is it that you need to import into the IV00105 for at least the Functional Currency - a one time process?

    We have / are using IM to import Items into the system and do not have issues with the MC requirement.

  • Galina Profile Picture
    Galina 1,075 on at
    RE: Item Currency and eConnect

    Thanks for the suggestion, but I already have all necessary integrations with IM implemented.

    Ideally, I'd want to move everything to BizTalk server we have and use its eConnect adapter. Almost done with that, but Inventory Item is the one that gives me hard time because of the multicurrency requirements.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Currency and eConnect

    Galina, if you are going to automate with IM for this integrations then you can use AutoDim tool.  I have used this in one of my previous projects.  What is the GP Version you use?

  • Galina Profile Picture
    Galina 1,075 on at
    RE: Item Currency and eConnect

    Thanks for the reply!

    Unfortunately running check links is not an option for us since I'm trying to implement automatic process.

    For now I'm just starting Integration Manager via macro and using its adapter rather than eConnect. Very clunky...

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Currency and eConnect

    Galina, while importing the items you don't need to import in IV00105 table.  After importing you can run Check Links on the Item Master in order to create this.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans