fmAccounting Link (MYOB AccountRight Edition) Version History

v1.45 – 22/6/2020

  • updated Items::MYOBItemJSON calculation formula for plug-in branch to better handle uploading inventoried Items
  • updated Items::MYOBItemJSON calculation formula for plug-in branch to upload the AssetAccount for inventoried Items only
  • Delete API Requests: fixed native branch HTTP Verb (changed to DELETE instead of GET)
  • Delete API Requests : updated native branch to check for Response Code = 200 and $lastError = 10 (not a request error)
  • Invoices: added script to search for MYOB Invoice by Invoice Number
  • Bills: added script to search for MYOB Bill by Bill Number
  • Purchase Orders: added script to search for MYOB Purchase Order by Purchase Order Number

v1.42 – 4/3/2020

  • updated Invoices:: ShippingMethod auto-enter calculation formula to correctly default to the Contacts ShippingMethod
  • fixed issue with downloading active Inventory Items in native branch

v1.41 – 15/1/2020

  • updated Create Contact in MYOB script to include the Address Location and Address Street fields for the native branch
  • updated Create Contact in MYOB script to set the JSON data type for some Term fields to JSONNumber to handle empty values
  • updated Create Invoice in MYOB script to set the JSON data type for some Term fields to JSONNumber to handle empty values
  • updated Create Order in MYOB in MYOB script to set the JSON data type for some Term fields to JSONNumber to handle empty values
  • updated Create Purchase Order in MYOB script to set the JSON data type for some Term fields to JSONNumber to handle empty values
  • updated Create Bill in MYOB script to set the JSON data type for some Term fields to JSONNumber to handle empty values

v1.4 – 19/12/2019

  • updated to BaseElements plug-in to v3.3.8 (Code Signed) for FileMaker Pro 18 compatibility
  • updated for native FileMaker Pro v16 or higher functions/scripts
  • updated Customer Payments upload to correctly handle Order Payments
  • added script trigger to the PaymentItems::_kf_MYOBInvoiceID and PaymentItems::_kf_MYOBOrderID fields on the Payments Form layout to set the MYOB ID when manually adding a Payment Allocation
  • Create Invoice in MYOB: fixed issue when updating the InvoiceItems ShipQuantity field for non Item Invoices
  • added script to search for MYOB Contact with same Company Name or Individual Name
  • added script to search for MYOB Contact by Card ID
  • fixed issue in Convert Order to Invoice script when creating the Invoice Items from the Order Items
  • added Timesheets examples (download and upload)
  • added download PayrollCategories example

v1.3 – 11/12/2018

  • added Inventory Adjustments examples
  • added Orders examples
  • added Supplier Payments examples
  • added Item Price Matrix (Custom Price Levels) examples
  • added button to manually enter/re-enter MYOB Company File login credentials
  • updated Invoices to only upload the first 255 characters of the line item description (API limits)
  • updated Bills to only upload the first 255 characters of the line item description (API limits)
  • updated Purchase Orders to only upload the first 255 characters of the line item description (API limits)
  • updated Item to only upload the first 255 characters of the description and first 30 characters of Name (API limits)
  • updated Contacts (Customers) to only upload the first 50 characters of the Company Name (API limits)
  • updated Contacts (Customers)to only upload the first 30 characters of the Last Name (API limits)
  • updated Contacts (Customers)to only upload the first 50 characters of the Company Name (API limits)
  • updated Contacts (Suppliers) to only upload the first 50 characters of the Company Name (API limits)
  • updated Contacts (Suppliers)to only upload the first 50 characters of the Last Name (API limits)
  • updated Contacts (Suppliers)to only upload the first 50 characters of the Company Name (API limits)
  • updated Contacts downloads to include CurrentBalance, Credit Available and Credit PastDue
  • added new button/script to just get the Contact Balances from MYOB
  • fixed bug with uploading Bills that were converted from a Purchase Order
  • added LibraryPath field to Companies table
  • added ProductVersion to All Company Files value list
  • updated MYOBItemJSON calculation formula
  • added button to download current balance from MYOB for an Invoice
  • added button to download any Customer Payments from MYOB for an Invoice
  • fixed bug in Get All FormTemplates script (was referencing Categories table not FormTemplates)
  • fixed bug with BillDeliveryStatus when uploading/downloading Bills
  • added InvoiceDelivery and PurchaseOrderDelivery fields to Contacts Form layout
  • added InvoiceDeliveryStatus to Invoices layouts
  • added OrderDeliveryStatus to Purchase Orders layouts
  • added BillDeliveryStatus to Bills layouts
  • updated Bill Items download to download BackorderQuantity for line items
  • updated Invoices upload to delete and refresh Invoice Line Items so latest Invoice Line Item RowVersions are stored
  • updated Invoices layouts to only show Customer Contacts in the Contact ID field

v1.26 – 13/03/2018

  • fixed trial version privileges for Purchase Orders and Bills
  • when downloading Invoices from MYOB and uploading Invoices to MYOB it now stores the MYOB Invoice Number

v1.25 – 23/02/2018

  • added Bills examples
  • fixed issue with Purchase Orders Supplier Contacts value list
  • deselected “Do not replace existing value of field” for UnitPrice in PurchaseOrderItems and InvoiceItems tables
  • fixed URL  bug in Get All Service PurchaseOrders script when not filtering by date range
  • modified Purchase Order Line Items to reference BillQuantity instead of ShipQuantity

v1.21 – 27/11/2017

  • updated Get Invoices scripts to check for existing Invoice by MYOB ID and skip if already exists
  • updated Get Payments script to check for existing Payment by MYOB ID and skip if already exists
  • added new option to Get Payments script for Payment Date Range (between 2 dates)
  • added new option to Get Invoices scripts for Invoice Date Range (between 2 dates)

v1.2 – 31/10/2017

  • added Purchase Orders examples
  • minor changes to the MYOBItemJSON calculation formula to prevent JSON syntax errors
  • when uploading Invoices the JournalMemo value is retrieved if this field is empty in FileMaker
  • added JournalMemo field to Invoices layouts
  • fixed bug with Purchase Orders Supplier Contacts value list
  • updated Get Inventory scripts to download LastPurchasePrice field (read only)
  • updated upload scripts to check that the $parameters variable is not empty
  • updated Invoices ShipToAddress to include Customer Company Name

v1.13 – 23/05/2017

  • fixed issue with Set HTTP Headers subscript when uploading found set of records

v1.12 – 07/04/2017

  • added Get MYOB Invoice PDF (download the MYOB PDF for an Invoice to FileMaker)
  • changed rounding in Invoices to not round the InvoiceItem Tax Amount and round the Total Tax amount
  • fixed InvoiceItems List layout showing incorrect field for Account Code
  • changed InvoiceItems::UnitPrice field auto-enter calculation to “do not replace existing value” to prevent this being blank for non Item type Invoices when changing the Tax Code
  • updated to Base Elements plug-in v3.3.4

v1.11 – 06/03/2017

  • fixed issue navigating from MYOB Company layout to selected Job
  • updated reset script to also reset the  Interface::LinkedMyMYOBLogin field
  • trial version changes

v1.1 – 30/01/2017

  • added Jobs endpoint examples
  • added JobBudgets endpoint examples
  • updated GeneralJournals to download/upload Job IDs
  • updated Invoices to download/upload Job IDs
  • modified GeneralJournals Form layout to only show non header Accounts
  • updated InvoiceItems and GeneralJournalItems to use the MYOBDisplayUID for upload calculations

v1.0.9 – 16/01/2017

  • added timestamps to GET GeneralJournals script
  • added Total Debit/Total Credit fields to GeneralJournals list view

v1.0.8 – 12/01/2017

  • updated to Base Elements plug-in v3.3.3
  • fixed missing New Record step in Create new Employee Record script
  • added support for Company File User IDs linked with a my.MYOB login
  • fixed bug in Create Contact in MYOB script (missing Show Dialog step for found set confirmation)
  • added GeneralJournals endpoint examples (GET, PUT and POST)

v1.0.7 – 23/11/2016

  • added test to Invoice Payment upload for MYOB Invoice ID value
  • fixed bug with ContactsLastModifiedTimestamp not being updated when downloading Contacts by timestamp

v1.0.6 – 07/11/2016

  • updated all Invoice Types to support Header rows
  • added Round function to Invoice Items Unit Price auto-enter calculation

v1.0.5 – 04/11/2016

  • updated Service Invoice Items to support Header rows when uploading

v1.0.4 – 05/10/2016

  • updated Invoice layouts line items Account Code to only show non header Accounts (cannot upload Invoice Item to a Header Account)
  • fixed bug in OnFirstWindowOpen script when setting the $$myobCompanyBaseURL correctly for Cloud users
  • removed the auto-complete using existing values for the Invoices::Customer PO No. field
  • updated script ‘Get All Invoices’ to set the $currentTimestamp variable

v1.0.3 – 10/05/2016

  • fixed bug with Create Item script when checking MYOB Item ID for POST or PUT request
  • fixed bug with Invoices Total Payments calculation

v1.0.2 – 02/05/2016

  • added Read Only fields to GET Inventory Items
  • added new module: FormTemplates
  • updated Contacts to upload/download Form Template
  • updated Contacts conditional formatting for mandatory fields to reflect only those mandatory for  a Customer or a Supplier

v1.0.1 – 19/04/2016

  • added option to delete existing Company Files record when downloading
  • changed Desktop API Authentication Web Viewer display to address issue with Windows not displaying contents correctly

v1.0 – 12/04/2016

  • initial public release

Still need help? Contact Us Contact Us