MYOB Purchase Order Integration - Profile Configuration
- Julie Doyle-Whitelock (Deactivated)
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:
Setting: True: Link function is switched on False: Link function switched off |