Production and Sales Distribution Details Report

Back to Qbyte Metrix List of Reports Back to Explorer

1 Overview
2 Report Structure
3 Report Columns
4 Data Export Uses
5 Selection Criteria Considerations
- 5.1 Business Associates
- 5.2 Products
6 Data Capture

Overview

This report is basically a type of balance report, but it uses volumes allocated to the entity/owner instead of at the facility level. It shows the following:

Opening Inventory
Production
Receipts
Fractionation
Transfers Out
Sales (Volume, Energy, Value and Value Net of Transportation)
Closing Inventory

In addition, the report displays details as to each delivery that the entity/owner participated in.

This report is one of the most useful reports as it can be used for almost any property, regardless of allocation method, Gas Flow, non-Gas Flow, Operated or Partner Operated. It is one of the few reports that can be run after different Step processes. After running the Step02 - Sales and Transfers process, this report can be run, and it will show all data except Sales Energy, Value and Value Net of Transportation. Even if Step02 does not complete successfully, there may be data on this report. Depending upon the type of errors that causes Step02 to fail, you may see only Opening, Produced and Closing or you may see the other Step02 columns; the data, however, may not be completely accurate. After running the Step03 - Pricing process, this report can be run, and it will now include Sales Energy, Value and Value Net of Transportation.

This report can be a great way to get an overall view of a property. It is a quick way to see which products are being processed at the various facilities, whether there are units or not, taken-in-kind royalties, transfers, taken-in-kind partners, overall facility balancing, etc. If you are taking over a desk or covering for someone on vacation or on sick leave, running this report can be a quick way to get familiar with the property and may point out specific areas you may want to take a closer look at. For the same reason, this is also one of the main reports that we request when looking at support calls. This is also the best report to use as backup to the Voucher Report for Sales, Alberta Oil Crown, and Taken-In-Kind Royalties. This report displays the data at the same level that is used to determine the Entry Definition for each of these transactions.

Report Structure

The report will start a new page when one of the following changes is made: Production Date, Facility, Control Group, or Product.

Within each page there is a header for the Producing Battery and then a header for each entity (Well, Unit, Default Source) within that Producing Battery that has volume at the current facility.

Each header will have a corresponding total; in addition for each Producing Battery there is a total for non-unit and Unit volumes, so, depending upon the data, there can be many total lines. And, finally, there is a Product total for the current facility.

The Producing Battery header may also contain a Transferred from battery. The Transferred from battery indicates the battery that sent the volumes to the current facility. This is only displayed when the battery that sent the volume is not the same as the Producing Battery. It is possible that the current facility receives volumes on behalf of the same Producing Battery from more than one battery, depending upon how the volumes flow through the Control Group.

For example: Battery RANGO4 sends Oil to both Battery RANGO1 and RANGO2. Battery RANGO1 sends Oil to Battery RANGO2 (including some of the Oil it received from RANGO4). In this case RANGO2 has some Oil from RANGO4 that came directly from RANGO4 and some Oil from RANGO4 that came through RANGO1.

Report Columns

Report Column Name	Description

Report Column Name	Description
Participant	Owner ID/Name This represents the owner of the volume.
Part. Type	Participant Type This indicates the source of the volume. Possible values are: WIO - Working Interest Owner CRWN - Crown Royalty ROY - Production Royalty RLO - Recovered Injection XWIO - Working Interest Transfer XCRWN - Crown Royalty Transfer XROY - Production Royalty Transfer XRLO - Recovered Injection Transfer EXVO - Exchange Owner (Volumetric) EXVA - Exchange Owner (Financial)
Royalty Payor	Owner ID This represents the owner that produced the volume and gave it to the Participant in-lieu of a cash royalty. Populated when Participant is a Royalty Owner, either from Alberta Oil Crown or a Taken-In-Kind Royalty Obligation.
Open Inv	Opening Inventory Volume
Transfers Received	Transfers Received Volume (Incoming) This is the volume that was received from Battery-to-Battery Oil Transfers or Gas and By-Product Inventory Transfers.
Fractionation	Fractionation Volume (Incoming) This is the volume of Spec product that was processed from Mix Fractionation. This will only be populated for Saskatchewan plants using Mix Fractionation. For more information, see How to Use Mix Fractionation at Saskatchewan Plants .
Produced	Production (Incoming) This is the volume that was produced.
Transfers Sent	Transfers Sent (Outgoing) This is the volume that was delivered as Battery-to-Battery Oil Transfers or Gas and By-Product Inventory Transfers.
Sent for Fractionation	Sent for Fractionation (Outgoing) This is the volume of Mix product that was put through the Mix Fractionation process. This will only be populated for Saskatchewan plants using Mix Fractionation. For more information, see How to Use Mix Fractionation at Saskatchewan Plants .
Sales	Sales Volume (Outgoing) This is the volume that was delivered as anything other than Transfers (Battery-to-Battery or Inventory Transfers). Note: This does not mean the volume was sold; it just means that some sort of custody transfer has taken place. For example, volume lost due to Fire, Theft, Spill or Blending Shrinkage will be reported under this column. Similarly, Oil delivered for Load Injection will also be reported in this column; as in Qbyte Metrix oil volume injected for load purposes is deemed sold.
Energy	Gigajoules This is the energy associated with any Gas or Raw Gas sales volume. Note: This will only be populated when the report is run after Step03 - Pricing has been processed.
Sales Value	Value ($) This is the value of any sales volume. This reflects the adjusted sales value, which is the value associated with the sales based on the entered price/contract amount less any pricing deductions (Quality Adjustment, Tariff, Line Loss, Other#1 and Other#2) entered on the Pricing screen. Note: This will only be populated when the report is run after Step03 - Pricing has been processed.
Sales Value Net of Transportation	Value Net of Transportation ($) This is the Sales Value less any associated transportation cost (entered on Pricing screen). Note: This will only be populated when the report is run after Step03 - Pricing has been processed.
Close Inv	Closing Inventory
Purchaser	Owner ID/Name or Purchaser Type For deliveries that have an actual Purchaser, this column will contain the Owner ID/Name of the Purchaser. For deliveries that do not have an actual Purchaser (i.e. Facility Transfers, Losses due to Fire, Theft, etc.) this column will contain the Purchaser Type.
Rev Rec'd	Revenue Received This is the indication of whether the delivery is Receiving Revenue or not. This flag indicates whether you, as the Owning Company, are responsible for marketing and collecting revenue for this delivery. For deliveries other than some sort of transfer, this flag is typically No when the Participant is a taken-in-kind partner and is responsible for the marketing of their own volume. The possible values are: Yes or No Note: A Revenue Received value of Yes does not necessarily mean that there is a non-zero dollar amount associated with the delivery.
Disposition System	Destination Type/ID/Name This is the destination of the delivery. Not all deliveries have destinations (i.e. Losses due to Fire, Theft, etc.)

The following additional fields are available when the report is exported to Excel, unformatted.

Column Name	Description

Column Name	Description
Obligation Id	This is the Royalty Obligation Id for a Taken-in-Kind royalty and will only be populated on rows with Part. Type = ROY or XROY or with Royalty Part. Type = ROY. This may be useful when there is more than one obligation payable to the same Royalty Owner.
Pricing UDF1	This is the User-Defined field associated with the corresponding Pricing record associated with the sales.
Cost Centre Code	This is the Cost Centre associated with the well/tract.
Transportation Value	This is the actual Transportation Value associated with the sales.
Quality Cost	This is the actual Quality Adjustment Cost associated with the sales.
Tariff Cost	This is the actual Tariff Cost associated with the sales.
Line Loss Cost	This is the actual Line Loss Cost associated with the sales.
Other1 Cost	This is the actual Other#1 Cost associated with the sales.
Other2 Cost	This is the actual Other#2 Cost associated with the sales.
Base Sales Value	This is the value associated with the sales based solely on the entered price/contract amount without entered pricing deductions (Quality Adjustment, Tariff, Line Loss, Other#1 and Other#2).

Data Export Uses

Although the report itself is extremely useful, exporting the report to Excel, unformatted, provides you with even more ways to use the data. When the report is exported, in addition to the Sales Value and Value Net of Transportation, a Transportation Value column is available. (There was not enough room on the report to show both Value Net of Transportation and Transportation Value.) This column can be used to verify the Transportation booked when you are booking Pricing Transportation instead of using Facility Charges.

In addition to using the exported data for filtering and accumulating to get various sub-totals, etc., there are various other checks that you can do with the exported data. Below are just a few examples; we are sure that there are many other useful ways you could use this data.

Finding Crown Closing Inventories

The Alberta government does not take kindly to its volumes sitting in inventory, and, therefore, a common business practice is to deliver Alberta Oil Crown volumes first so that none remain in inventory, if possible. The easiest way to check that there is no Crown in inventory is to use the filtering capability in Excel.

First, filter on either Part. Type or Participant Type Name, whichever you are most comfortable with, and select any that appear in your list that are associated with Crown. When using Part. Type the values are the underlying Qbyte Metrix codes, and when using Participant Type Name, the values are more descriptive. Note: A list of the codes and the descriptions are listed in the Report Columns section under Part. Type.

Second, filter on the Close Inv column, looking for non-zero volumes.

Finding Negative Closing Inventories

You may want to look for negative closing inventories at an entity/owner to identify either over-lifting situations or maybe where your Market Master may not be set up correctly. The easiest way to do this is to simply click on the Close Inv filter in Excel. This displays a list of the values it found in the spreadsheet, in order, so any negative volumes should be at the top of the list.

Finding Receipt Closing Inventories

A common business practice is to try to deliver any received volumes before you deliver production so that you reduce the volume of inventory you are carrying on behalf of others. To help you identify potential issues, you can use the filtering ability in Excel.

First, filter on either Part. Type or Participant Type Name, whichever you are most comfortable with, and select any that appear in your list that are associated with Transfers. When using Part. Type the values are the underlying Qbyte Metrix codes, and when using Participant Type Name, the values are more descriptive. Note: A list of the codes and the descriptions are listed in the Report Columns section under Part. Type.

Second, filter on the Close Inv column, looking for non-zero volumes.

Selection Criteria Considerations

Business Associates

When this report is run with one or more Business Associates selected, only those rows where the Business Associate is a Participant will be included. Rows where the Business Associate is the Royalty Payor for another Participant will not be displayed. Consider running the Partner Production and Sales Distribution Details report if you are looking for this information.

Products

When this report is run with one or more Products selected, only rows for that product will be displayed. There is no automatic handling of Parent/Child products, Gas/Raw Gas or BYP (Liquid By-products). For example, if you select C4 you will not see any records for C4MX, C4SP, IC4MX, IC4SP, NC4MX or NC4SP.

Data Capture

The data associated with this report is calculated during Step01 - Allocations, Step02 - Sales and Transfers and Step03 - Pricing . The report can be run after Step02 - Sales and Transfers and the report will basically be complete, but the Sales Energy, Value and Value Net of Transportation will not be populated. Only after running Step03 - Pricing will all columns on the report be populated. However, if Step02 - Sales and Transfers happens to not complete successfully, this report can still be run. Depending upon the errors that caused Step02 to fail, there may or may not be any data related to outgoing transactions, or that data may be partial data only. However, the data related to incoming data (Opening Inventory, Production, Transfers Received, Fractionation) will be populated.