When a user tries to change the application of item ledger entries, they can see the following error message: "Remaining Quantity is too low in Item Ledger Entry Entry No.='341'." In Dynamics NAV 2013 we made a much needed change to the inventory costing functionality, and the error message is the result of that: We wanted people to know that they cannot post the changes because they made the changes in a way that would result in incorrect quantities. This blog post explains the scenarios where users can see this error message, and suggests a better way to change application.
Scenario 1: Application Worksheet
- In the Item journal, create the following lines:
- Type Purchase; Posting Date: Jan 28, 2017; Item 80001; Quantity 10; Unit Amount 15;
- Type Purchase; Posting Date: Jan 29, 2017; Item 80001; Quantity 7; Unit Amount 10;
- Type Purchase; Posting Date: Jan 30, 2017; Item 80001; Quantity 3; Unit Amount 10;
- Type Sale; Posting Date: Jan 31, 2017; Item 80001; Quantity 10; Unit Amount 12;
- Run the Adjust Cost - Item Entries batch job.
You can now review the status of the generated item ledger entries.
The sale was applied to the first and oldest purchase in accordance to the items costing method FIFO. However, the sale was a special deal and the favourable price based upon the acquisition of a special consignment, purchase entry 340 and 341.
Currently the sale demonstrates a loss with a higher Cost Amount (Actual) than Sales Amount (Actual). So you try to make a re-application and apply the sale to the two purchases by using the application worksheet.
- Open the Application Worksheet and filter on item 80001.
- Remove the existing application.
- Choose the sales entry line.
- Choose Navigate, and then choose Applied Entries.
- The Applied Entries window appears and shows the applied purchase entry, 339.
- Choose Remove Application and then choose OK.
- Apply the sale to the two purchases from the special consignment – fixed application.
- Select the sales entry line.
- Choose Navigate, and then choose Unapplied Entries.
- The Unapplied Entries window appears and shows three purchase entries available for application.
- Select the purchase entries from the special consignment with Remaining Quantity = 7, entry 340 and entry 341 with Remaining Quantity = 3, and then click OK.
The error message appears:
“Remaining Quantity is too low in Item Ledger Entry Entry No.='341'.”
The stated entry no. will depend on which entry is the active line when you click OK, because that is when the validation is made.
Scenario 2: Journal or Document Line
The same error message can be experienced when posting an item journal or document line, in the attempt of making a fixed application to several inbound item ledger entries.
Assume the same transactions has been created as in step 1a – 1c. This time for item 80002 in the demonstration database.
A sale of 10 units is to be recorded. To select supply from the special consignment, drill down in the Applies-to Entry field on the journal or document line to select the particular purchase item ledger entries, as below, and click OK.
Note, that only one entry number can be stored in the Applies-to Entry field. It will be entry no. of the active line in the item ledger entries window above.
When you post the line, the error message is generated:
“Remaining Quantity is too low in Item Ledger Entry Entry No.='345'.”
In the event of creating fixed applications, the outbound entry can only be supplied by one inbound entry, covering the full quantity. The selection of several lines (entries) in the scenarios above to cover the outbound entry quantity is overruled, and only the active line is considered for fixed application, as there is only one cost source allowed.
One inbound entry, the cost source, can however supply several outbound entries in fixed applications.
For example, you have a Purchase item ledger entry with 10 units. In the Application Worksheet window, you choose the purchase entry as the active line and then, when you choose to navigate to Unapplied Entries, and you see there are several outbound entries shown, you can select several lines and then click OK. Back in the Application Worksheet page, you will see that all selected outbound entries respectively, state the entry no. of the purchase in the Applies-to Entry field.
How to: Change the Application of Item Ledger Entries
In the case where a sales event (or any outbound entry) requires fixed application and several inbound entries are required to fully supply the outbound entry, it can be represented in several lines in the document or journal. In the scenario above when entering a line in a journal or document, the sale of 10 units can be split into two lines with corresponding quantity to the supplying item ledger entries.
After running Adjust Cost –Item Entries batch job, the sale entries are valued to the cost of the special consignment transactions and provide a profit, with the favourable sales price in mind. The first inbound entry, purchase entry 343 is still open.
In the first scenario where the sale is already posted, represented in one item ledger entry of quantity -10, the application worksheet is not providing any option to apply the sale to the two purchases.
Depending on the specific situation different work arounds can be considered. Below are suggestions, briefly described.
- Post negative adjustments of quantity 7 and 3 respectively and have them applied to respective purchase entry from the special consignment.
Post a positive adjustment with quantity 10 at same cost as the special consignment.
Apply the sale to this positive adjustment entry in the application worksheet.
- Reverse the Sale of 10 units in a Credit memo.
Create a new Sales document with two lines with quantity 7 and 3 respectively and apply them to the existing purchase entries.
For more information, see Design Details: Item Application
Dynamics NAV Escalation Engineer