hi Yifat
A few additional problems:
If there is requirement to share inventTable across multiple companies then there is good chance that there are inter-company transactions for these items. i.e. an item will be manufactured in one company and sold to another group company.
Notice that this further means that an item will have to be of type BOM in the company where it is being manufactured and the item will have to of type ITEM in the company where it is being purchased.
Further, potentially the "item group" will have to be different since in one company it is being posted as finished goods and in other company it is being posted as raw material.
The only way out is to share the invent table by code.
regards
harry
ps: on (sort of unrelated) complication is min quantity, max quantity (especially for inventory), if a factory has two machines where the values for these fields differ per machine then some more modifications are required. This will have some significance in batch-processing environment.
ps: on (sort of unrelated) complication is min quantity, max quantity (especially for inventory), if a factory has two machines where the values for these fields differ per machine then some more modifications are required. This will have some significance in batch-processing environment.
Yifat Mervis <[EMAIL PROTECTED]> wrote:
Hi there,
Just a thought...
When sharing the inventtable, you may or may not want to share the
inventtablemodule table. This table has all the prices for the items. If
you do not share this table, every time you add a new item in one
company you will have to run a consistence check with fix, so that the
inventtablemodule is populated.
Again, the inventtablemodule holds the prices, as in our case, the sales
prices of the items were different in the different companies... so the
customer opted not to share this table and a consistency check needs to
be run every time a new item is created.
Good luck
______________________________________
Yifat Mervis
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of
Dyachenko, Dmitry
Sent: Thursday, July 14, 2005 12:43 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Sharing InventTable for multiple
companies
I did it for CustTable. Nothing difficult, actually, but you need to
understand axapta tables schema (for Inventory module, of course) very
well. Otherwise, I'd not recommend you to follow "sharing" way.
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Jayson
Joseph Thattil
Sent: Thursday, July 07, 2005 10:35 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] Sharing InventTable for multiple
companies
Hi All,
Thanks for the inputs.
We are planning to share the items only across the
companies. I understand now that I need to share
Itemgroup / model group / dimension group etc..
We dont need to share the Transaction tables
Inventtory on hand etc..
Is it possible me know how much tables you ended up
sharing through Virtual company to make this work?
Will it pose any threat for an
maintainance,upgradation,data migration etc..
Thanks again for your valuable comments
TJJ
--- Brandon George <[EMAIL PROTECTED]> wrote:
> You have to make sure to put InventTable,
> InventLocation, and InventModule
> in a 'Virutal Company'. (We called our V02). At that
> point, make sure that
> your companies are apart of that Virtual Company,
> and then you have Items /
> Inventory Shared out.
>
> -Brandon
>
> _____
>
> From: Axapta-Knowledge-Village@yahoogroups.com
> [mailto:[EMAIL PROTECTED] On
> Behalf Of Jesper Kehlet
> Sent: Thursday, July 07, 2005 12:47 PM
> To: Axapta-Knowledge-Village@yahoogroups.com
> Subject: RE: [Axapta-Knowledge-Village] Sharing
> InventTable for multiple
> companies
>
>
> I have seen a couple of installations sharing
> InventTable, but it's not
> without effort. Remember there are other tables
> like InventTableModule etc.
> that InventTable is dependent upon. It can
> definitely be done, and in less
> time & effort than writing "synchronization code",
> but it will take some
> planning...
>
> _____
>
> From: Axapta-Knowledge-Village@yahoogroups.com
> [mailto:[EMAIL PROTECTED] On
> Behalf Of tj_jayson
> Sent: Wednesday, July 06, 2005 8:28 PM
> To: Axapta-Knowledge-Village@yahoogroups.com
> Subject: [Axapta-Knowledge-Village] Sharing
> InventTable for multiple
> companies
>
>
> Hi All,
>
> Our client installation is having 5 companies and
> planning to share
> Item Table for these companies.
>
> Are there any LIVE applications shares Items table
> for multiple
> companies?
>
> Will it end up sharing many table in Axapta because
> of the Foreign
> Key
> used for sharing tables?
>
> Is it advisable from your experience to share
> ItemsTable?
>
> Your valuable inputs will be highly appreciated
>
> Thanks
>
> TJJ
>
>
>
>
>
>
> Sharing the knowledge on Axapta.
>
>
>
> Sharing the knowledge on Axapta.
>
>
>
> _____
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group "Axapta-Knowledge-Village
>
<http://groups.yahoo.com/group/Axapta-Knowledge-Village>
> " on the web.
>
>
> * To unsubscribe from this group, send an email to:
>
> [EMAIL PROTECTED]
>
<mailto:[EMAIL PROTECTED]
ubsc
> ribe>
>
>
> * Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>
>
> _____
>
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Sharing the knowledge on Axapta.
Yahoo! Groups Links
Sharing the knowledge on Axapta.
Yahoo! Groups Links
Sharing the knowledge on Axapta.
Start your day with Yahoo! - make it your home page
Sharing the knowledge on Axapta.
YAHOO! GROUPS LINKS
- Visit your group "Axapta-Knowledge-Village" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
