Differences

This shows you the differences between two versions of the page.

--- training:inventory_adjustments_and_automatic_posting_to_ledger0808211254 [2008/08/21 14:45 (16 years ago)] – external edit 127.0.0.1
+++ training:inventory_adjustments_and_automatic_posting_to_ledger0808211254 [2021/04/22 12:27 (3 years ago)] (current) – [Inventory Stock Adjustment] agera
@@ Line 1: / Line 1: @@
-===== Problem Description =====
+====== Inventory Stock Adjustment ======
-How to adjust inventory quantities in stock and automatically post to an inventory adjustments account in the general ledger and reduce the inventory asset account at the same time.
-===== Solution =====
+See
-This tutorial explains the setup for, and the process used to adjust the quantities in stock of your inventory while automatically posting to an inventory adjustment account in your general ledger.
+https://support.windwardsoftware.com/a/solutions/articles/66000486149
-The 5 steps required to set this up are:
-- Create an inventory adjustment ledger account if it doesn't already exist.
-- Create a non-inventory type sub-category.
-- Create a part in this sub-category with no cost or selling price.
-- Make sure the Transfer Invoice is in your Invoice Tree.
-- Create a customer account for your company with a price schedule set at cost and tax exempt.
-The following video tutorial explains each one of these steps and then shows how to create a Transfer Invoice that removes or adds inventory from stock while posting to the adjustmant account.
+===== Overview =====
+In the business world, inventory stock adjustment is important. It is one way to make sure you have the correct stock on hand and that your inventory value as well will be up to date. This stock adjustment could be caused by several reasons such as stolen items, data entry error, etc.
+===== Different Ways of Handling Inventory Stock Adjustments =====
+**1. Manual Adjustment** \\
+This can be helpful, especially if there are only very few inventory items that you would like to change its quantity. <note important>__**WARNING**__: Once you have done a manual stock adjustment, a Journal Entry is needed so that the value of the adjustment made will also reflect in your inventory ledger.</note> \\
+{{:training:manual_stock_adjustment.jpg?800|}}
+**2. Inventory Transfer** \\
+Another way of doing an inventory adjustment is by doing an Inventory Transfer. This process //**no longer requires any Journal Entry**// as it will automatically create a posting in your ledger after item/s is attached in the Transfer invoice itself. \\
+In order for you to do an Inventory Transfer, you need to make sure to set up the following: \\
+  * Create a customer account for your company with a price schedule set at cost and tax-exempt.
+  * Make sure the Transfer Invoice is in your Invoice Tree.
+  * Create an inventory adjustment ledger account if it doesn't already exist.
-Note: this article is also publicly available at http://wiki.wws5.com/share/Inventory_adjustments_and_automatic_posting_to_ledger0808211254.html
+{{:training:inventory_transfer.jpg?800|}}
-{{training:inventory_adjustments_and_automatic_posting_to_ledger0808211254.flv|}}
+<note>You can also use a non-inventory part number as a way to offset the value of the Transfer invoice you have created instead of manually adding the ledger in the invoice itself. You may refer to this
+[[http://wiki.wws5.com/lib/exe/fetch.php?media=training:inventory_adjustments_and_automatic_posting_to_ledger0808211254.flv|training video.]]</note>
+**3. Physical Inventory Count** \\
+Physical Inventory Count is best used if you have many inventory items that need updating in terms of its quantity. This is especially true when you are doing your [[faq:how_to_complete_a_yearend|year-end]]. Once the physical count has processed, print, and export the variance report. Because once it is closed, you can no longer pull it back up. Likewise, //**a Journal Entry is also required**// upon completion of the physical count. \\
+**4. Data Load** \\
+You can also do inventory stock adjustment by doing a data load. This as well will //**require you to do a Journal Entry**// once the data load is done.
-Created by Harry Czerednikow at 8/21/2008 12:54:14 PM
+<note important>You will need to create an inventory adjustment ledger account if you haven’t created any yet. This will be used as an offset whenever creating a Journal Entry for your inventory ledger.</note>