Detailed Party Ledger

This report shows what sits behind a partner balance: every invoice line with quantity, net unit price after discount and tax, discount, tax and a running balance. Accountants and sales managers use it to reconcile with customers and vendors and to answer price questions. It is added under the Accounting reports and reads posted (and optionally draft) entries across selected partners. It exports to PDF and Excel and supports Arabic and English with right-to-left layout.

1. 1

   Open the ledger wizard

   The user opens the Party Ledger Detailed entry under the accounting reports menu. A wizard appears with company, dates, partners and options. Access requires the party ledger user group. Nothing is stored except the temporary wizard record.

   • Menu under accounting reports
   • Requires the ledger user group
   • Company defaults to the current one
2. 2

   Choose partners and period

   The user sets date from and to, picks one or many partners and chooses the partner type (customer, vendor or both). The opening balance is calculated one day before the start date. The user can also select the currency. Each partner is reported separately.

   • Date from and to
   • Select partners and partner type
   • Pick the currency
3. 3

   Filter posted or draft entries

   The Target Moves option limits the report to posted entries or includes drafts. This lets the user review unposted invoices before closing a period. The choice is applied to the opening balance and the movements alike. The result reflects the selected filter in its title.

   • Posted only or include drafts
   • Applies to opening balance too
   • Review before closing a period
4. 4

   Tune the display

   The user chooses a font scale and how product names appear on the lines. Larger fonts help printing for review, smaller ones fit long ledgers. The choices only affect the printout. Arabic and English text is rendered right-to-left or left-to-right as needed.

   • Font scale option
   • Product name mode option
   • RTL and LTR handled
5. 5

   Print the PDF

   Print PDF produces the ledger with opening balance, product lines with quantity, net unit price, discount percentage and amount, tax amount, net line total and running balance. Two PDF actions exist, one with the company header and one plain without letterhead. The layout uses a dedicated paper format. The report can be reprinted at any time from the wizard.

   • Print with or without company header
   • Net price after discount and tax
   • Running balance per line
6. 6

   Export to Excel

   Export to Excel builds a workbook in which each partner has a separate sheet, and the file is offered for download from the wizard. It carries the same columns as the PDF. Accountants use it for filtering and further analysis. The generated file name is stored on the wizard record.

   • One sheet per partner
   • Same columns as the PDF
   • Download from the wizard

Back to version applications