The following outlines the available settings for the MYOB Purchase Orders integration initialisation file.

Default initialisation filename:

Int_MYOBOrders_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 Orders

UseWizard

Description:

Specifies whether integration will be run manually or automatically.

Setting:

0: Integration will be run based on the values in the .ini file and can be run automatically without user intervention.

1: Integration will be run using a wizard allowing users to modify the details of the integration.

YieldMilliSeconds

Description:

Length of time to pause the program in milliseconds.

Setting:

0 (default)

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 Purchase Orders"
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 used, 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: Determines which data for MYOB Purchase Orders is updated. Setting: 1: CostCentre 2: Entity 3: Items 4: Orders 5 (default): All
OrderCriteria	Description: Criteria for selecting which jobs are updated. Setting: 1 (default): AllJobs 2: ByConstructionManager 3: BySupervisor 4: SingleJob(JobNumber)
OrderCriteriaID	Description: ID for the construction manager, supervisor, or single job as indicated in the OrderCriteria. Setting: 0 (default)
Context	Description: Region division ID if users only want to process integration for a certain context. Setting: 0 (default): All region divisions will be processed.
OnlyIntegrateNew	Description: Instructs integration to only process newly added job orders. Does not process any updated data. Setting: True: Only new records will be included. False (default): All records will be included.
StartIntegrationDate	Description: If OnlyIntegrateNew is set to True, then MYOB Purchase Orders with dates >= to the StartIntegrationDate will be retrieved. If StartIntegrationDate is set to None, then integration continues as if OnlyIntegrateNew was set to False. Setting: None dd/mm/yyyy
EndIntegrationDate	Description: If OnlyIntegrateNew is set to True, then MYOB Purchase Orders with dates <= EndIntegrationDate will be retrieved. If EndIntegrationDate is set to None, then today's date will be used. Setting: None dd/mm/yyyy

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

CostCentreCode

Description:

Determines whether MYOB accounts or cost centres are integrated to Framework ECM cost centres.

Setting:

Accounts

CostCentres

WorkOrderLinkField

Description:

Determines which field is used for work order linking.

Setting:

Memo

Comment

LinkPOsToLogisticsItems

Description:

Unlinks cancelled Orders from uncalled Construction Logistics Activities.
Links valid Orders to Construction Logistics Activities based on criteria.

Setting:

True: Link function is switched on

False: Link function switched off

Browser not supported