MYOB Accounts Link Interface

This section describes the fields in the Accounts Interface routine and the activities required to facilitate posting Ostendo transactions to MYOB.

The routine has 3 display panels

Panel 3 - Configuration Settings

This screen requires you to point this Accounting Interface routine to both Ostendo and MYOB.  The following fields are shown in this screen

Cutover Date: This is used to allow you to define the date when Ostendo Transactions will begin posting to MYOB.  Transactions prior to this date will be received by this function but will not be passed on to MYOB.

Ostendo Accounting File Paths

Receive Path: This defines where the Batch details received from Ostendo will be stored.  Click on the 3 dots icon and select the location of the folder.  Note: Each Company will have a pre-generated folder with AcctLink_COMPANY\Pending\ where ‘COMPANY’ is the name of your Company

Send Path: This defines where the details of the Batch - after updating MYOB - will be stored.  Click on the 3 dots icon and select the location of the folder.  Note: Each Company will have a pre-generated folder with AcctLink_COMPANY\Processed\ where ‘COMPANY’ is the name of your Company

MYOB ODBC

Company File: This defines the location of the MYOB Company database.  Click on the 3 dots icon and select the location of the database

MYOB Application: This defines where the MYOB application program (Example: C:\Premier10\Myobp.exe) is located.  Click on the 3 dots icon and select the location of the program

Username: Enter the MYOB username (Example: Administrator) required to access the Company File

Password: Enter the password used with the above MYOB username that is required to access the Company File

File Access

Single User Access: This must be set up to reflect the current way that MYOB is set up in your company

Multi-User Access: This must be set up to reflect the current way that MYOB is set up in your company

Protocol: This must be set up to reflect the current way that MYOB is set up in your company

Panel 2 - Configuration Settings

This screen requires that you map Ostendo’s Cost Centres and Tax Codes to MYOB’s Account Codes and Tax Codes.

Step 1. In the first instance you should go into Ostendo and select File>Accounting Link.   Click on the ‘Export Lookup Files’ button and that will download Ostendo’s Cost Centres and Tax Codes to this function.

Step 2. The Ostendo Cost Centres will be displayed in the left-hand column.  In the right-hand column select the equivalent MYOB Account codes from the drop-down list.

(NB: If Simplified Posting is enabled, the PURCHASE RECEIPTS Cost Centre should be mapped to a COGS GL Account in the Accounting Software)

Step 3. Click on the ‘Tax Codes’ tab down the left side of the screen to display the Tax Codes downloaded from Ostendo.  The Ostendo Tax Codes will be displayed in the left-hand column.  In the right-hand column select the equivalent MYOB Tax Codes from the drop-down list.

Panel 1 - Process

This screen lets you view the status of batches received from Ostendo. 

Within the Accounting Link screen in Ostendo a Batch is created when the ‘Export Batch Files for sending’ checkbox is ‘checked’ and the ‘Process Batch Files’ button is selected.  That batch is sent to this routine and stored in the ‘Receive Path’ location defined above.  Upon receipt the displayed text in this screen will show the number of Batches waiting to be processed

(Button) Process:  If this button is pressed then

a) All the unprocessed batches will update the appropriate Account Codes in MYOB.

Any encountered errors will be displayed for your immediate assessment.

You should note that correction and re-sending of invalid Transactions is controlled from within Ostendo.  Therefore the updated statuses for Batch and Transactions should be transferred back to Ostendo.   To do this go into Ostendo and, in the ‘Accounting Link’ screen ‘check’ the ‘Import Received Batch Files’ checkbox and then click the ‘Process Batch Files’ Button. 

b) Any new Suppliers from Ostendo will be created in MYOB and any amended Supplier details will update the Supplier record in MYOB

c) Each new Purchase Invoice received from Ostendo will be created as an Invoice in MYOB.  You should note that the Description against each Invoice line will be derived from the Ostendo Invoice line’s description.

Buttons

Close: Close this MYOB Accounting interface process and exit the screen.

Process: Process all the batches in the above ‘Pending’ folder