MYOB Accounts Receivable Integration - Profile Configuration

IntegrationType

Description: 

Specifies the type of integration to be performed. This is a fixed value that should not be changed.

Setting: 

MYOB Claims

ODBCConnectionType

Description: 

Indicates if the MYOB database is SQL Server or Microsoft Access.

Setting: 

1 (default): SQL Server

2: Microsoft Access

ODBCDSN_Framework

Description:

ODBC DSN name for the Framework ECM database.

Setting: 

FworkSQLEcm

ODBCConnect_Framework

Description:

ODBC DSN connection string for the Framework ECM database.

Setting: 

None

ODBCDSN_FrameworkLicense

Description:

ODBC DSN name for the Framework licence database.

Setting:

FworkSQLLic

ODBCDSN_Destination

Description:

ODBC DSN name of the MYOB database.

Setting:

MYOB ODBC

ODBCConnect_Destination

Description:

ODBC DSN connection string for the MYOB database.

Setting:

"uid=enterUserName;pwd=enterPassword"

Mail_System

Description:

Email delivery method.

Setting: 

0: No email will be sent.

1: Email will be sent using MAPI.

2 (default): Email will be sent using SMTP.

Mapi_Profile

Description:

Microsoft Outlook user profile name.

Setting:

(default): Outlook

Mail_From

Description:

Name or email address of who/where the email is being sent from.

Setting:

FrameworkIntegration

Mail_Recipient

Description:

Mail recipients for the integration logs. Multiple addresses can be added if separated with a semi-colon (;). Spaces are not necessary before or after the semi-colon.

Setting:

enterRecipientEmail@yourDomain.com.au;integrationsupport@insulagroup.com.au

Mail_Subject

Description:

Email subject heading.

Setting:

"Framework Integration: MYOB Accounts Receivable"

SMTP_Server

Description:

If using Mail_System 2 (SMTP), add the SMTP Server name.

Setting:

enterSMTPServerName (replace this text with your SMTP Server name)

SMTP_UseSecurity

Description:

Security setting for the SMTP server.

Setting:

0 (default): A username or password is not required.

1: A username and password is required. If this setting is implemented, the SMTP_UserName and SMTP_Pwd fields must have a valid username and password.

SMTP_UserName

Description:

Valid username for the SMTP server.

Setting:

enterUserName (replace this text with a valid SMTP Server User Name)

SMTP_PWD

Description:

Valid password for the SMTP username.

Setting:

enterPassword (replace this text with a valid SMTP Server Password)

CriteriaMethod

Description:

Job selection criteria for retrieving records from Framework ECM to process.

Setting:

1: Single region/division.

2: Single job.

3: Single team.

4 (default): All jobs.

5: Accounts entity.

CriteriaData

Description:

Input criteria data for the criteria method.

Setting:

0

DepositRunStartDate

Description:

Date used to select receipts that were entered into MYOB after or on this date.

Setting:

01/01/2006

DepositRunEndDate

Description:

Date used to select receipts that were entered into MYOB before or on this date.

Setting:

01/01/2006

ConsistencyCheckout

Determines whether the consistency check process calculates the totals for each claim or all claims for the job.

1 (Default): Claim

2: Job

PreAdmin

Description:

Indicates whether the consistency check includes the Pre-Administration stage.

Setting:

False

Admin

Description:

Indicates whether the consistency check includes the Administration stage.

Setting:

True

Construction

Description:

Indicates whether the consistency check includes the Construction stage.

Setting:

True

Maintenance

Description:

Indicates whether the consistency check includes the Maintenance stage.

Setting:

False

MYOB_TaxCode

Description:

Value for the MYOB tax code.

Setting:

GST (default)

MYOB_AccountNumber

Description:

Value for the MYOB account number.

Setting:

49000

MYOB_PaymentDueCode

Description:

Value for the MYOB payment due code.

Setting:

2 (default)

MYOB_BalanceDueDays

Description:

Value for the MYOB balance due days.

Setting:

0 (default)

ActionCreateInvoices

Description:

Creates a file of Framework ECM claims invoices in a format that can be inserted into MYOB.

Setting:

0: Framework Integration will not create invoices.

1 (default): Framework Integration will create invoices.

ActionProcessReceipts

Description:

Retrieves MYOB receipts and inserts them into Framework ECM, updating invoices in the process.

Setting:

0 (default): Framework Integration will not process receipts.

1: Framework Integration will process receipts.

ActionCheckingConsistency

Description:

Checks that Framework ECM and MYOB have matching invoices and receipts.

Setting:

0 (default): Framework Integration will not check consistency. 

1: Framework Integration will check consistency.