FAQ
- About TransPost
- MYOB ODBC
- Configuration
- General Use
- Importing Customers
- Importing Sales
- Specific Errors
About TransPost
Q: What does TransPost do?
A: TransPost creates a savable mapping for data in comma delimited flat files and imports it into MYOB through the MYOB ODBC.
Q: What data does TransPost import.
A: TransPost imports Customer Cards, Sales, Jobs, and Activity Slips.
Q: What operating systems does TransPost run on
A: TransPost runs on Windows XP, Windows Vista and Windows 7.
Q: What versions of MYOB is TransPost compatible with?
A: TransPost works with:
- AccountRight Enterprise v19.x
- AccountRight Premier v19.x
- AccountRight Plus v19.x
- AccountRight Standard v19.x
- Premier Enterprise v6.5
- Premier v12.5
- Accounting Plus v18.5
- Accounting v18.5
- Premier Enterprise v6
- Premier v12
- Accounting Plus v18
- Accounting v17 (2008 release only)
Q: Does TransPost work with AccountRight 2011?
A: No. MYOB has not released the ODBC for AccountRight 2011. When it is released we will release an update to take advantage of this.
Q: When will this be?
A: Unknown. MYOB states in their support notes that: "A new ODBC driver is being developed for use with MYOB's 2011 feature releases and will be available shortly." Accountright 2011 Premier is slated for release in the third quarter of 2012 and it is likely that this will be
Q: Can I use TransPost over a network?
A: MYOB isn't designed to be used over a LAN. It requires a copy on each machine or a Terminal Services network. Each copy of MYOB and by extension each copy of TransPost will only work on the machine that it was intalled
MYOB ODBC
Q: What is the MYOB ODBC?
A: The ODBC is a software protocol that allows data exchange into the MYOB database.
Q: How do I Activate the MYOB ODBC?
A: For Australia go to https://my.myob.com.au/Pages/ODBCActivation.aspx
You will be required to quote the TransPost add-on Solution activation number - 3588465 - and your MYOB serial number.
Configuration
Q: What is the Activation Key?
A: The TransPost Activation key is a unique key that is for your copy of MYOB. Click on 'Registration & Activation' and enter your details.
Q: What is my MYOB serial number?
A: Your MYOB Serial Number is a unique 12 digit number that is used to identify your software. It is located on the back of your software CD sleeve (for boxed products), or provided by MYOB when purchasing a downloaded version.
It can also be found in MYOB 'Setup' --> 'Company Information'
General Use
Q: What file formats does TransPost import from?
A: TransPost imports from comma delimited flat files (CSV).
Q: Is it possible to get carriage returns from a csv file into MYOB. eg. In the notes of description sections?
A: Unfortunately not. The MYOB ODBC takes the input and rebuilds it starting a new record with the second part of the field.
Importing Customers
Q: What is needed to import a customer?
A: CoLastName is the only mandatory field in the customer data type. Howerever it is highly recommended that you supply a unique CardID to simplify identifying the customer when importing a sale.
Q: Can I modify a customer card with TransPost?
A: Not at this time.
Importing Sales
Q: I cannot find the field for Customer PO#.
A: Customer PO# is called CustomersNumber.
Q: I cannot find the field in 'Item Sales' for Ship.
A: The field Ship is called Quantity.
Q: Why aren't they called the same thing?
A: Because MYOB called them different things in the MYOB ODBC.
Specific Errors:
Occurs when trying to register using TransPost 1-2-2-64.
Solution: Download and install the latest version of TransPost.
Occurs when trying to import a sale requiring an account when a default account is not set.
Solution: Run TransPost Configuration and supply a default account. This will be the account used for a sale when the account is not supplied with the sale
The MYOB ODBC requires the following information to access a Company File:
- MYOB Program pathname
- MYOB company file pathname
- MYOB ODBC driver name
- MYOB username
- MYOB Password
You have not filled in all the required information in the TransPost Configuration.
Solution: Run TransPost Configuration and fill in this information. If your MYOB username does not have a password go into MYOB and create a password for your username.
The MYOB ODBC driver name you have entered in TransPost configuration is incorrect.
Solution: The appropriate ODBC driver and driver names for each version of MYOB that TransPost is compatible with are as follows:
|
Region |
Release Year |
Release Version |
ODBC Version |
Driver Name |
|
AU |
2010 |
AccountRight Enterprise v19 AccountRight Premier v19 AccountRight Plus v19 AccountRight Standard v19 |
10 |
MYOAU1001 |
|
2009 |
Premier Enterprise v6.5 Premier v12.5 Accounting Plus v18.5 Accounting v18.5 |
9 |
MYOAU0901 |
|
|
2008 |
Premier Enterprise v6 Premier v12 Accounting Plus v18 Accounting v17 |
8 |
MYOAU0801 |
|
NZ
|
2010 |
AccountRight Enterprise v19 AccountRight Premier v19 AccountRight Plus v19 AccountRight Standard v19 |
9 |
MYONZ0901 |
|
2008 |
Premier Enterprise v6 Premier v12 Accounting Plus v18 Accounting v18 |
8 |
MYONZ0801 |
Reason: You have an old MYOB ODBC driver that does not have the field CompanyFileNumber. This number is vital to TranPost.
Solution: Upgrade to a more recent version of MYOB. (Not AccountRight 2011 until further notice.)