Unreconciled Transactions

<< Click to Display Table of Contents >>

Navigation:  The Mobileezy Desktop Application > Working with Transactions >

Unreconciled Transactions

Previous pageReturn to chapter overviewNext page

Show/Hide Hidden Text

On occasion, transactions do not export to the Accounting System after an export is attempted.  There are a large number of factors that can contribute to this, generally the errors are of two types:

1.Connection Error:  Mobileezy cannot connect to the Accounting System.
2.Data Error:  Data sent through to the Accounting System is rejected.

 

Transactions that will not export are marked in Mobileezy as Unreconciled and are found in the Unreconciled Errors tab.  They will need to be handled from this tab.

Unreconciled errors occur when transactions sent to the Accounting System are rejected.  They are handled through the unreconciled errors tab.

Alert to Unreconciled Errors        Unreconciled Alert after an Export Attempt

You will be alerted in two ways if any transactions are not exported successfully after you perform an export operation.

1.A dialog box will appear advising you that there were a number of errors and a certain number of transactions have not been exported.  The dialog will advise you to look in the unreconciled errors tab.
Screenshot of Unreconciled Error Dialog
Unreconciled Error Message on Export
2.There will be a number in the title of the Unreconciled Errors tab.

Navigation of the Unreconciled Transactions Tab        Navigation of the Unreconciled Errors Tab

The Unreconciled Errors tab is found under the Transactions icon.  It will show a listing of any transactions that will not export to the Accounting System, along with details of the error.

Screenshot of the Unreconciled Errors Tab
Unreconciled Errors Tab

In the table below, you will find an explanation of each of the components of the Unreconciled Errors tab.

Area

Image

Description

Unreconciled Errors Tab

Unreconciled Errors Tab

Shows the number of transactions found in the unreconciled errors listing.  (3 transactions pictured.)

Open Transaction Button

Open Report Icon

Opens the unreconciled error transaction in the Crystal Reports viewer.

Flagged Checkbox

Flagged Transaction

Shows whether a transaction has been flagged for action.

Transaction ID column

Transaction ID Column Heading

Shows the invoice / order number of the transaction. All transactions are prefixed with the User ID.

Sync Date column

Sync Date Column Heading

Shows the date and time that the transaction was synchronised from the Handheld or created in the Desktop Order Entry System.

Error # Column

Error Number Column Heading

Shows the error number provided to Mobileezy by the Accounting System.

Error Details Column

Error Details Column Heading

Shows a description of the error as provided by the Accounting System.

Print Flagged Button

Print Flagged Button

Prints all flagged transactions when pressed.

Flag All Button

Flag All Button

Puts a check box in the flag boxes for all transactions when pressed.

Flag None Button

Flag None Button

Removes the check box from the flag boxes for all transactions when pressed.

Reschedule Button

Reschedule Button

Moves all flagged transactions to the Completed Transactions tab when pressed.

Reconcile Button

Reconcile Button

Moves all flagged transactions to the Reconciled History tab when pressed.

Some Common Unreconciled Errors        Some Common Unreconciled Errors with MYOB

There is a large number of different errors that can occur when transactions are exported from Mobileezy to MYOB.  Some of the common error codes, reasons for their occurrence and method of resolving them are found below.

Error #

Error Details

Reason for Error

Method to Resolve

-1

Account Number may not be blank

Default error given by MYOB when there is a connection issue.

Resolve connection error to MYOB, reschedule transactions and then re-export.

-10

Invalid Date

The date format on the transaction is not compatible with MYOB.

Change the date format in the calender settings on the computer that is performing the transaction export to d/MM/yyyy.

-183

Duplicate Invoice Number

The invoice number has already been used in your Accounting System.

The invoice number can be changed in Desktop Order Entry System.

If this is not possible, enter the invoice manually into MYOB and then reschedule the transaction and mark as imported.

-225

Insufficient quantity at Location specified

There is an insufficient quantity of one of the product lines in the Location specified on the invoice for which you are tracking inventory in MYOB.  MYOB will not allow the export of transactions that would result in a negative inventory value.

Determine which item on the invoice will result in negative stock and adjust inventory levels in MYOB.

-39

Income account must be specified for each item

The income account on one of the items on the transaction has not been specified in MYOB.

Open MYOB > Go to Lists > Item.  Find and edit each of the item numbers found on the transaction and input the income account code.
Unreconciled Errors_Error -39_Item Income Account

-81

Tax account linked account is missing

The linked account for the tax code on the transaction has not been setup in MYOB.

Open MYOB > Go to Lists > Tax Code and locate the tax code that appears on the transaction.

Select edit and input the linked account details

Unreconciled Errors_Error -81_Linked Tax Account MYOB

 

Some Common Unreconciled Errors with Reckon Accounts        Some Common Unreconciled Errors with Reckon Accounts

There is a large number of different errors that can occur when transactions are exported from Mobileezy to Reckon Accounts.  Some of the common error codes, reasons for their occurance and method of resolving them are found below.

Error #

Error Details

Reason for Error

Method to Resolve

3120

Object “xxxx-xxxxxxxxxxx” specified in the request cannot be found

There are two possible causes for this error.

1) A payment has been applied to the invoice in Reckon Accounts before export of the transaction from Mobileezy. This can occur due to manual application of the payment before the datalink has finished running or from re-export of a transaction due to second payment being applied.

2) There are two accounts with the status 'Account Receivable' and one is marked inactive.

 

1) Either remove the payment in Reckon Accounts, then reschedule the transaction and export; or  reschedule the transaction and mark as imported.

 

 

 

 

 

2) Delete one of the 'Account Receivable' accounts.  Marking it as inactive is not sufficient, it must be deleted.

Rescheduling Transactions for Export        Rescheduling Transactions for Export

After the error is resolved, you will need to reschedule the transaction for another export attempt.  To do this:

1.From the Unreconciled Errors tab
2.Flag the transaction (s) that you want to reschedule by clicking the checkbox in the flagged column.
3.Press the Reschedule button.

The transactions will be sent back to the Completed Transactions tab, by default there will be a tick in the flagged check box.

Reconciling Unreconciled Transactions        Reconciling Unreconciled Transactions

Transactions can be reconciled from the Unreconciled Errors tab.  You may wish to do this if the error cannot be resolved or you do not want the transaction to be exported to your Accounting System.

1.To reconcile any errors:
2.Flag the transaction (s) that you want to reschedule by clicking the checkbox in the flagged column.
3.Press the Reconcile button.

The transactions will be sent to the Reconciled History tab.  Once reconciled they cannot be removed from this tab.  The reconciled history tab will build up over time, showing a full history of any reconciled transactions.

See Also

Completed Transactions

The Invoice Replication Report