In the Application Worksheet window, you can view and manually change certain item application entries that are created automatically during inventory transactions.
When you post a transaction where items are moved in or out of inventory, an item application is created between each inventory increase and inventory decrease. These applications determine the flow of costs from the goods that are received in inventory to the cost of goods going out of inventory. Because of the way the unit cost is calculated, an incorrect item application could lead to a skewed average cost and a skewed unit cost. For more information, see Design Details: Item Application.
The following scenarios might require that you undo an application or reapply item ledger entries:
If possible, use a document to reapply an item ledger entry. For example, if you must make a purchase return of an item to which a sale has already been applied, you can reapply by creating and posting the purchase return document by using the correct application in the Appl.-to Item Entry field on the purchase return line. You can use the Get Posted Document Lines to Reverse function or the Copy Document function in the purchase return document to make this easier. When you post the document, the item ledger entry is automatically reapplied. For more information, see How to: Process Purchase Returns or Cancellations.
If you cannot use a document to reapply, such as when you have to correct a fixed application, then use the Application Worksheet window to correct an application.
The following are important considerations to remember when you are working with the application worksheet:
icon, enter Application Worksheet, and then choose the related link. Close the View Applied Entries – Applied Entries window.
The Remaining Quantity field of the two item ledger entries are increased by the quantity that has been unapplied. The removed item ledger entry is now available for reapplication in the View Applied Entries – Unapplied Entries window.
You should not leave application entries unapplied for longer periods of time because other users cannot process the affected items until you reapply the application entries or close the Application Worksheet window. The following error message is displayed if you try to perform actions that involve a manually unapplied application entry:
You cannot perform this action because entries for item
icon, enter Application Worksheet, and then choose the related link. To reapply entries that were removed since the worksheet was opened, select the item ledger entry that you want to reapply. On the Actions tab, in the Functions group, choose Reapply.
This reapplication to the original balance also occurs automatically when you close the Application Worksheet window.
Select one or more item ledger entries that you want to apply to the entry selected in the Application Worksheet window, and then choose the OK button.
An item application entry is created between the two item ledger entries. The Remaining Quantity fields of the two entries are reduced by the applied quantity.
If you have chosen to make an application that would create an infinite loop in the cost adjustment process, then the application that you proposed is not made. This can occur when the original entries created negative stock. The application is not made. Therefore, you must select a different entry for the application.
How to: Close Open Item Ledger Entries Resulting from Fixed Application in the Item Journal
How to: Process Purchase Returns or Cancellations
Managing Inventory Costs
Design Details: Item Application
Working with Dynamics NAV
© 2017 Microsoft. All rights reserved.