Open

Back to IFS Excalibur & IFS Land Integration

IFS Excalibur and IFS Land System Setup

IFS Land and IFS Excalibur must have identical land payment information for the interop to work correctly. Review the following setup screens to ensure Check and Invoice Interoperability is successful.

IFS Land System Setup

Address Book Setup

The EXTERNAL_INTERFACE_ASSEMBLY_LOCATION configuration under Administration > Common should point to the location of the address book parser assemblies on the app server.

Check Invoice Setup

The CHECK_INVOICE_INTERFACE_SYSTEM configuration under Administration > Common should have the value MIDCAP.

IFS Excalibur System Setups

In order to update Leases from IFS Land, the user must run the IFS Excalibur 159181.POST utility to create the appropriate index for updates to be possible. This is performed by IFS Services during implementation.

Interop Default Master (IO295)

In the Interop Default Master (IO295) screen, IFS Land Interoperability must be selected.  In addition, you can choose a default company for interoperability.

The standard supported workflow requires the IFS Land Originates Land Leases and Land Payments and Check and Invoices Printed within Accounting boxes to be selected.

Open

Print Setup Defaults (COM294)

In the Print Setup Defaults (COM294) screen, under Land Lease Records, the Certex Printing checkbox should be selected if Certex is in use.  

Land/Lease System Setup (LLR295)

In the Land/Lease System Setup (LLR295) screen, GL Accounts must be assigned for all desired Land Payment Codes, i.e. DR, SI, AR.

GL Accounts

The GL Accounts from IFS Excalibur should be set up in IFS Land. There are six different kinds of accounts:

• CASH OPERATING ACCOUNT

• WITHHOLD ACCOUNT

• BANK SERVICE CHARGE ACCOUNT

• SUSPENSE ACCOUNT

• PAYOR ACCOUNT BASED ON GROUP CODE

• PAYMENT TYPES

• RECEIVABLES ACCOUNT

• PAYABLE ACCOUNT

The GL Accounts should be linked to the code and rule tables:

• Link Cash Operating Account to Bank Account Codes Table

• Link Withhold, Suspense and Bank Service Charge Accounts to Payment Type Codes Table

• Link Receivables Account to the Invoice Form Codes Table

Cost Center Setup

IFS Excalibur Cost Center next number must be reset during the implementation of this integration to ensure the Lease and Cost Center are built with the correct unique ID and errors are prevented.

• Errors generated from IFS Land clash with Cost Centers created for other Accounting purposes.

IFS Land will continually generate Cost Centers when Accounting is simultaneously generating Cost Centers. The IFS Land Cost Center next number will begin in a separate block of numbers within IFS Excalibur. This is the same approach used for the next number related to Check Numbering.

IFS Excalibur Code Setup

The following codes must be set up in IFS Excalibur, and IFS Land codes must be set up to match. Codes must be manually synchronized during initial setup.

• Country, State and County Codes

• Prospect Codes (LLR165)

• Land Payment Codes (LLR184)

• Bank Account Codes (COM168)

• Payment Type Codes (AP190)

• Invoice Type Codes (AP170)

• Mineral Type

• Product Category Codes (EPA165)

• Lease Status Codes (LLR162)

• Participant Interest Type Codes (LLC122) 

• Date Type Codes

• Well Type Codes (LLR176)

• Well Status Codes (LLR180)