Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 3,812

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

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Integration Manager - Required fields for updating Inventory Item

    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,

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: Integration Manager - Required fields for updating Inventory Item

    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.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Integration Manager - Required fields for updating Inventory Item

    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!!!

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans