web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Item Currency and eCon...
Microsoft Dynamics GP (Archived)

Item Currency and eConnect

(0) ShareShare
ReportReport
Posted on by Galina 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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    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.

  • Galina Profile Picture
    Galina 1,077 on at

    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 on at

    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,077 on at

    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.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    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,077 on at

    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 12 on at

    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?

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans