Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Item Currency and eConnect

(0) ShareShare
ReportReport
Posted on by 1,077

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
    12 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
    1,077 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
    12 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
    1,077 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
    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
    1,077 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
    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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans