Gross Sales Allocation Process - REV153

The gross sales allocation process allows you to enter gross sales (GSLs) at a meter/lease level and allocate them down to individual wells for calculation, distribution, and payment. You can set up and maintain the necessary allocation schedules to relate meter/lease level wells and their subordinate individual wells using the Gross Sales Allocation Schedule - REV152 entry screen.

Use either the Gross Sales Batch - REV170A program or the CDEX interface to enter GSLs into a batch. You can enter GSLs for both meter/lease level wells and individual wells in the same batch. In either case, you must calculate them using the Revenue Gross Sales Calculation - REV178 program. The Revenue Gross Sales Calculation - REV178 program checks to see whether any of the GSLs are for meter/lease level wells and then automatically flags the batch and the applicable GSLs as requiring allocation.

Once the system successfully calculates all GSLs in an allocation-required batch, you must allocate them using the this program before you can do any further processing on this batch. This process allocates the meter/lease level GSLs into new multiple individual well-level GSLs. Any individual well level GSLs in the batch are left alone. The allocate flag on the batch is set to `A' to indicate that the batch has gone through the Gross Sales Allocation Process - REV153 program. The Gross Sales Allocation process prints a report of successfully allocated batches, including the new GSL IDs, or a report of unsuccessfully allocated batches. Once these new individual well level GSLs are allocated, you can maintain them as necessary using REV170. You must calculate these new GSLs using the Revenue Gross Sales Calculation - REV178 program. Once they are calculated, you can distribute and pay them following the normal GSL processing cycle.

A Purchaser Property Master record must be set up for each well you want to allocate to. The purchaser must be the same as the purchaser on the 'allocated from' Purchaser Property Master. The property number must be the P2 Excalibur well number.

The gross sales data entry programs and related processes require each gross sale to have a division order. Since gross sales entered at the meter/lease level are never distributed to owners at the meter/lease level, you must create a fictitious division order for the product `A'ny. If you are entering net amounts during GSL entry, the fictitious division order must have a correct receiving interest.

Both the "allocated-from" and the "allocated-to" gross sales exist in the gross_sales_ledger file. All reports and processes use the "allocated-from" GSLs until the "allocated-to" GSLs are created by Gross Sales Allocation Process - REV153; the "allocated-to" GSLs are then used.

You can generate GSL reversing entries in the Gross Sales Reversals - REV170F program using the "allocated-to" GSLs only. You cannot reverse the "allocated-from" GSL. Also, you can only reverse the distribution of the "allocated-to" GSLs using the Gross Sales Distribution Reversal - REV182 program.

Run the following reports after gross sales calculation:

The reports listed above aid in finding errors and provide good balancing tools for cash. If you make changes to any gross sales item, rerun the Revenue Gross Sales Calculation - REV178 program and any or all of the reports listed above to verify the changes.