Aged Analysis Detail Report Columns

From FloristWiki

(Difference between revisions)
Jump to: navigation, search
Current revision (08:38, 18 April 2008) (edit) (undo)
 
(8 intermediate revisions not shown.)
Line 1: Line 1:
-
{| border="1"
+
{| style="border:1px black solid; border-collapse:collapse; text-align:left;" cellpadding="6"
-
|+ Caption
+
|-
-
|-
+
!style="width:100pt; background:#2B90DC; color:white; border-spacing:0px;" | '''Column'''
-
!Column1
+
!style="width:400pt; background:#2B90DC; color:white" | '''Description'''
-
!Column2
+
|-valign="top"
-
|-
+
! Customer No.
-
! Row1
+
| The account number of the customer with aged balance(s).
-
| Cell
+
|- valign="top"
-
|-
+
! Customer Name
-
! Row2
+
|Name of the customer with aged balance(s).
-
|cell
+
|-valign="top"
-
|-
+
! Phone Number
-
! next row heading
+
| Phone number of the customer with aged balance(s).
-
| cell
+
|-valign="top"
 +
! Days Late
 +
| Aging bucket or days late of the customer’s oldest transaction. If the oldest transaction is less than 120 days old, Days Late will show the aging bucket of the transaction (30 = ransactions 30-60 days old; 60 = transactions 61-90 days old; or 90 = transactions 91-120 days old). For transactions 121 days and older, Days Late shows the actual days late.
 +
|-valign="top"
 +
! Last Payment Date
 +
| Date on which the last payment was entered for the customer account.
 +
|-valign="top"
 +
! Accounting Type
 +
| Indicates whether the customer’s account is set up as a balance forward or open item account.
 +
|-valign="top"
 +
! Ticket #
 +
| Number associated with an order.
 +
|-valign="top"
 +
! Sale Date
 +
| Date of the ticket.
 +
|-valign="top"
 +
! Del Date
 +
| Scheduled delivery date.
 +
|-valign="top"
 +
! Transaction Date
 +
| Type of transaction. Transactions with balances prior to the Balance Forward date appear with transaction type of Balance Forward. If you generate the Aged Analysis report after running statements you may see Transaction Type of Finance Charge.
 +
|-valign="top"
 +
! Product Code
 +
| Code for the product.
 +
|-valign="top"
 +
! Product Description
 +
| Product name.
 +
|-valign="top"
 +
! Tax Code
 +
| Tax code associated with the transaction.
 +
|-valign="top"
 +
! Total Amount
 +
|Total amount for the transaction.
|-
|-
|}
|}
 +
Back to [[Aged Analysis Reports]]

Current revision

Column Description
Customer No. The account number of the customer with aged balance(s).
Customer Name Name of the customer with aged balance(s).
Phone Number Phone number of the customer with aged balance(s).
Days Late Aging bucket or days late of the customer’s oldest transaction. If the oldest transaction is less than 120 days old, Days Late will show the aging bucket of the transaction (30 = ransactions 30-60 days old; 60 = transactions 61-90 days old; or 90 = transactions 91-120 days old). For transactions 121 days and older, Days Late shows the actual days late.
Last Payment Date Date on which the last payment was entered for the customer account.
Accounting Type Indicates whether the customer’s account is set up as a balance forward or open item account.
Ticket # Number associated with an order.
Sale Date Date of the ticket.
Del Date Scheduled delivery date.
Transaction Date Type of transaction. Transactions with balances prior to the Balance Forward date appear with transaction type of Balance Forward. If you generate the Aged Analysis report after running statements you may see Transaction Type of Finance Charge.
Product Code Code for the product.
Product Description Product name.
Tax Code Tax code associated with the transaction.
Total Amount Total amount for the transaction.

Back to Aged Analysis Reports

Retrieved from "http://floristwiki.ftdi.com/index.php/Aged_Analysis_Detail_Report_Columns"
Personal tools
Navigation