Vendor Transactions Report — Printing

Sage ERP Accpac Accounts Payable 6.0

Vendor Transactions Report — Printing

The Vendor Transactions report lists transactions that were posted to vendor accounts during the period you specify when you print the report. You can order the transactions by document date, by document number, or by fiscal year and period.

For information on the contents of this report, see Vendor Transactions Report — Features.

When to print

Print the report when you want to see the current status of your vendor accounts.

Before using

Update account information by entering, importing, and posting outstanding batches.

To print the report

  1. Choose the Vendor Transactions icon from the A/P Transaction Reports folder.
  2. Then select:

Report Type. You can order transactions by document dates, by document numbers, or by fiscal year and period.

From Document Date ... To. Indicate a range of dates for which to include transactions. This option appears when you report transactions by document date or by document number.

From Year/Period... To. Specify the fiscal year and period range for which you want to report transactions. Documents outside this range do not appear on the report. This option appears when you report transactions by fiscal year and period.

Sort Transactions by Transaction Type. Select this checkbox if you want sort transactions by document type for each vendor on the report.

Select Vendors By. Specify up to four criteria to select the vendor accounts to list on the report.

For the first selection criterion, choose from Vendor Number, Vendor Group, or Short Name.

For the remaining three selection criteria choose from the above and Account Set, Vendor Balance, Vendor Equivalent Balance (multicurrency ledgers only), Vendor Name, Currency Code (multicurrency ledgers only), Start Date, and vendor optional fields, if any.

If you do not specify selection criteria, the report includes all vendor records that meet the other criteria you select in this form (for example, the program does not include vendor records with a zero balance unless you select the Print Vendors With A Zero Balance option).

Sort Vendors By. Specify up to four orders by which to sort records for the report.

Choose from: Vendor Group, Account Set, Vendor Balance, Vendor Equivalent Balance (multicurrency ledgers only), Vendor Name, Short Name, Currency Code (multicurrency ledgers only), and vendor optional fields, if any.

If you do not specify sorting criteria, the report orders the records by vendor number.

Show Group Title. If you want to include a title for each sorted group, select the Title checkbox for each group of records you are sorting by.

Show Group Subtotal.  If you want to include subtotals for each sorted group, select the Show Group Subtotal option for groups of records you are sorting by.

[Include] Contact/Phone/Credit. Choose this option if you want to list the vendor's contact person and phone number, and your credit limit for the vendor.

[Include] Space For Comments. Choose this option to leave blank space at the end of each vendor record for your notes.

[Include] Vendors With A Zero Balance. Choose this option to include accounts with a zero balance, for example, to find out which vendor accounts are dormant. Note that an account could have outstanding transactions even with a zero balance, for example, an offsetting invoice and credit note.

[Include] Totals By Transaction Type. Choose this option to list a total for each transaction type (invoices, debit notes, credit notes, interest, and prepayments) after the listing for each vendor.

Select Transaction Types. Select one or more transaction types to include on the report. The choices are Invoice, Debit Note, Credit Note, Interest, Prepayment and Payment.

[Show] Applied Details. Choose this option to include all the documents such as payments and credit notes that were applied to each reported invoice. If you do not select this option, the report shows only the balance owing for each document.

[Show] Fully Paid Transactions. Select this option to list documents that are fully paid, but not yet cleared from Accounts Payable.

Print Amounts In. If you use multicurrency accounting, use this option to select the currency for the report. You can list transaction amounts in the vendor currency or the functional currency. If you list transactions in the functional currency, and you have performed a revaluation, the report shows the new functional amounts.

  1. Click Print.

    If printing to a printer, Accounts Payable displays the print destination form to let you confirm your printer selection and change the number of copies to print. Choose OK if the settings are correct; otherwise, choose Cancel or Setup.

    If printing to a file, Accounts Payable displays the name of the file, so you can change it or cancel printing.

    If printing to the screen (preview), Accounts Payable displays the report. If you want, you can then export it to a file or send it to the printer.

    If printing to an e-mail, Accounts Payable displays an e-mail message form for you to fill in, and inserts the report as an attachment when you choose Send.

    If printing to a schedule, Accounts Payable displays the Schedule Report form.

 

Related Topics