If you’re in an environment where you have multiple companies setup and each company uses the same items, you might be tempted to share the item table across all companies.<\/p>\n
In versions prior to 5.0, you can get away with this since the Adjust Cost process are done using the Item Ledger and Item Application Entry table. When inventory is taken out, it’ll use the proper average cost when the Adjust Cost process is ran.<\/p>\n
However, in version 5.0, they introduced the Avg. Cost Adjmt. Entry Point table and the Cost is Adjust field on the item card. This means that if if you just share the tables and adjust cost is ran for Company A, it’ll mark the Cost Is Adjusted to true. This means that the Adjust Cost process will never be ran for Company B. In addition, when transactions are posted for Company B, it’ll look at the Avg. Cost Adjmt. Entry Point table and detect that the cost has not been adjusted and mark it for adjustment again.<\/p>\n
The best solution to this problem is to suggest the users to update item information for both companies. However, if the business requirement is to share the Item table, it’s recommended that you keep the tables separate. And write a batch process to update items\u00a0at the end of day or if it needs to be real time, write code to something like:<\/p>\n
\u00a0 ItemCompanyB.CHANGECOMPANY(‘Company B’);
\n\u00a0 IF ItemCompanyB.GET(“No.”) THEN BEGIN
\n\u00a0\u00a0\u00a0 CostPostedGL := ItemCompanyB.”Cost is Posted to G\/L”;
\n\u00a0\u00a0\u00a0 CostAdj := ItemCompanyB.”Cost is Adjusted”;
\n\u00a0\u00a0\u00a0 UnitCost := ItemCompanyB.”Unit Cost”;
\n\u00a0\u00a0\u00a0 ItemCompanyB.TRANSFERFIELDS(Rec);
\n\u00a0\u00a0\u00a0 ItemCompanyB.”Cost is Posted to G\/L” := CostPostedGL;
\n\u00a0\u00a0\u00a0 ItemCompanyB.”Cost is Adjusted” := CostAdj;
\n\u00a0\u00a0\u00a0 ItemCompanyB.”Unit Cost” := UnitCost;
\n\u00a0\u00a0\u00a0 IF NOT ItemCompanyB.INSERT THEN
\n\u00a0\u00a0\u00a0\u00a0\u00a0 ItemCompanyB.MODIFY;
\n\u00a0 END;<\/p>\n
You can probably write a better code, but you should be able to get the idea. This will also require that all the item master information be entered into one company.<\/p>\n","protected":false},"excerpt":{"rendered":"
If you’re in an environment where you have multiple companies setup and each company uses the same items, you might be tempted to share the item table across all companies. In versions prior to 5.0, you can get away with this since the Adjust Cost process are done using the Item Ledger and Item ApplicationRead more<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1],"tags":[33,55],"class_list":["post-24","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-inventory-costing","tag-share-tables"],"yoast_head":"\n