Reckon Accounts Datalink

<< Click to Display Table of Contents >>

Navigation:  The Mobileezy Desktop Application > Working with the Datalink >

Reckon Accounts Datalink

Previous pageReturn to chapter overviewNext page

Show/Hide Hidden Text

The Reckon Accounts datalink is the connection between Mobileezy and Reckon Accounts.  The datalink is the function used to import all the customers, employees, suppliers, items and pricing into Mobileezy and also enables the export of transactions into Reckon Accounts.

The datalink is configured during the Mobileezy installation process and in most cases is only completed once.  After the initial configuration, it must be run on a regular basis to maintain data consistency between the two software systems.

ReckonLogotransperant

Steps for Initial Configuration        Steps for Initial Configuration

There are four simple steps for initial configuration of the Reckon Accounts datalink.  Each of these must be completed in its entirety before the two systems will be able to exchange data.

1.Complete the datalink setup
2.Set Mobileezy as an integrated application in Reckon Accounts
3.Export the Unit of Measure report files (Only required when multiple units of measure are in use)
4.Run the datalink.

MYOB AccountRight Live Datalink Settings        Initial Setup of the  Reckon Accounts Datalink

During the installation process the datalink is configured in the Configuration Assistant dialog.

1.Select the backend account type Reckon Accounts (QuickBooks) from the drop down menu and press the Setup Datalink button.
Screenshot of Reckon Accounts Datalink setup
Select Reckon Accounts

  

2.In the next screen, click the Browse button and find the location of your Reckon Accounts datafile then press the Next button and then Finish.
Screenshot of Company File Selection
Select the Company File

 

3.Press the Run Datalink button to run the datalink for the first time.  Reckon Accounts will prompt you with a dialog asking whether you want to allow Mobileezy to access the datafile.  Select Yes, always; allow access even if ReckonAccounts is not running and then press Ok.
Screenshot of Authorisation Duakig in Reckon Accounts
Authorise Mobileezy to Access Reckon Accounts

 

MYOB AccountRight Live Datalink Settings        Reckon Accounts Datalink Settings

There are 10 settings available in the Reckon Accounts datalink.  After initial configuration, these settings can be accessed under Setup > Datalink > Datalink Setup.  These settings can be configured at any point after the initial setup, however you must be aware that altering the datalink settings can cause irreversible changes to your Mobileezy database.  It is advisable to take a backup of your Mobileezy database before altering any of the datalink settings.

A description of the function of each of these settings is shown in the table below:

Setting

Description

Company File Location

The filepath of the linked Reckon Accounts Company file.

Address / Address 2

Defines which Reckon Accounts address is shown in the bill to and ship to address fields on sales transactions. (Defaults to Bill To/Ship To)

Barcode Source

Defines the location of the source of the item barcode data. (Default is mobileezy Barcode)

Deposit Payments To

Defines the account that payments taken in Mobileezy are posted to.  (Defaults to Let Reckon Accounts Decide)

Pay Bills From

Defines bank account from which bill payments made in Mobileezy are posted to. (Defaults to (Not Set)). Only required for Purchasing Module.

Bin Code Source

Defines the location of the Bin Code data.  (Default is blank).  Only required for Picking Module.

Write the import file, but don't import

Writes the transaction export file to a csv file but does not export to Reckon Accounts. (Defaults to Off)

Ignore First Line of Address Details

Excludes the first line of the Bill To and Ship to address fields in Reckon Accounts from being imported into Mobileezy (Defaults to Off)

Get Units of Measure from Reckon Accounts Report files

Sets Mobileezy to obtain unit of measure data from UOMSetsWithRelatedUnits.csv and UOMSetsWithRelatedUnits.csv saved in the Mobileezy data folder. (Defaults to Off)

Use Mobileezy Price Levels

Controls whether the Mobileezy price level tabs (Customer and Item price levels) are visible (Defaults to On).

MYOB AccountRight Live Datalink Settings        Configuring the Datalink to obtain Units of Measure from Reckon Accounts Reports

The Reckon Accounts SDK version 6.1 does not allow for the direct integration of units of measure between Mobileezy and Reckon Accounts.  As a result the integration is completed via export of csv files from Reckon Accounts where they are saved to theMobileezy data folder.

Use the following instruction to setup the integration.

1.In Mobileezy under the Setup icon select the Datalink Setup tab and then Click on Datalink Setup:
2.On the Datalink tab set Get Units of Measure from Reckon Accounts Report Files to true. (NB. Requires the v7 extras licence key)
Screenshot of Datalink Setting
Datalink Setting

 

3.In Reckon Accounts, go to Reports, select Lists and select the report Unit of Measure Sets with Related Units from the list.
Screenshot of Reckon Accounts Report Menu
Reckon Accounts Report Menu

 

4.Press Export and when prompted, select Export Reckon Accounts report to a Comma Separated Values.csv file and press the export button. When prompted, browse to the location Program Data > Mobileezy v7 > Data and save with the name UOMSetsWithRelatedUnits.csv
Screenshot of Report Export in Reckon Accounts
Exporting the UOM Sets with Related Units Report

 

Screenshot of Example Report
Example UOM Sets with Related Units Report

  

5.Repeat steps 3 and 4 with the Units of Measure report, saving it in the same location with the name ItemsWithUOM.csv
Screenshot of Report Export in Reckon Accounts
Exporting the Report

 

Screenshot of Exporting the Report
Exporting the Items with UOM report
Example Report
Example Items with UOM Report
6.Run the datalink

Note: Every time that a new item is added to Reckon Accounts with alternate units of measure, this process must be repeated.

See Also:

Creating Handheld Users

Creating DOES Users

Desktop Installation

Datalink