Leverandørgjeldsliste for Exact ved bruk av Excel Add-in?

Spørsmål (en)
, ,
1

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.

2

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
3

Dette spørsmålet ble automatisk lukket etter minst 1 uke med inaktivitet, etter at en mulig løsning ble gitt. Det siste svaret som ble gitt, er merket som en løsning.

Vennligst still et nytt spørsmål via et eget emne dersom problemet oppstår igjen. Husk å inkludere en lenke til dette emnet i det nye spørsmålet ved å lime inn URL-en i teksten.