You are viewing an old version of this page. Return to the latest version.
Difference between revisions of "Journal Voucher"
(Tag: Visual edit) |
(Tag: 2017 source edit) |
||
Line 1: | Line 1: | ||
<div style="text-align: center;"> | <div style="text-align: center;"> | ||
− | [[Financials]] | [[ | + | [[Financials]] | [[Inventory]] |
</div><br /> | </div><br /> | ||
==Journal Voucher== | ==Journal Voucher== | ||
Line 9: | Line 9: | ||
**[[Chart of Account]] | **[[Chart of Account]] | ||
**[[Proforma]] | **[[Proforma]] | ||
− | |||
− | |||
− | |||
=====Journal Voucher Record List===== | =====Journal Voucher Record List===== | ||
− | [[ | + | =====Adding Journal Voucher===== |
+ | |||
+ | # Go to Financials then click [[Journal Voucher]] | ||
+ | # Click '''Add Journal Voucher''' Button | ||
+ | # Fill out the necessary fields on the Journal Voucher Header Form. | ||
+ | # Fill out the Accounting Details of the Journal Voucher Form then Click '''Save''' | ||
− | |||
− | |||
{| class="wikitable" | {| class="wikitable" | ||
+ | !Field | ||
+ | !Description | ||
+ | !Expected Values | ||
+ | |- | ||
|1.Voucher No. | |1.Voucher No. | ||
|•Voucher Number of the Transaction upon creation | |•Voucher Number of the Transaction upon creation | ||
Line 31: | Line 35: | ||
|•Date | |•Date | ||
|- | |- | ||
− | |4.[ | + | |4.[https://docs.oojeema.com/Proforma Proforma] |
|•Financial statements is to facilitate comparisons of historic data and projections of future performance. | |•Financial statements is to facilitate comparisons of historic data and projections of future performance. | ||
|•Proforma list provided in the Proforma Maintenance Module | |•Proforma list provided in the Proforma Maintenance Module | ||
Line 39: | Line 43: | ||
|•Alphanumeric | |•Alphanumeric | ||
|- | |- | ||
− | |6.[ | + | |6.[https://docs.oojeema.com/Chart_of_Account Account] |
|•Account to be charged for credit and debit amount on the transaction | |•Account to be charged for credit and debit amount on the transaction | ||
|•Account list in the Chart of Accounts Maintenance Module | |•Account list in the Chart of Accounts Maintenance Module | ||
Line 61: | Line 65: | ||
*<span style="color: rgb(51, 51, 51)">Account should be on '''ACTIVE''' status when using it upon creating or editing a transaction.</span> | *<span style="color: rgb(51, 51, 51)">Account should be on '''ACTIVE''' status when using it upon creating or editing a transaction.</span> | ||
**This can be seen in [[Chart of Account]] Maintenance Module. | **This can be seen in [[Chart of Account]] Maintenance Module. | ||
− | |||
*Journal Voucher is autogenerated when creating a [[Sales Return]]. | *Journal Voucher is autogenerated when creating a [[Sales Return]]. | ||
*Journal Voucher is autogenerated when creating a [[Purchase Return]]. | *Journal Voucher is autogenerated when creating a [[Purchase Return]]. | ||
*Only one user can use Add Voucher function at a time. | *Only one user can use Add Voucher function at a time. | ||
− | |||
=====Editing Journal Voucher===== | =====Editing Journal Voucher===== | ||
− | [[ | + | |
− | + | # Go to Financials then click [[Journal Voucher]] | |
+ | # Select the Journal Voucher that needs an edit, click the drop-down arrow then choose '''Edit.''' | ||
+ | # Update the necessary the fields. Then click '''Save.''' | ||
+ | |||
{| class="wikitable" | {| class="wikitable" | ||
!Field | !Field | ||
Line 121: | Line 126: | ||
*Journal Vouchers that are auto-generated from [[Payment Voucher]] cannot be edited. | *Journal Vouchers that are auto-generated from [[Payment Voucher]] cannot be edited. | ||
*Only one user can use Edit Voucher function at a time. | *Only one user can use Edit Voucher function at a time. | ||
− | |||
− | =====Journal Voucher | + | =====Importing and Exporting Journal Voucher===== |
− | + | 1. Under Journal Voucher 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 such as Date Filter, Search Bar and Source filter for precise searching and exporting of records. | |
− | + | * When Importing the records, the user should follow the following steps provided in the Importing Journal Voucher 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 | ||
− | + | {| 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: "Open Sans", 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;" |Import Data Dictionary of Journal Voucher | ||
+ | ! style="background-color:rgb(234, 236, 240);text-align:center;" |Field | ||
+ | ! style="background-color:rgb(234, 236, 240);text-align:center;" |Description of Data Output | ||
+ | ! 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 (Y/N) | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |1.Document Set | ||
+ | | style="" |Manual Entry of Document Set of Journal Voucher | ||
+ | | style="" |*Alphanumeric | ||
+ | <nowiki>*</nowiki>Underscore "_" | ||
+ | | style="" |*Other Special characters not mentioned | ||
+ | | style="vertical-align:middle;text-align:center;" |Y | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |2.Transaction Date | ||
+ | | style="" |Manual entry of Transaction Date of the Voucher | ||
+ | | style="" |*Numeric | ||
+ | <nowiki>*</nowiki>Dash "-" | ||
− | ===== | + | <nowiki>*</nowiki>Backslash "\" |
− | + | | style="" |*Other Special characters not mentioned | |
+ | | style="vertical-align:middle;text-align:center;" |Y | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |3.Reference No. | ||
+ | | style="" |Manual Entry of Accounts Payable Reference No. | ||
+ | | style="" |*Alphanumeric | ||
+ | <nowiki>*</nowiki>Underscore "_" | ||
+ | |||
+ | <nowiki>*</nowiki>Dash "-" | ||
+ | | style="" |*Other Special characters not mentioned | ||
+ | | style="vertical-align:middle;text-align:center;" |N | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |4.Notes | ||
+ | | style="" |Manual Entry of Journal Voucher Reference No. | ||
+ | | style="" |*Alphanumeric | ||
+ | |||
+ | <nowiki>*</nowiki>Underscore "_" | ||
− | * | + | <nowiki>*</nowiki>Dash "-" |
+ | | style="" |*Other Special characters not mentioned | ||
+ | | style="vertical-align:middle;text-align:center;" |N | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |5.Account Name | ||
+ | | style="" |Manual Entry of Account Name - must be based from [[Chart of Account]] Maintenance | ||
+ | | style="" |*Numeric | ||
+ | <nowiki>*</nowiki>Account Name based from [[Chart of Account]] Maintenance Module | ||
+ | | style="" |*Any input not mentioned in the allowed inputs | ||
+ | | style="vertical-align:middle;text-align:center;" |Y | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |6.Description | ||
+ | | style="" |Manual Entry of Account Description | ||
+ | | style="" |*Alphanumeric | ||
+ | <nowiki>*</nowiki>Special Characters | ||
+ | | style="" |*None | ||
+ | | style="vertical-align:middle;text-align:center;" |N | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |7.Debit | ||
+ | | style="" |Manual entry of Debit Amount | ||
+ | | style="" |*Numeric | ||
+ | | style="" |*Any input except numbers | ||
+ | | style="vertical-align:middle;text-align:center;" |Y | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |8.Credit | ||
+ | | style="" |Manual entry of Credit Amount | ||
+ | | style="" |*Numeric | ||
+ | | style="" |*Any input except numbers | ||
+ | | style="vertical-align:middle;text-align:center;" |Y | ||
+ | |} | ||
− | =====Journal Voucher | + | =====Journal Voucher Record Options===== |
− | + | {| 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: "Open Sans", 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 Disbursement Voucher 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;" |Print | ||
+ | ! style="background-color:rgb(234, 236, 240);text-align:center;" |Post | ||
+ | ! style="background-color:rgb(234, 236, 240);text-align:center;" |Unpost | ||
+ | ! style="background-color:rgb(234, 236, 240);text-align:center;" |Cancel | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |'''UNPOSTED''' | ||
+ | | 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="" | | ||
+ | | style="vertical-align:middle;text-align:center;" |☑ | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |'''POSTED''' | ||
+ | | 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="vertical-align:middle;text-align:center;" | | ||
+ | |- style="box-sizing: inherit;" | ||
+ | | style="" |'''CANCELLED''' | ||
+ | | 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="" | | ||
+ | | style="vertical-align:middle;text-align:center;" | | ||
+ | |} | ||
+ | Notes: | ||
− | * | + | *Only Manually created Journal Vouchers can be edited |
+ | **Manually created Journal Vouchers can be edited while viewing the record. | ||
+ | *Any auto-generated Journal Voucher will set its status into '''POSTED''' | ||
− | {| class="wikitable" | + | {| class="wikitable" style="margin: auto;" |
|+Categories: | |+Categories: | ||
! colspan="2" |'''Modules''' | ! colspan="2" |'''Modules''' | ||
|- | |- | ||
|Financials | |Financials | ||
− | |[[Financials]]<nowiki> | </nowiki>[[Journal Voucher | + | |[[Financials]]<nowiki> | </nowiki>[[Journal Voucher]] |
|- | |- | ||
|Inventory | |Inventory | ||
Line 156: | Line 261: | ||
|Maintenance | |Maintenance | ||
|[[Proforma]]<nowiki> | </nowiki>[[Chart of Account]] | |[[Proforma]]<nowiki> | </nowiki>[[Chart of Account]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|}<br /> | |}<br /> |
Revision as of 13:02, 21 December 2021
Contents
Journal Voucher
Allows the user to create a voucher to be used for financial activity like sales return and purchase return.
Requirements before using Journal Voucher
- The user should setup the following Maintenance Module in order to proceed on using the Journal Voucher
Journal Voucher Record List
Adding Journal Voucher
- Go to Financials then click Journal Voucher
- Click Add Journal Voucher Button
- Fill out the necessary fields on the Journal Voucher Header Form.
- Fill out the Accounting Details of the Journal Voucher Form then Click Save
Field | Description | Expected Values |
---|---|---|
1.Voucher No. | •Voucher Number of the Transaction upon creation | •Alphanumeric(Auto-Generated) |
2.Reference No. | •Reference Number of the Transaction | •Alphanumeric |
3.Transaction Date | •Date when the Transaction was Created | •Date |
4.Proforma | •Financial statements is to facilitate comparisons of historic data and projections of future performance. | •Proforma list provided in the Proforma Maintenance Module |
5.Notes | •Other Remarks on the Transaction | •Alphanumeric |
6.Account | •Account to be charged for credit and debit amount on the transaction | •Account list in the Chart of Accounts Maintenance Module |
7.Description | •Any remarks or description on the Account | •Alphanumeric |
8.Debit | •Debit Amount for the Transaction | •Number |
9.Credit | •Credit Amount for the Transaction | •Number |
Notes:
- Proforma should be on ACTIVE status when using it upon creating or editing a transaction.
- This can be seen in Proforma Maintenance Module
- Past Transactions with INACTIVE Proforma prior to its deactivation can still be used.
- Account should be on ACTIVE status when using it upon creating or editing a transaction.
- This can be seen in Chart of Account Maintenance Module.
- Journal Voucher is autogenerated when creating a Sales Return.
- Journal Voucher is autogenerated when creating a Purchase Return.
- Only one user can use Add Voucher function at a time.
Editing Journal Voucher
- Go to Financials then click Journal Voucher
- Select the Journal Voucher that needs an edit, click the drop-down arrow then choose Edit.
- Update the necessary the fields. Then click Save.
Field | Description | Expected Values |
---|---|---|
1.Voucher No. | •Voucher Number of the Transaction upon creation | •Alphanumeric(Auto-Generated) |
2.Reference No. | •Reference Number of the Transaction | •Alphanumeric |
3.Transaction Date | •Date when the Transaction was Created | •Date |
4.Proforma | •Financial statements is to facilitate comparisons of historic data and projections of future performance. | •Proforma list provided in the Proforma Maintenance Module |
5.Notes | •Other Remarks on the Transaction | •Alphanumeric |
6.Account | •Account to be charged for credit and debit amount on the transaction | •Account list in the Chart of Accounts Maintenance Module |
7.Description | •Any remarks or description on the Account | •Alphanumeric |
8.Debit | •Debit Amount for the Transaction | •Number |
9.Credit | •Credit Amount for the Transaction | •Number |
Notes:
- Proforma should be on ACTIVE status when using it upon creating or editing a transaction.
- This can be seen in Proforma Maintenance Module
- Past Transactions with INACTIVE Proforma prior to its deactivation can still be used.
- Account should be on ACTIVE status when using it upon creating or editing a transaction.
- This can be seen in Chart of Account Maintenance Module.
- When Sales Return record was updated, the Journal Voucher corresponds to it will also be updated.
- Journal Vouchers that are auto-generated from Payment Voucher cannot be edited.
- Only one user can use Edit Voucher function at a time.
Importing and Exporting Journal Voucher
1. Under Journal Voucher 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 such as Date Filter, Search Bar and Source filter for precise searching and exporting of records.
- When Importing the records, the user should follow the following steps provided in the Importing Journal Voucher 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
Field | Description of Data Output | Allowed Inputs | Input Restrictions | Required (Y/N) |
---|---|---|---|---|
1.Document Set | Manual Entry of Document Set of Journal Voucher | *Alphanumeric
*Underscore "_" |
*Other Special characters not mentioned | Y |
2.Transaction Date | Manual entry of Transaction Date of the Voucher | *Numeric
*Dash "-" *Backslash "\" |
*Other Special characters not mentioned | Y |
3.Reference No. | Manual Entry of Accounts Payable Reference No. | *Alphanumeric
*Underscore "_" *Dash "-" |
*Other Special characters not mentioned | N |
4.Notes | Manual Entry of Journal Voucher Reference No. | *Alphanumeric
*Underscore "_" *Dash "-" |
*Other Special characters not mentioned | N |
5.Account Name | Manual Entry of Account Name - must be based from Chart of Account Maintenance | *Numeric
*Account Name based from Chart of Account Maintenance Module |
*Any input not mentioned in the allowed inputs | Y |
6.Description | Manual Entry of Account Description | *Alphanumeric
*Special Characters |
*None | N |
7.Debit | Manual entry of Debit Amount | *Numeric | *Any input except numbers | Y |
8.Credit | Manual entry of Credit Amount | *Numeric | *Any input except numbers | Y |
Journal Voucher Record Options
Status | View | Edit | Post | Unpost | Cancel | |
---|---|---|---|---|---|---|
UNPOSTED | ☑ | ☑ | ☑ | ☑ | ☑ | |
POSTED | ☑ | ☑ | ☑ | |||
CANCELLED | ☑ | ☑ |
Notes:
- Only Manually created Journal Vouchers can be edited
- Manually created Journal Vouchers can be edited while viewing the record.
- Any auto-generated Journal Voucher will set its status into POSTED
Modules | |
---|---|
Financials | Financials | Journal Voucher |
Inventory | Purchase Return | Sales Return |
Maintenance | Proforma | Chart of Account |