More information

Calculated Invoices/Finance Charges

Access this report using Reports>Accounts Receivable>Calculated Invoices/Finance Charges.

Use this report to print the information that was calculated on a Bill (Invoice) but has not yet been processed further. It is intended to be used in conjunction with the Review Modify Calculated Invoices step and to provide a comprehensive view of calculated data in contrast to the one off view available through the Review Modify Calculated Invoices form. For regular (non finance charge) charges, the report will show are all charges calculated but not yet printed in an Invoice. For Finance Charges, the report will show all charges calculated but not yet transferred to history. Finance Charges are considered printed in the system even though they are never part of a printed artifact. The Calculated Invoices/Finance Charge report is comprised of the Invoice number, Date, Customer ID, comments regarding the Charges, and all of the detailed Charge information.

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
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.
Calculation Date	The date the invoice or finance charge was calculated.
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.
Distribution Code Description	The description of the Distribution Code
GL Code	The sales tax payable general ledger account.
Currency ID	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.
Line Number	The line number of the invoice or finance charge.
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.
Finance Charge Invoice Number	The invoice number associated with the finance charge.
Finance Charge Invoice Comments	The comments entered on the invoice associated with the finance charge.
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 find Sales Orders related to Invoices, select “Sales Order Number” not equal to “<Blank>,” on the Filter tab.