Accounts payable listing for Exact using Excel Add In?

[t6d6]

Has anyone built an Accounts Payable listing that shows invoices due for payment together with the bank details for each vendor using this tool? Is this possible?

I’m trying to find another solution to the lack of non-SEPA payment capability in Exact Online, and if I can get a spreadsheet output showing the payments due together with their bank details I may be able to solve it.

[forums]

A simple query that can be run from the Query Tool in the Modeler ribbon or using a block based on a free query is:

select aom.Division
,      aom.AccountCode
,      aom.AccountName
,      bat.BICCode
,      bat.BankAccount
,      bat.IBAN
,      aom.number_attr
,      aom.yourref
,      aom.description
,      aom.invoicedate
,      aom.duedate
,      aom.currency_code_attr
,      aom.invoiceamtfc
,      aom.outstandingamtfc
from   ( select to_number(aom.division_code) Division
         ,      aom.outstandingitems_ap_account_code_attr AccountCode
         ,      aom.outstandingitems_ap_account_name AccountName
         ,      replace(aom.outstandingitems_ap_account_id_attr, '{', '', '}', '') AccountId
         ,      aom.number_attr
         ,      aom.yourref
         ,      aom.description
         ,      aom.invoicedate
         ,      aom.duedate
         ,      aom.currency_code_attr
         ,      aom.invoiceamtfc
         ,      aom.outstandingamtfc
         from   APOutstandingItems aom
       ) aom
left
outer
join   BankAccounts bat
on     bat.division = aom.division
and    bat.Account  = aom.AccountId
and    bat.Blocked  = false
and    bat.Main     = true
order
by     aom.division
,      aom.AccountCode

[forums]

This question was automatically closed after at least 1 week of inactivity after a possible solution was provided. The last answer given has been marked as a solution.

Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.