Payables and vendors management AE041

General description #

This extensions adds several reports for managing payables and vendors. The reports can be accessed through the Tell Me.

Vendor Ledger Entry Overview #

Report ID: 79023 (landscape) a 79024 (portrait)

A report that lists all vendor ledger entries. We can filter to specific types of documents and sort output according to different criteria. Available documents are outputs, invoices, credit memos, finance charge memos, reminders and refunds The report is available in both portrait and landscape layouts.

Vendor Balance #

Report ID: 79032

A report showing vendor balances where we can find the posting date, all document types, external document number, vendor balance, and due date.

  • Date from & Date to - Balance check interval
  • Print details – Details of individual items
  • Print summary by currency - In the end part of the report, a summary by currency is printed
  • Print summary by vendor/currency – In the end part of the report, a summary by vendor/currency is printed.
  • Print Summary by Posting Group - In the end part of the report, a summary by posting group is printed
  • Show Remaining Amount to date – Shows Remaining balance to Date to
  • Filters - for Vendors and Vendor entries

Payables 30-60-90 #

Report ID: 79033

This reports displays the payables of all or selected clients. The payables are displayed in selected time intervals.

  • Due -You can select Backward (not due) or Forward (overdue).
  • Amount in LCY - If set to true, amounts are printed in local currency instead of their original currency.
  • To Date - Limits the range, in which the Due functionality looks for entries.
  • Print overview by vendor - Summary by individual vendors
  • Print overview by posting group - Summary by posting groups
  • Intervals - Possibility to set custom range on the maturity of payables
  • Filters - for Vendors and Vendor entries

Simplified layout for excel export #

Simplified .rdlc report layout is available for easy export to excel. You can choose what layout to use on the Report Layout Selection pagee. Download

Full layout for excel export #

New full layout Payables 30-60-90 - Excel export for exporting into Excel has been added.

  • When printing overview by customer:
    • Option to print Description from Vendor Ledger Entry.
    • Option to print Vendor's Posting group.
    • Option to print Payable Account from Vendor Posting Group.
  • When printing overview by posting group:
    • Option to print Payable Account from Vendor Posting Group.
  • When not printing by LCY the new column with Totals in LCY has been added as the last column.