Difference between revisions of "Item Class"

(Tag: 2017 source edit)
Line 1: Line 1:
 
<div style="text-align: center;">
 
<div style="text-align: center;">
[[Maintenance]] | [[Item Class Aids]] | [[Item Master]] | [[Chart of Account]] | [[Tax]]
+
[[Maintenance]] | [[Item Master]] | [[Chart of Account]] | [[Tax]]
 
</div>
 
</div>
 
==Item Class==
 
==Item Class==
Line 9: Line 9:
 
*#[[Chart of Account]]
 
*#[[Chart of Account]]
 
*#[[Tax]]
 
*#[[Tax]]
*For detailed instructions on how to setup the needed [[Maintenance]] Module, the user may visit the following Job Aid pages:
 
*#[[Chart of Accounts Aids]]
 
*#[[Tax Aids]]
 
  
 
=====Item Class Record List=====
 
=====Item Class Record List=====
[[File:Item Class Record List.png|center|thumb|Item Class Record List]]
+
=====Adding Item Class=====
  
=====Adding Item Class=====
+
# Go to Maintenance then Click [[Item Class]]
[[File:Adding Item Class.png|center|thumb|776x776px|Adding Item Class]]
+
# Click '''Add Item Class''' Button
{| class="wikitable"
+
# Fill up the necessary fields then click '''Save.'''
 +
 
 +
{| class="wikitable" style="margin: auto;"
 
!Field
 
!Field
 
!Description
 
!Description
Line 33: Line 32:
 
|3.Debit Account
 
|3.Debit Account
 
|•Debit Account on Sales Details
 
|•Debit Account on Sales Details
|•Account List under Chart of Accounts
+
|•Account List under [[Chart of Account|Chart of Accounts]]
 
|-
 
|-
 
|4.Credit Account
 
|4.Credit Account
 
|•Credit Account on Sales Details
 
|•Credit Account on Sales Details
|•Account List under Chart of Accounts
+
|•Account List under [[Chart of Account|Chart of Accounts]]
 
|-
 
|-
 
|5.Debit Account
 
|5.Debit Account
 
|•Debit Account on Purchase Details
 
|•Debit Account on Purchase Details
|•Account List under Chart of Accounts
+
|•Account List under [[Chart of Account|Chart of Accounts]]
 
|-
 
|-
 
|6.Credit Account
 
|6.Credit Account
 
|•Credit Account on Purchase Details
 
|•Credit Account on Purchase Details
|•Account List under Chart of Accounts
+
|•Account List under [[Chart of Account|Chart of Accounts]]
 
|-
 
|-
 
|7.Inventory Account
 
|7.Inventory Account
 
|•Account Details on Inventory Detail
 
|•Account Details on Inventory Detail
|•Account List under Chart of Accounts
+
|•Account List under [[Chart of Account|Chart of Accounts]]
 
|-
 
|-
 
|8.Revenue Type
 
|8.Revenue Type
 
|•Tax Revenue Type on Item Class
 
|•Tax Revenue Type on Item Class
|•Tax Type List under Chart of Account Maintenance Module
+
|•Tax Type List under [[Chart of Account]] Maintenance Module
 
|-
 
|-
 
|9.Expense Type
 
|9.Expense Type
 
|•Tax Expense Type on Item Class
 
|•Tax Expense Type on Item Class
|•Tax Type List under Chart of Account Maintenance Module
+
|•Tax Type List under [[Chart of Account]] Maintenance Module
 
|}
 
|}
  
Line 67: Line 66:
 
**Some Tax details can be found on [[Tax]] maintenance module for reference but for accounting details, it is more advise to look on the [[Chart of Account]]
 
**Some Tax details can be found on [[Tax]] maintenance module for reference but for accounting details, it is more advise to look on the [[Chart of Account]]
  
*For detailed instructions on how to create an Item Class, the user can visit the Item Class Job Aids which can be found [[Item Class Aids|here]].
+
=====Editing Item Class=====
  
=====Editing Item Class=====
+
# Go to Maintenance then Click [[Item Class]]
[[File:Editing Item Class.png|center|thumb|774x774px|Editing Item Class]]
+
# Select the Item Class that needs an update. Click the drop-down arrow then click '''Edit'''
{| class="wikitable"
+
# Update the necessary Fields and Click '''Save'''
 +
 
 +
<br />
 +
{| class="wikitable" style="margin: auto;"
 
!Field
 
!Field
 
!Description
 
!Description
Line 86: Line 88:
 
|3.Debit Account
 
|3.Debit Account
 
|•Debit Account on Sales Details
 
|•Debit Account on Sales Details
|•Account List under Chart of Accounts
+
|•Account List under [[Chart of Account|Chart of Accounts]]
 
|-
 
|-
 
|4.Credit Account
 
|4.Credit Account
 
|•Credit Account on Sales Details
 
|•Credit Account on Sales Details
|•Account List under Chart of Accounts
+
|•Account List under [[Chart of Account|Chart of Accounts]]
 
|-
 
|-
 
|5.Debit Account
 
|5.Debit Account
 
|•Debit Account on Purchase Details
 
|•Debit Account on Purchase Details
|•Account List under Chart of Accounts
+
|•Account List under [[Chart of Account|Chart of Accounts]]
 
|-
 
|-
 
|6.Credit Account
 
|6.Credit Account
 
|•Credit Account on Purchase Details
 
|•Credit Account on Purchase Details
|•Account List under Chart of Accounts
+
|•Account List under [[Chart of Account|Chart of Accounts]]
 
|-
 
|-
 
|7.Inventory Account
 
|7.Inventory Account
 
|•Account Details on Inventory Detail
 
|•Account Details on Inventory Detail
|•Account List under Chart of Accounts
+
|•Account List under [[Chart of Account|Chart of Accounts]]
 
|-
 
|-
 
|8.Revenue Type
 
|8.Revenue Type
 
|•Tax Revenue Type on Item Class
 
|•Tax Revenue Type on Item Class
|•Tax Type List under Chart of Account Maintenance Module
+
|•Tax Type List under [[Chart of Account]] Maintenance Module
 
|-
 
|-
 
|9.Expense Type
 
|9.Expense Type
 
|•Tax Expense Type on Item Class
 
|•Tax Expense Type on Item Class
|•Tax Type List under Chart of Account Maintenance Module
+
|•Tax Type List under [[Chart of Account]] Maintenance Module
 
|}Notes:
 
|}Notes:
  
Line 116: Line 118:
 
*Tax Details are optional when editing an Item Class, Tax details can be used as long as it on '''ACTIVE''' status in the [[Chart of Account]] maintenance module
 
*Tax Details are optional when editing an Item Class, Tax details can be used as long as it on '''ACTIVE''' status in the [[Chart of Account]] maintenance module
 
**Some Tax details can be found on [[Tax]] maintenance module for reference but for accounting details, it is more advise to look on the [[Chart of Account]]
 
**Some Tax details can be found on [[Tax]] maintenance module for reference but for accounting details, it is more advise to look on the [[Chart of Account]]
*For further instructions on how to edit an Item Class, the user can visit the Item Class Job Aid which can be found [[Item Class Aids|here]]
 
  
=====Item Class Option=====
+
=====Importing and Exporting Item Class=====
[[File:Item Class Option.png|center|thumb|Item Class Option]]Notes:
+
1. Under [[Item Class]], Click Options
  
*For further instructions on how to Export and Import an Item class, the user can visit the Item Class Job Aid which can be found [[Item Class Aids|here]]
+
2. Under Options, The user may Export or Import The Record
  
=====Item Class Import Option=====
+
* When Exporting the records, the user may also use the filter options through tabs for precise searching and exporting of records.
[[File:Item Class Import Option.png|center|thumb|Item Class Import Option]]Notes:
+
* When Importing the records, the user should follow the following steps provided in the Importing Item Class Screen such as
 
+
** Downloading the template link provided under Step 1.
*For further instructions on how to Import an Item class, the user can visit the Item Class Job Aid which can be found [[Item Class Aids|here]]
+
** Filling up the information needed for each columns of the template
 +
** Uploading the updated Template
  
 +
{| class="wikitable" style="box-sizing: inherit; border-collapse: collapse; border-spacing: 0px; background-color: rgb(248, 249, 250); font-size: 14px; color: rgb(34, 34, 34); margin: auto; border: 1px solid rgb(162, 169, 177); font-family: &quot;Open Sans&quot;, Roboto, arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"
 +
|+ style="box-sizing: inherit; padding-top: 8px; padding-bottom: 8px; color: rgb(119, 119, 119); text-align: left; font-weight: bold;" |Item Class Import Details
 +
! colspan="5" |'''Item Class Details'''
 +
|- style="box-sizing: inherit;"
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |'''Field'''
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |'''Description'''
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |'''Allowed Inputs'''
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |'''Input Restrictions'''
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |'''Required Field?'''
 +
|- style="box-sizing: inherit;"
 +
| style="" |1. Item Class
 +
| style="" |Defines the item base from properties and attributes
 +
| style="vertical-align:middle;text-align:left;" |*Alphanumeric
 +
<nowiki>*</nowiki>Special Characters
 +
| style="" |*Up to 25 characters
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |2. Parent Class
 +
| style="" |The Item Class being inherited from
 +
| style="" |*Existing Item Class record from Item Class Maintenance Module
 +
| style="" |*Any inputs not mentioned in the allowed inputs
 +
<nowiki>*</nowiki>Inactive Item Class
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|-
 +
! colspan="5" |'''Accounting Details'''
 +
|-
 +
!'''Field'''
 +
!'''Description'''
 +
!'''Allowed Inputs'''
 +
!'''Input Restrictions'''
 +
!'''Required Field?'''
 +
|-
 +
|3. Sales Debit Account
 +
|Assigned Debit Account when selling an Item
 +
|*Account Name under Account List provided in [[Chart of Account|Chart of Accounts]] Maintenance Module
 +
|*Any inputs not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |4. Sales Credit Account
 +
| style="" |Assigned Credit Account when selling an Item
 +
| style="" |*Account Name under Account List provided in [[Chart of Account|Chart of Accounts]] Maintenance Module
 +
| style="" |*Any inputs not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |5. Purchase Debit Account
 +
| style="" |Assigned Debit Account when Purchasing an Item
 +
| style="" |*Account Name under Account List provided in [[Chart of Account|Chart of Accounts]] Maintenance Module
 +
| style="" |*Any inputs not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |6. Purchase Credit Account
 +
| style="" |Assigned Credit Account when Purchasing an Item
 +
| style="" |*Account Name under Account List provided in [[Chart of Account|Chart of Accounts]] Maintenance Module
 +
| style="" |*Any inputs not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |7. Inventory Account
 +
| style="" |Assigned Account on Inventory Changes
 +
| style="" |*Account Name under Account List provided in [[Chart of Account|Chart of Accounts]] Maintenance Module
 +
| style="" |*Any inputs not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |8. Revenue Type(Tax)
 +
| style="" |Assigned Tax Type on Tax Revenue
 +
| style="" |*Tax Name under Tax Type List provided in [[Tax]] Maintenance Module
 +
| style="" |*Any inputs not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" |No
 +
|-
 +
|9. Expense Type(Tax)
 +
|Assigned Tax Type on Tax Expense
 +
|*Tax Name under Tax Type List provided in [[Tax]] Maintenance Module
 +
|*Any inputs not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" |No
 +
|}
 +
<br />
 
=====Item Class Record Option=====
 
=====Item Class Record Option=====
[[File:Item Class Record Option.png|center|thumb|Item Class Record Option]]Notes:
+
{| class="wikitable" style="box-sizing: inherit; border-collapse: collapse; border-spacing: 0px; background-color: rgb(248, 249, 250); font-size: 14px; color: rgb(34, 34, 34); margin: auto; border: 1px solid rgb(162, 169, 177); font-family: &quot;Open Sans&quot;, Roboto, arial, sans-serif; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"
 +
|+ style="box-sizing: inherit; padding-top: 8px; padding-bottom: 8px; color: rgb(119, 119, 119); text-align: left; font-weight: bold;" |Actions Available base on Item Class Record Status
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Status
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |View
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Edit
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Deactivate
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Activate
 +
! style="background-color:rgb(234, 236, 240);text-align:center;" |Delete
 +
|- style="box-sizing: inherit;"
 +
| style="" |'''ACTIVE'''
 +
| style="vertical-align:middle;text-align:center;" |
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
|- style="box-sizing: inherit;"
 +
| style="" |'''INACTIVE'''
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |
 +
| style="vertical-align:middle;text-align:center;" |☑
 +
| style="vertical-align:middle;text-align:center;" |
 +
|}
 +
Notes:
  
 +
*The user may edit the record under view screen.
 
*Item Class is required field on [[Item Master]] Module. Item Class can be use as long as its status is '''ACTIVE'''
 
*Item Class is required field on [[Item Master]] Module. Item Class can be use as long as its status is '''ACTIVE'''
 
**'''INACTIVE''' Item class can still be used as long as it is already tag on the past records prior to its deactivation
 
**'''INACTIVE''' Item class can still be used as long as it is already tag on the past records prior to its deactivation
*For further instructions on how to View, Edit, Deactivate and Delete an Item class, the user can visit the Item Class Job Aid which can be found [[Item Class Aids|here]]
+
**Used Item Class record cannot be deleted.
 +
*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.
  
=====Item Class View Record=====
+
<br />
[[File:Item Class View Record.png|center|thumb|Item Class View Record]]Notes:
+
{| class="wikitable" style="margin: auto;"
 
 
*The user can edit the details while viewing the record.
 
*For further instructions on how View and Edit an Item Class Record., the user can visit the Item Class Job Aid, which can be found [[Item Class Aids|here]]
 
 
 
{| class="wikitable"
 
 
|+Categories:
 
|+Categories:
 
! colspan="2" |'''Modules'''
 
! colspan="2" |'''Modules'''
Line 147: Line 247:
 
|Maintenance
 
|Maintenance
 
|[[Maintenance]]<nowiki> | </nowiki>[[Item Class]]<nowiki> | </nowiki>[[Item Master]]<nowiki> | </nowiki>[[Chart of Account]]<nowiki> | </nowiki>[[Tax]]
 
|[[Maintenance]]<nowiki> | </nowiki>[[Item Class]]<nowiki> | </nowiki>[[Item Master]]<nowiki> | </nowiki>[[Chart of Account]]<nowiki> | </nowiki>[[Tax]]
|-
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
|-
 
|Maintenance Aids
 
|[[Item Class Aids]]<nowiki> | </nowiki>[[Item Master Aids]]<nowiki> | </nowiki>[[Chart of Accounts Aids]]<nowiki> | </nowiki>[[Tax Aids]]
 
 
|}
 
|}

Revision as of 11:35, 16 December 2021

Item Class

This maintenance screen allows the users to configure the item class to be used on categorizing their items.

Requirements before using Item Class
Item Class Record List
Adding Item Class
  1. Go to Maintenance then Click Item Class
  2. Click Add Item Class Button
  3. Fill up the necessary fields then click Save.
Field Description Expected Values
1.Item Class •Class of the Item •Alphanumeric
2.Parent Class •Parent of the Item Class •Parent Class List Field
3.Debit Account •Debit Account on Sales Details •Account List under Chart of Accounts
4.Credit Account •Credit Account on Sales Details •Account List under Chart of Accounts
5.Debit Account •Debit Account on Purchase Details •Account List under Chart of Accounts
6.Credit Account •Credit Account on Purchase Details •Account List under Chart of Accounts
7.Inventory Account •Account Details on Inventory Detail •Account List under Chart of Accounts
8.Revenue Type •Tax Revenue Type on Item Class •Tax Type List under Chart of Account Maintenance Module
9.Expense Type •Tax Expense Type on Item Class •Tax Type List under Chart of Account Maintenance Module

Notes:

  • Accounting details are required when creating or editing Item Class, Accounting details can be used as long as it is on ACTIVE status in the Chart of Account maintenance module.
  • Tax Details are optional when creating an Item Class, Tax details can be used as long as it on ACTIVE status in the Chart of Account maintenance module
    • Some Tax details can be found on Tax maintenance module for reference but for accounting details, it is more advise to look on the Chart of Account
Editing Item Class
  1. Go to Maintenance then Click Item Class
  2. Select the Item Class that needs an update. Click the drop-down arrow then click Edit
  3. Update the necessary Fields and Click Save


Field Description Expected Values
1.Item Class •Class of the Item •Alphanumeric
2.Parent Class •Parent of the Item Class •Parent Class List Field
3.Debit Account •Debit Account on Sales Details •Account List under Chart of Accounts
4.Credit Account •Credit Account on Sales Details •Account List under Chart of Accounts
5.Debit Account •Debit Account on Purchase Details •Account List under Chart of Accounts
6.Credit Account •Credit Account on Purchase Details •Account List under Chart of Accounts
7.Inventory Account •Account Details on Inventory Detail •Account List under Chart of Accounts
8.Revenue Type •Tax Revenue Type on Item Class •Tax Type List under Chart of Account Maintenance Module
9.Expense Type •Tax Expense Type on Item Class •Tax Type List under Chart of Account Maintenance Module

Notes:

  • Accounting details are required when editing Item Class, Accounting details can be used as long as it is on ACTIVE status in the Chart of Account maintenance module.
  • Tax Details are optional when editing an Item Class, Tax details can be used as long as it on ACTIVE status in the Chart of Account maintenance module
    • Some Tax details can be found on Tax maintenance module for reference but for accounting details, it is more advise to look on the Chart of Account
Importing and Exporting Item Class

1. Under Item Class, 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.
  • When Importing the records, the user should follow the following steps provided in the Importing Item Class 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
Item Class Import Details
Item Class Details
Field Description Allowed Inputs Input Restrictions Required Field?
1. Item Class Defines the item base from properties and attributes *Alphanumeric

*Special Characters

*Up to 25 characters Yes
2. Parent Class The Item Class being inherited from *Existing Item Class record from Item Class Maintenance Module *Any inputs not mentioned in the allowed inputs

*Inactive Item Class

Yes
Accounting Details
Field Description Allowed Inputs Input Restrictions Required Field?
3. Sales Debit Account Assigned Debit Account when selling an Item *Account Name under Account List provided in Chart of Accounts Maintenance Module *Any inputs not mentioned in the allowed inputs Yes
4. Sales Credit Account Assigned Credit Account when selling an Item *Account Name under Account List provided in Chart of Accounts Maintenance Module *Any inputs not mentioned in the allowed inputs Yes
5. Purchase Debit Account Assigned Debit Account when Purchasing an Item *Account Name under Account List provided in Chart of Accounts Maintenance Module *Any inputs not mentioned in the allowed inputs Yes
6. Purchase Credit Account Assigned Credit Account when Purchasing an Item *Account Name under Account List provided in Chart of Accounts Maintenance Module *Any inputs not mentioned in the allowed inputs Yes
7. Inventory Account Assigned Account on Inventory Changes *Account Name under Account List provided in Chart of Accounts Maintenance Module *Any inputs not mentioned in the allowed inputs Yes
8. Revenue Type(Tax) Assigned Tax Type on Tax Revenue *Tax Name under Tax Type List provided in Tax Maintenance Module *Any inputs not mentioned in the allowed inputs No
9. Expense Type(Tax) Assigned Tax Type on Tax Expense *Tax Name under Tax Type List provided in Tax Maintenance Module *Any inputs not mentioned in the allowed inputs No


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

Notes:

  • The user may edit the record under view screen.
  • Item Class is required field on Item Master Module. Item Class can be use as long as its status is ACTIVE
    • INACTIVE Item class can still be used as long as it is already tag on the past records prior to its deactivation
    • Used Item Class record cannot be deleted.
  • 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 | Item Class | Item Master | Chart of Account | Tax