You’re offline. This is a read only version of the page.
We want to share data of Item Master accross companies as a new company is introduced in the system.
Questions :-
1> Procedure to share the item Master relate data (Tables) ?
2> How to find the List of tables related to item Master ?
3> Is it a good option to share item data between companies ? Will it create complexities in future ?
Please answer my question , It is very important from Project point of view.
Regards,
Nikhil
*This post is locked for comments
Hi Dennis,
I went through your post and thought you might be able to help me out. I am implementing something similar to synchronisation you pointed in InventTableModule. I am looping through DataArea table to get the list of all relevant companies but the issue I am facing is while using the changecompany() function, system missed some companies.
I am triggering the update action to other companies from certain fields in InventTableModule.
Any help will be gr8.
Thanks
Altamash
Hello, it is Henning again.
This time I have a question regarding sharing Item Configuration tables. I am very interested if somebody has some experience in that area. I have a felling that this should be easier to achieve than sharing item tables,
We are currently about to decide to use Item Configuration instead of Rule based Configuration (Product builder) in alignment with our efforts to streamline and modulize our configurable products.
So in my mind I have an idea of how it could work - when a new configuration ID is created it should immediately be available with the same configuration in all business units in our operation. All bom's and items will exist in all units.
Thankfull for input on this.
Kind regards,
Henning
Thank you Dennis.
You are confirming what we thought. Thank you pushing us in the direction of synchronizing item information.
We are thankful for all information we can get regarding this since it is very central in the setup we are planning for AX2009.
Kind regards,
Henning
Hi Nikhil and Henning,
sharing is good from maintenance point of view. However sharing the Item Master across companies looks easy, but you have to be carefull and first figure out the financial consequences. Firstly the sharing only the InventTable will not do the trick for you. For users to see actual data in the InventTable form, also the InventTableModule and InventItemLocation should contain data as well. So sharing only the InventTable across companies is not a good thing. Secondly the InventTableModule holds financials data, like last purchase price and costprice (if parameters are set). Sharing this table also means sharing purchprices, inventprices and salesprices. Depending on your version of AX and which inventory valuation model is used this could lead to practical problems. Is the valuation model of each company the same? Do you want to share the Qty fields like lowest, highest Qty, etc. Sharing the inventtable also means sharing the related tables as well, like Itemgroup, Inventory Model group, Dimension group, etc (or at least make sure the same values are used). In trading companies I always use the InventTableModule fields to automatic calculate the salesprices. How is this done in your business case?
Another issue could be using the financial dimensions of the InventTable for posting to the ledger. If company A wants to use different financial dimension value for Item X than company B does, sharing the InventTable is not likely the solution.
So the biggest problems with sharing is that's it is ALL of NOTHING. Another solution that you could consider is a thing I would like to call synchronisation. This is not a solution I can share here on this forum, but I can point you in the right direction. You can make use of the databaselog to trigger insert, update actions on the Item Master data and use this to synchronise data from company A to B etc. You can make it so flexible that you can synchronise only certain fields or even certain field that contain specific values and set it up per company. This way you can synchronise the ItemId value from the InventTableModule to create the record that is necessary to see the item in the InventTable form. Maintenance could be done in a Maintenance company and from there on it could be synchronised to the companies you are using.
Kind regards,
Dennis
Some more additional information. I have loked at the invent table and I see taht a lot of the fields will have different settings in the different unit types. I try to show it below. From my knowledge and what I have read at this tread you kan only make a whole table "global". Please correct me if I am wrong here. We are running AX 4 in 5 sites already, but not in the setup that we want to implement now.
Ok, the setup in Invent:
Company A (factory) B (Distribution) C (Sales)
Item 10 10 10
Item Descr (Multilang) ABC ABC ABC
Item Type BOM ITEM ITEM
Warehouse WH1 WH2 WH1
WH1 WH3
ITEM GROUP F F F
Main Vendor - A B
Cost price X X+ Y% X+ Z%
This is only some of the the fields, but enough to show that it is hard to have a global Invent table unlees somone has a very good idea.
I am thankfull for all kind of help I can get here.
Kind regards,
Henning
Hi.
I have read these posings with great interest.
We are currently implementing AX 2009 in our global enviromnet (1 central installation, 14 countries, 17 sites)
Our setup is Production - Distribution Center - sales units with Product Builder, Intercompany and tranparent Supply Chain.Heavy use of Project and Service modules.
Item maintenance in this setup is a major issue. The same item can be a BOM type item in the factory, but only an item type in Distribution and Sales. When a BOM is beeing created from Product Builder, it should be available to all units with the same reference ID.
The Invent table includes several fields that are used different in the different companies.
Do yo think your description of replication can be used in our setup?
Kind regards,
Henning
Hi Nikhil,
i guess you answered your first question your self.. yes.. its useful to be able to copy an item across companies and link them together according to the intercompany setup.
when you are copying items across to a different company, you must ensure that the corresponding group level data exists in both companies... so if you are copying items that belong to item group 'Std' this group must exist in the other company as well... the same rule applies to any referential field... like units, tax groups, etc...
its probably best to share these tables (group tables) via virtual company.
hope this helps.
let us know if you have any more questions.
regards,
Mohammed Rasheed
www.dynamic-ax.co.uk
Hi,
Anybody has used "Create item in Company" functionality in item master ?
I have some questions :-
1> Why is it used ?
- According to me it is useful to create a item in a Company from item in other company.
2> I was trying to do the same with a item from a company to a Blank Company(with no data)
- I got the following errors :-
- Some things missing in some tables
- And Conversion of unit code was not specified ?
I am not able to understand this error . Please help me in this issue .
Regards,
Nikhil
Hi Nikhil, In case you are unable to do so, send me the requirements and Ill send you an XPO. Remember to send me AX Version & Build Number :-)
Hi,
A quick overview on what you need to do...
-Identify which is/are the key fields in Item Master based on which the item has to be replicated
-Advisable to make these fields mandatory
-In the InventTable methods, create a new method say [replicateItem()] where you use changeCompany() method to change the company to the new company and create the item details there.
-In the Insert() method of InventTable use a try/ catch block and refer to this method [this.replicateItem()] using necessary filters
This should do.
However you need to be careful about the following
-Update of Items in 1 company- Should it be replicated in all applicable companies
-Deletions of items when there are no Transactions.
Hope it helps.
#1
Mohamed Amine Mahmoudi
100
Super User 2025 Season 1
#2
Community Member
48
#3
Zain Mehmood
6
Moderator
Share
Report
All responses (
Answers (
