Posting Quantity Adjustments for Bins

If you are using bins at a location, you will need to occasionally adjust the quantity in a bin, when the quantity recorded in the system is inaccurate because of a physical gain or loss of an item.  There are two methods of posting a quantity adjustment in a bin.  Which one you use depends on whether the location is set up to use directed put-away and pick or not. The two methods are described below:

To Post Bin Quantity Adjustments in Locations Without Directed Put-away and Pick:

If you are not using directed put-away and pick in the location, you can change the quantity in a bin in the inventory item journal. Posting the item journal adjusts the quantity in the item ledger entries and the warehouse entries.

  1. Open the Item Journal window.

  2. Fill in the fields on each journal line.  For Help about a specific field, click the field and press F1.

  3. Click Posting, Post.

To Post Bin Quantity Adjustments in Locations With Directed Put-away and Pick:

If you are using directed put-away and pick in the location, you will use the warehouse item journal to register the quantity adjustment in the bin. When you register these differences, the positive and negative adjustment quantities are registered in the warehouse adjustment bin. The quantities are not automatically posted to the item ledger. The entries in the adjustment bin originate from the warehouse item journal, the warehouse physical inventory journal, the item journal, or a number of other documents that indicate changes in warehouse inventory. For more information, see Warehouse Adjustment Bin.

At appropriate intervals as defined by company policy, you must post the warehouse adjustment bin records in the item ledger. Some companies find it appropriate to post adjustments to the item ledger every day, while others may find it adequate to reconcile less frequently. The process to post the warehouse adjustment bin records in the item ledger is described here:

  1. Open the Item Journal window.

  2. Fill in the fields on each journal line. For Help about a specific field, click the field and press F1.

  3. Click Functions, Calculate Whse. Adjustment, and fill in the filters as appropriate in the batch job request window. The program will calculate adjustments only for the entries in the adjustment bin that meet filter requirements. As in other batch job request windows, you can create many new Field fields by clicking the AssistButton in the Field field on a new line and selecting a new criterion.

  4. On the Options tab, fill in the Document No. field with a number that you enter manually. Because no number series has been set up for this batch job, use the number scheme set up by the warehouse, or enter the date (year-month-date) followed by your initials.

  5. To run the Calculate Whse. Adjustment function, click OK. The program totals the positive and negative adjustments for each item and creates lines in the item journal for any items where the sum is a positive or negative quantity.

  6. Click Posting, Post to enter the quantity differences in the item ledger. The inventory in the warehouse bins now corresponds precisely to the inventory in the item ledger.

Related Topics

Warehouse Adjustment Bin

Registering Quantity Adjustments in the Whse. Item Journal



© 2009 Microsoft Corporation. All rights reserved.