Difference between revisions of "AR Transaction Report"

(Changed categories.)
 
(8 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 Transaction Report]] | [[AR Transaction Report Aids]] | [[Accounts Receivable]]
+
[[Financial Statement]] | [[AR Transaction Report]] | [[Accounts Receivable]]
 
</div>
 
</div>
  
Line 6: Line 6:
  
 
====AR Transaction Report Menu====
 
====AR Transaction Report Menu====
[[File:AR Transaction Report Menu.png|center|thumb|1048x1048px|AR Transaction Report Menu]]
+
[[File:Financial Statements - AR Transaction Report - Record List.png|border|center|1500x1500px]]
 +
 
 +
 
 
'''AR Transaction 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 customer's invoice</span>
 
'''AR Transaction 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 customer's invoice</span>
 +
 +
=====<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 AR Transaction Report</span></span></span>=====
 +
 +
*The user should setup have the following records in order to proceed on using the <span style="box-sizing: inherit;">[[AR Transaction Report]]</span>
 +
*#[[Customer]]
 +
*#[[Accounts Receivable]]
 +
*#[[Receipt Voucher]]
 +
 
{| class="wikitable"
 
{| class="wikitable"
 
|+AR Transaction Report Terms on Oojeema Prime System
 
|+AR Transaction Report Terms on Oojeema Prime System
Line 14: Line 24:
 
|-
 
|-
 
|1. '''Record Filter'''(Date Range, Customer)
 
|1. '''Record Filter'''(Date Range, Customer)
|Provides a set of filter option for precise searching of records.
+
|Provides a set of filter options for precise searching of records.
  
*Date Range is automatically set for the current month
+
*The Date Range is automatically set for the current month
*Customer is automatically set to filter all
+
*The [[Customer]] is automatically set to filter all
 
|-
 
|-
 
|2. '''Export'''
 
|2. '''Export'''
Line 63: Line 73:
 
|<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">the set default days on the customer for them to pay their outstanding balance on their receivables</span>
 
|<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">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
+
*If terms are not set in [[Customer]] Maintenance Module, the due date will be automatically set 7 days after the transaction Date
 
|-
 
|-
 
|14. '''Status'''
 
|14. '''Status'''
Line 70: Line 80:
 
Notes:
 
Notes:
  
*Customer Status must be '''ACTIVE''' in order to check its status in the AR Transaction Report.  
+
*Customer Status must be '''ACTIVE''' in order to check its status in the [[AR Transaction Report|AR Transaction Report.]]
 
**Customer Records can be seen in [[Customer]] Maintenance Module
 
**Customer Records can be seen in [[Customer]] Maintenance Module
*For detailed Instructions on how to view the Vouchers and Export the Customer AR Transaction Report, the user may view the AR Transaction Report Job Aids which can be found [[AR Transaction Report Aids|here]].
 
  
 +
=====<span class="mw-headline" id="Exporting_AR_Transaction_Report" style="box-sizing: inherit;">Filtering and Exporting AR Transaction Report</span>=====
 +
 +
#Click [[Reports]] under Main Menu
 +
#Under Reports page, click AR Transaction Report under Financial Statements section
 +
#Under AR Transaction 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 Transaction Report - Export.png|border|center|1625x1625px]]
 +
<br />
 +
=====<span class="mw-headline" id="Viewing_Vouchers_on_AR_Transaction_Report" style="box-sizing: inherit;">Viewing Vouchers on AR Transaction Report</span>=====
 +
 +
#Click [[Reports]] under Main Menu
 +
#Under Reports Page, Click '''[[AR Transaction Report]]''' under Financial Statement Reports.
 +
#Under [[AR Transaction Report]], Check the Voucher Number Column, you will see the voucher list with links for a specific date. Click on the voucher number to redirect you to the View mode of the selected Voucher.
 +
#*The user may receive payment while viewing an [[Accounts Receivable]] record.
 +
#*The user may tag [[Profit Center]] while viewing an [[Accounts Receivable]] record.
 +
#**They may only tag a [[Profit Center]] if the [[Accounts Receivable]] is not yet Posted.
 +
 +
[[File:Financial Statements - AR Transaction Report - View.png|border|center|2019x2019px]]
 +
<br />
 
{| class="wikitable"
 
{| class="wikitable"
 
|+Categories:
 
|+Categories:
Line 85: Line 113:
 
|- 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 93: Line 121:
 
|-
 
|-
 
|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]]<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]]
+
|[[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]]<nowiki> | </nowiki>[[Receipt Voucher 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]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Income Statement Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[General Ledger Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[General Journal Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Trial Balance Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Statement of Account Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Accounts Receivable Aging Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AR Detailed Report Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AR Transaction Report Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Accounts Payable Aging Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AP Detailed Report Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[AP Transaction Report Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Cash Position Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Check List Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Deposit List Aids]] <span style="color: rgb(34, 34, 34)"><nowiki>|</nowiki></span> [[Collection Register Aids]]
 
 
|}
 
|}
 +
[[Category:Financial Statements]]
 +
[[Category:Financials]]
 +
[[Category:Sales]]
 +
[[Category:Sales Reports]]

Latest revision as of 14:22, 7 April 2022

AR Transaction Report

AR Transaction Report Menu

Financial Statements - AR Transaction Report - Record List.png


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

Requirements before using AR Transaction Report
AR Transaction Report Terms on Oojeema Prime System
Field Description
1. Record Filter(Date Range, Customer) Provides a set of filter options for precise searching of records.
  • The Date Range is automatically set for the current month
  • The Customer is automatically set to filter all
2. Export Allows the user to Export the Records 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. Payment Voucher Reference Voucher used to pay the Accounts Receivable.
7. Transaction Date Date when the Voucher was created.
8. Invoice No Reference No. of the source transaction of the Accounts Receivable
9. Amount Total Amount of the Receivable
10. Amount Applied 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 Applied.
12. Remarks Any information or notes applied in the specific Receivable,
13. 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
14. Status The current status of the Voucher used in the Receivable (It can be Posted/Open/Cancelled)

Notes:

Filtering and Exporting AR Transaction Report
  1. Click Reports under Main Menu
  2. Under Reports page, click AR Transaction Report under Financial Statements section
  3. Under AR Transaction 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 Transaction Report - Export.png


Viewing Vouchers on AR Transaction Report
  1. Click Reports under Main Menu
  2. Under Reports Page, Click AR Transaction Report under Financial Statement Reports.
  3. Under AR Transaction Report, Check the Voucher Number Column, you will see the voucher list with links for a specific date. Click on the voucher number to redirect you to the View mode of the selected Voucher.
Financial Statements - AR Transaction 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