|
Report: Customer Advances, Detailed
|
|
Focus:
Focus of Report is to provide a detailed listing of advances (and repayments) made by
customers (mills). The report shows each transaction, both issuance and
repayment, for each advance.
- This report requires the "ENABLE_MILL_ADVANCES" setup item be
enabled.
- The report is based strictly on entries under Data Entry | Advances from
Customers
Selection Window:
The selection window allows you to filter the report by:
- Date/Time. You can directly ender a date/time range for the start
and end dates for your report. If you leave the end time blank, the
program will assume you want the entire day for the end date. In the
example below, the start date/time is 8/1/2004 00:00:00 (a blank is assumed
to be time 00:00:00) and the end date/time is 8/15/2004 00:00:00.
Because the end date time is blank (or 00:00:00), the program assumes you
want the whole day of the 15th and makes the end date/time 8/16/2004
00:00:00. In the selection query, the program returns records
whose start date/time is greater than OR equal to the start/date time and strictly
less than the end date/time. You do not need to select a period
-- this selection is merely used to facilitate the entry of the state and
end dates. If you select a period, you can always edit the state and
end dates to be any date you choose. For example, you can pick a
period defined as 8/1/2004 to 8/12/2004, and then extend the end date by
three days to 8/15/2004.
- Block: You can select any or all of your blocks.
- Customer: You can select any or all of your customers.
(Customers are identified on Revenue Contracts)
Detailed Description:
The report will show a summary of advances and repayments
on those advances.
Report:
The report shows the following columns:
-
Transaction Date: Date of transaction
-
Type: Type of transaction. "ADV"
for Advance issuance; "RP" for repayment.
-
Code: Unique reference code for the advance
-
Area: Primary Part 1 for the Block
-
Compartment: Primary Part 2 for the Block
-
Block: Block
-
Species: Species
-
Customer: Customer who issued the advance
-
Advances Received: Advance received from the customer
(may be more than one) for the specific block/species combination
-
Advances Repaid: Amounts repaid on the advance.
Each repayment is shown in sequential order, line-by-line.
-
Amount Outstanding: Running balance on the
advance.
-
Production Vol: Volume upon the advance issuance
was based (an input item when the advance is created)
-
Delivered Vol: Volume that is recorded upon a
repayment
-
Decked Vol: Running balance equal to the
difference between Production Vol and
Delivered Vol. This value is intended to reflect the volume of wood
harvested, but not yet delivered.
Note: The date range selection determines the
date range for the issuance of advances. The repayments are all
repayments (regardless of date) for the advances that fall within the
selected date range.
Example One:
Example Report 1
Key Notes:
