Item Application Entry table

Gjuro_S._Zlikovski

Hi to all!

We need help regarding Item Application Entry table.
What is the primary use for this table and what parts of Navision business logic rely on it? We are heaving trouble understanding this table because there are no documentation about it (it's a table for internal use).

For example, what problems could occur if there are inconsistencies in data in this table or if some data is missing and what are the possible ways to repair it?

We know that this table is used in Adjust Cost - Item Entries batch job and for applying Item Ledger Entries, but we don't know the details, especially concerning when different costing method are used.

Thanks.

David_Cox

Basic terms it is the link between the Item Ledger Entries.

10001 Purchase 100 Widgits Received at 1000 LCY

10999 Sale 10 Widgits Shipped and Invoiced at 1999 LCY
Item Application Links the Sale to the Purchase so you can track Movement and cost of Sale.

Lets say the Invoice comes in from the Vendor at 974 LCY
When this is posted the system knows to apply the cost at 9.74 a unit and not 1.00, by using the application entry to track the applied entries

The application entries also track transfers, consumption, job, and production.

As for rebuilding the table, it is not that easy, Navision used to hold the "Applied to Entry No." on the Item Ledger but it is not filled in anymore, so if data has been delete by mistake I think the only way is to extract it from the last backup before the data was deleted.

We really need to know, How much data is missing, firstly create a report, on the Item Ledger Entry if the "Remaining Quantity" is less than the Quantity, then look for the Application Entries "Applied From" and "Applied To" or Inbound and Outbound which ever naming convention they are using, add the Applied Quantities, there may be more than one, then IF ("Applied Quantity"' + "Remaining Quantity") <> Quantity Show on the Report the differences, this will identify Un-Applied Entries, if your report is correct the group total by Item No.", should net to zero for the Missing Application Entries, from this list you may be able to reconstruct the Application Entries.

If you need help with how to, once you know how much of a problem there is let us know.

Gjuro_S._Zlikovski

Thank you for your reply!

We are using Standard and Average costing methods, and as far as we know, in these cases entries are applied automatically and the order in which they are applied should not be important (unlike FIFO and LIFO methods).

Do you think it is possible to rebuild the table by applying entries in a different order and still have the correct data?

David_Cox

Gjuro S. Zlikovski wrote:

Thank you for your reply!

We are using Standard and Average costing methods, and as far as we know, in these cases entries are applied automatically and the order in which they are applied should not be important (unlike FIFO and LIFO methods).

Do you think it is possible to rebuild the table by applying entries in a different order and still have the correct data?

I don't think that these costing methods Affect the Application which is "Applied to First" in all caes except LIFO.

So this should help once you have Identify the affected "Item Ledger Entries".