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

Community site session details

Session Id :
Business Central forum

How do we manage the item mapping inter-company wise?

(0) ShareShare
ReportReport
Posted on by

For an example;  Company A and B are inter-companies.

if Company A creates a purchase order with item X - ID 001 & Item Y - ID 002 ,to buy some goods from B, due to inter-company setup, the system will automatically generates a sales order in Company B. However, to come up the Company B's sales order as specific to Company A's Purchase order, the item X and Y should be with same ID codes as 001 and 002 in Company B's item master. 

So, is there any other way to avoid this situation?

How do we manage the item mapping inter-company wise?

Categories:
I have the same question (0)
  • Verified answer
    AJAnsari Profile Picture
    5,754 on at
    RE: How do we manage the item mapping inter-company wise?

    To my knowledge, there is no out-of-the-box item mapping option in Business Central. If you are a developer, I invite you to play with Item Cross-References, where you can set a Cross-Reference code for Customers and Vendors. If you have an Intercompany Partner set up as a Customer or a Vendor (which you should, if you are buying and selling items), you can consider developing an extension in AL to look at the Cross-Reference code for an item associated with the Intercompany Customer to map it to the appropriate item in the other company.

    Or, you can do something similar to what Microsoft has done with Intercompany Chart of Accounts in Business Central, and develop a extension that uses a central mapping table for Items, and then write code to use this mapping table to locate the correct item in an intercompany transaction.

    I hope this helps. If my response has answered your question, please verify by clicking Yes next to "Did this answer your question?"

  • Verified answer
    Community Member Profile Picture
    on at
    RE: How do we manage the item mapping inter-company wise?

    Yes, we can use Cross-Reference function in order to do the item mapping for inter companies based on Customer/Vendor.

    In the ITEM card, Navigate -> Cross References -> Select Customer/Vendor, Add Customer/Vendor Number, Add Cross Ref. No (Item no of other company)

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans