| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
Return to MYOB Accounts Receivable Integration
Article Index
| Table of Contents |
|---|
The following outlines the available settings for the MYOB the MYOB Accounts Receivable integration 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. |