Treating Dimensions as Companies

hi How difficult will it be to have Dimensions defined as Companies for having Multi Company accounting. Will it be feasible> What are the differences in Dimensions & Company granuales? with best regards Vaibhav

Hi vaibhav, In terms of accounting if all the companies exist within the same frame work then you can use the Dimensions as Company. The difficult part of this approach is to maintain company specific data. There will be customers, vendors, items etc which will be shared among the companies. For Eg: if you are looking for Stock out Warnings or Planning Warnings the result of these will be wrong as the calculations do not take place based on the Dimensions. Similar for credit limits and many more issues like these. If you are implementing just the G/L then you can use dimensions as countries.

Thanks Prashanth for the information. with regards Vaibhav

I would also stress you want to be careful on your reporting because certain reports will ignore dimension values when figuring. Also, I’m pretty sure Inventory valuation processes will ignore dimension values. I can also forsee problems in the Payroll system. Even though the latest Payroll setups for v3.60 are being designed with multi-company support using dimensions, it doesn’t always work in the accounting sense. I wouldn’t try to run bank accounts with dimensions either. Keep a separate bank account card for each company, not posting to the same bank account with dimensions. I can also see problems with the remittance of taxes because (at least in North America) each company will have it’s own tax numbers. Ultimately, the package is designed for working with individual companies. If consolidations are what you would like to overcome, you should read the specific information on consolidating multiple companies instead of working towards trying to push everything into a single company.

using dimension for multi-company accounting creates problem at the inter company level tansactions. Say a simple transction of payment from one company to another,then what dimension value will you use, company A or B? we are using the dimensional values for multi-branch accounting (MIS purpose)but then we had to create several workarounds.

I’m doing this right now and it’s a pain. I’ve just finished dimensionalizing Tax Entries so that the revaluation of exchange rates can do everything it needs to do. Year-end by Company dimension was easy in comparison. We even have companies in different currencies! We’re not doing this again. [xx(] What we’re suggesting to our clients is that if the functionality exists within Navision (in this case Consolidations) then they should purchase those granules. It might seem like more money up front but that will certainly be cheaper than paying for a developer to make all of the required changes and for an integrator to test the changes. Good luck! Django