Skip to main content

Documentation Index

Fetch the complete documentation index at: https://help.kwentra.com/llms.txt

Use this file to discover all available pages before exploring further.

Report Business Value: Vendor Listing Details Report helps you see the transactions and Journal Vouchers created on Vendor accounts, whether it’s system-generated from receiving orders & vendor payments for example or created by users directly on the vendor account How does it work? Reports → Backoffice → Receivable → Vendor Listing Details
  1. Select the date range you desire.
  2. Select the Vendor accounts you want to track or leave it empty to select all vendor accounts
  3. Choose the Export option you desire i.e. Excel “XLS / XLSX / ODS” or PDF.
Report Columns Output:
  • Vendor Name:
  • Vendor AccountNumber:
  • Open balance: The account’s opening balance starting from the selected period.
      • GL Period (grouped by month)
        • Date The date of the JV transaction.
        • Serial The serial number of the JV transaction.
        • User The username responsible for the JV
        • Code the JV code (if any)
        • Description (comment) the JV description.
        • Debit JV debit amount.
        • Credit JV credit amount.
      • Total Account Name (row) Shows the total sum of transactions for the displayed account
        • Debit
        • Credit
      • Current Postings (row) is the sum of the transactions that took place within the selected period.
      • Closing Balance (row) is the closing balance of the account at the end of the selected period.

​
Update: 18th of March

​
New Group by Field And Balance Column

The Vendor Listing Details report now has a Group By option and a running Balance column, making vendor account reconciliation faster and more accurate. Business Value
  • Switch between viewing individual transactions and grouping by GL period using a single setting.
  • See the running balance after each transaction — no manual calculation needed.
  • Saves time when reconciling vendor accounts at period end.
Use Cases
  • Finance reviews a vendor’s full transaction history with a running balance to spot overdue amounts quickly.
  • An AP accountant runs month-end reconciliation grouped by GL period — same as before, no workflow change needed.
  • An auditor uses the Balance column to trace exactly when a vendor’s balance exceeded the credit limit.
How It Works Group By Parameter
Where to find it: Reports → BO → Payable → Vendor Listing Details
A new “Group by” parameter has been added to the report filters with two options:
  • None — transactions are listed individually in chronological order with no grouping. The Balance column displays a running balance after each transaction.
  • GL Period — transactions are grouped by General Ledger period. This is the report’s previous default behaviour.
Balance Column A “Balance” column is now included in the report output. It shows the cumulative running balance after each transaction row, calculated as:
  • Opening Balance + Debits − Credits = Running Balance at each row.
When “Group by: GL Period” is selected, the Balance column shows the period-end balance after each period group. This matches the behaviour of the Account Listing Details report. Backward Compatibility Existing saved report configurations will continue to work. The default value for the new “Group by” parameter for new report runs is “GL Period”, which preserves the previous grouping behaviour. Change to “None” to access the new ungrouped running-balance view.
Note: The Balance column figure at the last row of the report equals the vendor’s total outstanding balance as of the report end date.