Skip to main content

Hi,

As part of our monthly reconciliations, we are required to send to our banking partner an aged debtors. I want to use IFS to do this rather than manually creating an excel sheet which is taking too long, however they’ve advised they need the report by transaction date, rather than due date. I can’t seem to find the function to change this when ordering the report, is anyone able to offer assistance?

Thanks

Hi ​@chenderson24 

Have you tried to create a query to extract aged debtor data and order by transaction date instead of due date.?

 

For example;

SELECT
    customer_id,
    invoice_id,
    transaction_date,
    amount_due,
    age
FROM
    customer_ledger
WHERE
    amount_due > 0
ORDER BY
    transaction_date;
 

Hi you can also use

  1. the Customer Open Item Balance History, export and structure the items in Excel
  1. Use customer Credit Management (you have to update the date at the last day of the month) Aging Buckets can be setup in the Basic Data, also export into excel.
  2. Audit Interface

           You will receive 2 Files.
 

The text File contains the results from the report (I agree you have to pimp it a little bit in Excel ;)
 

The export can be used in also non german countries like this.The export Format is always

semicolon separated and can be easily imported into Excel.

Note that there are multiple other audit sources available, some view based some report based. The export will always have a text file as a result (the xml files describes the columns of the text file)

Thanks both, i will try and run the report again as per your instructions and will let you know how i get on!

Hi both, i’ve still been unable to get this report, i need to be able to back date it to our aged debtors as per 31.12.24 and have it by transaction date, do you have any ideas?

Reply


Terms & ConditionsCookie settings