This chapter contains these topics:
Section 40.2, "Throughput Reconciliations - Review (P415111)"
Section 40.3, "Throughput Reconciliations - Approve (P415111)"
Section 40.4, "Operational Reconciliations - Review (P415112)"
Section 40.5, "Operational Reconciliations - Approve (P415112)"
Section 40.6, "Throughput Reconciliation Report - Detail (P415403)"
Section 40.7, "Throughput Reconciliation Report -Totals (P415403)"
Section 40.8, "Update Throughput Reconciliations - Proof (P415020)"
Section 40.9, "Update Throughput Reconciliations - Update (P415020)"
Section 40.11, "Operational Reconciliations Summary Report (P415404)"
Section 40.12, "Operational Reconciliations Detail Report (P415407)"
Section 40.13, "Update Operational Reconciliations - Proof (P415021)"
Section 40.14, "Update Operational Reconciliations - Update (P415021)"
Section 40.18, "Reconciliation Status Inquiry & Change (P415113)"
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| 1. Enter the Reconciliation Status Code which indicates the transaction has been throughput reconciled.
Records with this status (and any status greater than the one entered) will be protected from changes. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| 1. List the User Defined Codes which contain the document types that make up the following categories:
Load Confirm Sales: system code record type Other Metered Outgoings: system code record type Non-Metered Outgoings: system code record type |
|
| 2. Enter the screen format to initially display:
1 = ambient volume 2 = standard volume (default) 3 = weight |
|
| 3. Enter the beginning (current) reconciliation status. | |
| 4. Enter the next reconciliation status. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| 1. List the User Defined Codes which contain the document types that make up the following categories:
Load Confirm Sales: system code record type Other Metered Outgoings: system code record type Non-Metered Outgoings: system code record type |
|
| 2. Enter the screen format to initially display:
1 = ambient volume 2 = standard volume (default) 3 = weight |
|
| 3. Enter the beginning (current) reconciliation status. | |
| 4. Enter the next reconciliation status. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| 1. List the User Defined Code containing the document types for the following:
Incomings: system code record type Outgoings: system code record type |
|
| 2. Enter the User Defined Code which lists the document types that must be throughput reconciled prior to being operationally reconciled:
system code record type |
|
| 3. Enter the reconciliation status of records that have been throughput reconciled. (If Processing Option 2 is non-blank.). | |
| 4. Enter the beginning (current) reconciliation status. | |
| 5. Enter the next reconciliation status. | |
| 6. Enter the processing mode:
' ' = Review Only (default) '0' = Review and Approve '1' = Approve Only (Roll to next page for explanation) Review Only - Selects OUTGOINGS at the current status (4) and updates all transactions to the next status (5). Review and Approve - Selects OUTGOINGS at the current status (4) and updates all transactions to the next status (5) AND updates the reconciliation flag to 'I'. |
c |
| 7. Enter the screen format to initially display:
1 = Ambient Volume 2 = Standard Volume (default) 3 = Weight |
c |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| 1. List the User Defined Code containing the document types for the following:
Incomings: system code record type Outgoings: system code record type |
|
| 2. Enter the User Defined Code which lists the document types that must be throughput reconciled prior to being operationally reconciled:
system code record type |
|
| 3. Enter the reconciliation status of records that have been throughput reconciled. (If Processing Option 2 is non-blank.). | |
| 4. Enter the beginning (current) reconciliation status. | |
| 5. Enter the next reconciliation status. | |
| 6. Enter the processing mode:
' ' = Review Only (default) '0' = Review and Approve '1' = Approve Only (Roll to next page for explanation) Review Only - Selects OUTGOINGS at the current status (4) and updates all transactions to the next status (5). Review and Approve - Selects OUTGOINGS at the current status (4) and updates all transactions to the next status (5) AND updates the reconciliation flag to 'I'. Approve Only - Selects ALL transactions at the current status (4) and updates all transactions to the next status (5) AND updates the reconciliation flag to 'I'. |
c |
| 7. Enter the screen format to initially display:
1 = Ambient Volume 2 = Standard Volume (default) 3 = Weight |
c |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| 1. List the User Defined Codes which contain the document types that make up the following categories:
Load Confirm Sales: system code record type Other Metered Outgoings: system code record type Non-Metered Outgoings: system code record type |
|
| 2. Enter a '1' to print the detailed transactions or a '2' to print totals only.
The default is to print totals only. |
|
| 3. Enter the current reconciliation status. | |
| 4. Enter the "As Of" date thru which you want records to be included. | |
| 5. Document Type for Load & Delivery Transactions created. (With the exception of Sales Orders created during Milk Run Processing and Charge to Org during Disposition). | |
| 6. Enter '1' to print detailed Load and Delivery transactions. ' ' is the default and will not print detailed Load and Delivery transactions. | |
| 7. Enter the Trip Status code that is "Delivery Confirmed". | |
| 8. Enter the unit of measure in which you want the Total Depot Gain/Loss displayed. | |
| 9. Enter the quantities to display:
' ' = standard volume (default) 1 = ambient volume 2 = weight |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| 1. List the User Defined Codes which contain the document types that make up the following categories:
Load Confirm Sales: system code record type Other Metered Outgoings: system code record type Non-Metered Outgoings: system code record type |
|
| 2. Enter a '1' to print the detailed transactions or a '2' to print totals only.
The default is to print totals only. |
|
| 3. Enter the current reconciliation status. | |
| 4. Enter the "As Of" date thru which you want records to be included. | |
| 5. Document Type for Load & Delivery Transactions created. (With the exception of Sales Orders created during Milk Run Processing and Charge to Org during Disposition). | |
| 6. Enter '1' to print detailed Load and Delivery transactions.
' ' is the default and will not print detailed Load and Delivery transactions. |
|
| 7. Enter the Trip Status code that is "Delivery Confirmed". | |
| 8. Enter the unit of measure in which you want the Total Depot Gain/Loss displayed. | |
| 9. Enter the quantities to display:
' ' = standard volume (default) 1 = ambient volume 2 = weight |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| SELECTION CRITERIA: | |
| 1. List the User Defined Codes which contain the document types that make up the following categories:
Load Confirm Sales: system code record type Other Metered Outgoings: system code record type Non-Metered Outgoings: system code record type |
|
| 2. Enter the current reconciliation status. | |
| 3. Enter the next reconciliation status. | |
| 4. Enter the Transaction Date to use when selecting records.
All unreconciled records thru this date will be included. |
|
| PRINT OPTIONS: | |
| 5. Enter the quantities to display:
' ' = standard volume (default) 1 = ambient 2 = weight |
|
| UPDATE OPTIONS: | |
| 6. Enter '1' to update the Gain/Loss File.
Default of blank will run the report in proof mode. |
|
| 7. Enter the Reconciliation Date to use when in update mode.
If no date is entered, the current system date will be used. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| SELECTION CRITERIA: | |
| 1. List the User Defined Codes which contain the document types that make up the following categories:
Load Confirm Sales: system code record type Other Metered Outgoings: system code record type Non-Metered Outgoings: system code record type |
|
| 2. Enter the current reconciliation status. | |
| 3. Enter the next reconciliation status. | |
| 4. Enter the Transaction Date to use when selecting records.
All unreconciled records thru this date will be included. |
|
| PRINT OPTIONS: | |
| 5. Enter the quantities to display:
' ' = standard volume (default) 1 = ambient 2 = weight |
|
| UPDATE OPTIONS: | |
| 6. Enter '1' to update the Gain/Loss File.
Default of blank will run the report in proof mode. |
|
| 7. Enter the Reconciliation Date to use when in update mode.
If no date is entered, the current system date will be used. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| 1. Enter the status code beyond which a dip reading cannot be changed. This will indicate the point at which a reading has been operationally reconciled. | |
| 2. Enter a '1' to be prompted to accept the dip readings. | |
| 3. Enter the DREAM Writer version to use when calling P415203, Tank Reading Inquiry.
Version ZJDE0001 will be used as the default if left blank. |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| 1. List the User defined Code containing the document types for the following:
Incomings: system code record type Outgoings: system code record type |
|
| 2. Enter the current reconciliation status. | |
| 3. Enter the "From" reconciliation date to use when selecting records. | |
| 4. Enter the "Thru" reconciliation date to use when selecting records. | |
| 5. Enter the point through which records have been processed. This option controls the retrieval of records.
' ' = review (default) '0' = approval without prior review '1' = approval with prior review |
|
| 6. Enter the unit of measure you want the Total Depot Gain/Loss displayed in. | Change to: Enter the unit of measure in which you want the Total Depot Gain/Loss displayed. |
| 7. Enter the quantities to display:
' ' = standard volume (default) 1 = ambient volume 2 = weight |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| 1. List the User Defined Code containing the document types for the following:
Incomings: system code record type Outgoings: system code record type |
|
| 2. Enter the current reconciliation status. | |
| 3. Enter the "From" reconciliation date to use when selecting records. | |
| 4. Enter the "Thru" reconciliation date to use when selecting records. | |
| 5. Enter the point through which records have been processed. This option controls the retrieval of records.
' ' = review (default) '0' = approval without prior review '1' = approval with prior review |
|
| 6. Enter the unit of measure in which you want the Total Depot Gain/Loss displayed. | |
| 7. Enter the quantities to display:
' ' = standard volume (default) 1 = ambient volume 2 = weight |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| RECORD SELECTION: | |
| 1. Enter the As Of Date: | |
| 2. Enter the As Of Time: | |
| 3. Enter the current reconciliation status. | |
| 4. Enter the next reconciliation status. | |
| 5. Enter '1' to update records.
Default of blank will not update records. |
|
| 6. Enter the document type to be used for creating the adjusting entry. | |
| 7. Enter the General Ledger date for processing the update.
If left blank the current system date will default. |
|
| 8. Enter the General Ledger date for processing the retroactive gain/loss.
If left blank the current system date will default. |
|
| 9. Enter '1' to run in summary mode.
The G/L accounts will be summarized within each document number. If run in detail, G/L accounts will be produced for each detail line. |
|
| 10. Enter the DREAM Writer version to use for the G/L Functional Server XT0911Z1.
If left blank the default version ZJDE0001 will be used. |
|
| 11. List the User Defined Code containing the document types for the following:
Incomings: system code record type Outgoings: system code record type |
|
| 12. Enter the unit of measure you want the Total Depot Gain/Loss displayed in. | |
| 13. Enter the quantities to display:
' ' = standard volume (default) 1 = ambient volume 2 = weight |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| RECORD SELECTION: | |
| 1. Enter the As Of Date: | |
| 2. Enter the As Of Time: | |
| 3. Enter the current reconciliation status. | |
| 4. Enter the next reconciliation status. | |
| 5. Enter '1' to update records.
Default of blank will not update records. |
|
| 6. Enter the document type to be used for creating the adjusting entry. | |
| 7. Enter the General Ledger date for processing the update.
If left blank the current system date will default. |
|
| 8. Enter the General Ledger date for processing the retroactive gain/loss.
If left blank the current system date will default. |
|
| 9. Enter '1' to run in summary mode.
The G/L accounts will be summarized within each document number. If run in detail, G/L accounts will be produced for each detail line. |
|
| 10. Enter the DREAM Writer version to use for the G/L Functional Server XT0911Z1.
If left blank the default version ZJDE0001 will be used. |
|
| 11. List the User Defined Code containing the document types for the following:
Incomings: system code record type Outgoings: system code record type |
|
| 12. Enter the unit of measure you want the Total Depot Gain/Loss displayed in. | |
| 13. Enter the quantities to display:
' ' = standard volume (default) 1 = ambient volume 2 = weight |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| 1. Enter the range of transaction dates for inclusion of records.
(Blanks will default to system date) From Date Thru Date |
|
| 2. Enter the relation to use for the variance selection.
GT = greater than LT = less than EQ = equal to |
|
| 3. Enter the quantity to compare the variance to for selection. | |
| 4. Enter one of the following:
A = compare the volume difference % = compare the percent variance |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| 1. Enter the screen format to initially display:
1 = Ambient Volume 2 = Standard Volume (default) 3 = Weight |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| SCREEN CONTROL OPTIONS: | |
| 1. Enter '1' to allow the update of the reconciliation status. | |
| 2. Enter default depot (if blank, the depot from the User Defaults will be used). |
| Processing Option | Processing Options Requiring Further Description |
|---|---|
| SCREEN CONTROL OPTIONS: | |
| 1. Enter '1' to allow the update of the reconciliation status. | |
| 2. Enter default depot (if blank, the depot from the User Defaults will be used). |