Partner Operated Battery Balance
- IFS Energy & Resources
- IFS Energy and Resources (Deactivated)
- IFS Energy & Resources
Back to Monthly Data Entry and Balance Screens Back to Partner Operated Battery Maintenance Back to BC Petrinex Inclusion Project Overview Back to How To: Spreadsheet Import Partner Operated Sales
- 1 Introduction
- 2 Transactions
- 2.1 Sales
- 2.2 Royalties
- 2.3 Production
- 2.4 Wellhead
- 3 Pricing
- 4 Totals
- 5 Edit Well Transactions
Introduction
When a battery has been set up as a partner operated battery, the Explorer menu options adjust accordingly. The Balance menu option is displayed, but the screen launched is the Partner Operated Battery Balance and reflects the different data elements required. For a partner operated battery, data is entered as transactions for each well attached to the battery. Clients can choose to use pricing data to value the entered transactions instead of entering value on each transaction.
Well-level transactions can be added in the Battery Maintenance on the Wells tab, when wells are first being linked to the battery, and can also be added directly on this screen, either manually one at a time or using the Edit Well Transactions option to create multiple transactions at once. In addition, some of the transaction types can be created via the Import Partner Operated Monthly process or by using the Upload from Spreadsheet button on the Partner Operated Battery Balance. Typically, this is used to upload data generated from Petrinex, as the formats of these spreadsheet uploads are based on the Petrinex report layouts. For more information see Partner Operated Facility Upload. Finally, Sales transactions can be updated, (not created), using the Import by Template process and the PARTNEROPSALES template. See How to: Spreadsheet Import Partner Operated Sales Transactions for more details. Well-level transactions will be copied into the next month during the Month End Close, with the volumes/values being reset to zero.
Pricing data can be entered at various levels, depending on how specific the data is.
For example: Price per product, price per product/purchaser, price per product/destination, etc. Entered pricing data will be copied into the next month during the Month End Close, with prices/values being reset to zero.
ACTION BUTTONS | |
|---|---|
Edit Well Transactions | This button allows you to mass create/delete/update transactions. See the Edit Well Transactions section for more details. |
Upload from Spreadsheet (Petrinex) | This button allows you to import data into this battery from Petrinex reports. See Partner Operated Facility Upload for more information. |
Close | This button closes the screen. |
Run Process | This button launches the Run Process submission screen to allow you to submit Step processing for the battery. Note: This button is disabled when the battery is closed, locked, or not balanced. |
TABS | |
|---|---|
Transactions | This tab displays the Primary Plant for the battery (entered on the Battery Maintenance Production tab), a grid with the wells attached to the battery and several sub-tabs for various transaction types (Sales, Royalties, Production, and Wellhead). This tab is used to enter data for the various transactions associated with wells attached to the battery. |
Pricing | This tab displays the Primary Plant for the battery (entered on the Battery Maintenance Production tab), a grid with the pricing records associated with the battery and a Details section for the selected row in the grid. This tab is used to enter pricing information and allocate the revenue to the various transactions. |
Totals | This tab displays a summary of all transactions. |
Upload Results | This tab displays upload details and error messages. |
Transactions
Wells are listed in a grid at the top of the Transactions tab. Highlighting a well displays the transactions entered for the well, if any, and allows you to create, modify, or delete transactions as required.
Below the Wells grid is a series of tabs for each of the several types of transactions.
Sales
The Sales tab contains data for the selected well. Depending on the battery master configuration, either just Net fields are enabled, just Gross fields are enabled, or both Net and Gross fields are enabled. The sales, transportation, and pricing deduction values can be entered manually for each transaction, or they can be allocated based on pricing data entered on the Pricing tab.
The sales volume, value, GJs, transportation, and pricing deductions (Net and/or Gross) can also be updated using the Import by Template and the PARTNEROPSALES template. See How to: Spreadsheet Import Partner Operated Sales Transactions for more details.
Volume, value, GJs, and transportation will always be visible. The pricing deduction fields, (Quality Adjustment, Tariff, Line Loss, Other#1, and Other#2), will be visible only when either the Show Deductions button was clicked or the Show Pricing Dedns. The Default option is Yes on the Battery Maintenance - Production screen. The Oil Val Receiving Type/ID fields will appear when the battery is in a province that is using Oil Valuation RTP submissions.
For Sales transactions, the Pricing Deductions may or may not be visible by default, depending upon the Show Pricing Dedns. Default option on the Battery Maintenance - Production screen. If not visible by default, the Show Deductions button will make the Pricing Deduction fields visible and replace the Show Deductions button with the Hide Deductions button. Even without the pricing deduction fields visible, the grid will have many columns. The following picture shows them all at once to make it easier to review.
With the pricing deductions visible, the grid will have many more columns. The following picture shows them all at once. Notice the Show Deductions button has been replaced with the Hide Deductions button. Before users enter pricing deduction values, a number of considerations should be taken into account. These considerations are the same for operated properties and can be viewed on Pricing Monthly Processing.
Action buttons include Save, Save and Advance to Next Well, Revert, Show/Hide Deductions, Create New, and Delete Row(s).
The Show Deductions button will be visible when pricing deduction fields are not visible and when clicked will cause the pricing deduction fields to be made visible. The Show Deductions button will be replaced with the Hide Deductions button.
The Hide Deductions button will be visible when pricing deduction fields are visible and, when clicked, will cause the pricing deduction fields to be hidden. If the Hide Deductions button is clicked after making changes to any sales data without saving the changes, a message will pop up indicating you have un-saved changes. Pricing deduction fields cannot be hidden when there are unsaved changes. Save or Revert the changes before clicking the Hide Deductions button. The Hide Deductions button will be replaced with the Show Deductions button.
SALES GRID | |
|---|---|
Product | The Product associated with the transaction. This is a required field. |
Plant Facility | The Plant associated with the transaction. This is an optional field.
When uploading transaction data from a spreadsheet, the Plant Facility column can be populated from the data in the WIO file for those batteries that have the Upload Plant flag set to Yes on the Partner Operated Battery Maintenance - Production tab. When uploading the Plant Facility, the process will first look for a GP or GS in the Cascade Facility column.
Note: The Plant Facility will be uploaded only if a valid Qbyte Metrix Plant ID is found matching the Petrinex ID in the file, and if it is OFF production. |
Purchaser | The Purchaser associated with the transaction. This is a required field. Note: None of the transactions being uploaded from a spreadsheet (Petrinex formats of Volumetric and WIO reports) have Purchaser information, so if a new Sales transaction is encountered in a file being uploaded the Partner Operated Upload Default Purchaser entered on the System Configuration - Partner Operated tab will be used. If there is a matching transaction (ignoring Purchaser) then the volume in the uploaded file will be put on the first matching transaction found. The user may have to split the uploaded volume to multiple sales transactions with the correct Purchasers. |
Purch Seq# | The Sequence Number associated with the transaction. This is a required field, but if left blank it will default to 0 upon Save. Note: If there is already a Sequence 0 being used then an error will be displayed.
|
Pricing UserDefined1 | This is a read-only field and is populated during Pricing Allocation based on the Pricing record used to value the transaction. Note: The column heading defaults to UserDefined1. This can be changed by the User Defined Labels tab (Administration > System Configuration > User Defined Labels). Select Edit and then change the Field Label for the Field Name PartnerOpBatteryPrice.userDefined1. |
Net Volume | The Net Volume associated with the transaction. Net refers to the portion of the transaction that is associated with the partners in the DOI that are not being Excluded.
|
Net Value | The Net Value associated with the transaction. This value should represent the value being received from the purchaser for the transaction less any crown allowable pricing deductions. Net refers to the portion of the transaction that is associated with the partners in the DOI that are not being Excluded.
|
Net GJs | Net GJs associated with the transaction. Net refers to the portion of the transaction that is associated with the partners in the DOI that are not being Excluded.
|
Net Transportation | The Net Transportation cost associated with the transaction. Net refers to the portion of the transaction that is associated with the partners in the DOI that are not being Excluded.
|
Net Quality Adj. | The Net Quality Adj. cost associated with the transaction. Net refers to the portion of the transaction that is associated with the partners in the DOI that are not being Excluded.
|
Net Tariff | The Net Tariff cost associated with the transaction. Net refers to the portion of the transaction that is associated with the partners in the DOI that are not being Excluded.
|
Net Line Loss | The Net Line Loss cost associated with the transaction. Net refers to the portion of the transaction that is associated with the partners in the DOI that are not being Excluded.
|
Net Other#1 | The Net Other#1 cost associated with the transaction. Net refers to the portion of the transaction that is associated with the partners in the DOI that are not being Excluded.
|
Net Other#2 | The Net Other#2 cost associated with the transaction. Net refers to the portion of the transaction that is associated with the partners in the DOI that are not being Excluded.
|
Net Base Value | This is a display-only field that is calculated based on the other Net fields (Net Value plus Net Quality Adj. plus Net Tariff plus Net Line Loss plus Net Other#1 plus Net Other#2). This represents the net value received from the purchaser prior to any crown allowable pricing deductions. |
Destination Type | The Entity Type of Destination associated with the transaction. This is an optional field.
Note: When generating data for the Oil Valuation RTP, only Oil Sales transactions with an entered Destination will be included. |
Destination ID | The ID of the Destination associated with the transaction. This is an optional field.
Note: When generating data for the Oil Valuation RTP, only Oil Sales transactions with an entered Destination will be included. When uploading transaction data from a spreadsheet, the Destination column can be populated from the From/To column in the WIO file for those batteries that have the Upload Destination flag set to Yes on the Partner Operated Battery Maintenance - Production tab. The From/To facility must have a Qbyte Metrix Facility or Delivery System set up with a matching Petrinex ID in the production date. |
Oil Val Receiving Type | The Entity Type of the Receiving Facility (as per Oil Valuation RTP submission) associated with the transaction. This is an optional field.
|
Oil Val Receiving ID | The ID of the Oil Val Receiving facility associated with the transaction. This is an optional field.
For more information on Oil Valuation RTP for Partner Operated batteries see Oil Valuation Data and RTP - Partner Operated. |
Gross Volume | The Gross Volume associated with the transaction. Gross refers to the portion of the transaction that is associated with all the partners in the DOI.
|
Gross Value | The Gross Value associated with the transaction. This value should represent the value being received from the purchaser for the transaction less any crown allowable pricing deductions. Gross refers to the portion of the transaction that is associated with all the partners in the DOI.
|
Gross GJs | The Gross GJs associated with the transaction. Gross refers to the portion of the transaction that is associated with all the partners in the DOI.
|
Gross Transportation | The Gross Transportation cost associated with the transaction. Gross refers to the portion of the transaction that is associated with all the partners in the DOI.
|
Gross Quality Adj. | The Gross Quality Adj. cost associated with the transaction. Gross refers to the portion of the transaction that is associated with all the partners in the DOI.
|
Gross Tariff | The Gross Tariff cost associated with the transaction. Gross refers to the portion of the transaction that is associated with all the partners in the DOI.
|
Gross Line Loss | The Gross Line Loss cost associated with the transaction. Gross refers to the portion of the transaction that is associated with all the partners in the DOI.
|
Gross Other#1 | The Gross Other#1 cost associated with the transaction. Gross refers to the portion of the transaction that is associated with all the partners in the DOI.
|
Gross Other#2 | The Gross Other#2 cost associated with the transaction. Gross refers to the portion of the transaction that is associated with all the partners in the DOI.
|
Gross Base Value | This is a display-only field that is calculated based on the other Gross fields (Gross Value plus Gross Quality Adj. plus Gross Tariff plus Gross Line Loss plus Gross Other#1 plus Gross Other#2). This represents the gross value received from the purchaser prior to any crown allowable pricing deductions. |
Royalties
The Royalties tab in the Battery Balance screen allows you to set up manual entry royalties.
Rather than setting up a formula, you can simply enter the final royalty payable value as provided by the operator.
Action buttons include Save, Save and Advance to Next Well, Revert, Create New, and Delete Row(s).
ROYALTIES GRID | |
|---|---|
Product | The Product associated with the transaction. This is a required field. |
Royalty Type | The Royalty Type associated with the transaction. This is a required field.
|
Royalty Owner | The Royalty Owner associated with the transaction. This is a required field. |
Gross Volume | The Gross Volume associated with the transaction. Gross refers to the portion of the transaction that is associated with all the partners in the DOI.
|
Gross Value | The Gross Value associated with the transaction. Gross refers to the portion of the transaction that is associated with all the partners in the DOI.
|
Net Volume | The Net Volume associated with the transaction. Net refers to the portion of the transaction that is associated with the partners in the DOI that are not being Excluded.
|
Net Value | The Net Value associated with the transaction. Net refers to the portion of the transaction that is associated with the partners in the DOI that are not being Excluded.
|
Tax Type | The Tax Type associated with the transaction. This can impact how the royalty is booked. This is a required field.
|
Production
The Production tab allows you to enter production volumes. These production volumes are allocated production volumes and not original wellhead volumes (Wellhead volumes are entered on the Wellhead tab). This data can be entered manually, uploaded using the Upload from Spreadsheet button, or can be automatically set equal to the sales volumes using the Force VAS = Sales buttons. Production volumes are not booked but are typically entered for internal reporting purposes or for calculating royalty obligations that are based on production volume.
Action buttons include Force VAS = Sales, Save, Save and Advance to Next Well, Revert, Create New and Delete Row(s).
The Force VAS = Sales button will automatically set the production volume based on the sales volume entered on the Sales tab.
PRODUCTION GRID | |
|---|---|
Product | Product associated with the transaction. This is a required field. |
Plant Facility | Plant associated with the transaction. This is an optional field.
When uploading transaction data from a spreadsheet, the Plant Facility column can be populated from the data in the WIO file for those batteries that have the Upload Plant flag set to Yes on the Partner Operated Battery Maintenance - Production tab. When uploading the Plant Facility, the process will first look for a GP or GS in the Cascade Facility column.
Note: The Plant Facility will only be uploaded if a valid Qbyte Metrix Plant ID is found matching the Petrinex ID in the file, and if it is OFF production. |
Gross Volume | Gross Volume associated with the transaction. Gross refers to the portion of the transaction that is associated with all the partners in the DOI.
|
Net Volume | Net Volume associated with the transaction. Net refers to the portion of the transaction that is associated with the partners in the DOI that are not being Excluded.
|
Wellhead
The Wellhead screen allows you to enter raw gas wellhead production volume rather than plant production volume. You can also indicate if the well is Shut-in. The shut-in status will be used when calculating facility charges with a shut-in look-up table.
Action buttons include Save, Save and Advance to Next Well, and Revert.
WELLHEAD GRID | |
|---|---|
Producing Hours | The Producing Hours for the well. This is an optional field. If left blank it will default to 0.
|
Wellhead Gas Production | The Wellhead Raw Gas production. This is an optional field. If left blank it will default to 0.
Note: This should represent the gross volume produced at the wellhead. It can be used in Royalty Obligation formulas. |
Wellhead Oil Production | The Wellhead Raw Gas production. This is an optional field. If left blank it will default to 0.
Note: This should represent the gross volume produced at the wellhead. It can be used in Royalty Obligation formulas. |
Shut-in | The Shut-in indicator.
Note: This will be used in Facility Charge calculations when looking at Shut-in tables associated with the formula. |
Pricing
The Pricing tab allows you to set up records to associate price/values with specific transaction attributes (i.e., transaction type, product, purchaser/royalty owner, destination, etc.) instead of entering value, transportation and/or pricing deduction costs on each well transaction. Once set up, these pricing records can be applied to all matching transactions using the Allocate button. Not only do pricing records reduce initial data entry by calculating/allocating value to all appropriate transactions but they also make it easier to deal with changes or amendments. Simply change the volume or GJs on the impacted transactions and then click the Allocate button to re-apply pricing records based on the modified volume/GJs, instead of having to manually calculate and re-enter modified values on each transaction.
For partner operated properties that need to generate Oil Valuation RTP submissions, use the Pricing tab to associate a Shipper Owner Contract with matching Oil sales transactions when the Generate Oil Valuation Data process is run.
Another reason to use the Pricing tab is to set up a Battery Default Oil Price to be used in Oil Royalty Obligations based on Production Volumes when there are no Oil Sales. Create an Oil Sales pricing record where All Purchasers = Yes, All Purchaser Sequences = Yes, All Destinations = Yes, and Pricing Option = Price Per Unit.
Pricing records will be copied into the next month during the Month End Close. Price/Value data will be reset to zero in the next month. Transportation and pricing deduction rates/values will also be reset to zero in the next month, by default. However, transportation and pricing deduction rates will be copied into the next month when the corresponding option on the Region Master is Yes. (Retain Purchaser Transportation Rates controls whether transportation rates are copied into the next month. Retain Purchaser Deduction Rates controls whether pricing deduction rates are copied into the next month.)
The grid at the top of the page displays the pricing Information you have previously saved. The Pricing Deductions may or may not be visible by default, depending upon the Show Pricing Dedns. Default option on the Battery Maintenance - Production screen. If not visible by default, the Show Deductions button will make the Pricing Deduction fields visible and replace the Show Deductions button with the Hide Deductions button. Even without the pricing deduction fields visible, the grid will have many columns. The following picture shows them all at once to make it easier to review.
With the pricing deductions visible, the grid will have many more columns. The following picture shows them all at once. Notice the Show Deductions button has been replaced with the Hide Deductions button. Before entering pricing deduction values there are a number of considerations that should be taken into account. These considerations are the same for operated properties and can be viewed on Pricing Monthly Processing.
The Allocate button is enabled when at least one pricing record exists. When the Allocate button is clicked, all pricing records are processed and applied to their matching transactions. This means that all matching transactions will have the value re-calculated along with the transportation and pricing deductions, where applicable. However, since pricing records can have different fields specified that may cause a transaction to match to more than one pricing record, they must first be sorted in priority order. In general, the more fields populated on the pricing record, the higher the priority, however, certain fields will take precedence. The following lists the priority order by transaction type, with the highest priority at the top of the list.
Crown/Freehold/Override
Royalty Owner specified
All Royalty Owners
Sales
Plant, Purchaser, Purchaser Sequence, and Destination Type/ID specified
All Plants, Purchaser, Purchaser Sequence, and Destination Type/ID specified
Plant, Purchaser, Purchaser Sequence and All Destinations specified
All Plants, Purchaser, Purchaser Sequence and All Destinations specified
Plant, All Purchasers, and Destination Type/ID specified
All Plants, All Purchasers, and Destination Type/ID specified
Plant, All Purchasers, and All Destinations specified
All Plants, All Purchasers, and All Destinations specified
It also populates the values on the Totals tab.
The Pricing tab allows you to:
Input prices for many products before using the Allocate button to allocate revenue to the wells.
Price Crown, freehold, and overriding royalties in the same manner.
Allocate partner operated revenue based on total value or price per unit. Gas sales can still be allocated by gigajoule or sales volume.
Price by destination.
For example: If an operator sends gas to more than one pipeline, you can apply different prices to each destination (pipeline). The destination can be uploaded from the Petrinex Working Interest Owner file.Price by plant facility.
For example: If gas and products are produced/sold at multiple plants, you can apply different prices for the products at each plant facility. If there is a Primary Plant for the battery and the Plant Facility is left blank on the sales transaction, it is assumed that the Plant associated with the transaction is the Primary Plant and it is used as such when the Allocation button is clicked.The plant facility can be uploaded from the Petrinex Working Interest Owner file.
Price by purchaser sequence number. Unique sequence numbers can be assigned to enable different prices for the same purchaser.
When a pricing row is used to price a sales transaction, the associated User Defined field is displayed next to the Purchaser Seq # within the Sales grid of the Transactions tab.
Details
The Details section shows the details of the currently highlighted pricing record, or the pricing record being currently created. Depending upon whether pricing deductions are applicable (Sales transactions only) or visible, the pricing deduction options may or may not be displayed.
With pricing deductions visible the Details section will have additional options.
DETAILS | |
|---|---|
Transaction Type | Available options include:
|
Product | Drop-down list of products applicable to the battery. |
All Plants | This field indicates whether the pricing record applies to any/all plants or to a specific plant. Available options include Yes or No. This field is only enabled for Sales transactions when the product is not OIL. |
Plant Facility | This field is enabled when the All Plants option above is No. This is an auto-suggest for plants in any province that are NOT on production. Note: If there is a Primary Plant for the battery and the Plant Facility is left blank on the sales transaction, it is assumed that the Plant associated with the pricing record is the Primary Plant and it is used as such when the Allocation button is clicked. |
All Purchasers/All Royalty Owners | This field indicates whether the pricing record applies to any/all purchasers (Sales transactions) or to any/all royalty owners (Crown, Freehold, Override transactions). Available options include Yes or No. |
Purchaser/Royalty Owner | This field is enabled when the All Purchasers/All Royalty Owners option above is No. This is an auto-suggest for owners. The list of valid owners is limited to only those owners entered as a Purchaser/Royalty Owner on transactions for the product. This means that the transactions MUST be set up before the pricing records. |
All Sequences | This field indicates whether the pricing record applies to all sequences for the selected purchaser. Available options include Yes or No. This field is enabled for Sales transactions only. |
Sequence # | This field is enabled when the All Sequences option above is No. The sequence can be 1-99. Note: You cannot have a pricing record with All Sequences = No when there is another pricing record with All Sequences = Yes and all other fields are the same (excluding Sequence #). There cannot be mixture of all sequences and specific sequences when all other fields are the same. |
All Destinations | This field indicates whether the pricing record applies to any/all destinations. Available options include Yes or No. This field is enabled for Sales transactions only. |
Destination Type | This field is enabled when the All Destinations option above is No. Available options include:
|
Destination ID | This field is enabled when the All Destinations option above is No and a Destination Type has been selected. This is an auto-suggest for entities of the Destination Type selected. Note: An Advanced Search link will also be visible when the Destination ID is enabled to help the user select the correct entity. |
UserDefined1 | This field is a user-defined text field (maximum 16 characters) that can be entered by the user. All transaction records that use this pricing record when the Allocate button is clicked will have this text populated in their user-defined1 field. This can then be used to reconcile Purchaser statements with the sales volume and value calculated within Qbyte Metrix. Note: The label/column heading for this field defaults to UserDefined1. However, this can be changed on the User Defined Labels tab (Administration > System Configuration > User Defined Labels). Select Edit and then change the Field Label for the Field Name = PartnerOpBatteryPrice.userDefined1. |
Shipper Owner Contract | This field represents the Shipper Owner Contract used for Oil Valuation RTP submissions. This field will be used to populate the Shipper Owner Contract on the Oil Valuation RTP submission when the Generate Oil Valuation Data process is run for this battery. To run the Generate Oil Valuation Data for a Partner Operated battery the General Oil Valuation RTP field on the Battery Maintenance - Production screen must be set to Yes. This field is enabled when the Product is OIL and Transaction Type is Sales. Note: This field is only visible when the battery is in a province that is using the Oil Valuation RTP submissions. For more information on Oil Valuation RTP for Partner Operated batteries see Oil Valuation Data and RTP - Partner Operated |
Pricing Option | Available options include:
|
Allocate By | This indicates what the basis of calculation/allocation is for the pricing record. This is used when calculating/allocating Pricing, Transportation, and Pricing Deductions (Quality Adj., Tariff, Line Loss, Other#1, and Other#2). Available options include:
|
Price | This is only visible when the Pricing Option is Price Per Unit. Maximum size of 4v8 ( 9999.99999999 ). It can be negative. |
Value | This is only visible when the Pricing Option is Total Contract Value. Maximum size of 9v2 (999999999.99). It can be negative. |
Transportation Type | This indicates whether there is to be transportation costs associated with the pricing record and how it is to be calculated/allocated. Available options include:
This field is enabled for Sales transactions only. |
Transportation Rate | This is only visible when the Transportation Type is Rate. Maximum size of 4v8 (9999.99999999). It can be negative. |
Transportation Value | This is only visible when the Transportation Type is Total Amount. Maximum size of 9v2 (999999999.99). It can be negative. |
Pricing Deductions - the following fields are only visible when pricing deductions are being shown (using the Show Deductions button or having the Show Pricing Dedns. Default option set to Yes on the Battery Maintenance - Production screen). | |
Quality Adj. Type | This indicates whether there is to be quality adjustment costs associated with the pricing record and how it is to be calculated/allocated. Available options include:
This field is enabled for Sales transactions only. |
Quality Adj. Rate | This is only visible when the Quality Adj. Type is Rate. Maximum size of 4v8 ( 9999.99999999 ). It can be negative. |
Quality Adj. Value | This is only visible when the Quality Adj. Type is Total Amount. Maximum size of 9v2 (999999999.99). It can be negative. |
Tariff Type | This indicates whether there is to be tariff costs associated with the pricing record and how it is to be calculated/allocated. Available options include:
This field is enabled for Sales transactions only. |
Tariff Rate | This is only visible when the Tariff Type is Rate. Maximum size of 4v8 ( 9999.99999999 ). It can be negative. |
Tariff Value | This is only visible when the Tariff Type is Total Amount. Maximum size of 9v2 (999999999.99). It can be negative. |
Line Loss Type | This indicates whether there is to be line loss costs associated with the pricing record and how it is to be calculated/allocated. Available options include:
This field is enabled for Sales transactions only. |
Line Loss Rate | This is only visible when the Line Loss Type is Rate. Maximum size of 4v8 ( 9999.99999999 ). It can be negative. |
Line Loss Value | This is only visible when the Line Loss Type is Total Amount. Maximum size of 9v2 (999999999.99). It can be negative. |
Other#1 Type | This indicates whether there is to be other#1 costs associated with the pricing record and how it is to be calculated/allocated. Available options include:
This field is enabled for Sales transactions only. |
Other#1 Rate | This is only visible when the Other#1 Type is Rate. Maximum size of 4v8 ( 9999.99999999 ). It can be negative. |
Other#1 Value | This is only visible when the Other#1 Type is Total Amount. Maximum size of 9v2 (999999999.99). It can be negative. |
Other#2 Type | This indicates whether there is to be other#2 costs associated with the pricing record and how it is to be calculated/allocated. Available options include:
This field is enabled for Sales transactions only. |
Other#2 Rate | This is only visible when the Other#2 Type is Rate. Maximum size of 4v8 ( 9999.99999999 ). It can be negative. |
Other#2 Value | This is only visible when the Other#2 Type is Total Amount. Maximum size of 9v2 (999999999.99). It can be negative. |
Preview
The Preview section will display an approximation of what the total values will be when the pricing record is applied to all matching records. The Preview calculations are done when a previously saved pricing record is highlighted, the Preview button is clicked, or when the Save button is clicked.
The Preview calculations are an approximation of what the calculated/allocated values will be when the Allocate button is clicked. (They are only approximations because the calculations are done at the total-level, sum of all matching records, as opposed to at each well-transaction and they do not take into account different-levels of pricing records. For example, if there is a pricing record for all Oil Sales with purchaser 000001 and another for all Oil Sales with destination Plant 000003. An Oil Sales transaction with purchaser 000001 and destination Plant 000003 will be included in the Preview calculations for both pricing records. However, during the Allocate calculations, the pricing record with purchaser 000001 will be used as that level takes precedence. During the Allocate calculations, all pricing records are taken into account. During the Preview calculations, only the current record is taken into account.
The Preview calculations are based on either Net or Gross volume/GJs entered, depending upon Transaction Level on the Battery Maintenance - Production screen. When the Transaction Level is Both, the calculations are done on the Net volume/GJs only.
When Allocate By = Sale Volume, the Preview section will look as follows for Sales transactions when pricing deductions are being shown.
When Allocate By = Gigajoule, the Preview section will look as follows for Sales transactions when pricing deductions are being shown.
Possible fields in the Preview section are as follows:
Field | Description |
|---|---|
Volume | The accumulated volume of all transactions that match the current pricing record. This field is only displayed when Allocate By = Sales Volume. |
GJs | The accumulated GJs of all transactions that match the current pricing record. This field is only displayed when Allocate By = Gigajoule. |
Value | The accumulated value of all transactions that match the current pricing record. This is calculated by first either multiplying either the Volume or GJs field, depending upon Allocate By, by the entered Price when Pricing Option = Price Per Unit or when Pricing Option = Total Contract Value, simply taking the entered Value. When the Transaction Type = Sales, there is a second step to subtract any calculated pricing deductions from this value, so that it reflects the value that is being received from the purchaser. |
Transportation Value | The accumulated transportation cost of all transactions that match the current pricing record. When Transportation Type = Rate, this is calculated by multiplying either the Volume or GJs field, depending upon Allocate By, by the entered Transportation Rate. When Transportation Type = Total Amount, this is simply the entered Transportation Value. This field is only displayed when Transaction Type = Sales. |
Pricing Deductions - the following fields are only visible when pricing deductions are being shown (using the Show Deductions button or having the Show Pricing Dedns. Default option set to Yes on the Battery Maintenance - Production screen). | |
Quality Adj. Value | The accumulated quality adjustment cost of all transactions that match the current pricing record. When Quality Adj. Type = Rate, this is calculated by multiplying either the Volume or GJs field, depending upon Allocate By, by the entered Quality Adj. Rate. When Quality Adj. Type = Total Amount, this is simply the entered Quality Adj. Value. This field is only displayed when Transaction Type = Sales and pricing deductions are being shown. |
Tariff Value | The accumulated tariff cost of all transactions that match the current pricing record. When Tariff Type = Rate, this is calculated by multiplying either the Volume or GJs field, depending upon Allocate By, by the entered Tariff Rate. When Tariff Type = Total Amount, this is simply the entered Tariff Value. This field is only displayed when Transaction Type = Sales and pricing deductions are being shown. |
Line Loss Value | The accumulated line loss cost of all transactions that match the current pricing record. When Line Loss Type = Rate, this is calculated by multiplying either the Volume or GJs field, depending upon Allocate By, by the entered Line Loss Rate. When Line Loss Type = Total Amount, this is simply the entered Line Loss Value. This field is only displayed when Transaction Type = Sales and pricing deductions are being shown. |
Other#1 Value | The accumulated other#1 cost of all transactions that match the current pricing record. When Other#1 Type = Rate, this is calculated by multiplying either the Volume or GJs field, depending upon Allocate By, by the entered Other#1 Rate. When Other#1 Type = Total Amount, this is simply the entered Other#1. Value. This field is only displayed when Transaction Type = Sales and pricing deductions are being shown. |
Other#2 Value | The accumulated other#2 cost of all transactions that match the current pricing record. When Other#2 Type = Rate, this is calculated by multiplying either the Volume or GJs field, depending upon Allocate By, by the entered Other#2 Rate. When Other#2 Type = Total Amount, this is simply the entered Other#2 Value. This field is only displayed when Transaction Type = Sales and pricing deductions are being shown. |
Base Value | The accumulated base value of all transactions that match the current pricing record. Base value is calculated as Value plus Quality Adj. Value plus Tariff Value plus Line Loss Value plus Other#1 Value plus Other#2 Value. This field is only displayed when Transaction Type = Sales and pricing deductions are being shown. |
Reminder: Once you have entered all the pricing records, or you need to re-apply pricing records after making changes to transactions, use the Allocate button to apply all pricing records to their matching sales or royalty transactions and update values on the appropriate transaction tabs.
Totals
The Totals tab displays a summary of all sales, royalties and production volumes and values. Sales transactions will be summarized to the product/purchaser level. Royalty transactions will be summarized to the product/royalty type/royalty owner level. Production transactions will be summarized to the product level.
For Sales transactions, the Pricing Deductions may or may not be visible by default, depending upon the Show Pricing Dedns. Default option on the Battery Maintenance - Production screen. If not visible by default, the Show Deductions button will make the Pricing Deduction fields visible and replace the Show Deductions button with the Hide Deductions button.
With pricing deduction fields visible the Sales grid can have many columns, so the following picture shows them all at once to make it easier to review.
Edit Well Transactions
The Edit Well Transactions button allows you to add, delete, or change purchasers for a single well, multiple wells, or all wells.
All transactions pertaining to partner operated wells can be maintained using the new Edit Well Transactions button.
Clicking the Edit Well Transactions button will display the Edit Well Transactions screen.
From this screen, you can select the Action (Modify, Add, or Delete) and the Transaction Type (Sales, Royalties, or All).
Action
You must select a well (or multiple wells) from the Wells accordion before selecting an Action. The Source or Destination accordions will not be enabled unless at least one well is selected.
Once a well is selected, you can make changes to the well and then Save.
Transaction Type
Production and wellhead transactions cannot be created or changed using Edit Well Transactions. They are still accessed using the Partner Operated Battery Balance screen and the Production or Wellhead tabs.
Add Well Transactions - Transaction Type: Sales/Royalties
The Default Transaction Setting accordion is enabled when a well (or multiple wells) is selected. This grid can be used to add new sales or royalty transactions to the selected well.
Create New will create additional rows on the grid.
The Plant Facility is disabled for Product Oil.
The Purchaser Sequence always defaults to 0.
The Plant Facility entered on the transaction must be OFF production and can be from any province. For partner operated batteries in British Columbia, the Plant Facility will only be displayed for Production Dates equal to or greater than the BC Petrinex Implementation Date.
Once all data is entered, Save will create the transactions for the selected well. Rows will also be created within the Production tab for transactions that contain a Plant Facility. If the transactions already exist, a Some transactions were not saved because they were duplicates message will be displayed at the top of the screen.
Sales or royalty transactions can be added to acknowledged and unacknowledged wells.
Modify Well Transactions - Transaction Type: Sales/Royalties
The Source/Destination accordion is enabled when a well (or multiple wells) is selected. This grid can be used to retrieve existing transactions to modify from the selected well.
Transactions for the selected well can be retrieved by Product, Purchaser, and/or Destination.
Once the criteria are entered, clicking the Retrieve Transactions button will display the transactions that match the selected criteria. If the battery has a Primary Plant (Battery Maintenance > Production tab) and the primary plant is entered as the Plant Facility to retrieve transactions, Sales transactions that match all retrieval criteria, as well as the Sales Transactions that have a blank Plant Facility, together with the other retrieval criteria will be displayed.
The Plant Facility entered on the transaction must be OFF production and can be from any province. For partner operated batteries in British Columbia, the Plant Facility will only be displayed for Production Dates equal to or greater than the BC Petrinex Implementation Date.
The Reselect Transactions button allows you to start over if you do not receive the expected results. Criteria can be changed, and the Retrieve Transactions button will become enabled again.
The Destination Transaction section on the screen is enabled when a well is selected.
You can change the Product, Plant Facility, Purchaser, Sequence, Destination Type and/or Destination ID and the Perform Modification button to apply the changes to the selected well(s). A message will appear at the top of the screen if not all modifications can be applied.
Sales or royalty transactions of acknowledged wells can now be modified.
Delete Well Transactions
Transaction Type: Sales/Royalties
The Source/Destination accordion is enabled when a well (or multiple wells) is selected. This grid can be used to retrieve existing transactions to delete from the selected well.
Transactions for the selected well can be retrieved by Product, Plant Facility, Purchaser and/or Destination.
Once the criteria are entered, selecting the Retrieve Transactions button will display the transactions that match the selected criteria. If the battery has a Primary Plant (Battery Maintenance > Production tab) and the primary plant is entered as the Plant Facility to retrieve transactions, Sales transactions that match all retrieval criteria, as well as the Sales Transactions that have a blank Plant Facility, together with the other retrieval criteria will be displayed.
The Plant Facility entered on the transaction must be OFF production and can be from any province. For partner operated batteries in British Columbia, the Plant Facility will only be displayed for Production Dates equal to or greater than the BC Petrinex Implementation Date.
The Reselect Transactions button allows you to start over if you do not get the expected results. Criteria can be changed, and the Retrieve Transactions button will be enabled again.
Use the Delete Transactions button to delete the transactions from the selected well.
Sales or royalty transactions of acknowledged wells can be deleted.
Transaction Type: All
When Transaction Type = All, you are given the option to select a single well or multiple wells. When at least one well is selected, the Delete All Transactions button is enabled in the Source/Destination section.
Clicking the Delete All Transactions button will delete all sales, royalties, production, and wellhead transactions for the well(s). The Well Acknowledged status will change to No. This option is a convenient way to reset the partner operated battery.
Copyright© 2024 IFS AB. Copying prohibited. All rights reserved.