ManPageR Aging

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



Report: Aging

Description : Aging Report

Help : The aging report allows you to report on Open Items (Invoices). Select the aging buckets, you want to have in your report. If you select a currency, you get only invoices of that currency, otherwise the amounts are converted to your primary accounting currency. If you do not select a Statement Date, the system date is used to calculate the buckets. If you do not list the individual invoices, the Due Date is the earliest due date for the business partner and the Due Days are the average due days of all invoices.

Class Name: org.compiere.process.Aging ReportView Name: T_Aging


Parameters

Name Description Help Technical Data
Statement date Date of the statement The Statement Date field defines the date of the statement. StatementDate

Date

Sales Transaction This is a Sales Transaction The Sales Transaction checkbox indicates if this item is a Sales Transaction. IsSOTrx

YesNo

Currency The Currency for this record Indicates the Currency to be used when processing or reporting on this record C_Currency_ID

TableDir

Business Partner Group Business Partner Group The Business Partner Group provides a method of defining defaults to be used for individual Business Partners. C_BP_Group_ID

TableDir

Business Partner Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson C_BPartner_ID

Search

List Invoices Include List of Invoices IsListInvoices

YesNo

Contributions

Columns in T_Aging:

InvoicedAmt Invoiced C_Invoice.GrandTotal, all invoiced
OpenAmt Invoiced - Paid OpenAmt, something like GrandTotal - Paid (according C_AllocationLine)
DueDate Due Date max(DueDate)
DaysDue Days Due avg(DaysDue), DaysDue negative if the account is not overdue
Fields for Projection
DueAmt Without overdue sum(OpenAmt) where DaysDue <= 0
Due0 Due Today sum(OpenAmt) where DaysDue = 0
Due0_7 Due this week including today sum(OpenAmt) where DaysDue between -7 and 0
Due0_30 Due this month sum(OpenAmt) where DaysDue between -30 and 0
Due1_7 Due this week not including today sum(OpenAmt) where DaysDue between -7 and -1
Due8_30 Due between next 8-30 days sum(OpenAmt) where DaysDue between -30 and -8
Due31_60

Due between next 31-60 days (next month)

sum(OpenAmt) where DaysDue between -60 and -31
Due31_Plus Due after 30 days sum(OpenAmt) where DaysDue <= -31
Due61_90 Due between next 61-90 days sum(OpenAmt) where DaysDue between -90 and -61
Due61_Plus Due after 60 days sum(OpenAmt) where DaysDue <= -61
Due91_Plus Due after 90 days sum(OpenAmt) where DaysDue <= -91
Fields for Aging
PastDueAmt All OverDue sum(OpenAmt) where DaysDue > 0
PastDue1_7 Overdue last week sum(OpenAmt) where DaysDue between 1 and 7
PastDue1_30 Overdue between 1 - 30 days sum(OpenAmt) where DaysDue between 1 and 30
PastDue8_30 Overdue between 8 - 30 days sum(OpenAmt) where DaysDue between 8 and 30
PastDue31_60 Overdue between 31-60 days sum(OpenAmt) where DaysDue between 31 and 60
PastDue31_Plus Overdue greater 30 days sum(OpenAmt) where DaysDue >= 31
PastDue61_90 Overdue between 61-90 days sum(OpenAmt) where DaysDue between 61 and 90
PastDue61_Plus Overdue greater 60 days sum(OpenAmt) where DaysDue >= 61
PastDue91_Plus Overdue greater 90 days sum(OpenAmt) where DaysDue >= 91
Personal tools