Difference between revisions of "AR Detailed Report"

(Changed categories.)
 
(18 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
<div style="text-align: center;">
 
<div style="text-align: center;">
[[Financial Statement]] | [[AR Detailed Report]] | [[AR Detailed Report Aids]] | [[Accounts Receivable]]
+
 
</div><br />
+
[[Financial Statement]] | [[Accounts Receivable]] | [[AR Detailed Report]] | [[Accounts Receivable Aging]] | [[AR Transaction Report]]
 +
</div>
 
==AR Detailed Report==
 
==AR Detailed Report==
  
 
=====AR Detailed Report Menu=====
 
=====AR Detailed Report Menu=====
[[File:AR Detailed Report Menu.png|center|thumb|1000x1000px|AR Detailed Report Menu]]
+
[[File:Financial Statements - AR Detailed Report - Record List.png|border|center|1500x1500px]]
'''AR Detailed Report''' r<span style="color: rgb(51, 51, 51)">efers to the list of detailed customers with unpaid invoices.</span>
 
  
AR Detailed Report Terms on Oojeema Prime System
 
  
#'''Record Filter'''(Date Range, Customer) - Provides a set of filter option for precise searching of records.
+
'''AR Detailed Report''' r<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">efers to the list of detailed customers with unpaid invoices.</span>
#*Date Range is default set at the current date
+
 
#*Customer is automatically set to Filter: All
+
=====<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 AR Detailed Report</span></span>=====
#'''Customer Code''' - Reference Code for customer record.
+
 
#*The set of Customers and Customer Code can be seen in [[Customer]] Maintenance Module.
+
*The user should setup have the following records in order to proceed on using the <span>AR Detailed Report</span>
#*Customer Codes is a unique field on [[Customer]] Maintenance Module, thus, it cannot be edited once created.
+
*#[[Customer]]
#'''Customer Name''' - The Customer Name affiliated to the Customer Code.
+
*#[[Sales Invoice]]
#*Customer Name can be edited in [[Customer]] Maintenance Module.
+
*#[[Accounts Receivable]]
#'''Voucher Number''' - Reference Number of a specific [[Accounts Receivable]].
+
 
#'''Transaction Date''' - Date when the Voucher was created.
+
{| class="wikitable"
#'''Invoice No'''. - Reference No. of the source transaction of the [[Accounts Receivable]]
+
|+AR Detailed Report Terms on Oojeema Prime System
#*The Reference No can be a [[Sales Invoice]] or Billing Transaction
+
!Field
#'''Amount''' - Total Amount of the Receivable
+
!Description
#'''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.
+
|1. '''Record Filter'''(Date Range, Customer)
#*AR detailed report will clear the record of the Accounts receivable when the remaining balance reaches zero.
+
|Provides a set of filter option for precise searching of records.
 +
 
 +
*Date Range is default set at the current date
 +
*Customer is automatically set to Filter: All
 +
|-
 +
|2. '''Export'''
 +
|Allows the user to Export the report into spreadsheet.
 +
|-
 +
|3. '''Customer Code'''
 +
|Reference Code for customer record.
 +
 
 +
*The set of Customers and Customer Code can be seen in [[Customer]] Maintenance Module.
 +
*Customer Codes is a unique field on [[Customer]] Maintenance Module, thus, it cannot be edited once created.
 +
|-
 +
|4. '''Customer Name'''
 +
|The Customer Name affiliated to the Customer Code.
  
 +
*Customer Name can be edited in [[Customer]] Maintenance Module.
 +
|-
 +
|5. '''Voucher Number'''
 +
|Reference Number of a specific [[Accounts Receivable]].
 +
|-
 +
|6. '''Transaction Date'''
 +
|Date when the Voucher was created.
 +
|-
 +
|7. '''Invoice No'''
 +
|Reference No. of the source transaction of the [[Accounts Receivable]]
 +
*The Reference No can be a [[Sales Invoice]]
 +
|-
 +
|8. '''Remarks'''
 +
|Notes or descriptions attached on the Receivable.
 +
|-
 +
|9. '''Amount'''
 +
|Total Amount of the Receivable
 +
|-
 +
|10. '''Amount Paid'''
 +
|The Total Amount paid for the Receivable (It can be partial or whole)
 +
|-
 +
|11. '''Balance'''
 +
|The remaining Balance after computing the Total amount less the Amount Paid.
 +
 +
*AR detailed report will clear the record of the Accounts receivable when the remaining balance reaches zero.
 +
|}
 +
Notes:
 +
 +
*Customer Status must be '''ACTIVE''' in order to check its status in the AR Detailed Report.
 +
**Customer Records can be seen in [[Customer]] Maintenance Module
 +
 +
=====<span class="mw-headline" id="Exporting_AR_Detailed_Report" style="box-sizing: inherit;">Exporting AR Detailed Report</span>=====
 +
 +
#Click [[Reports]] under Main Menu
 +
#Under Reports page, click AR Detailed Report under Financial Statements section
 +
#Under AR Detailed Report, click the Export Button on the right side. Take note that the user can filter the date and the customer for precise exportation of records.
 +
 +
[[File:Financial Statements - AR Detailed Report - Export.png|border|center|2274x2274px]]
 +
<br />
 +
=====<span class="mw-headline" id="Viewing_Vouchers_on_AR_Detailed_Report" style="box-sizing: inherit;">Viewing Vouchers on AR Detailed Report</span>=====
 +
 +
#Click [[Reports]] under Main Menu
 +
#Under Reports page, click AR Detailed Report under Financial Statements section
 +
#Under AR Detailed Report, click the reference links under voucher number column to check the records corresponding to the customer’s transaction on a specific date.
 +
#*The user may Receive Payment of the receivable while viewing the record
 +
#*The user may tag a [[Profit Center]] when viewing a specific Accounts Receivable record
 +
#**The user may only tag a [[Profit Center]] if the status is not yet Posted
 +
 +
 +
[[File:Financial Statements - AR Detailed Report - View.png|border|center|1976x1976px]]
 
<br />
 
<br />
 
{| class="wikitable"
 
{| class="wikitable"
Line 36: Line 100:
 
|-
 
|-
 
|Financials
 
|Financials
|[[Accounts Receivable]]
+
|[[Accounts Receivable]]<nowiki> | </nowiki>[[Receipt Voucher]]
 
|- style="height:25px;"
 
|- style="height:25px;"
 
|Maintenance
 
|Maintenance
|[[Maintenance]]<nowiki> | </nowiki>[[Customer]]
+
|[[Maintenance]]<nowiki> | </nowiki>[[Customer]]<nowiki> | </nowiki>[[Profit Center]]
 
|-
 
|-
 
| 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 47: Line 111:
 
|-
 
|-
 
|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]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Accounts Receivable Aging]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AP Detailed Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AR Transaction Report]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[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]]<nowiki> | </nowiki>[[Profit and Loss 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]]<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 Receivable Aging Aids]]<nowiki> | </nowiki>[[AP 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:Financials]]
 +
[[Category:Financial Statements]]
 +
[[Category:Sales]]
 +
[[Category:Billing]]

Latest revision as of 14:20, 7 April 2022

AR Detailed Report

AR Detailed Report Menu
Financial Statements - AR Detailed Report - Record List.png


AR Detailed Report refers to the list of detailed customers with unpaid invoices.

Requirements before using AR Detailed Report
AR Detailed Report Terms on Oojeema Prime System
Field Description
1. Record Filter(Date Range, Customer) Provides a set of filter option for precise searching of records.
  • Date Range is default set at the current date
  • Customer is automatically set to Filter: All
2. Export Allows the user to Export the report into spreadsheet.
3. Customer Code Reference Code for customer record.
  • The set of Customers and Customer Code can be seen in Customer Maintenance Module.
  • Customer Codes is a unique field on Customer Maintenance Module, thus, it cannot be edited once created.
4. Customer Name The Customer Name affiliated to the Customer Code.
  • Customer Name can be edited in Customer Maintenance Module.
5. Voucher Number Reference Number of a specific Accounts Receivable.
6. Transaction Date Date when the Voucher was created.
7. Invoice No Reference No. of the source transaction of the Accounts Receivable
8. Remarks Notes or descriptions attached on the Receivable.
9. Amount Total Amount of the Receivable
10. Amount Paid The Total Amount paid for the Receivable (It can be partial or whole)
11. Balance The remaining Balance after computing the Total amount less the Amount Paid.
  • AR detailed report will clear the record of the Accounts receivable when the remaining balance reaches zero.

Notes:

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


Viewing Vouchers on AR Detailed Report
  1. Click Reports under Main Menu
  2. Under Reports page, click AR Detailed Report under Financial Statements section
  3. Under AR Detailed Report, click the reference links under voucher number column to check the records corresponding to the customer’s transaction on a specific date.
    • The user may Receive Payment of the receivable while viewing the record
    • The user may tag a Profit Center when viewing a specific Accounts Receivable record
      • The user may only tag a Profit Center if the status is not yet Posted


Financial Statements - AR Detailed Report - View.png


Categories:
Modules
Sales Sales Invoice
Financials Accounts Receivable | Receipt Voucher
Maintenance Maintenance | Customer | Profit Center
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