More information

Charge Register

Access this report using Reports>Accounts Receivable>Charge Register.

Use this report to show detail charge information for invoices that have been printed. This data was created using: Activities>Accounts Receivable>Calculate Invoices/Finance Charges and Print/Email Calculated Invoices; as well as, On Account-type Sales Orders created, canceled, or returned using the Activities>Accounts Receivable>Enter Orders, Cancel Orders, and Customer Returns forms.This report also shows if an invoice has been voided through the Void Invoices form.

Additional items, columns, and filters are available if any user defined fields were created by the Administrator using Organization>Set Up User Defined Fields. Only user defined fields with a field type of String, Editable Drop-Down List, Non-Editable Drop-Down List, Date, or Yes/No are available in the Items by Page group box on the Content tab.

User defined fields with a field type of Currency follow the formatting of the organization's functional currency. The functional currency was determined by the Administrator when the organization was created (File>New Organization>Functional Currency panel).

Report Criteria

Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report.

Use this tab to determine what data to include in the report and to define the report layout.

By selecting Available Items, the data is divided onto separate pages. The report starts a new page for each item, and the item is printed in the page header of the report.
By selecting Available Columns, the data that appears in the body of the report is determined.

Column	Description
Invoice Number	The invoice number assigned when the invoice was created (Transactions>Accounts Receivable>Enter A/R Invoices, Enter A/R Credits, and Enter A/R Receipts; Activities>Accounts Receivable>Enter Orders; Activities>Accounts Receivable>Sales Order Fulfillment>Print All Picking Tickets>Print; or Activities>Accounts Receivable>Sales Order Fulfillment>Sales Order Fulfillment Detail>Print Picking Ticket).
Invoice Date	The date assigned to the invoice.
Invoice Comments	The description entered on the Activities>Accounts Receivable>Calculate Invoices/Finance Charges>Finance Charges tab or Activities>Accounts Receivable>Enter Orders form.
Invoice Status	The status of the invoices, such as Printed or Unprinted.
Invoice Type	The type of invoice, such as Calculated or Historical.
Calculation ID	The calculation ID entered on the Activities>Accounts Receivable>Calculate Invoices/Finance Charges form or system generated number off the Activities>Accounts Receivable>Enter Orders form.
Customer ID	The customer ID (from Maintain>Accounts Receivable>Customers) associated with the invoice.
Customer Status	The status of the Customer ID-Active, Inactive, or Discontinued. The report shows A, I, or D.
Customer Name	The name associated with the Customer ID.
Class	The class (if appropriate) assigned to the customer.
Type	The type (if appropriate) assigned to the customer.
Website	The customer's URL for this webpage.
Billing Address	The customer billing address (Maintain>Accounts Receivable>Customers>Addresses tab) associated with the customer.
Billing Customer Contact Name	The name of the billing contact for this customer.
Billing Customer Contact Title	The title for the billing contact person, such as Ms. or Mr.
Billing Customer Contact Position	The billing contact's position, such as Sales Rep or Owner.
Billing Customer Contact Email	The customer contact email for the billing address.
Billing Customer Contact Phone	The customer contact telephone number for the billing address.
Billing Customer Contact Fax	The customer contact fax number for the billing address.
Service Address	The customer service address (Maintain>Accounts Receivable>Customers>Addresses>Service Address) associated with the customer.
Shipping Address	The customer shipping address (Maintain>Accounts Receivable>Customers>Addresses>Shipping Address) associated with the customer.
Resale Tax ID	The resale tax ID from the Maintain>Accounts Receivable>Customer>Customer tab.
Sales Tax Code	The sales tax code (Maintain>Accounts Receivable>Sales Tax Codes) associated with the invoice.
Sales Tax Authority	The tax authority (Maintain>Accounts Receivable>Sales Tax Authorities) associated with the Sales Tax Code.
Charge Code	The unique code that identifies the Charge Code (Maintain>Accounts Receivable>Charge Codes).
Charge Code Status	The status of the Charge Code-Active, Inactive, or Discontinued. The report shows A, I, or D.
Charge Code Description	The description of the Charge Code.
Distribution Code	The distribution code associated with the sales tax authority.
GL Code	The sales tax payable general ledger account.
Currency	The currency type assigned to the charge code, such as USD, CAD, EUR, GBP, or MXN. Currencies were created and activated by the Administrator using the Organization>Currency Setup form.
Currency Description	The description associated with the currency, such as US Dollar, Canadian Dollar, or Euro.
Fixed Charge	The fixed charge amount applied to the charge code.
Quantity	The quantity associated with the charge code.
Unit Price	The unit price associated with the charge code.
Charge Amount	The amount associated with the charge code.
Taxable Line	"Yes" displays if the charge code is taxable.
Sales Tax Line	"Yes" displays if sales tax applies to the invoice.
Finance Charge Line	"Yes" displays if a finance charge applies.
Voided Invoice	"Yes" displays for a voided invoice.
Created By	The login name of the user that created the invoices.
Printed By	The login name of the user that printed the invoices (Activities>Accounts Receivable>Print/Email Calculated Invoices or Activities>Accounts Receivable>Enter Orders).
Sales Order Number	The sales order entry number from Activities>Accounts Receivable>Enter Orders>Information tab.
Sales Order Date	The date associated with the order number.
Sales Order Invoiced	A designation of Yes or No, depending on if the sales order has been invoiced. This indicates that Sales Order is related to an Invoice.
{User Defined Field} - Customers	A customers type user defined field and its data. There will be a separate column for each field that was created by the Administrator using Organization>Set Up User Defined Fields.
{User Defined Field} - Charge Codes	A charge codes type user defined field and its data. There will be a separate column for each field.
{User Defined Field} - A/R Invoice	An A/R Invoice type user defined field and its data. There will be a separate column for each field.
{User Defined Field} - A/R Invoice Detail	An A/R Invoice Detail type user defined field and its data. There will be a separate column for each field.

Use this tab to narrow down and more explicitly define the data to include in the report by selecting from the Available Filters.

Use this tab to set up any Available Options for the report.

Options	Description
Summarize Amounts	Select this option to add amounts together and display one line item with the total amount. All document information must be identical for the system to add items together.
Suppress Lines with All Zeros	Select this option so that documents with zero amounts do not print. This eliminates records having zero in all amount columns. If it is not selected, every line prints, even if it has a zero value.

Use this tab to change the font and page setup for a report.

Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be cleared by any user other than the user that locked the report.

To exclude Charge Amounts from the Total Charges for voided A/R Invoices, select "Voided Invoices" equal to "No," on the Filter tab.
To find Sales Orders related to Invoices, select “Sales Order Number” not equal to “<Blank>,” on the Filter tab.