Allocation Spreadsheet Upload

Back to Allocation Back to Spreadsheet Uploads

1 Introduction
- 1.1 Allocation Details Spreadsheet Upload

Introduction

You can allocate dollars and volumes that have been coded to a given AFE, cost centre, and account to a different set of AFEs, cost centres, and accounts using the Allocation Controls screen (JIBS011).

Allocation Details Spreadsheet Upload

The Allocation Detail Spreadsheet Upload (ADTU001.xls) can be used to upload the Allocation To information into an allocation based on actuals or wells. The spreadsheet upload requires that the allocation control first needs to be created in the Allocation Controls screen, and that allocation detail records do not already exist on the allocation control.

Note:

If you open the ADTU001 spreadsheet using the File Explorer, you will encounter a "ValidateUniqueness() Failure - Unable to validate whether or not allocation records are unique:" error.

In this field...	Enter this information...

In this field...	Enter this information...
Control ID	The ID of the allocation.
AFE Num	The AFE to allocate costs to.
CC Num	The cost centre to allocate costs to.
Org ID	The organization to allocate costs to.
GL Sub Code	The GLsub code to use when allocating costs.
Major Acct	The major account to allocation costs to. If left blank, the costs will be allocated to the original account.
Minor Acct	The minor account to allocation costs to. Note: If left blank, the costs will be allocated to the original account.
Allocation Basis	The basis of the allocation. This field is required if the allocation method is set to W (Well).
Allocation Percent	The percent of costs to allocate. This field is required if the allocation method is set to A (Actuals).
DOI Deck ID	The DOI to use when allocating costs.
Continuity Code	The continuity code to use when allocating costs.

To upload allocation details:

1. Navigate to the menu and select Qbyte > Database Logon.

2. Enter the user ID, password and database to connect to the database.

3. To validate the data, navigate to the menu and select Qbyte > Validate Data.

4. To upload the data, navigate to the menu and select Qbyte > Upload Allocation.

After uploading:

The allocation details can still be modified in the Allocation Controls screen.
The allocation control will need to be set to Active.
If an allocation control of type W (Well) had been uploaded, the Calc Allocation button will need to be selected to calculate the percentages.