Difference between revisions of "Warehouse"

 
(2 intermediate revisions by the same user not shown)
Line 19: Line 19:
 
=====Adding Warehouse=====
 
=====Adding Warehouse=====
  
#Go to Maintenance then click [[Warehouse]]
+
#Click [[Warehouse]] under Maintenance Menu
#Click '''Add Warehouse''' Button
+
#Under Warehouse Menu Screen, Click '''Add Warehouse''' Button
#Fill out the necessary fields then click '''Save'''
+
#Fill out the necessary fields then click '''Save. Note: Fields with * are require fields'''
  
 
[[File:Maintenance - Warehouse - Add.png|border|center|1500x1500px]]
 
[[File:Maintenance - Warehouse - Add.png|border|center|1500x1500px]]
Line 27: Line 27:
  
 
{| class="wikitable" style="margin: auto;"
 
{| class="wikitable" style="margin: auto;"
!Field
+
!'''Field'''
!Description
+
!'''Description'''
!Expected Values
+
!'''Allowed Inputs'''
 +
!'''Restricted Inputs'''
 +
!'''Character Limit'''
 +
!'''Required Field'''
 
|-
 
|-
 
|1.Warehouse Code
 
|1.Warehouse Code
 
|•Reference Code for Warehouse
 
|•Reference Code for Warehouse
|•Alphanumeric
+
|*Alphanumeric
 +
 
 +
<nowiki>*</nowiki>Dash "-"
 +
 
 +
<nowiki>*</nowiki>Underscore "_"
 +
| style="vertical-align:middle;text-align:center;" |Other Special Characters not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" |10
 +
| style="vertical-align:middle;text-align:center;" |Yes
 
|-
 
|-
 
|2.Warehouse Description
 
|2.Warehouse Description
 
|•Description for Warehouse
 
|•Description for Warehouse
|•Alphanumeric
+
|*Alphanumeric
 +
 
 +
<nowiki>*</nowiki>Special Characters
 +
 
 +
<nowiki>*</nowiki>Space
 +
| style="vertical-align:middle;text-align:center;" |None
 +
| style="vertical-align:middle;text-align:center;" |50
 +
| style="vertical-align:middle;text-align:center;" |Yes
 
|}
 
|}
  
Line 43: Line 60:
  
 
*Warehouse Code is a required unique field in the module. This field is cannot be edited once the record is created.
 
*Warehouse Code is a required unique field in the module. This field is cannot be edited once the record is created.
*For detailed instructions on how to create a Warehouse, the user may visit Warehouse Job Aids which can be found [[Warehouse Aids|here]]
 
  
 
=====View Warehouse=====
 
=====View Warehouse=====
  
#Go to Maintenance then click [[Warehouse]]
+
#Click [[Warehouse]] under Maintenance Menu
 
#Select a Warehouse that needs to view its details. Click the drop-down arrow then click View.
 
#Select a Warehouse that needs to view its details. Click the drop-down arrow then click View.
 
#The user has an option to Edit the Warehouse record upon viewing it.
 
#The user has an option to Edit the Warehouse record upon viewing it.
Line 55: Line 71:
 
=====Editing Warehouse=====
 
=====Editing Warehouse=====
  
#Go to Maintenance then click [[Warehouse]]
+
#Click [[Warehouse]] under Maintenance Menu
#Find the Warehouse Entry that needs an update. Click the Drop-down Arrow then choose '''Edit.'''
+
#Select a Warehouse Entry that needs to updates its details. Click the Drop-down Arrow then choose '''Edit.'''
#Update the fields then click '''Save''' to finish the edit process.
+
#Update the necessary fields then click Save
  
 
[[File:Maintenance - Warehouse - Edit.png|border|center|1500x1500px]]
 
[[File:Maintenance - Warehouse - Edit.png|border|center|1500x1500px]]
 
<br />
 
<br />
{| class="wikitable" style="margin: auto;"
+
{| class="wikitable" style="margin: auto;" data-ve-attributes="{&quot;style&quot;:&quot;margin: auto;&quot;}"
!Field
+
!'''Field'''
!Description
+
!'''Description'''
!Expected Values
+
!'''Allowed Inputs'''
 +
!'''Restricted Inputs'''
 +
!'''Character Limit'''
 +
!'''Required Field'''
 +
|-
 +
|1.Warehouse Code
 +
|•Reference Code for Warehouse
 +
|N/A
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |N/A
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |N/A
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |N/A
 
|-
 
|-
|1.Warehouse Description
+
|2.Warehouse Description
 
|•Description for Warehouse
 
|•Description for Warehouse
|•Alphanumeric
+
|*Alphanumeric
|}
+
 
Notes:
+
<nowiki>*</nowiki>Special Characters
 +
 
 +
<nowiki>*</nowiki>Space
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |None
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |50
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Yes
 +
|}Notes:
  
 
*Warehouse Code is a unique field, the said field cannot be edited once created
 
*Warehouse Code is a unique field, the said field cannot be edited once created
Line 85: Line 117:
  
 
*When Importing the records, the user should follow the following steps provided in the Importing Warehouse Screen such as
 
*When Importing the records, the user should follow the following steps provided in the Importing Warehouse Screen such as
**Downloading the template link provided under Step 1.
 
**Filling up the information needed for each columns of the template
 
**Uploading the updated Template
 
  
 
[[File:Maintenance - Warehouse - Import.png|border|center|1710x1710px]]
 
[[File:Maintenance - Warehouse - Import.png|border|center|1710x1710px]]
 
<br />
 
<br />
{| class="wikitable" style="margin: auto;"
+
{| class="wikitable" style="margin: auto;" data-ve-attributes="{&quot;style&quot;:&quot;margin: auto;&quot;}"
|+ style="box-sizing: inherit; padding-top: 8px; padding-bottom: 8px; color: rgb(119, 119, 119); text-align: left; font-weight: bold;" |Warehouse Import Details
+
!'''Field'''
! style="background-color:rgb(234, 236, 240);text-align:center;" |'''Field'''
+
!'''Description'''
! style="background-color:rgb(234, 236, 240);text-align:center;" |'''Description'''
+
!'''Allowed Inputs'''
! style="background-color:rgb(234, 236, 240);text-align:center;" |'''Allowed Inputs'''
+
!'''Restricted Inputs'''
! style="background-color:rgb(234, 236, 240);text-align:center;" |'''Input Restrictions'''
+
!'''Character Limit'''
! style="background-color:rgb(234, 236, 240);text-align:center;" |'''Required Field?'''
+
!'''Required Field'''
|- style="box-sizing: inherit;"
+
|-
| style="" |1.Warehouse Code
+
|1.Warehouse Code
| style="" |Reference Code for Warehouse
+
|•Reference Code for Warehouse
| style="vertical-align:middle;text-align:left;" |*Alphanumeric
+
|*Alphanumeric
  
 
<nowiki>*</nowiki>Dash "-"
 
<nowiki>*</nowiki>Dash "-"
  
 
<nowiki>*</nowiki>Underscore "_"
 
<nowiki>*</nowiki>Underscore "_"
| style="" |*Up to 15 characters
+
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Other Special Characters not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |10
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Yes
 +
|-
 +
|2.Warehouse Description
 +
|•Description for Warehouse
 +
|*Alphanumeric
  
<nowiki>*</nowiki>Other Special Characters
+
<nowiki>*</nowiki>Special Characters
| style="vertical-align:middle;text-align:center;" |Yes
 
|- style="box-sizing: inherit;"
 
| style="" |2.Warehouse Description
 
| style="" |Description for Warehouse
 
| style="" |*Alphanumeric
 
  
<nowiki>*</nowiki>Special Characters
+
<nowiki>*</nowiki>Space
| style="" |*Up to 25 characters
+
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |None
| style="vertical-align:middle;text-align:center;" |Yes
+
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |50
 +
| style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |Yes
 
|}
 
|}
 
 
=====<span class="mw-headline" id="Activating_Item_Class_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Activating_Item_Type_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Activating_Chart_of_Account_Record" style="box-sizing: inherit;">Activating Warehouse Record</span></span></span>=====
 
=====<span class="mw-headline" id="Activating_Item_Class_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Activating_Item_Type_Record" style="box-sizing: inherit;"><span class="mw-headline" id="Activating_Chart_of_Account_Record" style="box-sizing: inherit;">Activating Warehouse Record</span></span></span>=====
 
Warehouse can be Activated in two ways:
 
Warehouse can be Activated in two ways:
Line 206: Line 236:
 
|Inventory
 
|Inventory
 
|[[Inventory Adjustment]]<nowiki> | </nowiki>[[Inventory Inquiry]]<nowiki> | </nowiki>[[Inventory Movement]]<nowiki> | </nowiki>[[Stock Transfer]]<nowiki> | </nowiki>[[Purchase Return]]<nowiki> | </nowiki>[[Sales Return]]
 
|[[Inventory Adjustment]]<nowiki> | </nowiki>[[Inventory Inquiry]]<nowiki> | </nowiki>[[Inventory Movement]]<nowiki> | </nowiki>[[Stock Transfer]]<nowiki> | </nowiki>[[Purchase Return]]<nowiki> | </nowiki>[[Sales Return]]
 +
|-
 +
! colspan="2" |'''Reports'''
 +
|-
 +
|Sales Reports
 +
|[[Sales per Warehouse]]
 
|}
 
|}
 +
[[Category:Maintenance]]

Latest revision as of 10:17, 12 April 2022

Warehouse

This maintenance screen allows the user to configure and add Warehouse to be used when adjusting, transferring stocks to be used on their transactions.

Warehouse Record List
Maintenance - Warehouse - Record List.png


Notes:

  • Warehouse can be used as long its status is ACTIVE
    • Items and Transactions tagged in the Warehouse are kept even it is deactivate.
    • Inventory Adjustment and Stock Transfer cannot be done if the warehouse is INACTIVE
    • Transactions under Sales Module, Purchase Module, Financials Module and Inventory Modules that uses Warehouse cannot be used if the status is INACTIVE
      • INACTIVE warehouse used on past transactions prior to its deactivation can still be used.
Adding Warehouse
  1. Click Warehouse under Maintenance Menu
  2. Under Warehouse Menu Screen, Click Add Warehouse Button
  3. Fill out the necessary fields then click Save. Note: Fields with * are require fields
Maintenance - Warehouse - Add.png


Field Description Allowed Inputs Restricted Inputs Character Limit Required Field
1.Warehouse Code •Reference Code for Warehouse *Alphanumeric

*Dash "-"

*Underscore "_"

Other Special Characters not mentioned in the allowed inputs 10 Yes
2.Warehouse Description •Description for Warehouse *Alphanumeric

*Special Characters

*Space

None 50 Yes

Notes:

  • Warehouse Code is a required unique field in the module. This field is cannot be edited once the record is created.
View Warehouse
  1. Click Warehouse under Maintenance Menu
  2. Select a Warehouse that needs to view its details. Click the drop-down arrow then click View.
  3. The user has an option to Edit the Warehouse record upon viewing it.
Maintenance - Warehouse - View.png


Editing Warehouse
  1. Click Warehouse under Maintenance Menu
  2. Select a Warehouse Entry that needs to updates its details. Click the Drop-down Arrow then choose Edit.
  3. Update the necessary fields then click Save
Maintenance - Warehouse - Edit.png


Field Description Allowed Inputs Restricted Inputs Character Limit Required Field
1.Warehouse Code •Reference Code for Warehouse N/A N/A N/A N/A
2.Warehouse Description •Description for Warehouse *Alphanumeric

*Special Characters

*Space

None 50 Yes

Notes:

  • Warehouse Code is a unique field, the said field cannot be edited once created
Importing and Exporting Warehouse

1. Under Warehouse, Click Options

2. Under Options, The user may Export or Import The Record

  • When Exporting the records, the user may also use the filter options through tabs for precise searching and exporting of records.
Maintenance - Warehouse - Export.png


  • When Importing the records, the user should follow the following steps provided in the Importing Warehouse Screen such as
Maintenance - Warehouse - Import.png


Field Description Allowed Inputs Restricted Inputs Character Limit Required Field
1.Warehouse Code •Reference Code for Warehouse *Alphanumeric

*Dash "-"

*Underscore "_"

Other Special Characters not mentioned in the allowed inputs 10 Yes
2.Warehouse Description •Description for Warehouse *Alphanumeric

*Special Characters

*Space

None 50 Yes
Activating Warehouse Record

Warehouse can be Activated in two ways:

  • Using drop-down arrow of a record can be used in single record Activation
Maintenance - Warehouse - Activate1.png


  • Using Activate Button for activating multiple record
Maintenance - Warehouse - Activate2.png


Deactivating Warehouse Record

Warehouse can be deactivated in two ways:

  • Using drop-down arrow of a record can be used in single record deactivation
Maintenance - Warehouse - Deactivate1.png


  • Using Deactivate Button for deactivating multiple record
Maintenance - Warehouse - Deactivate2.png


Deleting Warehouse Record

Warehouse can be deleted in two ways:

  • Using drop-down arrow of a record can be used in single record deletion
Maintenance - Warehouse - Delete1.png


  • Using Delete Button for deleting multiple record
Maintenance - Warehouse - Delete2.png


Warehouse Record Option
Actions Available base on Warehouse Record Status
Status View Edit Deactivate Activate Delete
ACTIVE
INACTIVE

Notes:

  • Warehouse record can be edited by the user while viewing its details.
  • Activating/Deactivating and Deleting of Records can be done in two ways.
    • For single records, the user may use the drop down arrow then the action that need to perform.
    • For multiple records, the user may tick the records then click the action button that need to perform
      • Click the Yes in the confirmation to proceed on the action taken.


Categories:
Modules
Maintenance Maintenance | Warehouse
Sales Sales | Sales Quotation | Sales Order | Delivery Receipt
Purchase Import Purchase Order | Purchase Requisition | Purchase Order | Purchase Receipt
Inventory Inventory Adjustment | Inventory Inquiry | Inventory Movement | Stock Transfer | Purchase Return | Sales Return
Reports
Sales Reports Sales per Warehouse