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

Article ID: 942457 - 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.
Expand all | Collapse all

On This Page

INTRODUCTION

This article describes how to correct imbalances between warehouse entries and item ledger entries in Microsoft Dynamics NAV.
Back to the top | Give Feedback

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 | Give Feedback

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 | Give Feedback
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations.
Back to the top | Give Feedback

Properties

Article ID: 942457 - Last Review: January 3, 2012 - Revision: 5.0
APPLIES TO
  • Microsoft Dynamics NAV 5.0
  • Microsoft Dynamics NAV 4.0
Keywords: 
kbexpertisebeginner kbhowto kbexpertiseinter kbnomt kbrapidpub kbmbsmigrate kbmbswarehousemanagement KB942457
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top