You are viewing an old version of this page. Return to the latest version.
Difference between revisions of "AR Transaction Report"
(Tag: Visual edit) |
(Tag: Visual edit) |
||
Line 6: | Line 6: | ||
====AR Transaction Report Menu==== | ====AR Transaction Report Menu==== | ||
− | |||
'''AR Transaction Report''' <span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{"style":"color: rgb(51, 51, 51)"}">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="{"style":"color: rgb(51, 51, 51)"}">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 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;">AR Detailed Report</span> | ||
+ | *# [[Customer]] | ||
+ | *# [[Sales Invoice]] | ||
+ | *# [[Accounts Receivable]] | ||
+ | |||
{| class="wikitable" | {| class="wikitable" | ||
|+AR Transaction Report Terms on Oojeema Prime System | |+AR Transaction Report Terms on Oojeema Prime System | ||
Line 14: | Line 21: | ||
|- | |- | ||
|1. '''Record Filter'''(Date Range, Customer) | |1. '''Record Filter'''(Date Range, Customer) | ||
− | |Provides a set of filter | + | |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 70: | ||
|<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{"style":"color: rgb(51, 51, 51)"}">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="{"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 | + | *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 77: | ||
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 | ||
− | + | ||
+ | ===== <span class="mw-headline" id="Exporting_AR_Transaction_Report" style="box-sizing: inherit;">Filtering and Exporting AR Transaction Report</span> ===== | ||
+ | |||
+ | # Under the Main Menu, Click '''Reports''' | ||
+ | # Under Reports Menu, Click '''[[AR Transaction Report]]''' under Financial Statement Reports. | ||
+ | # Under [[AR Transaction Report]], click the Export Button on the right side. Take note that you can filter the date range and the customer for precise exportation of records. | ||
+ | |||
+ | ===== <span class="mw-headline" id="Viewing_Vouchers_on_AR_Transaction_Report" style="box-sizing: inherit;">Viewing Vouchers on AR Transaction Report</span> ===== | ||
+ | |||
+ | # Under the Main Menu, Click '''Reports''' | ||
+ | # Under Reports Menu, 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 a [[Accounts Receivable]] record. | ||
{| class="wikitable" | {| class="wikitable" | ||
Line 96: | Line 115: | ||
|- | |- | ||
| colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules''' | | colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules''' | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
|Maintenance Aids | |Maintenance Aids | ||
|[[Customer Aids]] | |[[Customer Aids]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
|} | |} |
Revision as of 13:48, 2 December 2021
Contents
AR Transaction Report
AR Transaction Report Menu
AR Transaction Report refers to the list of detailed customer's invoice
Requirements before using AR Detailed Report
- The user should setup have the following records in order to proceed on using the AR Detailed Report
Field | Description |
---|---|
1. Record Filter(Date Range, Customer) | Provides a set of filter options for precise searching of records.
|
2. Export | Allows the user to Export the Records into Spreadsheet |
3. Customer Code | Reference Code for customer record. |
4. Customer Name | The Customer Name affiliated to the Customer Code.
|
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
|
14. 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
Filtering and Exporting AR Transaction Report
- Under the Main Menu, Click Reports
- Under Reports Menu, Click AR Transaction Report under Financial Statement Reports.
- Under AR Transaction Report, click the Export Button on the right side. Take note that you can filter the date range and the customer for precise exportation of records.
Viewing Vouchers on AR Transaction Report
- Under the Main Menu, Click Reports
- Under Reports Menu, 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 a Accounts Receivable record.
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 Payable Aging | AP Detailed Report | AP Transaction Report | Cash Position | Check List | Deposit List | Collection Register |
Job Aid Modules | |
Maintenance Aids | Customer Aids |