Error Logs Tab of the QuickBooks Form

On this tab, review any errors that occurred when records or transactions were sent to and from Vantagepoint.

You can also review the status of any record or transactions sent to and from Vantagepoint or any records and transactions in the process of being sent to and from Vantagepoint.

Updating between Vantagepoint and QuickBooks Online occurs when:
  • You first set up the integration between the two products, and you click Vantagepoint. Records entered in QuickBooks Online, such as employees and vendors, are add to Vantagepoint.
  • Automatic updating occurs between Vantagepoint and QuickBooks Online. The updating is based on the time interval that you specified on the Integration Setup tab in the QuickBooks integration utility. New and updated records and transactions in QuickBooks Online are updated in Vantagepoint. New transactions from Vantagepoint are updated in QuickBooks Online.
  • Manual updating occurs between Vantagepoint and QuickBooks Online. The updating starts when you click the Process Changes Now button on the Integration Setup tab in the QuickBooks integration utility. New records and transactions and revised records in QuickBooks Online are updated in Vantagepoint. New transactions from Vantagepoint are updated in QuickBooks Online.

Contents

In the grid on this tab, view the status for each record and transaction that was sent or is in the process of being sent to and from Vantagepoint. Select options in the Options section to filter and display a more specific set of records in the grid, such as only the failed records.

Options Section

Use the fields in this section to filter and display a smaller subset of items in the grid.

Field Description
Filter by Direction Select the direction in which the data is traveling by which to filter the items that display in the grid.
Options are:
  • All Directions: The items listed in the grid are related to data that Vantagepoint received from QuickBooks Online and data that Vantagepoint sent to QuickBooks Online.
  • Inbound: The items listed in the grid are related to data that Vantagepoint received from QuickBooks Online.
  • Outbound: The items listed in the grid are related to data that Vantagepoint sent to QuickBooks Online.
Filter by Status Select the status by which to filter the items displayed in the grid. The options define the status of the records that are being sent to and from Vantagepoint. The status for each item in the grid displays in the Status field for the item.

Options are:

  • New: The record is entered in Vantagepoint, but it is not in QuickBooks Online yet.
  • Processing: The record is part of a group of records that are currently being processed by the system. An unexpected error occurred for the record. The system will try to send it to QuickBooks Online again.
  • Processed: The record has been successfully processed and is kept as a historical reference.
  • Retry: The record did not match several criteria. It will be resent to QuickBooks Online again the next time the updating process occurs. The message in the Message field in the grid explains why.
  • Failed: The record failed to be updated in Vantagepoint or QuickBooks Online. The message in the Message field in the grid explains why. The system will try to update the failed record in Vantagepoint or QuickBooks Online when the next updating occurs between the two products if the number in the Retries field for the item in the grid is less than the number in the Maximum Number of Retries field on the Integration Setup tab of the QuickBooks integration utility.
Filter by Start Date Select a start date by which to filter the errors in the grid. This is the date on which an error occurred.
Filter by End Date Select an end date by which to filter the errors in the grid. This is the date on which an error occurred.
Filter Table Click this button to apply the filters that you entered in this section to the list of error to display in the grid.

Grid

This grid displays the information about any errors that occurred when data was updated between Vantagepoint and QuickBooks Online.

Field Description
Direction This field displays the direction in which the data was traveling:
  • Inbound: The error is related to data that Vantagepoint received from QuickBooks Online.
  • Outbound: The error is related to data that Vantagepoint sent to QuickBooks Online.
QuickBooks Online Entity This field displays the entity or table name in QuickBooks Online, such as Bill, Vendor, and BillPayment.
QuickBooks Online Key This field displays the primary key for the entry (either when it was sent from QuickBooks Online or when it was created in Vantagepoint). This key is usually not visible, but the system uses it to identify the record.
Vantagepoint Entity This field displays the entity (or table name) in Vantagepoint, such as jeControl, arControl, and Clendor.
Vantagepoint Key This field displays the primary key for the entry. If it is a key with multiple fields, the values are separated by the "|" char.
Action This field displays identifies whether the record is an Insert (I), Update (U) or a Delete (D).
Change Date This field displays the modification date from either Vantagepoint or QuickBooks Online.
Status This field displays the status of the transaction or record.

Possible statuses are:

  • New: The record is entered in Vantagepoint, but it is not in QuickBooks Online yet.
  • Processing: The record is part of a group of records that are currently being processed by the system. An unexpected error occurred for the record. The system will try to send it to QuickBooks Online again.
  • Processed: The record has been successfully processed and is kept as a historical reference.
  • Retry: The record did not match several criteria. It will be resent to QuickBooks Online again the next time the updating process occurs. The message in the Message field in the grid explains why.
  • Failed: The record failed to be updated in Vantagepoint or QuickBooks Online. The message in the Message field in the grid explains why. The system will try to update the failed record in Vantagepoint or QuickBooks Online when the next updating occurs between the two products if the number in the Retries field for the item in the grid is less than the number in the Maximum Number of Retries field on the Integration Setup tab of the QuickBooks integration utility.
Retries If a record or transaction that should be shared between Vantagepoint and QuickBooks Online fails to be added to either Vantagepoint or QuickBooks Online during the updating process, it will be retried the next time the updating occurs. If the updating of the record or transaction continues to fail, the number of failures is tracked in the Retries field.

If a record or transaction reaches the maximum number of retries (per the number entered in the Maximum Number of Retries field on the Integration Setup tab in the QuickBooks integration utility) and has still failed, you can do either of the following:

  • Change the number in the Retries field for the specific record or transaction. Reduce the number to be less than the maximum number of retries allowed so the record or transaction will be retried again when the next updating occurs.
  • Go to the Integration Setup tab in the QuickBooks integration utility, and click the Reset Counter button in the Scheduling Settings section. This resets the count of the actual retry attempts to zero in the Retries field for all records and transactions being updated between Vantagepoint and QuickBooks Online that have a Failed or Retry status.
Last Processed Date This field displays the last time the record was processed. This date can be different from the date in the Change Date field because the processing can be minutes or hours later than the change date.
Message This field provides specific information about an error or a notice that all was processed successfully.