This articles explains you how to export all account receivables outstanding items and payables outstanding items to Excel workbooks.

Instructions

Execute the following steps:

  • Start Invantive Query Tool.

  • Log on to Exact Online.

  • Copy the following statements in the source code editor:

use all

select *
from   aroutstandingitems

local export results as "${system:userdocumentsdirectory}\ar.xlsx" format xlsx include headers

select *
from   apoutstandingitems

local export results as "${system:userdocumentsdirectory}\ap.xlsx" format xlsx include headers
CODE
  • Press F5 or select the “Execute All“ button.

  • The output can be found as ar.xlsx and ap.xlsx in your documents folder.