/
Fields - REV100A

Fields - REV100A

Search the IFS Excalibur Wiki
 

 

An entry is required for fields shown in red.

Field

Description

Field

Description

Company

Enter a company ID, or press Enter to accept the default. The company must exist in the company_master file.

Purchaser

Enter a purchaser ID or press enter to accept the default. If you have read only access to Name Address Master - COM100A, you cannot add a new purchaser and the "Insufficient access rights" message displays. If you have full access to the Name Address Master - COM100A program, the system transfers you there.

Prior to the transfer, you can check for duplicates by accessing Cross Reference at the Purchaser field. If the Purchaser you are setting up already exists in the Name Address Master, select that purchaser for use in the Purchaser Property record. If you want to set up a new purchaser, escape from the cross-reference screen back to the Purchaser field and enter "NEW" to transfer to the Name Address Master - COM100A program.

Property

Enter the ID that the purchaser uses on his check or statement to identify this property, display the properties on file for this purchaser, or press Enter to accept the default. If the property is already set up, your well ID and name display.

Well

Enter the well ID for this property. You must assign a well to the company. You must also assign a state code to this well in the Well Master. No modifications are allowed if there is an associated gross sale.

Product

Enter one or more products for this property. The products that you enter must have a product category. Therefore, A (Any) product is not valid.

Stub

Enter a check stub master ID. The Gross Sales - REV170B program, pertaining to the selected product, uses the Check Stub Master to allow input of gross sales exactly as they appear on the purchaser's checks.

A warning message displays if you do not enter a check stub ID, and the system does not allow you to use the Check Stub feature in the Gross Sales program. The Check Stub Master item must be set up in the Check Stub Master - REV148 program before you can make entries at this field.

Validation

Enter the validation code for this product or press Enter to accept the default. The default indicates that the system does all calculations from entered gross or quantity. The following is a brief summary of the validation codes:

1 - First Purchaser, all calculations. Only volume and pressure or gravity are entered in gross sales.

3 - Calculate all amounts for comparison reporting. Use calculated amounts for those not entered.

4 - Calculate all taxes from entered gross instead of calculated gross.

6 - All entered amounts are used, but amount received is still validated to amounts entered in Accounts Receivable.

7 - No comparisons or validations are wanted.

Cash

Choose whether cash is recorded for sales on this product and property. Enter Y (Yes) if cash is normally received and recorded in Accounts Receivable (AR), with property and product, and you can input gross sales from purchaser's check stubs with the system automatically defaulting information that was entered in AR.

Enter (No) in this field if gross sales originate and feed into Revenue from another system. In the auto format process for gross sales entry, only the book value is updated for properties having No cash basis.

If the field is null, no updates are made in the gross sales auto format process.

With RAR cash clearing, a Y in this field enables the entry of gross sales in detail in the revenue system. Only the amount of the sale is entered in AR. If the property has a non-cash basis (N in the field), only the amount received is required on the revenue gross sale. For these non-cash properties, temporary Gross Sales Ledger (GSL) records are created. When the batch is posted to RAR, the book value is updated and the temporary GSL's are deleted.

Rollup Property

Enter one rollup property for this product. Use this property to roll up and post receivable amounts in the Revenue Receivable system.

BLLs

Select this check box if you want to convert volumes to barrels for this product. Convert gallons to barrels (Y/N) - Applies to NGL products (category N) only. If you enter Y, the system converts the gallons entered for calculating gross sales to barrels by dividing the gallons entered by 42.

Inflation Factor

Enter gross sales at one level and have the system inflate it to a higher level. You can enter the factor by which gross sales volumes and values (entered in Gross Sales - REV170BGross Sales Check Stub - REV170C, or Gross Sales Automated Formatted) are inflated, or press enter to accept the default.

Example: If you get paid at the tract level but you want to record revenues at the unit level, enter the tract's participation factor at this field. Therefore, in this example, if tract 1 has an inflation factor of .25, the gross sale of $100 entered at tract 1 would create a gross sale of $400 for the unit.

Stripper

This field is used for Colorado DR21-W forms.

  • Enter Y if this Well/Product is from a stripper well.

  • Enter N if this Well/Product is not from a stripper well.

Exp Date

Enter the date that each purchaser's product expired. This date must be a month end. The Gross Sales Data Entry programs, Gross Sales - REV170BGross Sales Check Stub - REV170C, and First Purchaser - REV170E, compare the sales date with the expiration date. If the expiration date is equal or exceeded, the system displays a warning message but allows you to continue.

Sup Pos

Enter one of the following:

  • Y - If you want to suppress the generation of 8/8ths accounting transactions for this purchaser.

  • N - If you do not want to suppress the generation of 8/8ths accounting transactions for this purchaser.

Use this option to prevent multiple postings of the 8/8ths amounts to the property ledgers when you have more than one purchaser for the same product, for the same property (split-stream wells).

Tax District

Enter one or more tax districts as appropriate for this property for special taxes. The Revenue Gross Sales Calculation - REV178 program calculates and deducts any taxes you define for the state and the districts that you enter at this field, which you did not enter in the gross sales item and flag as remit/reimburse.

If you did not previously enter the district, you can add and display it here. The state code for the tax district must be the same as the state code in the Well Master.

Analyst

Select an analyst from the drop-down list. The analyst is responsible for monitoring the activity on the property. The following reports are available for an individual analyst:








Copyright© 2024 IFS AB. Copying prohibited. All rights reserved.