Why not using the Location as Dimension 1 and then filter your Chart of Account on this Dim1 ?
I think is the most simple solution, except the multi-company ... But ... why not multi-company ? It is STD Navision, works fine and it is not so expensive ...
I have just done this in a V4.0 implementation. Assuming you want normal double entry bookkeeping rules to apply, if you are going to use a dimension to separate the locations you will have to write code to ensure that all postings always balance by this dimension value.
You will also have to consider how to reflect transactions between locations - this can be done by using 'intercompany accounts' in the Balance Sheet.
Comments
I think is the most simple solution, except the multi-company ... But ... why not multi-company ? It is STD Navision, works fine and it is not so expensive ...
You will also have to consider how to reflect transactions between locations - this can be done by using 'intercompany accounts' in the Balance Sheet.
Can you elaborate on that as to why i need to write code if i use dimensions for different locations