This is the second blog covering an overview of the ILE’s. In the previous blog we spoke about ILE’s, key fields and what it means if an Item Ledger Entry is ‘open’. This one will focus on inventory and the key fields associated with it. Building on from this, let’s consider further how Business Central deals with additional features that bolster the usefulness of Item Ledger Entries. If you didn’t get a chance to read the previous blog, click here.
Each Item Ledger Entry can have a number of financial values associated with it. which Business Central holds in a sub table, with their aggregated value being displayed on the ILE. A typical example would be:
- Purchase cost
- Associated purchase variance cost
- Freight charges
Consider this example from the previous blog after purchasing 10 widgets at £11 each, where the Widget’s standard cost is £10. There is also a related freight charge associated with this purchase of £7. Here is the purchase order:
The purchase order is then Posted. Reviewing the ILE, we get a purchase of 10 Widgets at a standard cost of £10 each.
This is the value entry against the ILE that is the sale of the six widgets. The associated value entries against the individual ILE can be viewed from the ILE. From the ILE page, click ‘Related’, ‘Entry’ and then ‘Value Entries’.
Note that there are four value entries here:
- The incoming 10 inventory, costed at £11 each. This amounts to an Cost Amount (Actual) cost of £110.
- The freight charge of £7
- the variance value is associated with the Widget having a standard cost of £10. Subtracting the actual cost from the standard cost leaves us with a sum like this:
- £10-£11=-£1. As we have purchased 10, we have to multiply this figure accordingly.
- Similarly, in this instance the freight charge of £7 will also generate a corresponding variance of -£7 to maintain the Widget standard cost of £10.
As was stated earlier the Cost Amount (Actual) on the ILE record is an aggregated sum of the value entries. So, the Cost Amount (Actual) on the ILE of £100 is the sum of the 4 value entries. These are: £110, £7, -£10 and £-£7.
Applied Item Entries
The ‘Applied Item Entries’ feature holds a historical record of the outgoing inventory against an incoming ILE record. The highlighted line refers to an earlier purchase of 10 Widgets where we can see all 10 have been used by the business leaving the remaining quantity at 0 and the ‘Open’ field set to being un-ticked.
The Applied Item Entries gives the historical detail record of this usage. From the ILE page, highlight the bottom entry, click ‘Related’, then ‘Application’ and finally, ‘Applied Entries’.
The above image shows where the 10 originally purchased Widgets have gone:
- Sales 102216 for a quantity of -6 on the 06/04/2020
- Sales 102217 for a quantity of -4 on the 06/04/2020
Similarly, if we highlight the ILE for the sale of 6 Widgets, then review ‘Related’, ‘Application’ and then ‘Applied Entries’.
Each individual ILE has its own unique ‘Entry No’. Take our example from above for the item Widget.
Looking at the posting date we can see that all these transactions took place on 06/04/2020. To establish the historical order these transactions took place is quite straightforward. Simply sort the Entry No. into chronological order. This can be done by selecting the small arrow on the corner of the field and then select ‘ascending’ after several options appear. The ILEs will then be ordered, with the oldest at the top.
Just before we wrap up part 2, in all our above examples we have been processing Non-Tracked items. If an item is serially tracked, then each individual serial number will have a unique item ledger entry. So, if the purchase receipt is for a serial tracked item with a quantity of five, the system will create five separate ILEs.
A lot tracked item will create an ILE grouped by lot number. So, if a purchase receipt is for five lot tracked items with a lot number of ‘1234’ and a separate quantity of seven, under lot number ‘7429’, the system will create two ILEs.