NAV2013R2 - How to find key between Value Entries and General Ledger Entreis

(0) Share

Report

Posted on by Sunny2014

Hi All,

I would like to find a key which NAV pulls out related transactions via NAVIGATE on back end.

For example, we can open one of the posted sales invoice. By clicking NAVIGATE button, NAVIGATE button pulls out G/L entry, Customer Ledger Entry, Tax Enry, Item Ledger Enry, Value Entry. By selecting G/L entry to click "Show more detail", NAV pulled out (Filtered) GL transaction generated from the sales order.

The reason I am posting this is when user posts item charge assignment (purchase receipt/transfer receipts), Assembly Order, and transfer order, NAV did not record global dimension i.e., assigns to each item. As a result, when we tried to use Analysis view using GL account (inventory account) per global dimenision, the calculatd amounts are incorrect becaause those transactions did not have global dimension in GL entries i.e., originating from Value entry. Looking at Value entry table and G/L Entry table via development environment, there are not common field between two tables but NAVIGATE function is handling to pull out related transactions from various ledger entry tables. So, I wonder if we can find the key, we will be able to fix the issue by some coding.

Thank you,

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (3)

Verified answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

It retrieves records based on the document no. and posting date. On the page you can view the about this and check filters or check the filter pane for the filters.

Was this reply helpful? Yes No
Verified answer

Alex A 2,913 on at

Like (0)

Report

Hello,

Make sure that the Dimensions appear on the Order documents when created, such as the Purchase Order or Transfer Order. If the Dimensions are configured properly on the Item card then they should come into the Order document lines when they are created.

Was this reply helpful? Yes No
Sunny2014 2 on at

Like (0)

Report

Thank you for suggestion;

Since Document No. and Posting date pull out all GL transactions, it cannot be traced back which GL transactins (line) originated from which line of value entriy table.

how can we trace relation beteen value entry and GL transactions per line? For example, single value entry generates two inventory related GL transactions (decrease inventory amount and increase cost of goods sold amount). Is General Ledger Entry table able to have source data code (i.e., value entry number) like value entry table has item ledger entry number?

Was this reply helpful? Yes No
Sunny2014 2 on at

Like (0)

Report

Thank you for the suggestion, Alex! I confirmed that assembly order and transfer order are contained global dimention code correctly popuated from item card. So, transfer order and assembly order transactions are ok (i found that old transactions generated before global dimensions were setup)

The remaining roblem is that item charge transactions from purchase order or purchase invoice do not pull out global dimension code from item card (even if item card is configured global dimension code as default dimension). Due to this, when we tried to sum-up inventory account value per global dimension using "analysis view by dimension" NAV does not fully pull up GL data generated from item charge (purch) assignment window. Since value entry table does not contain global dimension in case of item charge transaction, associated GL transaction does not have globl dimension code either. So, to solve the issue, we plan to develop some code in order to update global dimension column in value entry table and General Ledger Entry table. Do you have any idea - how to trace specific GL lines coming from whicch value entry transaccion?

Was this reply helpful? Yes No
Verified answer

RobertasR 5,004 on at

Like (0)

Report

Hi Sunny,

relating to Item Charges - when posting item charges system uses the SAME dimensions that were used on the original transaction, when posting to P&L. So I think the issue is in the original transactions rather than the system. It is not recommended to develop anything that changes that logic, unless you're talking about correcting the existing data - see table 5823 'G/L - Item Ledger Relation'. This links G/L entry and Value Entries.

Hope that helps.

Robertas

Was this reply helpful? Yes No
Sunny2014 2 on at

Like (0)

Report

Hi Robertas,

Thank you for the explanations!. I looked into the value entry table and still cannot find the rootcause (patterns) because with same item number (i.e., correctly configured global dimension code in the item card at the beginning of setup), most transactions (item charge) are reocrded global dimension code both value entry table and GL table but some other transacitons are not. Anyway, discussion with our client, they want to update global dimension field (only if the field is blank) in value entry table followed by the current item master setting. They said "no need to update GL table". So, we will not plan to make coding to update GL table but thank you for letting me know the table 5823 G/L - Item Ledger Relation. It is very helpful for further analysis!

Sunny

Was this reply helpful? Yes No