Inventory Adjustment
Inventory Adjustment
Purpose:
The Inventory Adjustment Form is very important to the well functioning of the BSC Food Distribution system. It allows you to increase/Decrease Inventory from any warehouse assigning the changes to the Inventory account and another selected expense account. In addition to this you can transfer merchandise among warehouses providing the user with a transfer report very valuable for this movement. Finally the Inventory Transfer form allows you to enter physical counts of merchandise. This feature in addition with the Variance Report are very helpful to track merchandise losses. The Inventory adjustment form provides a sum of all adjusted products in addition to the Total Cost of the Transaction at al times. Posting an Inventory adjustment transaction affects the Inventory as the Quantity on Hand and Average Cost is affected. However, the user has the option of affecting the GL balances or not.
Usage:
Inventory Increase/Decrease:
1- Open the Inventory Adjustment form by Clicking on Inventory/Inventory Adjustment
2- Press the “New” Button. This creates a New Transaction
3- Select Increase or Decrease in the Adjustment Drop Down list
4- Adjust the Transaction Date if Necessary
5- Enter a brief Description of the Reason for this transaction.
6- Check the “Post to GL” option if you want to affect the GL account balances with the posting of this transaction
7- Enter a more detailed description of this transaction in the “Notes” section. This is optional.
8- Select the Warehouse you will affect this Inventory Adjustment.
9- Press the Search Button to the right of the Default Account Textbox. This will allow you to search for the Expense or Inventory Adjustment account you will use in your transaction.
10- Press the Update Button to save your changes before you start adding Items to the grid.
11- Enter an Item Id or UPC in the “Item Id” textbox, press enter or tab, enter the Quantity and press enter. If you entered the Item Id/UPC right, that Item will be added to the Grid.
12- If you did not enter the Item id or the UPC right in the prior step, the search screen will open. You can also open the search screen by Clicking in the button of the Item Id Column in the Grid.
13- If you select a Batch Controlled Item you will be prompted to select from a list of all the available batches. If you select a catch weight Item the Weight Distribution will open for each of those Items.
14- You can change the Adjusted Quantity and the Cost of the selected Items right on the grid.
15- Press the Weight button to change the Weight distribution information of any of the Items Added
16- Change the Unit of Measure of any of the added Items by clicking on the “UOM” button if needed.
17- Change the Batch of any of the Raw Materials, if applicable.
18- Change the Warehouse/Bin information for any of the Items by clicking on the ”Whs/Bin” button.
19- Press the Update Button to Save Your changes
20- Press the Report Button to get a Report of all the Items being Decreased/Increased
21- Press the “Post” button to Post this transaction. This action will increase the Inventory on hand and affect the Average Cost of the Item if the Inventory Adjustment is “Increase”. ON the other hand, if the Inventory Adjustment is “decrease” the Inventory will be decrease at the current Average cost and the Average Cost Figure will remain unchanged.
Inventory Increase/Decrease:
1- Follow the Steps 1-19 of the Inventory Increase/Decrease Instructions. Just make sure to select “Physical” as a the Inventory adjustment type
2- Press the Report Button to get a Report of the new Quantities for the selected Items.
3- Press the “Variance Report” button to get a report that will show you the discrepancies of the current inventory count and the system information.
4- Press the “Post” button to Post this transaction. This action will set the Inventory on hand and enter a new Average Cost for the Item
Transfer Inventory:
1- Open the Inventory Adjustment form by Clicking on Inventory/Inventory Adjustment
2- Press the “New” Button. This creates a New Transaction
3- Select Transfer in the Adjustment Drop Down list
4- Adjust the Transaction Date if Necessary
5- Enter a brief Description of the Reason for this transaction.
6- Check the “Post to GL” option if you want to affect the GL account balances with the posting of this transaction
7- Enter a more detailed description of this transaction in the “Notes” section. This is optional.
8- Select the “From Warehouse” and “To Warehouse” you will use in the Inventory Transfer.
9- Press the Search Button to the right of the Default Account Textbox. This will allow you to search for the Expense or Inventory Adjustment account you will use in your transaction.
10- Press the Update Button to save your changes before you start adding Items to the grid.
11- Enter an Item Id or UPC in the “Item Id” textbox, press enter or tab, enter the Quantity and press enter. If you entered the Item Id/UPC right, that Item will be added to the Grid.
12- If you did not enter the Item id or the UPC right in the prior step, the search screen will open. You can also open the search screen by Clicking in the button of the Item Id Column in the Grid.
13- If you select a Batch Controlled Item you will be prompted to select from a list of all the available batches. If you select a catch weight Item the Weight Distribution will open for each of those Items.
14- You can change the Adjusted Quantity and the Cost of the selected Items right on the grid.
15- Press the Weight button to change the Weight distribution information of any of the Items Added
16- Change the Unit of Measure of any of the added Items by clicking on the “UOM” button if needed.
17- Change the Batch of any of the Raw Materials, if applicable.
18- Change the Warehouse/Bin information for any of the Items by clicking on the ”Whs/Bin” button.
19- When you are done entering the Items, click the “Prepare Transfer Button”. This will add the same items again but they will show “Increase” in the Action Column and they will be assigned to the “To” Warehouse.
20- If you Realize you have more Items to transfer and you have clicked the “Prepare Transfer” Button, you need to click in the Clear Transfer button first, Add the necessary Items and press the “Prepare Transfer” Button again.
21- Press the Update Button to Save Your changes
22- Press the Report Button to get a Report of two pages for the Items being Decreased and Increased.
23- Press the “Post” button to Post this transaction. This action will not affect the Inventory on hand, but it will move it around the different Warehouses/Bins. Transfers do not create any records in the GL as the Inventory balances stayed unaffected.
Edit and Existing Inventory Adjustment
1- Open the Inventory Adjustment form by Clicking on Inventory/Inventory Adjustment
2- Enter the Document # for the transaction you want to Edit and Press Enter. This action will brinig the transaction to the Inventory Adjustment form. If you don’t know the transaction number, press the Search button to the right of the “Document Id” Text Box, to be able to search and select it.
3- Make any Changes to the form Following the Three Processes Before
4- Update your transaction, Print it and Post it.
Copyright © 2018 Business Software Consulting, Inc. All Rights Reserved.