|
Customer Advances, Summary (#123)
|
|
Why:
You work for a mill(s) that issues advances to you on one or more blocks
based on estimated volumes (because the wood has not yet been delivered to the
mill). You use the "Customer Advances" functionality in The Logger's Edge,
and want to report upon the advances, repayments, and outstanding balances for a
given block.
Focus:
Focus of Report is to provide a summary of advances (and repayments) made by
customers (mills).
- This report requires the "ENABLE_MILL_ADVANCES" setup item to be
enabled in the BASIC SETUP window.
- The report is based strictly on entries under the menu item Data Entry | Advances from
Customers.
The window below shows an example of the entries made under this menu item.
Selection Window:
The selection window allows you to filter the report by:
- Date Range: You can either select a pay period, or you can simply enter the start and end date directly into the selection criteria window. The Period selection is merely a short-cut for entering a date range, so you can always edit the start 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. 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.
- 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.
The report shows the following columns:
-
Area: Primary Part 1 for the Block
-
Compartment: Primary Part 2 for the Block
-
Species: Species
-
Customer: Customer who issued the advance
-
Advances Received: Advances from the customer
(may be more than one) for the specific block/species combination
-
Advances Repaid: Amounts repaid on the advance.
-
Amount Outstanding: Balance on the Advances
-
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: 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.
Key Notes:
-
Calculators do not need to have been run in order for
the report to work.
-
All information displayed in this report is entered
under the Data Entry | Advances Issued from Customers menu item.
-
See the documentation provided
here
under the Special Features section of our website for more information.
Example Report:
Example Report
