item ledger entry quantity quantity remaining ?

carine

Hi all,

I am new in navision and I need some advice in field choice.

Does someone know the difference between Quantity and Quantity remaining field under the item ledger entry table.

What is the most suitable to established an inventory of item.

Cheers.

rhpnt

carine wrote:

I am new in navision and I need some advice in field choice.

By that you mean as a user or consultant/developer?

prizma1982

The quantity on the item ledger entries is a value that is owned by the entries or transactions that occur such as purchase or sale

while the remaining quantity is the residual value remaining on the line entries that can be used. (inventory)

for example, you buy a pencil with a quantity 10 pcs. then at the beginning you have 10 pcs quantity remaining on the field. then you sell it and take a pencil from that you have purchased as many as 3 pcs. so now you only have a remaining quantity of 7 pcs


I am also a beginner in NAV, sorry if my explanation is less

regard's

SPost29

The inventory field (a flow field) on the item table/card uses the item ledger entry quantity field to calculate the total inventory.

ara3n

The sum of both fields will give you the same result.

From performance reason I would use "Remaining Quantity". The number of records that are open and have remaining quantity ILE is much smaller than all ILE entries.

David_Singleton

ara3n wrote:

The sum of both fields will give you the same result.

Not in all cases, it will depend on what you are trying to calculate and what filters you are using.

If the developer does not understand the difference (and thus needs to ask) then safer is to use Quantity.

If you are using the same filters, then the performance will be identical.

ara3n

correct.

if you filter it further than item no, you will have different results.

As for as finding current entries that are on hand, "remaining quantity is after". Filtering on open removes majority of entries/transactions.

kapamarou

It is not so difficult to find a customer were someone deleted some Item Ledger Entries and forgot to correct the entries in Remaining Quantity and Open fields, and in the Item Application Entry table. :-#

For this reason I prefer the Quantity field.

ara3n

Well that's a good to find the problem if you use remaining quantity.