29 Print Ledger Reports

This chapter contains these topics:

29.1 Printing Ledger Reports

You print ledger reports to review the detail of the transactions between your company and your customers and suppliers. When you print customer and supplier ledger reports for France, the system prints the transactions in the accounting format that is generally used by French companies, with debit and credit amounts in two separate columns. In addition, you can specify:

  • Whether you want to print the reports based on main address book numbers or a parent number

  • Currency totaling, where invoices and vouchers with similar currencies are totaled

Printing ledger reports consists of the following tasks:

  • Printing customer ledger reports

  • Printing supplier ledger reports

29.2 Printing Customer Ledger Reports

Navigation

From EMEA Localization (G74), choose French Reports

From French Reports (G093151), choose Customer Ledger Report

The customer ledger report for France includes the following features:

  • Debit and credit amounts are printed in separate columns, rather than in a single column where the amounts are differentiated by a minus sign for a debit or reduction of the credit towards a customer.

  • The amount of the A/R drafts that are generated for a batch of invoices is printed in the credit column the same as any other payment.

  • You can print a report for all the transactions recorded for a certain customer based on a user-specified time lapse.

The system excludes the following documents from the customer ledger report:

  • A/R draft (RiBa) transactions, identified by document type R1

  • Gains and losses on foreign transactions, identified by document types RG and RL

  • Adjustments that are made to original invoices, identified by document type RE

29.2.1 Customer Ledger Report

Figure 29-1 Customer Ledger Report

Description of Figure 29-1 follows
Description of "Figure 29-1 Customer Ledger Report"

29.3 Printing Supplier Ledger Reports

Navigation

From EMEA Localization (G74), choose French Reports

From French Reports (G093151), choose Supplier Ledger Report

The supplier ledger for France includes the following features:

  • Debit and credit amounts are printed in separate columns (instead of a single column where the amounts are differentiated by a minus sign for a debit or reduction of the credit towards a supplier).

  • The amount held when a voucher is paid for a supplier that is subject to withholding tax is printed in the line immediately after the payment, rather than in the Discount Available column.

  • You can print a report for all the transactions recorded for a certain customer based on a user-specified time lapse.

The system excludes the following documents from the supplier ledger report:

  • Voided payments, identified by document type PO

  • Gains and losses on foreign transactions, identified by document types PG and PL

  • Adjustments made to original vouchers, identified by document type PE

29.3.1 Supplier Ledger Report

Figure 29-2 Supplier Ledger Report (1 of 3)

Description of Figure 29-2 follows
Description of "Figure 29-2 Supplier Ledger Report (1 of 3)"

Figure 29-3 Supplier Ledger Report (2 of 3)

Description of Figure 29-3 follows
Description of "Figure 29-3 Supplier Ledger Report (2 of 3)"

Figure 29-4 Supplier Ledger Report (3 of 3)

Description of Figure 29-4 follows
Description of "Figure 29-4 Supplier Ledger Report (3 of 3)"