Difference between revisions of "Supplier"

Line 1: Line 1:
 
<div style="text-align: center;">
 
<div style="text-align: center;">
[[Maintenance]] | [[Supplier Aids]]
+
[[Maintenance]] | [[Purchase]] | [[Inventory]]
 
</div>
 
</div>
 
==Supplier==
 
==Supplier==
Line 6: Line 6:
  
 
=====Supplier Record List=====
 
=====Supplier Record List=====
[[File:Supplier Record List.png|center|thumb|Supplier Record List]]Notes:
+
Notes:
  
 
*Supplier is required field on the transactions related to payments
 
*Supplier is required field on the transactions related to payments
Line 15: Line 15:
 
***[[Accounts Payable]]
 
***[[Accounts Payable]]
 
***[[Payment Voucher]]
 
***[[Payment Voucher]]
***[[Credit Memo]]
 
***[[Debit Memo]]
 
 
***[[Debit Voucher]]
 
***[[Debit Voucher]]
 
***[[Disbursement Voucher]]
 
***[[Disbursement Voucher]]
Line 22: Line 20:
  
 
=====Adding Supplier=====
 
=====Adding Supplier=====
[[File:Adding Supplier.png|center|thumb|868x868px|Adding Supplier]]
+
 
{| class="wikitable"
+
#Go to Maintenance then click [[Supplier]]
 +
#Click '''Add Supplier''' Button
 +
#Fill up the necessary fields. Please make sure that all tabs are filled out then click '''Save.'''
 +
 
 +
{| class="wikitable" style="margin: auto;"
 
!Field
 
!Field
 
!Description
 
!Description
Line 33: Line 35:
 
|-
 
|-
 
|2.Company Name
 
|2.Company Name
|•Supplier's COmpany Name
+
|•Supplier's Company Name
 
|•Alphanumeric
 
|•Alphanumeric
 
|-
 
|-
Line 72: Line 74:
  
 
*Code is a required unique field on Supplier Module. This cannot be edited once created.
 
*Code is a required unique field on Supplier Module. This cannot be edited once created.
*For detailed instructions on how to create a Supplier Record, the user may visit the Supplier Job Aids which can be found [[Supplier Aids|here]]
 
  
<br />
 
 
=====Editing Supplier=====
 
=====Editing Supplier=====
[[File:Editing Supplier.png|center|thumb|865x865px|Editing Supplier]]
+
 
{| class="wikitable"
+
#Go to Maintenance then click [[Supplier]]
 +
#Click '''Add Supplier''' Button
 +
#Fill up the necessary fields. Please make sure that all tabs are filled out then click '''Save.'''
 +
 
 +
{| class="wikitable" style="margin: auto;"
 
!Field
 
!Field
 
!Description
 
!Description
Line 83: Line 87:
 
|-
 
|-
 
|1.Company Name
 
|1.Company Name
|•Supplier's COmpany Name
+
|•Supplier's Company Name
 
|•Alphanumeric
 
|•Alphanumeric
 
|-
 
|-
Line 119: Line 123:
 
|}Notes:
 
|}Notes:
  
*For detailed instructions on how to edit a Supplier Record, the user may visit the Supplier Job Aids which can be found [[Supplier Aids|here]]
+
* Code cannot be edited once created.
 +
 
 +
=====Importing and Exporting Supplier Option=====
 +
1. Under Supplier Screen, Click Options
 +
 
 +
2. Under Options, The user may Export or Import The Record
  
=====Supplier Option=====
+
* When Exporting the records, the user may also use the filter options through tabs for precise searching and exporting of records.
[[File:Supplier Option.png|center|thumb|Supplier Option]]Notes:
+
* When Importing the records, the user should follow the following steps provided in the Importing Supplier 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
  
*For detailed instructions on how to Export and Import a Supplier Record, the user may visit the Supplier Job Aids which can be found [[Supplier Aids|here]]
+
{| 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;" |Customer Import Details
 +
! 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.Supplier Code
 +
| style="" |Supplier's Reference Code
 +
| style="vertical-align:middle;text-align:left;" |*Alphanumeric
 +
<nowiki>*</nowiki>Dash "-"
  
=====Supplier Importing Option=====
+
<nowiki>*</nowiki>Underscore "_"
[[File:Supplier Importing Option.png|center|thumb|Supplier Importing Option]]Notes:
+
| style="" |*Up to 20 characters
 +
<nowiki>*</nowiki>Other Special Characters
  
*For detailed instructions on how to Import a Supplier Record, the user may visit the Supplier Job Aids which can be found [[Supplier Aids|here]]
+
<nowiki>*</nowiki>Space
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |2.Company Name
 +
| style="" |Company Name of the Supplier
 +
| style="" |*Alphanumeric,  Period, Comma, Space, Percent, Ampersand, Left Parenthesis, Right Parenthesis, Left Bracket, Right Bracket, Underscore, Minus, Plus, Equal, Slash, Dollar Sign, Number Sign, At Sign, Exclamation, Single Quote, Double Quote, Colon, and Semicolon
 +
| style="" |*Up to 100 characters
 +
<nowiki>*</nowiki>Other Special Characters not mentioned
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |3.Address
 +
| style="" |Address of the Supplier
 +
| style="" |*Alphanumeric,  Period, Comma, Space, Percent, Ampersand, Left Parenthesis, Right Parenthesis, Left Bracket, Right Bracket, Underscore, Minus, Plus, Equal, Slash, Dollar Sign, Number Sign, At Sign, Exclamation, Single Quote, Double Quote, Colon, and Semicolon
 +
| style="" |*Up to 105 characters
 +
<nowiki>*</nowiki>Other Special Characters not mentioned
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |4.Email
 +
| style="" |Email of the Supplier
 +
| style="" |*Alphanumeric
 +
<nowiki>*</nowiki>Dash "-"
  
=====Supplier Record Option=====
+
<nowiki>*</nowiki>Underscore "_"
[[File:Supplier Record Option.png|center|thumb|Supplier Record Option]]Notes:
 
  
*For detailed instructions on how to View, Edit, Deactivate / Activate and Delete a Supplier Record, the user may visit the Supplier Job Aids which can be found [[Supplier Aids|here]]
+
<nowiki>*</nowiki>Must follow the format ___@__.__
 +
| style="" |*Up to 150 characters
 +
<nowiki>*</nowiki>Any Special Characters except Dash and Underscore
 +
| style="vertical-align:middle;text-align:center;" |No
 +
|- style="box-sizing: inherit;"
 +
| style="" |5.Business Type
 +
| style="" |Business Type of the Supplier's Company
 +
| style="" |*Individual
 +
<nowiki>*</nowiki>Corporation
 +
| style="" |*Any inputs not mentioned in the allowed inputs
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |6.Contact Number
 +
| style="" |Contact Number of the Supplier
 +
| style="" |*Numeric
 +
| style="" |*Up to 11 characters
 +
<nowiki>*</nowiki>Any inputs except numbers
 +
| style="vertical-align:middle;text-align:center;" |No
 +
|- style="box-sizing: inherit;"
 +
| style="" |7.First Name
 +
| style="" |First Name of the Supplier
 +
| style="" |*Alphanumeric,  Period, Comma, Space, Percent, Ampersand, Left Parenthesis, Right Parenthesis, Left Bracket, Right Bracket, Underscore, Minus, Plus, Equal, Slash, Dollar Sign, Number Sign, At Sign, Exclamation, Single Quote, Double Quote, Colon, and Semicolon
 +
| style="" |*Up to 20 characters
 +
<nowiki>*</nowiki>Other Special Characters not mentioned
 +
| style="vertical-align:middle;text-align:center;" |No
 +
|- style="box-sizing: inherit;"
 +
| style="" |8.Last Name
 +
| style="" |Last Name of the Supplier
 +
| style="" |*Alphanumeric,  Period, Comma, Space, Percent, Ampersand, Left Parenthesis, Right Parenthesis, Left Bracket, Right Bracket, Underscore, Minus, Plus, Equal, Slash, Dollar Sign, Number Sign, At Sign, Exclamation, Single Quote, Double Quote, Colon, and Semicolon
 +
| style="" |*Up to 20 characters
 +
<nowiki>*</nowiki>Other Special Characters not mentioned
 +
| style="vertical-align:middle;text-align:center;" |No
 +
|- style="box-sizing: inherit;"
 +
| style="" |9.Payment Terms
 +
| style="" |Payment Terms of the Supplier
 +
| style="" |*Numeric
 +
| style="" |*Up to 5 characters
 +
<nowiki>*</nowiki>Any inputs except numbers
 +
| style="vertical-align:middle;text-align:center;" |Yes
 +
|- style="box-sizing: inherit;"
 +
| style="" |10.TIN
 +
| style="" |Tax Identification Number of the Supplier
 +
| style="" |*Numeric
 +
| style="" |*Up to 12 characters
 +
<nowiki>*</nowiki>Any inputs except numbers
 +
| style="vertical-align:middle;text-align:center;" |No
 +
|- style="box-sizing: inherit;"
 +
| style="" |11.Credit Limit
 +
| style="" |Credit Limit of the Supplier
 +
| style="" |*Numeric
 +
| style="" |*Up to 20 characters
 +
<nowiki>*</nowiki>Any inputs except numbers
 +
| style="vertical-align:middle;text-align:center;" |No
 +
|}
  
=====Supplier View Record=====
+
=====Supplier Record Option=====
[[File:Supplier View Record.png|center|thumb|Supplier View Record]]Notes
+
Notes:
  
 
*The user is allowed to edit the details when viewing the record.
 
*The user is allowed to edit the details when viewing the record.
*For detailed instructions on how to View and Edit a Supplier Record, the user may visit the Supplier Job Aids which can be found [[Supplier Aids|here]]
+
*'''INACTIVE''' suppliers cannot be used in the transactions but can still be used if it is present in the past transactions
 +
*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.
  
{| class="wikitable"
+
{| class="wikitable" style="margin: auto;"
 
|+Categories:
 
|+Categories:
 
! colspan="2" |'''Modules'''
 
! colspan="2" |'''Modules'''
Line 153: Line 253:
 
|-
 
|-
 
|Financials
 
|Financials
|[[Accounts Payable]]<nowiki> | </nowiki>[[Credit Memo]]<nowiki> | </nowiki>[[Debit Memo]]<nowiki> | </nowiki>[[Disbursement Voucher]]<nowiki> | </nowiki>[[Payment Voucher]]<nowiki> | </nowiki>[[Petty Cash]]
+
|[[Accounts Payable]]<nowiki> | </nowiki>[[Debit Voucher]]<nowiki> | </nowiki>[[Disbursement Voucher]]<nowiki> | </nowiki>[[Payment Voucher]]<nowiki> | </nowiki>[[Petty Cash]]
 
|-
 
|-
 
|Inventory
 
|Inventory
 
|[[Purchase Return]]
 
|[[Purchase Return]]
|-
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
|-
 
|Maintenance Aids
 
|[[Supplier Aids]]
 
|-
 
|Purchase Aids
 
|[[Import Purchase Order Aid]]<nowiki> | </nowiki>[[Purchase Order Aid]]<nowiki> | </nowiki>[[Purchase Receipt Aid]]
 
|-
 
|Financials Aids
 
|[[Accounts Payable Aids]]<nowiki> | </nowiki>[[Credit Memo Aids]]<nowiki> | </nowiki>[[Debit Memo Aids]]<nowiki> | </nowiki>[[Disbursement Voucher Aids]]<nowiki> | </nowiki>[[Payment Voucher Aids]]<nowiki> | </nowiki>[[Petty Cash Aids]]
 
|-
 
|Inventory Aids
 
|[[Purchase Return Aids]]
 
 
|}
 
|}

Revision as of 11:50, 17 December 2021

Supplier

This maintenance screen allows the user to configure and add Supplier to be assigned when purchasing transactions

Supplier Record List

Notes:

Adding Supplier
  1. Go to Maintenance then click Supplier
  2. Click Add Supplier Button
  3. Fill up the necessary fields. Please make sure that all tabs are filled out then click Save.
Field Description Expected Values
1.Code •Reference Code of the Supplier •Alphanumeric
2.Company Name •Supplier's Company Name •Alphanumeric
3.Address •Address of the Supplier •Alphanumeric
4.Email •Email of the Supplier •Alphanumeric
5.Business Type •Business Type of the Supplier's Company •Individual/Corporate
6.Contact Number •Contact Number of the Supplier •Number
7.First Name •First Name of the Contact Person •Alphanumeric
8.Last Name •Last Name of the Contact Person •Alphanumeric
9.Payment Terms •Days on completing the sale •Number
10.TIN •Tax Identification Number of the Contact person •Number

Notes:

  • Code is a required unique field on Supplier Module. This cannot be edited once created.
Editing Supplier
  1. Go to Maintenance then click Supplier
  2. Click Add Supplier Button
  3. Fill up the necessary fields. Please make sure that all tabs are filled out then click Save.
Field Description Expected Values
1.Company Name •Supplier's Company Name •Alphanumeric
2.Address •Address of the Supplier •Alphanumeric
3.Email •Email of the Supplier •Alphanumeric
4.Business Type •Business Type of the Supplier's Company •Individual/Corporate
5.Contact Number •Contact Number of the Supplier •Number
6.First Name •First Name of the Contact Person •Alphanumeric
7.Last Name •Last Name of the Contact Person •Alphanumeric
8.Payment Terms •Days on completing the sale •Number
9.TIN •Tax Identification Number of the Contact person •Number

Notes:

  • Code cannot be edited once created.
Importing and Exporting Supplier Option

1. Under Supplier Screen, 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 Supplier 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
Customer Import Details
Field Description Allowed Inputs Input Restrictions Required Field?
1.Supplier Code Supplier's Reference Code *Alphanumeric

*Dash "-"

*Underscore "_"

*Up to 20 characters

*Other Special Characters

*Space

Yes
2.Company Name Company Name of the Supplier *Alphanumeric,  Period, Comma, Space, Percent, Ampersand, Left Parenthesis, Right Parenthesis, Left Bracket, Right Bracket, Underscore, Minus, Plus, Equal, Slash, Dollar Sign, Number Sign, At Sign, Exclamation, Single Quote, Double Quote, Colon, and Semicolon *Up to 100 characters

*Other Special Characters not mentioned

Yes
3.Address Address of the Supplier *Alphanumeric,  Period, Comma, Space, Percent, Ampersand, Left Parenthesis, Right Parenthesis, Left Bracket, Right Bracket, Underscore, Minus, Plus, Equal, Slash, Dollar Sign, Number Sign, At Sign, Exclamation, Single Quote, Double Quote, Colon, and Semicolon *Up to 105 characters

*Other Special Characters not mentioned

Yes
4.Email Email of the Supplier *Alphanumeric

*Dash "-"

*Underscore "_"

*Must follow the format ___@__.__

*Up to 150 characters

*Any Special Characters except Dash and Underscore

No
5.Business Type Business Type of the Supplier's Company *Individual

*Corporation

*Any inputs not mentioned in the allowed inputs Yes
6.Contact Number Contact Number of the Supplier *Numeric *Up to 11 characters

*Any inputs except numbers

No
7.First Name First Name of the Supplier *Alphanumeric,  Period, Comma, Space, Percent, Ampersand, Left Parenthesis, Right Parenthesis, Left Bracket, Right Bracket, Underscore, Minus, Plus, Equal, Slash, Dollar Sign, Number Sign, At Sign, Exclamation, Single Quote, Double Quote, Colon, and Semicolon *Up to 20 characters

*Other Special Characters not mentioned

No
8.Last Name Last Name of the Supplier *Alphanumeric,  Period, Comma, Space, Percent, Ampersand, Left Parenthesis, Right Parenthesis, Left Bracket, Right Bracket, Underscore, Minus, Plus, Equal, Slash, Dollar Sign, Number Sign, At Sign, Exclamation, Single Quote, Double Quote, Colon, and Semicolon *Up to 20 characters

*Other Special Characters not mentioned

No
9.Payment Terms Payment Terms of the Supplier *Numeric *Up to 5 characters

*Any inputs except numbers

Yes
10.TIN Tax Identification Number of the Supplier *Numeric *Up to 12 characters

*Any inputs except numbers

No
11.Credit Limit Credit Limit of the Supplier *Numeric *Up to 20 characters

*Any inputs except numbers

No
Supplier Record Option

Notes:

  • The user is allowed to edit the details when viewing the record.
  • INACTIVE suppliers cannot be used in the transactions but can still be used if it is present in the past transactions
  • 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 | Supplier
Purchase Purchase | Import Purchase Order | Purchase Order | Purchase Receipt
Financials Accounts Payable | Debit Voucher | Disbursement Voucher | Payment Voucher | Petty Cash
Inventory Purchase Return