The following outlines the available settings for the MYOB Accounts Receivable integration initialisation file.

Default initialisation filename:

Int_MYOBClaims_Default.ini

Settings

Key

Description/Setting

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

Databases

Key	Description/Setting
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 Configuration

Key	Description/Setting
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)

Criteria

Key	Description/Setting
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

Consistency

Key	Description/Setting
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

Special Values

Key	Description/Setting
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)

Actions

Key

Description/Setting

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.

Browser not supported