Difference between revisions of "AP Transaction Report"

Line 1: Line 1:
 
<div style="text-align: center;">
 
<div style="text-align: center;">
 
[[Financial Statement]] | [[AP Transaction Report]] | [[AP Transaction Report Aids]] | [[Accounts Payable]] </div>
 
[[Financial Statement]] | [[AP Transaction Report]] | [[AP Transaction Report Aids]] | [[Accounts Payable]] </div>
[[File:AP Transaction Report Menu.png|center|thumb|1055x1055px|AP transaction Report Menu]]
 
<br><span style="color: rgb(51, 51, 51)">'''AP Transaction Report''' - refers to the list of detailed supplier's invoices</span> AP Transaction Report Terms on Oojeema Prime System.
 
  
#'''Record Filter'''<span style="color: rgb(51, 51, 51)">(Date Range, Customer) - Provides a set of filter option for precise searching of records.</span>
+
== AP Transactions Report ==
#*Date Range is automatically set for the current month
+
[[File:AP Transaction Report Menu.png|center|thumb|1055x1055px|AP Transaction Report Menu]]
#*Customer is automatically set to filter all
+
<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">'''AP Transaction Report''' - refers to the list of detailed supplier's invoices</span>  
#'''Supplier Code''' - <span style="color: rgb(51, 51, 51)">Reference Code for customer record.</span>
+
{| class="wikitable"
#*The set of Suppliers and Supplier Code can be seen in <span>[[Supplier]]</span> Maintenance Module.
+
|+AP Transaction Report Terms on Oojeema Prime System.
#*Supplier Codes is a unique field on <span>[[Supplier]]</span> Maintenance Module, thus, it cannot be edited once created.
+
!Field
#'''Supplier Name''' - <span style="color: rgb(51, 51, 51)">The Supplier Name affiliated to the Supplier Code.</span>
+
!Description
#*Supplier Name can be edited in [[Supplier]] Maintenance Module.
+
|-
#'''Voucher Number''' - Reference Number of a specific [[Accounts Payable]].
+
|1. '''Record Filter'''<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">(Date Range, Customer)</span>
#'''Payment Voucher''' - Reference Voucher used to pay the [[Accounts Payable]]
+
|<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">Provides a set of filter option for precise searching of records.</span>
#*In most cases, [[Payment Voucher]] is used
 
#'''Transaction Date''' - Date when the Voucher was created.
 
#'''Invoice No.''' <span style="color: rgb(51, 51, 51)">- Reference No. of the source transaction of the [[Accounts Payable]]</span>
 
#'''Amount'''  <span style="color: rgb(51, 51, 51)">- Total Amount of the Payable</span>
 
#'''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 Payable
 
#'''Terms''' - the set default days on the supplier for them to pay their outstanding balance on their payable.
 
#*If terms are not set in Supplier 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)<br />
 
  
 +
*Date Range is automatically set for the current month
 +
*Customer is automatically set to filter all
 +
|-
 +
|2. '''Export'''
 +
|Allows the user to Export the record into Spreadsheet
 +
|-
 +
|3. '''Supplier Code'''
 +
|<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">Reference Code for customer record.</span>
 +
 +
*The set of Suppliers and Supplier Code can be seen in <span class="ve-pasteProtect">[[Supplier]]</span> Maintenance Module.
 +
*Supplier Codes is a unique field on <span class="ve-pasteProtect">[[Supplier]]</span> Maintenance Module, thus, it cannot be edited once created.
 +
|-
 +
|4. '''Supplier Name'''
 +
|<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">The Supplier Name affiliated to the Supplier Code.</span>
 +
 +
*Supplier Name can be edited in [[Supplier]] Maintenance Module.
 +
|-
 +
|5. '''Voucher Name'''
 +
|Reference Number of a specific [[Accounts Payable]].
 +
|-
 +
|6. '''Payment Voucher'''
 +
|Reference Voucher used to pay the [[Accounts Payable]]
 +
*In most cases, [[Payment Voucher]] is used
 +
|-
 +
|7. '''Transaction Date'''
 +
|Date when the Voucher was created.
 +
|-
 +
|8. '''Invoice No.'''
 +
|<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">Reference No. of the source transaction of the [[Accounts Payable]]</span>
 +
|-
 +
|9. '''Amount'''
 +
|<span class="ve-pasteProtect" style="color: rgb(51, 51, 51)" data-ve-attributes="{&quot;style&quot;:&quot;color: rgb(51, 51, 51)&quot;}">Total Amount of the Payable</span>
 +
|-
 +
|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 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 Receivable (It can be Posted/Open/Cancelled)
 +
|}
 
Notes:
 
Notes:
  

Revision as of 14:18, 24 March 2021

AP Transactions Report

File:AP Transaction Report Menu.png
AP Transaction Report Menu

AP Transaction Report - refers to the list of detailed supplier's invoices

AP Transaction 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 automatically set for the current month
  • Customer is automatically set to filter all
2. Export Allows the user to Export the record into Spreadsheet
3. Supplier Code Reference Code for customer record.
  • The set of Suppliers and Supplier Code can be seen in Supplier Maintenance Module.
  • Supplier Codes is a unique field on Supplier Maintenance Module, thus, it cannot be edited once created.
4. Supplier Name The Supplier Name affiliated to the Supplier Code.
  • Supplier Name can be edited in Supplier Maintenance Module.
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 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 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 Receivable (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
  • For detailed Instructions on how to view the Vouchers and Export the Customer AP Transaction Report, the user may view the AP Detailed Report Job Aids which can be found AP Transaction Report Aids.
Categories:
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
Financials Aids Accounts Payable Aids
Maintenance Aids Supplier 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 Payable Aging Aids | AP Detailed Report Aids | AP Transaction Report Aids | Cash Position Aids | Check List Aids | Deposit List Aids | Collection Register Aids