Difference Between Item Tracking Line and Reservation

matttrax

Looking for confirmation / thoughts / explanation.

From what I can gather:

Line --> Item Tracking Lines makes a single reservation entry with type Surplus.

Functions --> Reserve makes a negative and positive reservation entry with type Reservation

I think I need a combination of both for this company. They need to be able to reserve specific serial numbers (item tracking lines) so auto-reserve and reserve from current line don't work, but also need to see items that may not yet be received (reservations) which you can't do with select entries on item tracking lines.

It appears that the only way to do that is to do both. If I select an entry using item tracking lines and then create a reservation that serial is used, otherwise it's just the first available item in item ledger entries.

Am I correct here? Missing something? If I am, any thoughts on how this can be reduced from a multi-step process?

Marije_Brummel

Which version is this?

Item Tracking line has been removed by MS years ago... Now adays everything has been done in the Reservation Entry which gives us performance experts huge headaches.

matttrax

I'm developing in a 5.0 SP1 database. On a sales order, Line --> Item Tracking Lines is definitely still there.

I'd like to do everything through the reservation window since it shows already received and expected inventory. Just can't figure out how to pick a specific serial number.

I've attached a small sample for an order with one item. I want to be able to get the bottom result without filling in an item tracking line. If a mod is necessary then so be it, I just have to think there's something I'm not aware of.

matttrax

bump...anyone got something?

Marije_Brummel

This options is definately one of the weirdest DB designs in NAV. You are actualy looking at the ILE.

There is a tabel called "Value Entry Relation" that makes it possible to go to the ILE from the invoice.