Framework Preparation

For MYOB Accounts Receivable integration to be successful there are several requirements to be aware of:

External System Link (Accounts Reference)

To successfully use MYOB Accounts Receivable integration the job must already exist in MYOB, and it must be known to Framework ECM.

The job will be known to Framework ECM if the job numbers are the same in each system or if the job number as it appears in MYOB is entered into the Accounts Reference field on Framework ECM's Job Overview screen.

Invoice Numbers

Invoice numbers used when invoicing in Framework ECM must be unique and must not have been previously used in MYOB.

Not Applicable Functionality

To exclude a claim from integration, simply enter N/A in the Accounts Reference field of the Claim dialog.

Reconciliation

A full reconciliation between Framework ECM and MYOB must be completed before performing MYOB Accounts Receivable integration.

For all of the jobs that are to be integrated, both Framework ECM and the accounting system must contain the same invoices and receipts as each other, establishing a clear starting point for automated integration. For assistance with this reconciliation and for any mass data updates, contact Insula Software.

MYOB Accounts Receivable Integration Pre-Requisites

All Jobs Must Be In The Correct Work Flow Stage

Reports should be run to ensure that all jobs are up-to-date in the system. They should be in the correct major stage (Pre-Administration, Administration, Construction or Maintenance).

Work Flow Reporting Must Be Working Correctly

Common reports must be correctly set up and returning correct data.

Accounts Integration Must Be Running Correctly

Accounts integration must be running daily. All jobs must be being created and updated in MYOB.

Processes For Rolling Out MYOB Accounts Receivable Integration

Client Focussed Reporting

Obtain the current letters/reports that are currently being used by the client and customise the common reports to accommodate their needs.

Ensure that the unallocated payments formula is applicable.

Claims Rounding Method

Confirm the current claim rounding method used in the client's contracts and set the claims rounding method preference to reflect this.

Method For Raising Claims

Identify whether claims are raised on Forecast or Actual Completion dates. If claims are raised on forecasts, remove any manual forecast dates that are forecasted further out than the next construction day meeting.

Implementing The Claims Template

Confirm that the claims template(s) have been created in the Administration module of Framework ECM. If they haven't, assist the client in implementing them.

Building Contract Amount

Ensure that the building contract amount exists and is correct on the Building Contract screen.

Existing Variations (Post Contract Variation (PCV)/ Building Variation (BV))

Set the status of any existing Post Contract and Building Variations to Draft.

Applying The Claims Template

Apply the claims template to all existing jobs with a contract signed date to PCI Complete.

Checking The Claims Breakdown

Check the claims breakdown against the signed building contract to ensure that they are exactly the same. If they are not, modify the claims manually to match the signed building contract.

Creating Historical Variations (PCV/BV)

Create any historical variations (PCVs/BVs) as a one line variation item including total value.

Raising Invoiced Claims

Raise all claims that have been invoiced in the accounting system:

Enter the claim invoice date.
Enter the invoice number into the accounting system.
Set the exported flag to Yes.

Creating Payments In Framework ECM

Create the payments in Framework ECM that have already been received in the accounting system (linking them to the claim stage).

Resetting The Claim Rounding Method (Recommended)

Discuss with the client the different rounding methods available in Framework ECM and set the claim rounding method (preference) for the yet to be prepared contracts/new jobs.

Testing

Set up both the Framework ECM and MYOB databases in a test environment for extensive testing.

System Backup

Backup both the Framework ECM and the accounting system's database.

Go Live

Turn on claims integration.

Both systems will need to be kept up-to-date between the end of data entry and go live. This involves updating both systems manually (Raising Invoice Claims and Creating Payments in Framework ECM).

Procedural Requirements

With the implementation of claims integration, several procedural requirements should be observed when working with Framework ECM and MYOB.

Processing Initial Deposits

When commencing claims integration, the receipting of all money through MYOB means that no deposits/payments should be recorded directly into Framework ECM.

A procedural change is required that when a new job is created, the initial deposit date should be recorded but the initial deposit amount should be left as zero (0).

The receipting of the deposit into MYOB will create the deposit in Framework ECM, ensuring the jobs are reconciled between the two systems.

Not following this procedure and recording the deposit amount in Framework ECM will result in the deposit being doubled when integration is performed.

With this procedural change, Framework ECM will show an initial deposit of zero (0) and separately the integrated deposit from MYOB. This is normal and theFramework ECM initial deposit entry should be ignored.

Claims Preparation

The following work flow model displays the process by which claims are prepared before implementing Framework Integration with the third party application.

Framework Guides

MYOB Accounts Receivable Integration - Preparation