Difference between revisions of "AR Detailed Report"

Line 1: Line 1:
 
<div style="text-align: center;">
 
<div style="text-align: center;">
 +
 +
 
[[Financial Statement]] | [[AR Detailed Report]] | [[AR Detailed Report Aids]]
 
[[Financial Statement]] | [[AR Detailed Report]] | [[AR Detailed Report Aids]]
 
</div><br />
 
</div><br />
Line 5: Line 7:
  
 
=====AR Detailed Report Menu=====
 
=====AR Detailed Report Menu=====
[[File:AR Detailed Report Menu.png|center|thumb|1057x1057px|AR Detailed Report Menu]]
+
[[File:AR Detailed Report Menu.png|center|thumb|1058x1058px|<span style="color: rgb(51, 51, 51)">AR Detailed Report Menu</span>]]
 
+
'''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>
 +
{| class="wikitable"
 +
|+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.
  
'''AR Detailed Report''' r<span style="color: rgb(51, 51, 51)">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
 +
|-
 +
|2. '''Export'''
 +
|Allows the user to Export the report into spreadsheet.
 +
|-
 +
|3. '''Customer Code'''
 +
|Reference Code for customer record.
  
AR Detailed Report Terms on Oojeema Prime System
+
*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.
  
#'''Record Filter'''(Date Range, Customer) - Provides a set of filter option for precise searching of records.
+
*Customer Name can be edited in [[Customer]] Maintenance Module.
#*Date Range is default set at the current date
+
|-
#*Customer is automatically set to Filter: All
+
|5. '''Voucher Number'''
#'''Customer Code''' - Reference Code for customer record.
+
|Reference Number of a specific [[Accounts Receivable]].
#*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.
+
|6. '''Transaction Date'''
#'''Customer Name''' - The Customer Name affiliated to the Customer Code.
+
|Date when the Voucher was created.
#*Customer Name can be edited in [[Customer]] Maintenance Module.
+
|-
#'''Voucher Number''' - Reference Number of a specific [[Accounts Receivable]].
+
|7. '''Invoice No'''
#'''Transaction Date''' - Date when the Voucher was created.
+
|Reference No. of the source transaction of the [[Accounts Receivable]]
#'''Invoice No'''. - Reference No. of the source transaction of the [[Accounts Receivable]]
+
*The Reference No can be a [[Sales Invoice]] or Billing Transaction
#*The Reference No can be a [[Sales Invoice]] or Billing Transaction
+
|-
#'''Remarks''' - Notes or descriptions attached on the Receivable.
+
|8. '''Remarks'''
#'''Amount''' - Total Amount of the Receivable
+
|Notes or descriptions attached on the Receivable.
#'''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.
+
|9. '''Amount'''
#*AR detailed report will clear the record of the Accounts receivable when the remaining balance reaches zero.
+
|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:
 
Notes:
  

Revision as of 11:57, 24 March 2021


AR Detailed Report

AR Detailed Report Menu
File:AR Detailed Report Menu.png
AR Detailed Report Menu

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

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
  • For detailed Instructions on how to view the Vouchers and Export the Customer AR Detailed Report, the user may view the AR Detailed Report Job Aids which can be found here.
Categories:
Modules
Sales Sales Invoice
Financials Accounts Receivable
Maintenance Maintenance | Customer
Job Aid Modules
Sales Aids Sales Invoice Aids
Financials Aids Accounts Receivable Aids
Maintenance Aids Customer Aids
Reports Module (Reports)
Reports Financial Statement
Financial Statements Balance Sheet | Income 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
Reports Aid
Financial Statements Balance Sheet Aids | Income Statement Aids | General Ledger Aids | General Journal Aids | Trial Balance Aids | Statement of Account Aids | Accounts Receivable Aging Aids | AR Detailed Report Aids | AR Transaction Report Aids | Accounts Payable Aging Aids | AP Detailed Report Aids | AP Transaction Report Aids | Cash Position Aids | Check List Aids | Deposit List Aids | Collection Register Aids