Discussion

Difference between revisions of "AP Detailed Report"

(Changed categories.)
 
(14 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
<div style="text-align: center;">
 
<div style="text-align: center;">
−
[[Financial Statement]] | [[AP Detailed Report]] | [[AP Detailed Report Aids]] | [[Accounts Payable]]
+
[[Financial Statement]] | [[AP Detailed Report]] | [[Accounts Payable]]
 
</div>
 
</div>
−
[[File:AP Detailed Report Menu.png|center|thumb|1055x1055px|AP Detailed Report Menu]]
+
 
 +
==AP Detailed Report==
 
'''AP Detailed Report''' <span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">refers to the list of detailed supplier</span> <span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">with unpaid invoices.</span>
 
'''AP Detailed Report''' <span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">refers to the list of detailed supplier</span> <span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">with unpaid invoices.</span>
 +
[[File:Financial Statements - AP Detailed Report - Record List.png|center|1500x1500px]]
 +
<br />
 +
 +
=====<span class="mw-headline" id="Requirements_before_using_AR_Detailed_Report" style="box-sizing: inherit;"><span class="mw-headline" id="Requirements_before_using_Accounts_Receivable_Aging" style="box-sizing: inherit;"><span class="mw-headline" id="Requirements_before_using_Sales_Quotation" style="box-sizing: inherit;">Requirements before using AP Detailed Report</span></span></span>=====
 +
 +
*The user should setup have the following records in order to proceed on using the <span style="box-sizing: inherit;">A</span><span>P</span> <span style="box-sizing: inherit;">Detailed Report</span>
 +
*#[[Supplier]]
 +
*#[[Accounts Payable]]
  
−
<span style="color: rgb(51, 51, 51)">AP Detailed Report Terms on Oojeema Prime System</span>
+
{| class="wikitable" style="margin: auto;"
 +
|+<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">AP Detailed Report Terms on Oojeema Prime System</span>
 +
!Field
 +
!Description
 +
|-
 +
|1. '''Record Filter'''(Date Range, Supplier)
 +
|Provides a set of filter option for precise searching of records.
  
−
# '''Record Filter'''(Date Range, Supplier) - Provides a set of filter option for precise searching of records.
+
*Date Range is set default at the current date
−
#* Date Range is set default at the current date
+
*Supplier is automatically set to Filter: All
−
#* Supplier is automatically set to Filter: All
+
|-
−
# '''Supplier Code''' - Reference Code for supplier record.
+
|2. '''Export'''
−
#* The set of Suppliers and Suppliers Code can be seen in <span>[[Supplier]]</span> Maintenance Module.
+
|Allows the user to Export the records into Spreadsheet.
−
#* Supplier Codes is a unique field on <span>[[Supplier]]</span> Maintenance Module, thus, it cannot be edited once created.
+
|-
−
# '''Supplier Name''' - The Supplier Name affiliated to the Supplier Code.
+
|3. '''Supplier Code'''
−
#* Customer Name can be edited in <span>[[Supplier]]</span> Maintenance Module.
+
|Reference Code for supplier record.
−
# '''Voucher Number''' - Reference Number of a specific <span>[[Accounts Payable]]</span>.
+
|-
−
# '''Transaction Date''' - Date when the Voucher was created.
+
|4. '''Supplier Name'''
−
# '''Invoice No'''. - Reference No. of the source transaction of the <span>[[Accounts Payable]]</span>
+
|The Supplier Name affiliated to the Supplier Code.
−
# '''Remarks''' - Notes or descriptions attached on the Payable.
 
−
# '''Amount''' - Total Amount of the Payable
 
−
# '''Amount Paid''' - The Total Amount paid for the Receivable (It can be partial or whole)
 
−
# '''Balance''' - The remaining Balance after computing the Total amount less the Amount Paid.
 
−
#* AP detailed report will clear the record of the Accounts Payable when the remaining balance reaches zero.
 
  
 +
*Supplier Name can be edited in <span class="ve-pasteProtect">[[Supplier]]</span> Maintenance Module.
 +
|-
 +
|5. '''Voucher Number'''
 +
|Reference Number of a specific <span class="ve-pasteProtect">[[Accounts Payable]]</span>.
 +
|-
 +
|6. '''Transaction Date'''
 +
|Date when the Voucher was created.
 +
|-
 +
|7. '''Remarks'''
 +
|Notes or descriptions attached on the Payable.
 +
|-
 +
|8. '''Amount'''
 +
|Total Amount of the Payable
 +
|-
 +
|9. '''Amount Paid'''
 +
|The Total Amount paid for the Receivable (It can be partial or whole)
 +
|-
 +
|10. '''Balance'''
 +
|The remaining Balance after computing the Total amount less the Amount Paid.
 +
 +
*AP detailed report will clear the record of the Accounts Payable when the remaining balance reaches zero.
 +
|}
 
Notes:
 
Notes:
  
−
* Supplier Status must be '''ACTIVE''' in order to check its status in the AP Detailed Report.
+
*Supplier Status must be '''ACTIVE''' in order to check its status in the AP Detailed Report.
−
** Customer Records can be seen in <span>[[Supplier]]</span> Maintenance Module
+
**Supplier Records can be seen in <span>[[Supplier]]</span> Maintenance Module
−
* For detailed Instructions on how to view the Vouchers and Export the Supplier AP Detailed Report, the user may view the AP Detailed Report Job Aids which can be found [[AP Detailed Report Aids|here]].
 
  
−
{| class="wikitable"
+
=====<span class="mw-headline" id="Exporting_AP_Detailed_Report" style="box-sizing: inherit;">Exporting AP Detailed Report</span>=====
 +
 
 +
#Click [[Reports]] under Main Menu
 +
#Under Reports Page, click AP Detailed Report under Financial Statements section
 +
#Under [[AP Detailed Report]], click the Export Button on the right side. Take note that you can filter the date and the supplier for precise exportation of records.
 +
 
 +
[[File:Financial Statements - AP Detailed Report - Export.png|border|center|3034x3034px]]
 +
<br />
 +
=====<span class="mw-headline" id="Viewing_Vouchers_on_AP_Detailed_Report" style="box-sizing: inherit;">Viewing Vouchers on AP Detailed Report</span>=====
 +
 
 +
#Click [[Reports]] under Main Menu
 +
#Under Reports page, click AP Detailed Report under Financial Statements section
 +
#Under AP Detailed Report, click the reference links under Voucher Number  column to check the records corresponding to the supplier’s transaction on a specific date.
 +
#*The user may print  the Issued Payment Information in the [[Payment Voucher]] details under view of [[Accounts Payable]]
 +
 
 +
[[File:Financial Statements - AP Detailed Report - View.png|border|center|3146x3146px]]
 +
 
 +
 
 +
{| class="wikitable" style="margin: auto;"
 
|+Categories:
 
|+Categories:
 
! colspan="2" |'''Modules'''
 
! colspan="2" |'''Modules'''
−
|-
 
−
|Sales
 
−
|[[Sales Invoice]]
 
 
|-
 
|-
 
|Financials
 
|Financials
−
|[[Accounts Receivable]]
+
|[[Accounts Payable]]
 
|- style="height:25px;"
 
|- style="height:25px;"
 
|Maintenance
 
|Maintenance
−
|[[Maintenance]]<nowiki> | </nowiki>[[Customer]]
+
|[[Maintenance]]<nowiki> | </nowiki>[[Supplier]]
 
|-
 
|-
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Module ([[Reports]])'''
 
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Module ([[Reports]])'''
Line 49: Line 95:
 
|-
 
|-
 
|Financial Statements
 
|Financial Statements
−
|[[Balance Sheet]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Income Statement]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[General Ledger]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[General Journal]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Trial Balance]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Statement of Account]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Accounts Receivable Aging]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AR Detailed Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AR Transaction Report]] [[Accounts Payable Aging]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AP Detailed Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AP Transaction Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Cash Position]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Check List]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Deposit List]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Collection Register]]
+
|[[Balance Sheet]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Income Statement]] <span style="color: rgb(34, 34, 34)"><nowiki>| </nowiki>[[Profit and Loss Statement]]<nowiki> |</nowiki></span> [[General Ledger]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[General Journal]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Trial Balance]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Statement of Account]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Accounts Receivable Aging]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AR Detailed Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AR Transaction Report]]<nowiki> | </nowiki>[[Accounts Payable Aging]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AP Detailed Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AP Transaction Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Cash Position]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Check List]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Deposit List]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Collection Register]]
−
|-
 
−
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
−
|-
 
−
|Sales Aids
 
−
|[[Sales Invoice Aids]]
 
−
|-
 
−
|Financials Aids
 
−
|[[Accounts Receivable Aids]]
 
−
|-
 
−
|Maintenance Aids
 
−
|[[Customer Aids]]
 
−
|-
 
−
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Aid'''
 
−
|-
 
−
|Financial Statements
 
−
|[[Balance Sheet Aids]]<nowiki> | </nowiki>[[Income Statement Aids]]<nowiki> | </nowiki>[[General Ledger Aids]]<nowiki> | </nowiki>[[General Journal Aids]]<nowiki> | </nowiki>[[Trial Balance Aids]]<nowiki> | </nowiki>[[Statement of Account Aids]]<nowiki> | </nowiki>[[Accounts Receivable Aging Aids]]<nowiki> | </nowiki>[[AR Detailed Report Aids]]<nowiki> | </nowiki>[[AR Transaction Report Aids]]<nowiki> | </nowiki>[[Accounts Payable Aging Aids]]<nowiki> | </nowiki>[[AP Detailed Report Aids]]<nowiki> | </nowiki>[[AP Transaction Report Aids]]<nowiki> | </nowiki>[[Cash Position Aids]]<nowiki> | </nowiki>[[Check List Aids]]<nowiki> | </nowiki>[[Deposit List Aids]]<nowiki> | </nowiki>[[Collection Register Aids]]
 
 
|}
 
|}
 +
[[Category:Purchase]]
 +
[[Category:Financials]]
 +
[[Category:Financial Statements]]

Latest revision as of 12:18, 8 April 2022

AP Detailed Report

AP Detailed Report refers to the list of detailed supplier with unpaid invoices.

Financial Statements - AP Detailed Report - Record List.png


Requirements before using AP Detailed Report
  • The user should setup have the following records in order to proceed on using the AP Detailed Report
    1. Supplier
    2. Accounts Payable
AP Detailed Report Terms on Oojeema Prime System
Field Description
1. Record Filter(Date Range, Supplier) Provides a set of filter option for precise searching of records.
  • Date Range is set default at the current date
  • Supplier is automatically set to Filter: All
2. Export Allows the user to Export the records into Spreadsheet.
3. Supplier Code Reference Code for supplier record.
4. Supplier Name The Supplier Name affiliated to the Supplier Code.
  • Supplier Name can be edited in Supplier Maintenance Module.
5. Voucher Number Reference Number of a specific Accounts Payable.
6. Transaction Date Date when the Voucher was created.
7. Remarks Notes or descriptions attached on the Payable.
8. Amount Total Amount of the Payable
9. Amount Paid The Total Amount paid for the Receivable (It can be partial or whole)
10. Balance The remaining Balance after computing the Total amount less the Amount Paid.
  • AP detailed report will clear the record of the Accounts Payable when the remaining balance reaches zero.

Notes:

  • Supplier Status must be ACTIVE in order to check its status in the AP Detailed Report.
    • Supplier Records can be seen in Supplier Maintenance Module
Exporting AP Detailed Report
  1. Click Reports under Main Menu
  2. Under Reports Page, click AP Detailed Report under Financial Statements section
  3. Under AP Detailed Report, click the Export Button on the right side. Take note that you can filter the date and the supplier for precise exportation of records.
Financial Statements - AP Detailed Report - Export.png


Viewing Vouchers on AP Detailed Report
  1. Click Reports under Main Menu
  2. Under Reports page, click AP Detailed Report under Financial Statements section
  3. Under AP Detailed Report, click the reference links under Voucher Number column to check the records corresponding to the supplier’s transaction on a specific date.
Financial Statements - AP Detailed Report - View.png


Categories:
Modules
Financials Accounts Payable
Maintenance Maintenance | Supplier
Reports Module (Reports)
Reports Financial Statement
Financial Statements Balance Sheet | Income Statement | Profit and Loss Statement | General Ledger | General Journal | Trial Balance | Statement of Account | Accounts Receivable Aging | AR Detailed Report | AR Transaction Report | Accounts Payable Aging | AP Detailed Report | AP Transaction Report | Cash Position | Check List | Deposit List | Collection Register
Retrieved from "https://docs.oojeema.com/index.php?title=AP_Detailed_Report&oldid=6663"