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.
    • 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:
      • 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.

      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.0

      Microsoft .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:
      • 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)

      Improvements:

      • 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

      3.3.2.479

      6/9/2016

      New Features:

      • 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

      3.3.2.473

      5/3/2016

      New Features:

      • 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))

    Improvements:

  • 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

    Fixed:

    • 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.

    3.3.1.440

    27/4/2016

    New Features:

    • 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>

    Improvements:

    • 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.

    3.2.0.347

    19/8/2015

    New Features:

    • 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.

    Fixed:

    • 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.)

      3.1.0.296

      1/2/2015

      New Features:

      • 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)

      Improvements:

      • 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)

      Fixed:

      • 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!)

      2.2.1.208

      31/3/2014

      Fixed:

      • When updating customer Terms only updated as defined by supplied input (fixing problem introduced in 2.2.1.204)

      2.2.1.204

      25/3/2014

      New Features:

      • 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

      Improvements:

      • 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

      Fixed:

      The following now work correctly:
      • 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)

      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.
      • 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

      1.3.2.61

      22/11/2012

      New Features:

      • Copy mapping button to create duplicate mappings for creating mappings similar to previous mappings

      Improvements:

      • 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

      Fixed:

      • 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

      Known Problems:

      • Importing updates to existing Customer data which do not include specific terms changes the customer terms to 30th after EOM

      1.3.1.32

      24/06/2012

      New Features:

      • 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

      Improvements:

      • 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

      Fixed:

      • 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

      Known Problems:

      • Service run frequency dropbox contains no options

      1.3.0.24

      20/04/2012

      New Features:

      • Inventory Items Import and Updating
      • Tool Tips for MYOB fields
      • Tab delimited file support
      • Updating customer cards

      Fixed:

      • Improved insertion checking for sales imported with invoice number not mapped
      • Better error and warning messages

      Known Problems:

      • Jobs will not insert with customer left blank.

      1.2.2.66

      26/11/2011

      Fixed:

      • Problems with the Windows Service introduced in 1.2.2.64

      Known Problems:

      • Sales imported without an invoice number will insert but will result in an error message: "Sale(:log field) not inserted."
      • Where "log field" refers to the "key field for logging" selected for the import

      • Jobs will not insert with customer left blank.