Dimensions and G/L Entry

Xav · 2010-03-23

Hello,

I need information about dimensions.
Currently, when an invoice is validated with several lines, and all the dimensions are identical for all rows, then there is only one line in the G/L Entry table.
When the dimensions are different from one line to another, all lines are represented in the G/L Entry table.
Is it possible to display all lines in G/L entries, even if they have identical analytical axes? Is this configurable?

ssingla · 2010-03-23

AFAIK this is not possible without customization.

Can you provide more information why you require such a feature? Maybe we can suggest some workaround.

Xav · 2010-03-23

The purpose of this request is to change routes after validation of an invoice.
It is therefore essential that all invoice lines exist in the G/L Entry. I see no alternatives.

David_Singleton · 2010-03-23

Xav wrote:

Hello,

I need information about dimensions.
Currently, when an invoice is validated with several lines, and all the dimensions are identical for all rows, then there is only one line in the G/L Entry table.
When the dimensions are different from one line to another, all lines are represented in the G/L Entry table.
Is it possible to display all lines in G/L entries, even if they have identical analytical axes? Is this configurable?

This used to be a very common request in Navision, especially before Dimensions joined the party. But in some cases I still see a need for this.

In fact it used to be the core of my interview with potential new Navision developers. It was the first development question I would give a new candidate.

I nver cared about the solution, but watching them develop it told me how well they knew Navision. The user that went straight to CU80 and then searched for a reference to CU12 got me interested. Better was one that first thing they did was create a sample invoice, post it and then open the tables.

ether way watching someone solve this problem is in my opinion the fastest way to see how well they know Navision in an interview environment.

einsTeIn.NET · 2010-03-23

You're an invidious employer...

jannestig · 2010-03-23

Hasn't he answered his own question then ?

If individual lines are only posted when all lines have different dimension values then the answer should be
just to create a dimension and value unique to each item (GL lines or item charges not sure of your use)

EG i would just create an dimension called itemdim and setup it up against each item.

This is the easiest way, you can just create a codeunit to import item no's and description from item table
watching out for field lengths

This will give you individual lines into your vat and sales account but just the 1 into youe customer account

Quite a few customers like this as they could see Item NOs in the GL then and it helped them identify items causing differences in balance with more efficeny in some cases

Of course you have to weight up performance impact and How you run adjust costs of course

Easy

David_Singleton · 2010-03-23

einsTeIn.NET wrote:

You're an invidious employer...

Wow I do hope that lost something in translation. :-k

einsTeIn.NET · 2010-03-23

Don't get me wrong! It was a joke!

David_Singleton · 2010-03-23

Probably the wrong English translation then

You probably meant evil or cruel. 8)

jannestig · 2010-03-23

I believe the word is insidious

Xav · 2010-03-24

Thank you for your responses. To add another dimension is a good idea.
But i have another question. I need to know how to link lines of posted purchase invoice with entry No. of G/L Entries. is that this link exists?

Sunset · 2010-03-24

Xav wrote:

Thank you for your responses. To add another dimension is a good idea.
But i have another question. I need to know how to link lines of posted purchase invoice with entry No. of G/L Entries. is that this link exists?

Why would you want to do this? Standard NAV has the Navigate function to see all postings that are related.

David_Singleton · 2010-03-24

Xav wrote:

Thank you for your responses. To add another dimension is a good idea.
But i have another question. I need to know how to link lines of posted purchase invoice with entry No. of G/L Entries. is that this link exists?

See this is why I do this test, because there are so many different ways to resolve it. And in the end it all comes down to the fact that to do any customization in Navision you need to know the full requirements of the user. In this case you feel you have the solution, and then come up with another issue, meaning that you have not yet fully defined the requirement.

Define the requirement FIRST!

jannestig · 2010-03-24

but would i have passed your examination with my proposed answer given the fact i had an incomplete requirement

Xav · 2010-03-24

Maybe I can not understand. Moreover, my english is very bad and I often use translators.
My goal is to change the dimensions lines recorded on an posted invoice and then update the dimensions of G/L entries. But why, I would use all the possibilities offered by Navision because I do not want to inultiles and dangerous developments.

Sunset · 2010-03-24

jannestig wrote:

but would i have passed your examination with my proposed answer given the fact i had an incomplete requirement

I would say not quite [-X Given that the ledgers being created are based on each unique set of dimensions. So if you for some reason have the same item twice on the invoice it would still only be 1 ledger entry. But it does come close without any modifications =D>

jannestig · 2010-03-24

aha this sounds like a discussion like the one about item ledger entries being updated. :S

SO i could summarize as follows

Invoice is posted
> some internal process (for dimension chaing routing?)
Process to update posted Document dimensions
> flow on to update the related posted GL line Dimensions

This sounds more an issue of we need to know what information that is represented by your dimensions needs to be updated and why?

I could think of say Department EG Department 1 buys something but department 2 pays the bill, Invoice posted with Department 2 dimension
but cost is actually assigned against Department 1 and should be represented as such

From what you describe i almost think you would be better off using a prepayment invoice (at 100% payment required) with 1st dimension values.
You post and pay the prepayment.Then you update the invoice lines and post as normal .

You would have two document numbers but you could trace them eaily enough.

This would allow you to audit how the dimensions have changed

David_Singleton · 2010-03-24

99% of solving a problem in Navision is to define what the problem is. In the case of the ideal consultant/developer; their first step would be to ask ME questions, starting with "Sorry I really don't think there is enough information to solve this". In an interview I have never had a developer complete the solution. I am only looking to see their thought processes.

its why I often refuse to answer simple questions from beginners on mibuso UNTIL they at least try to solve it them selves AND make it clear that they have studied the actual problem and the issues around it. It goes back to giving fish verses teaching how to fish. Sometimes instead of thinking "Hmm that person is hungry let me give him a fish" its better to find out why he is hungry and solve the problem of WHY he is hungry so that in a years time he wont be hungry again.

Miklos_Hollender · 2014-05-14

David Singleton wrote:

Interesting. I mean I would think you would expect people to already have done it like 5 times and just bang it out on the keyboard and not experiment with it.

Dimensions and G/L Entry

Comments

Categories