Exporting Purchase Orders from Streamtime to MYOB
In Streamtime, all exporting is done from the list screen. Purchase Order exports for accounts packages are done from the Orders > List Orders screen.
Streamtime will export Order details from the supplier, including supplier invoice number and amount to MYOB.
As with Invoices, before attempting to export Orders, make sure the supplier name is entered in MYOB.
Perform a find for orders that have a status of “Received”. These are completed orders with a supplier invoice number entered that haven't been exported to MYOB yet.
Once you have a list of Received Orders, click 'Export' and confirm by selecting 'Yes'.
A Dialog box appears asking where you want to save the exported file.
Ensure you select “Tab-Separated Text”, and name and save the file.
The next dialog to appear on the screen asks if you want to set these Orders as exported. We recommend that you leave this dialog on screen, and open MYOB and import the Orders using the next steps below. If the import is successful, come back to Streamtime and select “Yes”.
Importing Orders to MYOB from Streamtime
In MYOB go to File > Import Data > Purchases > Service Purchases
MYOB will now ask to confirm the file format for the import. Make sure "Data Record" is selected against the 'First Record is:' field, leaving the rest as default. You may need to re-name the file as a .txt file on a Mac before importing with some versions of MYOB.
The next window shows the first record from your import file on the left, and the right list window shows the fields in MYOB.
Clicking the Match All button will automatically match the ‘Import Fields’ in the left list with the ‘MYOB Fileds’ in the right list.
The first time you select 'Match All' it is important that you scan down the right list window checking that each import field will be imported into the correct place inside MYOB. This prevents errors with invoices that may be rejected during the import.
Click the 'Import' button to continue.
Errors during an MYOB import can be identified by checking the MYOBLOG.TXT file that is created by MYOB after you perform an import. This file will identify error Order and indicate why they were rejected (use excel to open this file). The location of this file is usually indicated at the end of the import process.
We have a Knowledge Base article which explains common MYOB errors and how to resolve them here.
How to do a manual match in MYOB?
Make sure you are on the Import Data screen. DO NOT click on the Match All button. Instead select the data field you want to import in the left window list (single click to highlight). Click on the target field in MYOB in the right window list. This action will link the import data to the correct import field. When all required fields have been matched click on the import button to continue.
Note: All fields marked with an astrix must be imported (* = these are required fields).
Please review our webpage for full details here - Accounting Integration Chart