Hello,
I've got a problem. The client operates 5 different companies for the same business for the same database. The data of Customers, vendors and items should be shared across the group, master tables and ledger tables. :-k
Ledger tables? Are you sure on this?
So if a customer buys a box of chocolade from company A for 100$. in Company B,C,D,E the customer also ows 100 dollars?
Anyways do a search on master table sharing. Basically the best approach is to write code on insert, modify, delete to synch the record.
Ahmed Rashed Amini
Independent Consultant/Developer
I think what mperez means is that they want each company to have access to all other companies' ledger entries, not necessarily to actually share the records. So from company 1 you would be able to see that company 3 owes Vendor A $100.
So the master tables would be actually shared, but you'd have to find a way to display ledger data from the other companies.
But that search should give you some pretty good thigns to start looking into.
Comments
So if a customer buys a box of chocolade from company A for 100$. in Company B,C,D,E the customer also ows 100 dollars?
Anyways do a search on master table sharing. Basically the best approach is to write code on insert, modify, delete to synch the record.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
So the master tables would be actually shared, but you'd have to find a way to display ledger data from the other companies.
But that search should give you some pretty good thigns to start looking into.
RIS Plus, LLC