Difference between revisions of "AR Transaction Report"

Line 1: Line 1:
 
<div style="text-align: center;">
 
<div style="text-align: center;">
 
[[Financial Statement]] | [[AR Transaction Report]] | [[AR Transaction Report Aids]] | [[Accounts Receivable]]
 
[[Financial Statement]] | [[AR Transaction Report]] | [[AR Transaction Report Aids]] | [[Accounts Receivable]]
</div><br />
+
</div>
 +
 
 +
== AR Transaction Report ==
 +
 
 +
==== AR Transaction Report Menu ====
 +
[[File:AR Transaction Report Menu.png|center|thumb|1000x1000px|AR Transaction Report Menu]]
 +
'''AR Transaction Report''' <span style="color: rgb(51, 51, 51)">refers to the list of detailed customer's invoice</span>
 +
 
 +
AR Transaction Report Terms on Oojeema Prime System
 +
 
 +
# '''Record Filter'''(Date Range, Customer) - Provides a set of filter option for precise searching of records.
 +
#* Date Range is automatically set for the current month
 +
#* Customer is automatically set to filter all
 +
# '''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.
 +
# '''Customer Name''' - The Customer Name affiliated to the Customer Code.
 +
#* Customer Name can be edited in [[Customer]] Maintenance Module.
 +
# '''Voucher Number''' - Reference Number of a specific [[Accounts Receivable]].
 +
# '''Payment Voucher''' - Reference Voucher used to pay the [[Accounts Receivable]].
 +
#* In most cases, [[Receipt Voucher]] is used
 +
# '''Transaction Date''' - Date when the Voucher was created.
 +
# '''Invoice No'''. - Reference No. of the source transaction of the [[Accounts Receivable]]
 +
#* The Reference No can be a [[Sales Invoice]] or Billing Transaction
 +
# '''Amount''' - Total Amount of the Receivable
 +
# '''Amount Applied''' - 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 Applied.
 +
# '''Remarks''' - Any information or notes applied in the specific Receivable,
 +
# '''Terms''' -  <span style="color: rgb(51, 51, 51)">the set default days on the customer for them to pay their outstanding balance on their receivables</span>
 +
#* If terms are not set in [[Customer]] Maintenance Module, the due date will be automatically set 7 days after the transaction Date
 +
# '''Status''' - The current status of the Voucher used in the Receivable (It can be Posted/Open/Cancelled)
 +
 
 +
Notes:
 +
 
 +
* Customer Status must be '''ACTIVE''' in order to check its status in the AR Transaction 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 [[AR Transaction Report Aids|here]].
 +
 
 
{| class="wikitable"
 
{| class="wikitable"
 +
|+Categories:
 
! colspan="2" |'''Modules'''
 
! colspan="2" |'''Modules'''
 
|-
 
|-
 
|Sales
 
|Sales
|[https://docs.oojeema.com/Sales_Invoice Sales Invoice]
+
|[[Sales Invoice]]
 
|-
 
|-
 
|Financials
 
|Financials
|[https://docs.oojeema.com/Accounts_Receivable Accounts Receivable]
+
|[[Accounts Receivable]]<nowiki> | </nowiki>[[Receipt Voucher]]
|- style="height:25px;" data-ve-attributes="{&quot;style&quot;:&quot;height:25px;&quot;}"
+
|- style="height:25px;"
 
|Maintenance
 
|Maintenance
|[https://docs.oojeema.com/Maintenance Maintenance]<nowiki> | </nowiki>[https://docs.oojeema.com/Customer Customer]
+
|[[Maintenance]]<nowiki> | </nowiki>[[Customer]]
 
|-
 
|-
| colspan="2" style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |'''Reports Module ([https://docs.oojeema.com/Reports Reports])'''
+
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Module ([[Reports]])'''
 
|-
 
|-
 
|Reports
 
|Reports
|[https://docs.oojeema.com/Financial_Statement Financial Statement]
+
|[[Financial Statement]]
 
|-
 
|-
 
|Financial Statements
 
|Financial Statements
|[https://docs.oojeema.com/Balance_Sheet Balance Sheet] <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}"><nowiki>|</nowiki></span> [https://docs.oojeema.com/Income_Statement Income Statement] <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}"><nowiki>|</nowiki></span> [https://docs.oojeema.com/General_Ledger General Ledger] <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}"><nowiki>|</nowiki></span> [https://docs.oojeema.com/General_Journal General Journal] <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}"><nowiki>|</nowiki></span> [https://docs.oojeema.com/Trial_Balance Trial Balance] <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}"><nowiki>|</nowiki></span> [https://docs.oojeema.com/Statement_of_Account Statement of Account] <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}"><nowiki>|</nowiki></span> [https://docs.oojeema.com/Accounts_Receivable_Aging Accounts Receivable Aging] <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}"><nowiki>|</nowiki></span> [https://docs.oojeema.com/AR_Detailed_Report AR Detailed Report] <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}"><nowiki>|</nowiki></span> [https://docs.oojeema.com/AR_Transaction_Report AR Transaction Report] <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}"><nowiki>|</nowiki></span> [https://docs.oojeema.com/Accounts_Receivable_Aging Accounts Receivable Aging] <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}"><nowiki>|</nowiki></span> [https://docs.oojeema.com/AP_Detailed_Report AP Detailed Report] <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}"><nowiki>|</nowiki></span> [https://docs.oojeema.com/AR_Transaction_Report AR Transaction Report] <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}"><nowiki>|</nowiki></span> [https://docs.oojeema.com/Accounts_Payable_Aging Accounts Payable Aging] <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}"><nowiki>|</nowiki></span> [https://docs.oojeema.com/AP_Detailed_Report AP Detailed Report] <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}"><nowiki>|</nowiki></span> [https://docs.oojeema.com/AP_Transaction_Report AP Transaction Report] <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}"><nowiki>|</nowiki></span> [https://docs.oojeema.com/Cash_Position Cash Position] <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}"><nowiki>|</nowiki></span> [https://docs.oojeema.com/Check_List Check List] <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}"><nowiki>|</nowiki></span> [https://docs.oojeema.com/Deposit_List Deposit List] <span class="ve-pasteProtect" style="color: rgb(34, 34, 34)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(34, 34, 34)&quot;}"><nowiki>|</nowiki></span> [https://docs.oojeema.com/Collection_Register 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></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]]
 
|-
 
|-
| colspan="2" style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |'''Job Aid Modules'''
+
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 
|-
 
|-
 
|Sales Aids
 
|Sales Aids
|[https://docs.oojeema.com/Sales_Invoice_Aids Sales Invoice Aids]
+
|[[Sales Invoice Aids]]<nowiki> | </nowiki>[[Receipt Voucher Aids]]
 
|-
 
|-
 
|Financials Aids
 
|Financials Aids
|[https://docs.oojeema.com/Accounts_Receivable_Aids Accounts Receivable Aids]
+
|[[Accounts Receivable Aids]]
 
|-
 
|-
 
|Maintenance Aids
 
|Maintenance Aids
|[https://docs.oojeema.com/Customer_Aids Customer Aids]
+
|[[Customer Aids]]
 
|-
 
|-
| colspan="2" style="vertical-align:middle;text-align:center;" data-ve-attributes="{&quot;style&quot;:&quot;vertical-align:middle;text-align:center;&quot;}" |'''Reports Aid'''
+
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Reports Aid'''
 
|-
 
|-
 
|Financial Statements
 
|Financial Statements
|[https://docs.oojeema.com/Balance_Sheet_Aids Balance Sheet Aids]<nowiki> | </nowiki>[https://docs.oojeema.com/Income_Statement_Aids Income Statement Aids]<nowiki> | </nowiki>[https://docs.oojeema.com/General_Ledger_Aids General Ledger Aids]<nowiki> | </nowiki>[https://docs.oojeema.com/General_Journal_Aids General Journal Aids]<nowiki> | </nowiki>[https://docs.oojeema.com/Trial_Balance_Aids Trial Balance Aids]<nowiki> | </nowiki>[https://docs.oojeema.com/Statement_of_Account_Aids Statement of Account Aids]<nowiki> | </nowiki>[https://docs.oojeema.com/Accounts_Receivable_Aging_Aids Accounts Receivable Aging Aids]<nowiki> | </nowiki>[https://docs.oojeema.com/AR_Detailed_Report_Aids AR Detailed Report Aids]<nowiki> | </nowiki>[https://docs.oojeema.com/AR_Transaction_Report_Aids AR Transaction Report Aids]<nowiki> | </nowiki>[https://docs.oojeema.com/Accounts_Receivable_Aging_Aids Accounts Receivable Aging Aids]<nowiki> | </nowiki>[https://docs.oojeema.com/AP_Detailed_Report_Aids AP Detailed Report Aids]<nowiki> | </nowiki>[https://docs.oojeema.com/AR_Transaction_Report_Aids AR Transaction Report Aids]<nowiki> | </nowiki>[https://docs.oojeema.com/Accounts_Payable_Aging_Aids Accounts Payable Aging Aids]<nowiki> | </nowiki>[https://docs.oojeema.com/AP_Detailed_Report_Aids AP Detailed Report Aids]<nowiki> | </nowiki>[https://docs.oojeema.com/AP_Transaction_Report_Aids AP Transaction Report Aids]<nowiki> | </nowiki>[https://docs.oojeema.com/Cash_Position_Aids Cash Position Aids]<nowiki> | </nowiki>[https://docs.oojeema.com/Check_List_Aids Check List Aids]<nowiki> | </nowiki>[https://docs.oojeema.com/Deposit_List_Aids Deposit List Aids]<nowiki> | </nowiki>[https://docs.oojeema.com/Collection_Register_Aids Collection Register Aids]
+
|[[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]]
 
|}
 
|}

Revision as of 12:22, 5 February 2021

AR Transaction Report

AR Transaction Report Menu

File:AR Transaction Report Menu.png
AR Transaction Report Menu

AR Transaction Report refers to the list of detailed customer's invoice

AR Transaction Report Terms on Oojeema Prime System

  1. Record Filter(Date Range, Customer) - Provides a set of filter option for precise searching of records.
    • Date Range is automatically set for the current month
    • Customer is automatically set to filter all
  2. 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.
  3. Customer Name - The Customer Name affiliated to the Customer Code.
    • Customer Name can be edited in Customer Maintenance Module.
  4. Voucher Number - Reference Number of a specific Accounts Receivable.
  5. Payment Voucher - Reference Voucher used to pay the 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. Amount - Total Amount of the Receivable
  9. Amount Applied - 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 Applied.
  11. Remarks - Any information or notes applied in the specific Receivable,
  12. Terms - the set default days on the customer for them to pay their outstanding balance on their receivables
    • If terms are not set in Customer Maintenance Module, the due date will be automatically set 7 days after the transaction Date
  13. Status - The current status of the Voucher used in the Receivable (It can be Posted/Open/Cancelled)

Notes:

  • Customer Status must be ACTIVE in order to check its status in the AR Transaction 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 | Receipt Voucher
Maintenance Maintenance | Customer
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 Receivable Aging | AP Detailed Report | AR Transaction Report | Accounts Payable Aging | AP Detailed Report | AP Transaction Report | Cash Position | Check List | Deposit List | Collection Register
Job Aid Modules
Sales Aids Sales Invoice Aids | Receipt Voucher Aids
Financials Aids Accounts Receivable Aids
Maintenance Aids Customer Aids
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 Receivable Aging Aids | AP 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