About the field Open in the Item Ledger Entry table

Dynamics 365 Business Central/NAV User Forum
#1

Hi everyone,
I want to know the signification of field Open in the Item Ledger Entry table.
I have an article with an entry in the Item Ledger entry table with the following information :

Document Type= Sales Shipment
Open= TRUE
Quantity= -3
Remaining Quantity= -3
Invoiced Quantity= -3
Applies-to-entry= 0
Completely Invoiced= TRUE

I am really confused.What does all that mean?

#2

This field shows whether the entry has been fully applied to.

A check mark in the field means that the entry has not yet been fully applied to. If this is the case, you can see the quantity that must still be applied to in the Remaining Quantity field.

The field can be updated by a subsequent application.

#3

Thanks for your answer…but how to do that? I mean how to apply?

#4

Hi poppins,

usually you don’t apply item ledger entries manually. The system does this automatically, based on the valuation method (FIFO, LIFO, Average, Standard Cost). Except for LIFO, the application logic always uses FIFO. There are (factual) exceptions to this. One is a direct application via “Applies-to Item Ledger Entry No.”, the other is item tracking codes. When serial numbers are used, the applications are similar to direct applications between selected item ledger entries.

There is a table where all the applications are recorded, it’s T339 “Item Application Entries”.

The main information is: Item application is done by the system, without intervention from the user.

with best regards

Jens

#5

Thanks for your answer…

But if the application is automatic, what can I do about this entry? and why it wasn’t automtically applied (what possible cause)?

#6

Hi poppins,

in your example: negative inventory. Depending on the setup of the inventory and the location, the application is limited by location code. Also, it can be limited by variant code, serial no. and lot no. However, standard NAV does allow situations with a resulting negative inventory. Yes, this is bad. In standard NAV2013R2, you can completely disallow negative inventory. In all earlier versions only by modifying CU22.

So, next step would be to list the inventory by location for this item.

with best regards

Jens