TransPost Version History
Version 3.3.6 - Released May 2019
Product Versions | |
TransPost 3.3.6.604 | |
TransPost Express 3.3.6.605 | |
Transpost Plus 3.3.6.608 | |
TransPost Premier 3.3.6.609 |
New Features
Customer Payment Allocation
In this version a payment can be allocated automatically over a number of invoices. If a Total Amount value is supplied without a specific invoice number that total amount will be allocated to pay off amount outstanding to invoices starting with the oldest until the total amount is allocated. Any surplus will be applied to the last applicable invoice which may wind up with a credit, but only if gthere are no more suitable invoices to apply it to. To allocate payments all that is required is to identify the customer, by either card ID or name and specify the total paid and the deposit account, which may be set as a default in the mapping. Optional extra fields are:- Receipt Number - If available it will speed up the process for checking that the payment has not yet been processed. If not supplied AccountRight will generate one.
- Payment Date - We recommend this. Without it it will default to today but the process for checking that the payment has not yet been processed will be slower
- Customers Number - restricts the payment to be applied only to invoices with the specific Customers Number
- Invoice Date - restricts the payment to be applied only to invoices with that date
- Memo as for allocated payments, any text you wish to use to describe the payment
Transfer Money
This simple new transaction imports Transfer Money transactions. It is available only in TransPost Plus and TransPost Premier.All that it requires is Date, From Account, To Account and Amount. Optionally TransferNumber, Memo and Category can be imported too.
Note: This feature is not available for Classic MYOB.
Activity Slips
Activity Slips have always been available for Classic AccountRight users in TransPost Plus and TransPost Premier. They can now also be imported into AccountRight Live.Other Changes
When Importing Jobs, if no description is provided one is constructed out of the Customer name if applicable and the Job Number.Miscellaneous Fixes
The following problems have been fixed:- In TransPost Plus and Premier, importing Purchases of Items which were not sold now works.
- In Configuration & Activation, the Online Authorisation button would not reliably
initiate the process of setting of a new Authorisation when an existing one already existed.
This is a problem when the existing authorisation is already linked to a log-in which no longer has
the requred permissions, as can occur when the original authorising staff member leaves the business.
This is now fixed.
- If a license serial number is copy/pasted from an email, applications such as Outlook tended to add a space on the end which invalidated it. As this has been the source of many bewildered support requests, the registration process now strips such spaces off automatically.
- TransPost Premier will now permit configuring files with different MYOB serial numbers. This is required when upgrading from Classic MYOB to AccountRight Live if the AccountRight Live license has a different serial number and files are being upgraded at different times.
- In TransPost Plus and Premier, Heading lines now work correctly in Purchases. Note: This feature is not available for Classic MYOB.
- A few users were getting the error "Unexpected error 3327 importing settinsg: An existing connection was forcibly closed by the remote host" which turns out to be caused by local system security settings forcibly blocking the response to activation and registration. This has been addressed in versions 3.3.5.571 onwards.
- The Update option for Jobs now works. Existing Jobs can be updated in both AccountRight Live and Classic MYOB.
- Occasional a tax amount of -0.5 cents would appear on tax free items because there was a carry-forward tax rounding. This carry-forward rounding will now only be applied to items with GST.
- When importing SpendMoney transactions TransPost often identified a transaction as already imported because there was a vaguely similar one. It was previously just checking payment number, date, payee card and memo if present, any or all of which might not be sup[plied in the data. Now it checks more details including accounts and amounts before concluding that a transaction has already been imported.
- In TransPost Plus there were also similar issues with Receive Money which have also been fixed.
- When configuring a company file the User ID and Password field are for the User ID and Password for the company file itself but for online files they can be omitted as this is linked to the online login. This is frequently,understandably, misunderstood so if an email style user ID is entered for an online file a pop-up will appear explaining this.
- The file line numbers shown on the log after the file name should now be correct. Previously the numbering went off if there were lines with no data.
- When no data is inported an imported data file is not created in the daily Import Logs folder, which is as it should be, but a link to this non-existent file was still being placed on the log. Clicking on the link caused an "unexpected error' message which has been causing some confusion. This link is no longer created so the error message cannot occur. We hope that removing this distraction will enable users to better focus on the log messages which explain why the data was not imported.
- When an input file is locked by another application, usually Excel, TransPost cannot process so the Import to MYOB button is disabled. As it is not obvious that the cause is a locked file we have now added an explanatory pop-up that appears when a locked file is selected.
- Importing mappings would skip importing any mapping if one of the same name already existed. This made it necessary to delete mappings before importing updated versions. Now, if a mapping already exists there is now a prompt to choose between replacing the mapping or skipping the import.
- CompanyName and LastName as independent fields. CoLastNAme will continue to be available where a single input could be either a company name or last name
- ShipCity, ShipState, ShipPostcode and ShipCountry will get assembled into the appropropriate address lines
- PayeeCity, PayeeState, PayeePostcode and PayeeCountry will get assembled into the appropropriate payee lines
- DiscountAmount will be converted into the discount percentage required by AccountRight
- IgnoreMinusSign set to Y in SpendMoney will suppress a minus sign in the Amount (useful for posting PayPal fees which PayPal outputs as negative)
- Retry and timing changes to address timeout issues
- Refunds and Reversals - while negative numbers indicate an opposite or reverse transaction, TransPost now looks amongst all sales not just open sales to find the invoice for negative payments
- Changes to Tax code processing to improve retrieval of Tax Codes and calculations to extend Inc-tax, ex-tax and tax amounts for classic Myob where not supplied in the input
- IsPersonal field
- Heading and Subtotal lines may be imported on sale orders as well as invoices (AccountRight Live only))
- Set default payment method and notes based on Custoemr card when no input or default supplied by mapping
- Additional defaults retrieved from customer cards in AccountRight include DeliveryStatus (Invoice Delivery), Salesperson, Comment (sale comment) and ShipVia (shipping method))
- Heading and Subtotal lines can be imported on sale (AccountRight Live only))
- Every line in a transaction is validated before a transaction is rejected on an error. This means that all errors in long transactions are identified in the first run.
- The log file now records the line number within a file ro whcih each message applies
- The transaction number assigned to any transaction is now recorded in the import log with the imported data
- TransPost will not attempt to process a file that is not readable. This is useful when running from a run schedule and files arrive slowly, e.g. downloaded via Drop box, as it effectively waits until it has landed.
- When processing payments using a numerical invoice number, it now looks up both the zero-padded 8 digit form and the unpadded format as the later may be imported into AccountRight Live.
- Amount paid can now be imported with a sale in AccountRight Live
- The data preview form is editable
- There is new error log which will only appear when a transaction fails to be imported>
- Additional defaults retrieved from AccountRight include Invoice Delivery and sales-person derived from the customer card.
- >MYOB generated transaction numbers retrieved and reported in the import log file.
- Log Messages relating to specific line items contain the number of the line within the transaction
- Every detail line validated, and allerrors logged, before rejecting a transaction.
- Job details can be updated.
- Heading and Subtotal lines can now be imported with sales invoices into AccountRight Live.
- Spend Money Transactions
Most mappings will work the same but note that payments are not imported as part of a sale. Use the Customer Payment type to import payments as a separate step.
- Additional defaults retrieved from AccountRight to enable import of sales with minimal data. See here for details.
- Now uses Base Selling Price correctly as default Price for Item Sales when used with AccountRight V 19 and older versions
(In the previous version it was reversing Item 'Prices Are Tax Inclusive' when reading it in via the ODBC.)
- Works via API with AccountRight 2014.4 (including AR Live) (as well as the classic versions)
Most mappings will work the same but note that payments are not imported as part of a sale. Use the Customer Payment type to import payments as a separate step.
- Export and import Mappings as XML files
- Line item prices will be retrieved from AccountRight if not supplied so to import Item Sales you only need Customer (name or cardID), Item Numbers and Quantities (and you can set missing Quantity to default to say 1)
- Improved data file viewer, showing both raw data and grid view
- Error messages regarding errors in line item details identify the line number (handy when importing sales with many lines)
- Item Sales now work with the MYOB ODBC NZ version. (Sorry bro, someone needed to tell us it was not working right. Now we know how different it is and have set up a NZ test file we can do better!)
- When updating customer Terms only updated as defined by supplied input (fixing problem introduced in 2.2.1.204)
- Sales fields default from Customer card when there is no mapped value or default
- Account
- Delivery Status
- Shipping method
- Terms
- Tax Codes default appropriately when there is no mapped value or default
- from Customer if 'Use Customer's Tax Code' checked in MYOB
- from Item 'Tax Code when Sold' for Item Sales
- from Activity 'Tax Code when Sold' for Time Billing Sales
- from Account otherwise
- Improved validation and error messages
- Invalid and missing values identified with clearer error messages
- Missing mandatory values are identified clearly
- Common warning messages from MYOB reporting that '... is blank ... default substituted' have been suppressed
- In their place invalid non-blank values are identified with an appropriate warning message and then treated as if blank<\li>
- When starting an import the path name of the Company file being updated is recorded in the log
- Time Billing Sales
- Customer Payments
- Customer update does not blank out existing unchanged address data
- Service processes consistently while the Company file is in use (only applicable to Premier and Enterprise)
- Improved wizard style forms for creating new mappings
- Welcome dialog for new users leading into the above
- New Introduction tab highlighting the process sequence for new users
- Copy mapping button to create duplicate mappings for creating mappings similar to previous mappings
- Ease of use changes to the configuration program
- Browse buttons on Run Schedule path fields
- Improve logging in the service and escalate to the System Error Log if it cannot log normally
- Discounts now work if '%' is present
- Credit card expiry mm/yy now inserted as is rather than mm/yy/
- When selecting a mapping from the combo, "First row contains headings" is now applied correctly.
- Hours/Minutes dropdown box now selectable on Run Schedule
- Newline characters now handled when present within file fields
- Importing updates to existing Customer data which do not include specific terms changes the customer terms to 30th after EOM
- Downloadable Mapping Templates
- eBay and Paypal Mapping templates included
- After proccessing data file error directory for Run Schedules
- Full import audit log detailing all MYOB fields changed by TransPost
- Tool Tips for Configuration Program
- Default log files location now in folder in 'Public Documents', 'Shared Documents'
- Better error and warning messages
- First Row contains headings now checked as default
- Issues with updating Customer Payment terms have been addressed
- Jobs without linked customers can now be imported
- Job Percent Complete now works with % sign in the field
- Spurious Authorisation code field has been removed from the Customer field list
- Issues with updating price level/quantity breaks have been addressed
- Service run frequency dropbox contains no options
- Inventory Items Import and Updating
- Tool Tips for MYOB fields
- Tab delimited file support
- Updating customer cards
- Improved insertion checking for sales imported with invoice number not mapped
- Better error and warning messages
- Jobs will not insert with customer left blank.
- Problems with the Windows Service introduced in 1.2.2.64
- Sales imported without an invoice number will insert but will result in an error message: "Sale(:log field) not inserted."
- Jobs will not insert with customer left blank.
Version 3.3.5 - Released December 2018
Product Versions | |
TransPost 3.3.5.565 | |
TransPost Express 3.3.5.571 | |
Transpost Plus 3.3.5.579 | |
TransPost Premier 3.3.5.580 |
This release is intended to fix a number of problems that have been reported over recent months. We have also introduced some minor changes.
Changes
Updating Items with new Item Numbers
Item Update now includes a NewItemNumber field. This can be used to change an Item's ItemNumber in AccountRight Live, retaining all the Items history, just like going in and manually changing the code.Note: This does not work with Classic AccountRight.
Line breaks within fields and numbering in Log references
When a line break occurring in the input file is within a quoted field the line break is treated as part of the data item rather than the end of the record. This deals with data exported from Excel where there are cells with multiple lines within them. The entire text, including the line break, will be passed on to AccountRight Live.Note: Line breaks cannot be passed to Classic MYOB so they will be replaced by a single space.
If a line representing a single record spans a number of lines in the file because there are line breaks within field then the log will identify the position of the record within the file by its starting and ending line numbers.
Where a log message refers to a line number within a transaction each complete record counts once even if it was input across multiple lines of the file. Fields to be used as column headings will have line breaks replaced with - and the special characters '\,removed. Note: headings used in pre-existing mappings will be converted.
Conditional Tax Code - with tax or without
Many common sources of data, such as online eCommerce and Expense systems provide a tax amount column but not a tax code but AccountRight expects a tax code and will derive it from defaults associated with the account or item referenced. In an environment where line items may either carry GST or be tax free it is not always possible to rely on the default tax code from the account or item number.We have introduced a special form of 'either or' tax code which specifies the tax code applicable if there is tax and the tax code to use if there is no/zero tax. It is primarily intended to be used in a mapping default and takes the form of two alternative tax codes sparated by ' or '.
For example setting the default tax code to GST or FRE will apply the tax code FRE if there is no tax and GST otherwise. In New Zealand the corresponding code would be S15 or Z.
Miscellaneous Fixes
The following problems have been fixed:Version 3.3.4 - Released August 2018
Product Versions | |
TransPost 3.3.4.553 | |
Transpost Plus 3.3.4.555 | |
TransPost Express 3.3.4.556 | |
TransPost Premier 3.3.4.557 |
Upgrade to use TLS 1.2
The primary purpose of this release is to upgrade TransPOst to use TLS1.2 when communicating with AccountRight Live online as MYOB were ceasing to accept communication via TLS 1.0Microsoft .NET Framework 4.6.2 is required for this release. Installing AccountRight Live installs MS .NET Framework 4.6.2. so most users would have it already.
To use any TransPost application to import data into an online AccountRight Live Company file from a computer that does not have AccountRight Live installed (Yes, you can do that!) you may need to install Microsoft .NET Framework 4.6.2 before upgrading.
Download and install Microsoft .NET Framework 4.6.2 from this link within the Microsoft Download Center https://www.microsoft.com/en-us/download/details.aspx?id=53345
Also Fixed
For TransPost Plus and Premier the problem with importing timesheets for Employees who have Custom List data is fixed in this release.3.3.3.530
17/4/2017
New Features:
These new import fields have been introduced wherever appropriate:Improvements:
3.3.2.479
6/9/2016
New Features:
3.3.2.473
5/3/2016
New Features:
Improvements:
Fixed:
3.3.1.440
27/4/2016
New Features:
Improvements:
3.2.0.347
19/8/2015
New Features:
Fixed:
3.1.0.296
1/2/2015
New Features:
Improvements:
Fixed:
2.2.1.208
31/3/2014
Fixed:
2.2.1.204
25/3/2014
New Features:
Improvements:
Fixed:
The following now work correctly:2.1.1.105
19/6/2013
New Features:
This release focussed on improving the user experience. Setting up mappings can be complex process and we decided that there should be more emphasis on making this process simpler for new users.1.3.2.61
22/11/2012
New Features:
Improvements:
Fixed:
Known Problems:
1.3.1.32
24/06/2012
New Features:
Improvements:
Fixed:
Known Problems:
1.3.0.24
20/04/2012
New Features:
Fixed:
Known Problems:
1.2.2.66
26/11/2011
Fixed:
Known Problems:
Where "log field" refers to the "key field for logging" selected for the import