Skip to content

Supplier reports

In this section, you will find the information about the supplier reports and their related options.

Checks and payments log

To generate this report, from the GEM-CAR 14 Main menu, go to Reports > Supplier management > Checks and payments log.

The checks and payments log report consists of a list of all checks to suppliers. It contains information about:

  • check numbers;
  • dates;
  • supplier numbers;
  • supplier names;
  • net amounts;
  • discount amounts; and
  • total amounts.

Options

Before generating the checks and payments log report, follow the guidelines below to configure the options.

  • Period: Enter the period in this field.

  • Date from and Date to: Select a period by entering dates in these fields or retrieve them using the calendar buttons.

  • Supplier number: To generate the report for a specific supplier only, enter the supplier number in this field.

  • Bank: To generate the report for checks made from a specific bank only, select the bank using this drop-down menu.

  • Check number: Select this option to sort the report by check numbers.

  • Branch: Select this option to sort the report by suppliers.

  • Date: Select this option to sort the report by dates.

  • A to Z: Select this option to sort the report in ascendant order.

  • Z to A: Select this option to sort the report in descendant order

Accounts payable aging

To generate this report, from the GEM-CAR 14 Main menu, go to Reports > Supplier management > Accounts payable aging.

You can generate 2 versions of this report. The Summary version contains a list of all supplier accounts payable. It features:

  • supplier numbers;
  • supplier names;
  • supplier telephone numbers; and
  • payable total amounts.

Payable amounts are also divided between 5 columns:

  • since less than 30 days;
  • since more than 30 days;
  • since more than 60 days;
  • since more than 90 days; and
  • since more than 120 days.

The detailed version contains the same information and columns, but also details all transactions.

Options

Before generating the Accounts payable aging report, follow the guidelines below to configure the options.

  • Period: Enter the period in this field.

  • Numeric: Select this option to sort the report numerically by supplier numbers.

  • Alphabetical: Select this option to sort the report alphabetically by supplier names.

  • End date: Enter the end date for the report in this field.

  • Supplier number: To generate the report for a specific supplier only, enter the supplier number in this field.

  • Summary or Detailed: Select either Summary or Detailed to generate the summary or detailed version of the report.

Summary of distributions (Suppliers)

To generate this report, in the GEM-CAR Main menu, go to Reports > Supplier management > Summary of distributions (supplier).

On the Summary of distributions (supplier) report, you will find the following information:

  • ledger numbers;
  • descriptions;
  • total amounts;
  • total petty cash payments;
  • total accounts payable; and
  • total distributions.

Options

When generating the report, you can configure the options below.

  • Period: Enter the period in this field.

  • Date from and Date to: Select a period by entering dates in these fields or retrieve them using the Calendar buttons.

  • Supplier number: To generate the report for a specific supplier only, enter the supplier number in this field.

  • First GL code and Last GL code: By default, GEM-CAR will include all ledgers on the report. Enter ledger numbers in these fields or retrieve them using the magnifying glass buttons to set the ledger range included on the report.

Accounts payable analysis

To generate this report, in the GEM-CAR Main menu, go to Reports > Supplier management > Accounts payable analysis.

On the Accounts payable analysis report, you will find the following information:

  • supplier names;
  • supplier numbers;
  • invoice dates;
  • invoice numbers;
  • invoice amounts;
  • expiration dates;
  • pay dates;
  • check numbers;
  • purchase order numbers;
  • paid amounts;
  • balances; and
  • supplier totals.

Options

When generating the report, you can configure the options below.

  • Numeric: Select this option to sort the report numerically by customer numbers.

  • Alphabetical: Select this option to sort the report alphabetically by customer names.

  • Supplier # from and Supplier # to: Enter supplier numbers in these fields to set a starting and ending point for the list. The default values 0000000000 and ZZZZZZZZZZ correspond to all suppliers. To generate the report for one supplier only, enter the same supplier number in both fields.

  • Inlcude accounts at 0: Select this option to include accounts with 0$ amounts on the report.

  • Date: Enter the date in this field or retrieve it using the Calendar button.