Integration Profile Configuration
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.
Integrated Fields
The integration of MYOB Accounts Receivable to Framework ECM is fixed in the content that is exchanged between the systems. There are no user-configurable integrated fields available for this type of integration.
...