Difference between revisions of "Inventory Adjustment"

 
(13 intermediate revisions by the same user not shown)
Line 1: Line 1:
<br /><div style="text-align: center;">
+
<div style="text-align: center;">
[[Inventory]] | [[Inventory Adjustment]] | [[Inventory Movement]]
+
[[Inventory]] | [[Inventory Movement]] | [[Inventory Inquiry]]
 
</div>
 
</div>
 
==Inventory Adjustment==
 
==Inventory Adjustment==
 
Allows the user to adjust the quantity of items on a specific warehouse
 
Allows the user to adjust the quantity of items on a specific warehouse
 +
=====Requirements before using Inventory Adjustment=====
 +
 +
*The user should setup the following [[Maintenance]] Module in order to proceed on using the [[Inventory Adjustment]]
 +
*#[[Brand]]
 +
*#[[Chart of Account]]
 +
*#[[Item Master]]
 +
*#[[Warehouse]]
  
 
=====Inventory Adjustment Notice=====
 
=====Inventory Adjustment Notice=====
[[File:Inventory Adjustment Notice.png|center|thumb|Inventory Adjustment Notice]]
+
[[File:Inventory - Inventory Adjustment - Notice.png|border|center|641x641px]]
 +
 
 +
 
 
Notes:
 
Notes:
  
Line 12: Line 21:
  
 
=====Inventory Adjustment List=====
 
=====Inventory Adjustment List=====
[[File:Inventory Adjustment List.png|center|thumb|Inventory Adjustment List]]
+
[[File:Inventory - Inventory Adjustment - Record List.png|border|center|1500x1500px]]
 +
 
  
 
Notes:
 
Notes:
  
* For easier access on a specific Item, the user can filter the search by [[Warehouse]], [[Brand]], [[Item Master|Item]] or both
+
*For easier access on a specific Item, the user can filter the search by [[Warehouse]], [[Brand]], [[Item Master|Item]] or both
  
 
*The [[Warehouse]] status should be active to proceed on the Inventory Adjustment.
 
*The [[Warehouse]] status should be active to proceed on the Inventory Adjustment.
Line 22: Line 32:
 
*The Item status should be active in order to adjust the item quantity on the Inventory Adjustment.
 
*The Item status should be active in order to adjust the item quantity on the Inventory Adjustment.
 
**Items can be seen in [[Item Master]] Maintenance Module
 
**Items can be seen in [[Item Master]] Maintenance Module
* Every Inventory Adjustment performed will be seen in [[Inventory Movement]] Module.
+
*Every Inventory Adjustment performed will be seen in [[Inventory Movement]] Module.
* For detailed steps on how to perform an Inventory Adjustment. You can visit the Inventory Adjustment Job Aids which can be found [[Inventory Adjustment Aids|here]]
+
 
 +
=====<span class="mw-headline" id="Performing_Inventory_Adjustment" style="box-sizing: inherit;">Performing Inventory Adjustment</span>=====
 +
 
 +
#Click [[Inventory Adjustment]] under Inventory Menu
 +
#Take note that there is also other users that using the system. Make sure to give them a heads-up that you will be doing an inventory adjustments. Click '''Proceed''' to continue.
 +
#Select [[Warehouse]]
 +
#Choose an Item that needs to be Adjusted then adjust its Quality using the (+) and (-) Button.
 +
#An adjustment modal will appear. Make sure to fill up the necessary information on the fields then click '''Save. Note: Fields with * are require fields'''
 +
#The movement of items can be seen in [[Inventory Movement]] Module. Clicking the Reference No. of the Adjustment will provide a clearer detail of the adjustment
 +
#*The user may print the inventory adjustment record by clicking the print button under view Adjustment in Inventory Movement Record
  
=====Inventory Adjustment Option=====
+
[[File:Inventory - Inventory Adjustment - Performing.png|border|center|2945x2945px]]
[[File:Inventory Adjustment Option.png|center|thumb|Inventory Adjustment Option]]Notes:
+
=====Beginning Balance Setup=====
 +
The user should set up the following modules in order to Import Beginning Balances.
  
* List of Accounts from Debit account can be seen in [[Chart of Account]] Maintenance Module
+
#[[Item Class]]
 +
#[[Item Master]]
 +
#[[Item Type]]
 +
#[[Unit of Measure]]
 +
#[[Warehouse]]
  
=====Inventory Adjustment Serialized Options=====
+
=====Import Beginning Balance=====
[[File:Inventory Adjustment Serialized Option.png|center|thumb|Inventory Adjustment Serialized Option]]
+
 
 +
#Click [[Inventory Adjustment]] under Inventory Menu
 +
#Take note that there is also other users that using the system. Make sure to give them a heads-up that you will be doing an inventory adjustments. Click '''Proceed''' to continue.
 +
#Under Inventory, Click Import Beginning Balance
 +
#Choose the date of the Beginning Balance to take effect before proceeding or click skip.
 +
#Download the Template provided in Step 1.
 +
#Fill up the information needed for each column of the template.
 +
#Upload the updated template then click Import to proceed
 +
 
 +
[[File:Inventory - Inventory Adjustment - Import Beginning Balance.png|border|center|1853x1853px]]
 +
{| class="wikitable"
 +
|+Import Beginning Balance Fields
 +
!'''Field'''
 +
!'''Description'''
 +
!'''Allowed Inputs'''
 +
!'''Input Restrictions'''
 +
!'''Required Field'''
 +
|-
 +
|1.Item Code
 +
|Reference Code of an Item
 +
|Item Code provided in Item Master Maintenance Module
 +
|Any inputs not mentioned in the required inputs
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|-
 +
|2.Item Name
 +
|Name of an Item corresponds to its Item Code
 +
|Item Name provided in Item Master Maintenance Module
 +
|Any inputs not mentioned in the required inputs
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|-
 +
|3.Warehouse
 +
|Warehouse assigned to the item
 +
|Warehouse Name provided in Warehouse Maintenance Module
 +
|Any inputs not mentioned in the required inputs
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|-
 +
|4.Quantity
 +
|Quantity of an Item
 +
|Numeric
 +
|Any inputs not mentioned in the required inputs
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|-
 +
|5.Price
 +
|Beginning Unit Price of an Item
 +
|Numeric
 +
|Any inputs not mentioned in the required inputs
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|}
 +
Notes:
  
*Serialized Items should have Serial Number or codes in order to proceed to Inventory Adjustments
+
*Import Beginning Balance will only be available if there are no transaction records done by the user.
  
=====Inventory Adjustment Serialized Item Serial No. List=====
 
[[File:Inventory Adjustment Serialized Item Serial No. List.png|center|thumb|Inventory Adjustment Serialized Item Serial No. List]]
 
 
<br />
 
<br />
{| class="wikitable"
+
{| class="wikitable" style="margin: auto;"
 
|+Categories:
 
|+Categories:
 
! colspan="2" |'''Modules'''
 
! colspan="2" |'''Modules'''
 
|-
 
|-
 
|Inventory
 
|Inventory
|[[Inventory Adjustment]]<nowiki> | </nowiki>[[Inventory Movement]]
+
|[[Inventory Adjustment]]<nowiki> | </nowiki>[[Inventory Movement]]<nowiki> | </nowiki>[[Inventory Inquiry]]
 
|-
 
|-
 
|Maintenance
 
|Maintenance
|[[Item Master]]<nowiki> | </nowiki>[[Brand]]<nowiki> | </nowiki>[[Warehouse]]<nowiki> | </nowiki>[[Chart of Account]]
+
|[[Chart of Account]]<nowiki> | </nowiki>[[Item Class]]<nowiki> | </nowiki>[[Item Master]]<nowiki> | </nowiki>[[Item Type]]<nowiki> | </nowiki>[[Unit of Measure]]<nowiki> | </nowiki>[[Warehouse]]
|-
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
|-
 
|Inventory Aids
 
|[[Inventory Adjustment Aids]]<nowiki> | </nowiki>[[Inventory Movement Aids]]
 
|-
 
|Maintenance Aids
 
|[[Item Master Aids]]<nowiki> | </nowiki>[[Brand Aids]]<nowiki> | </nowiki>[[Warehouse Aids]]<nowiki> | </nowiki>[[Chart of Accounts Aids]]
 
 
|}
 
|}
 +
[[Category:Inventory]]

Latest revision as of 12:04, 20 April 2022

Inventory Adjustment

Allows the user to adjust the quantity of items on a specific warehouse

Requirements before using Inventory Adjustment
Inventory Adjustment Notice
Inventory - Inventory Adjustment - Notice.png


Notes:

  • The system will lock for a mean time when a user proceed to use the Inventory Adjustment.
Inventory Adjustment List
Inventory - Inventory Adjustment - Record List.png


Notes:

  • For easier access on a specific Item, the user can filter the search by Warehouse, Brand, Item or both
  • The Warehouse status should be active to proceed on the Inventory Adjustment.
    • This can be seen in Warehouse Maintenance Module
  • The Item status should be active in order to adjust the item quantity on the Inventory Adjustment.
  • Every Inventory Adjustment performed will be seen in Inventory Movement Module.
Performing Inventory Adjustment
  1. Click Inventory Adjustment under Inventory Menu
  2. Take note that there is also other users that using the system. Make sure to give them a heads-up that you will be doing an inventory adjustments. Click Proceed to continue.
  3. Select Warehouse
  4. Choose an Item that needs to be Adjusted then adjust its Quality using the (+) and (-) Button.
  5. An adjustment modal will appear. Make sure to fill up the necessary information on the fields then click Save. Note: Fields with * are require fields
  6. The movement of items can be seen in Inventory Movement Module. Clicking the Reference No. of the Adjustment will provide a clearer detail of the adjustment
    • The user may print the inventory adjustment record by clicking the print button under view Adjustment in Inventory Movement Record
Inventory - Inventory Adjustment - Performing.png
Beginning Balance Setup

The user should set up the following modules in order to Import Beginning Balances.

  1. Item Class
  2. Item Master
  3. Item Type
  4. Unit of Measure
  5. Warehouse
Import Beginning Balance
  1. Click Inventory Adjustment under Inventory Menu
  2. Take note that there is also other users that using the system. Make sure to give them a heads-up that you will be doing an inventory adjustments. Click Proceed to continue.
  3. Under Inventory, Click Import Beginning Balance
  4. Choose the date of the Beginning Balance to take effect before proceeding or click skip.
  5. Download the Template provided in Step 1.
  6. Fill up the information needed for each column of the template.
  7. Upload the updated template then click Import to proceed
Inventory - Inventory Adjustment - Import Beginning Balance.png
Import Beginning Balance Fields
Field Description Allowed Inputs Input Restrictions Required Field
1.Item Code Reference Code of an Item Item Code provided in Item Master Maintenance Module Any inputs not mentioned in the required inputs Yes
2.Item Name Name of an Item corresponds to its Item Code Item Name provided in Item Master Maintenance Module Any inputs not mentioned in the required inputs Yes
3.Warehouse Warehouse assigned to the item Warehouse Name provided in Warehouse Maintenance Module Any inputs not mentioned in the required inputs Yes
4.Quantity Quantity of an Item Numeric Any inputs not mentioned in the required inputs Yes
5.Price Beginning Unit Price of an Item Numeric Any inputs not mentioned in the required inputs Yes

Notes:

  • Import Beginning Balance will only be available if there are no transaction records done by the user.


Categories:
Modules
Inventory Inventory Adjustment | Inventory Movement | Inventory Inquiry
Maintenance Chart of Account | Item Class | Item Master | Item Type | Unit of Measure | Warehouse