Table collections and virtual company
_____________________________________
In order to share the table data across the companies,
we will use table collections in combination with virtual companies
Create a new table by name "TS_VendorTable" and add 4 fields [VendorId, Name, Age, CreditLimit]
Go to AOT >> DataDictionary >> Table collections >> RC >> New Table collection >> Rename it to TSTC
Drag and drop TS_VendorTable table to the table collection
[Please note: Please do not add data in the table, there are high chances that data will be lost]
Go to SystemAdministration >> Setup >> Virtual company accounts >> Create a new virtual company by name "TsAc" and description as "virtual company accounts data - TS" and save the record.
Once you save the record, automatically you will find two other tabS [Company accounts, Table collections activated]
select some company accounts from right list to left list [ ceu, hyd, dat etc]
select TSTC collection from right list to left list.
Close the form, AX Client will shut down automatically.
Open new client to see HOW the sharing happens
sharing will actually happen with a field "dataareaid" in the table
data area id will be the virtual company account - "TsAc" for all those company which share the table collection.
_____________________________________
In order to share the table data across the companies,
we will use table collections in combination with virtual companies
Create a new table by name "TS_VendorTable" and add 4 fields [VendorId, Name, Age, CreditLimit]
Go to AOT >> DataDictionary >> Table collections >> RC >> New Table collection >> Rename it to TSTC
Drag and drop TS_VendorTable table to the table collection
[Please note: Please do not add data in the table, there are high chances that data will be lost]
Go to SystemAdministration >> Setup >> Virtual company accounts >> Create a new virtual company by name "TsAc" and description as "virtual company accounts data - TS" and save the record.
Once you save the record, automatically you will find two other tabS [Company accounts, Table collections activated]
select some company accounts from right list to left list [ ceu, hyd, dat etc]
select TSTC collection from right list to left list.
Close the form, AX Client will shut down automatically.
Open new client to see HOW the sharing happens
sharing will actually happen with a field "dataareaid" in the table
data area id will be the virtual company account - "TsAc" for all those company which share the table collection.
Note : TS are my initials
Hope you find this info useful.... :)
No comments:
Post a Comment