AR Transaction Report - Revision history

Gelo: Changed categories.

2022-04-07T06:22:44Z

Changed categories.

Gelo: Changed categories.

2022-04-06T06:10:16Z

Changed categories.

Gelo at 05:24, 30 March 2022

2022-03-30T05:24:20Z

Gelo at 05:45, 3 March 2022

2022-03-03T05:45:57Z

Gelo at 03:05, 1 March 2022

2022-03-01T03:05:14Z

Gelo at 05:15, 28 February 2022

2022-02-28T05:15:37Z

Gelo at 06:07, 2 December 2021

2021-12-02T06:07:39Z

Gelo at 06:06, 2 December 2021

2021-12-02T06:06:38Z

Gelo at 05:48, 2 December 2021

2021-12-02T05:48:06Z

Gelo at 04:41, 24 March 2021

2021-03-24T04:41:22Z

← Older revision		Revision as of 06:22, 7 April 2022
Line 125:		Line 125:
	[[Category:Financial Statements]]		[[Category:Financial Statements]]
	[[Category:Financials]]		[[Category:Financials]]
		+	[[Category:Sales]]
		+	[[Category:Sales Reports]]

← Older revision		Revision as of 06:10, 6 April 2022
Line 123:		Line 123:
	\|[[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]]		\|[[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]]
	\|}		\|}
		+	[[Category:Financial Statements]]
		+	[[Category:Financials]]

@@ Line 85: / Line 85: @@
 =====<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'''
+#Click [[Reports]] under Main Menu
-#Under Reports Menu, Click '''[[AR Transaction Report]]''' under Financial Statement Reports.
+#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 you can filter the date range and the customer for precise exportation of records.
+#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]]
@@ Line 93: / Line 93: @@
 =====<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'''
+#Click [[Reports]] under Main Menu
-#Under Reports Menu, Click '''[[AR Transaction Report]]''' under Financial Statement Reports.
+#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.

@@ Line 121: / Line 121: @@
 |-
 |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]]
 |}

@@ Line 89: / Line 89: @@
 #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.
-[[File:Financial Statements - AR Transaction Report - Export.png|border|center|1624x1624px]]
+[[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>=====

@@ Line 6: / Line 6: @@
 ====AR Transaction Report Menu====
 '''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>
@@ Line 86: / Line 89: @@
 #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>=====
@@ Line 91: / Line 96: @@
 #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.
+#*The user may receive payment while viewing an [[Accounts Receivable]] record.
 {| class="wikitable"
 |+Categories:
@@ Line 104: / Line 113: @@
 |- style="height:25px;"
 |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]])'''
@@ Line 113: / Line 122: @@
 |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]]
 |}

@@ Line 8: / Line 8: @@
 '''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 Detailed Report</span></span></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 Detailed Report</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]]
 {| class="wikitable"

@@ Line 1: / Line 1: @@
 <div style="text-align: center;">
-[[Financial Statement]] | [[AR Transaction Report]] | [[AR Transaction Report Aids]] | [[Accounts Receivable]]
+[[Financial Statement]] | [[AR Transaction Report]] | [[Accounts Receivable]]
 </div>
@@ Line 8: / Line 8: @@
 '''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 Detailed Report</span></span></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>
+*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]]
+*#[[Customer]]
-*# [[Sales Invoice]]
+*#[[Sales Invoice]]
-*# [[Accounts Receivable]]
+*#[[Accounts Receivable]]
 {| class="wikitable"
@@ Line 80: / Line 80: @@
 **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> =====
+=====<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 the Main Menu, Click '''Reports'''
-# Under Reports Menu, Click '''[[AR Transaction Report]]''' under Financial Statement 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.
+#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> =====
+=====<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 the Main Menu, Click '''Reports'''
-# Under Reports Menu, Click '''[[AR Transaction Report]]''' under Financial Statement 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.
+#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.
+#*The user may receive payment while viewing a [[Accounts Receivable]] record.
 {| class="wikitable"

@@ Line 6: / Line 6: @@
 ====AR Transaction Report Menu====
 '''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>
 {| class="wikitable"
 |+AR Transaction Report Terms on Oojeema Prime System
@@ Line 14: / Line 21: @@
 |-
 |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'''
@@ Line 63: / Line 70: @@
 |<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'''
@@ Line 70: / Line 77: @@
 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
-*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]].
 {| class="wikitable"
@@ Line 96: / Line 115: @@
 |-
 | colspan="2" style="vertical-align:middle;text-align:center;" |'''Job Aid Modules'''
 |-
 |Maintenance Aids
 |[[Customer Aids]]
 |}

@@ Line 6: / Line 6: @@
 ====AR Transaction Report Menu====
-[[File:AR Transaction Report Menu.png|center|thumb|1000x1000px|AR Transaction Report Menu]]
+[[File:AR Transaction Report Menu.png|center|thumb|1048x1048px|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''' <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 Terms on Oojeema Prime System
+*Date Range is automatically set for the current month
-#'''Record Filter'''(Date Range, Customer) - Provides a set of filter option for precise searching of records.
+*The set of Customers and Customer Code can be seen in [[Customer]] Maintenance Module.
-#*Date Range is automatically set for the current month
+*Customer Codes is a unique field on [[Customer]] Maintenance Module, thus, it cannot be edited once created.
-#*Customer is automatically set to filter all
+|-
-#'''Customer Code''' - Reference Code for customer record.
+|4. '''Customer Name'''
-#*The set of Customers and Customer Code can be seen in [[Customer]] Maintenance Module.
+|The Customer Name affiliated to the Customer Code.
 Notes: