How to reduce the number of recors per page to 100

From ODBClink wiki
Jump to navigation Jump to search

Overview

The defult number of records retrieved per page for MYOB AcccountRight Live is 400. This generally works fine however if you have many lines on invoices it may cause the MYOB API server to time out. If thats the case you will see a time out errer in the Get Data Log. To resolve that issue reduce the number of records from 400 to 100 and try the Get Data again.

How to reduce the number or records per page for MYOB AccountRight Live to 100

MYOB AccountRight Live Options
  1. Start ODBClink;
  2. From the Menu screen, click on Settings tab in Excel's ribbon;
  3. Find the Options section and click the Set User Options button;
  4. Select MYOB AccountRight Live options from the dialogue;
  5. Edit the Records Per Page field to be 100;
  6. Click Save and Close;
  7. Run the Get Data process.

Notes

  • If the get data fails due to maximum number of connections reached, increasing the number of records per page can help.
  • We recommend making the number of records per page a multiple of 100 (e.g. 100, 200, 300). IT MUST be a number between 100 and 1000.


Related Topics