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) / Integration Manager - ...
Microsoft Dynamics GP (Archived)

Integration Manager - Required fields for updating Inventory Item

(1) ShareShare
ReportReport
Posted on by DinB 4,085

I am trying to setup Integration Manager to update existing Items. I only need to update Current Cost. In the Destination Mapping, I am setting up all other fields at "Use Default". But some fields do not have "Use Default" option. Such as:

[Currency] >> Currency ID
[Qty/Sites] >> Site Display Options
[Vendors] >> Vendor ID

How should I configure them?

Also, what should be the "Rule" for "Record Source" in the "Options" tab for the Child Recordsets?

I want to make sure no other fields are changed by Integration Manager except Current Cost. How can I set this up?
Please advise.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    If you want to update the unit cost for the items, you need to get all related information to the inventory items (Such as Item Sites, Item vendors, etc) and then pass these value to IM. But, I am not sure if you can update the inventory unit cost without affecting other related information.

    So, better you can use the Adjust Cost Utility in Inventory to update the unit cost to the receipt. Also have a look on the below link.

    support.microsoft.com/.../872165

    Hope this helps!!!

  • Jonathan Fear Profile Picture
    Jonathan Fear Microsoft Employee on at

    Hi Max,

    As long as you are mapping the Item number and the and the Current cost that's all you need to worry about. If you do have other mappings on other folders simply set the Record Source to Use Default.

    If this is an existing integration that you use for importing items I would make a brand new integration that way you don't have to change this one too much.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    I feel it is quite essential to throw my point in here, the current cost field is a field that is used by the system and automatically populated after every single "In Transaction" in the system such as (Adjustment In, Receiving .. etc). It is the cost of the most recent replenishment transaction made in the inventory module.

    As for the Adjust cost utility, it is quite a different thing and doesn't affect the current cost at all, it way off your requirement as it affects inventory cost layers changing the actual unit cost. Additionally, it follow all the transactions related to this specific cost layer and make sure to get them updates. Corrective cost adjustment journal entries are posted to the general ledger to adjust the COGS, SALES ...etc

    Therefore, apart from the technicalities of this thread and the know-how of the IM, I feel this insight on the topic could provide some sort of an added value.

    Please never hesitate to share any further inquiries,

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

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans