Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. How to correct imbalances between warehouse entries and item ledger entries in Microsoft Dynamics NAV

How to correct imbalances between warehouse entries and item ledger entries in Microsoft Dynamics NAV

View products that this article applies to.

Source:
Microsoft Support

RAPID PUBLISHING

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION THAT IS CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED TO SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.

↑ Back to the top

INTRODUCTION

This article describes how to correct imbalances between warehouse entries and item ledger entries in Microsoft Dynamics NAV.

↑ Back to the top

More Information

When you post warehouse documents and adjustments in directed put-away and pick locations in Microsoft Dynamics NAV, the warehouse entries may be out of balance with the item ledger entries sometimes.

Usually, after you make an adjustment the warehouse bin quantities, you open the item journal and then run the Calculate Whse. Adjustment function. This function can restore the balance between the warehouse entries and the item ledger entries. However, sometimes the warehouse bin content may be out of balance with the item ledger entries, and the item journal report cannot correct the imbalance. In this situation, you must make a one-side adjustment to the warehouse entries to restore the balance.

To make a one-side adjustment to the warehouse entries to restore the balance, post a warehouse item journal line by using an adjustment. To do this, follow these steps:
  1. On the Tools menu, click Object Designer.
  2. Click Form, click the Whse. Item Journal form (7324), and then click Design.
  3. In the Form 7324 Whse. Item Journal - Form Designer dialog box, add two columns "From Zone" and "From Bin" to the grid of the journal. These two columns will automatically populate values that are the adjustment bin and the adjustment zone.
  4. Close the Form 7324 Whse. Item Journal - Form Designer dialog box, select the Compiled check box, and then click Yes to save the changes.
  5. Click Warehouse, expand Goods Handling Multiple Orders, and then click Whse. Item Journals.
  6. In the Warehouse Item Journal dialog box, type an appropriate adjustment in the Quantity field to make the warehouse entries match the item ledger entries. This adjustment can be a positive adjustment or a negative adjustment.
    Notes
    • If the item ledger entry quantity is greater than the warehouse entry quantity, the adjustment should be a positive quantity.
    • If the item ledger entry quantity is lower than the warehouse entry quantity, the adjustment should be a negative quantity.
  7. Add the From Zone Code field, From Bin Code field, To Zone Code field and To Bin Code field to the Whse. Item Journal by using show columns.
  8. Delete values from the From Zone Code field and the From Bin Code field. This action will guarantee the one-side adjustment of the warehouse entries for a positive adjustment.
  9. Delete values from the To Zone Code field and the To Bin Code field. This action will guarantee the one-side adjustment of the warehouse entries for a negative adjustment.
  10. Post the warehouse item journal.
  11. Verify that the quantity of the warehouse entries equals the quantity of the item ledger entries.

↑ Back to the top

DISCLAIMER

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE.

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.

↑ Back to the top

Keywords: kb, kbmbswarehousemanagement, kbmbspartner, kbmbsmigrate, kbrapidpub, kbexpertiseinter, kbnoloc, kbarchive, kbhowto, kbexpertisebeginner, kbmbsquickpub, kbnomt

↑ Back to the top

Article Info
Article ID : 942457
Revision : 1
Created on : 1/7/2017
Published on : 1/3/2012
Exists online : False
Views : 1315