You’re offline. This is a read only version of the page.
I am still learning how NAV works, but we have a situation where you can see a GL Entry with a specific value for a dimension, but the associated value for that same dimension is different on the associated posted invoice.
How can this be? (And how exactly are GL Entries and Invoices related? Perhaps I am not asking the right question due to lack of understanding at this point...)
*This post is locked for comments
Hi Surath
As far as I know if the G/L Entry Initiated in the Sub Ledger then G/L Entry Must Take the Same Dimension as in the sub ledger Posted Document Unless you haven't done any Customization to the default Dimension Process.
Hi Indika,
[quote]generally those should be match with the posted invoice.[/quote]
Can there be cases where dimension values posted in the sales invoice header and lines are different than the G/L entries.
Thanks.
HI,
Nav Has all the sub ledger integrated to G/L so based on purchase, sales , item journal etc system will post G/L Entries.
g/l entries get dimension value based on the sales line values mainly for Global Dimension value 1 & 2. based on what is selected as global dimension 1 or the 2 it will update g/l dimension.
if you go to posted invoice in the line show column to enable global dim 1 & 2 there you can see what values are entered for the posted invoice & click on the navigate button you can see all the tables impacted with the posted sales invoice including the g/l entries. once you drill down the g/l entries then you can see the global dim 1 & 2 value there as well generally those should be match with the posted invoice.
also below link you can learn about global dimension
msdn.microsoft.com/.../hh168606(v=nav.90).aspx
Thanks
Indika.
When you create an invoice, it has both header and lines parts. The header normally represent your counterparty (vendor or customer), and lines represent what you are buying or selling (it can be e.g. service or an item). Thus, when you post an invoice, you will get accounting transaction where one part will be presented by account that came from the posting group of the customer/vendor in the header, and the other part of the transaction will come from the posting group of what has been selected in the line (e.g., G/L account or item card).
Referring to your question: header and lines of the invoice may have the same dimension values, and they might have different dimension values. Moreover, each line of the invoice might have its own set of dimension values. So when posting your invoice, you might have a situation that the invoice header has one dimension (and that one has been populated to that part of transaction that represents vendor/customer payables/receivables account), and the part of transaction that came from lines of the purchase invoice can have a different dimension value.
Hope this helps.
Are thr global dimensions are same at both the places ?
The specific dimension in question I actually see listed as both a Global Dimension Code and a Shortcut Dimension
Global dimension need are mandatory for transactions and shortcut dimension selection is depend on reporting requirement and based on that it is selected
Ok, and what are the implications between the two types of dimensions for my situation?
Check in General ledger setup for dimensions i.e Global and Shortcut dimensions
Based on this you can figure out
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (