You are viewing an old version of this page. Return to the latest version.
Difference between revisions of "AP Transaction Report"
(Tag: Visual edit) |
(Tag: 2017 source edit) |
||
Line 4: | Line 4: | ||
==AP Transactions Report== | ==AP Transactions Report== | ||
<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{"style":"color: rgb(51, 51, 51)"}">'''AP Transaction Report''' - refers to the list of detailed supplier's invoices</span> | <span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{"style":"color: rgb(51, 51, 51)"}">'''AP Transaction Report''' - refers to the list of detailed supplier's invoices</span> | ||
− | + | ||
− | + | ===== <span class="mw-headline" id="Requirements_before_using_AR_Transaction_Report" style="box-sizing: inherit;"><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 AP Transaction Report</span></span></span></span> ===== | |
− | {| class="wikitable" | + | |
+ | * The user should setup have the following records in order to proceed on using the <span style="box-sizing: inherit;">A</span><span>P</span> <span style="box-sizing: inherit;">Transaction Report</span> | ||
+ | *# [[Supplier]] | ||
+ | *# [[Accounts Payable]] | ||
+ | *# [[Payment Voucher]] | ||
+ | |||
+ | {| class="wikitable" style="margin: auto;" | ||
|+AP Transaction Report Terms on Oojeema Prime System. | |+AP Transaction Report Terms on Oojeema Prime System. | ||
!Field | !Field | ||
!Description | !Description | ||
|- | |- | ||
− | |1. '''Record Filter'''<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{"style":"color: rgb(51, 51, 51)"}">(Date Range, | + | |1. '''Record Filter'''<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{"style":"color: rgb(51, 51, 51)"}">(Date Range, Supplier)</span> |
|<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{"style":"color: rgb(51, 51, 51)"}">Provides a set of filter option for precise searching of records.</span> | |<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{"style":"color: rgb(51, 51, 51)"}">Provides a set of filter option for precise searching of records.</span> | ||
*Date Range is automatically set for the current month | *Date Range is automatically set for the current month | ||
− | * | + | *Supplier is automatically set to filter all |
|- | |- | ||
|2. '''Export''' | |2. '''Export''' | ||
Line 48: | Line 54: | ||
|- | |- | ||
|10. '''Amount Applied''' | |10. '''Amount Applied''' | ||
− | |The Total Amount paid for the | + | |The Total Amount paid for the Payable (It can be partial or whole) |
|- | |- | ||
|11. '''Balance''' | |11. '''Balance''' | ||
Line 60: | Line 66: | ||
|- | |- | ||
|14. '''Status''' | |14. '''Status''' | ||
− | |The current status of the Voucher used in the | + | |The current status of the Voucher used in the Payable (It can be Posted/Open/Cancelled) |
|} | |} | ||
Notes: | Notes: | ||
Line 66: | Line 72: | ||
*Supplier Status must be '''ACTIVE''' in order to check its status in the AP Transaction Report. | *Supplier Status must be '''ACTIVE''' in order to check its status in the AP Transaction Report. | ||
**Supplier Records can be seen in <span>[[Supplier]]</span> Maintenance Module | **Supplier Records can be seen in <span>[[Supplier]]</span> Maintenance Module | ||
− | |||
− | {| class="wikitable" | + | ===== <span class="mw-headline" id="Exporting_AP_Transaction_Report" style="box-sizing: inherit;">Exporting AP Transaction Report</span> ===== |
+ | |||
+ | # Under the Main Menu, Click '''[[Reports]]''' | ||
+ | # Under Reports Menu, Click '''[[AP Transaction Report]]''' under [[Financial Statement]] Reports. | ||
+ | # Under [[AP Transaction Report]], click the Export Button on the right side. Take note that you can filter the date range and the supplier for precise exportation of records. | ||
+ | |||
+ | ===== <span class="mw-headline" id="Viewing_Vouchers_on_AP_Transaction_Report" style="box-sizing: inherit;">Viewing Vouchers on AP Transaction Report</span> ===== | ||
+ | |||
+ | # Under the Main Menu, Click '''[[Reports]]''' | ||
+ | # Under Reports Menu, Click '''[[AP Transaction Report]]''' under [[Financial Statement]] Reports. | ||
+ | # Under [[AP 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. | ||
+ | |||
+ | <br /> | ||
+ | {| class="wikitable" style="margin: auto;" | ||
|+Categories: | |+Categories: | ||
! colspan="2" |'''Modules''' | ! colspan="2" |'''Modules''' | ||
Line 87: | Line 105: | ||
|- | |- | ||
| 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 | ||
|[[Supplier Aids]] | |[[Supplier Aids]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
|} | |} |
Revision as of 11:24, 14 December 2021
Contents
AP Transactions Report
AP Transaction Report - refers to the list of detailed supplier's invoices
Requirements before using AP Transaction Report
- The user should setup have the following records in order to proceed on using the AP Transaction Report
Field | Description |
---|---|
1. Record Filter(Date Range, Supplier) | Provides a set of filter option for precise searching of records.
|
2. Export | Allows the user to Export the record into Spreadsheet |
3. Supplier Code | Reference Code for customer record. |
4. Supplier Name | The Supplier Name affiliated to the Supplier Code.
|
5. Voucher Name | Reference Number of a specific Accounts Payable. |
6. Payment Voucher | Reference Voucher used to pay the Accounts Payable
|
7. Transaction Date | Date when the Voucher was created. |
8. Invoice No. | Reference No. of the source transaction of the Accounts Payable |
9. Amount | Total Amount of the Payable |
10. Amount Applied | The Total Amount paid for the Payable (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 Payable |
13.Terms | The set default days on the supplier for them to pay their outstanding balance on their payable. |
14. Status | The current status of the Voucher used in the Payable (It can be Posted/Open/Cancelled) |
Notes:
- Supplier Status must be ACTIVE in order to check its status in the AP Transaction Report.
- Supplier Records can be seen in Supplier Maintenance Module
Exporting AP Transaction Report
- Under the Main Menu, Click Reports
- Under Reports Menu, Click AP Transaction Report under Financial Statement Reports.
- Under AP Transaction Report, click the Export Button on the right side. Take note that you can filter the date range and the supplier for precise exportation of records.
Viewing Vouchers on AP Transaction Report
- Under the Main Menu, Click Reports
- Under Reports Menu, Click AP Transaction Report under Financial Statement Reports.
- Under AP 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.
Modules | |
---|---|
Financials | Accounts Payable | Payment Voucher |
Maintenance | Maintenance | Supplier |
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 | Supplier Aids |