Tuesday 7 November 2006

Adresses

Adresses and Dynamics Ax.

In Dynamics there is a very nice concept surrounding adresses that allows you to tie an address quite easily to almost any object.

The adress management is also very nicely conceived in such a manner that the format used depends on the country to which an adress belongs, which allows for addresses being printed out in a controlled manner on documents without empty lines when it is another country etc.

However to my mind the concept is in some ways incomplete.

What would I like to see added to the product ?

Well first the address table should have an ID Code and a link table or indirection table should be made between an address and the place where it is associated to a setup entry. This allows one to enter just once f'ex the address of a Customer that is a Supplier etc, and also to maintain it just the once.

On the link or indirection table one can easily add a type denoting the Link Type this should be a table with some tick box options to allow one to be the main addres the other to be an invoice address another a delivery address etc.

To ensure that the address used at the time of creating the legal documents is maintained, the information still needs to be copied to the ...InvoiceJour table but all others could just have a link to the address code Id thus reducing storage required in the database quite significantly.

Also today maintaining multiple addresses / setting the one to use is quite clumsy, this could be a lot easier with this new method as several could be set / used / displayed easily on the header / lines as needed.

Just a thought taken from a series of projects realised where the address entity / fields everywhere have caused issues.

/Sven

No comments: