Field Descriptions

Table Information

FAQs

Enter Manual Bills

What can I do in this screen?

Use this screen to enter billing information for customer and project billings calculated and printed outside of Costpoint. The Post Manual Bills process (Projects\Process\Post) updates the AR_DETL_HS, AR_HDR_HS, and the MANUAL_BILL_HS tables when invoices that have been entered in this screen are posted.   

Warning: Do not use this screen to enter invoices generated in Costpoint.

The Enter Manual Bills screen is made up of one block, a table window, and three subtasks.  You can use them in the following manner:

Note: There is no screen for the MANUAL_BILL_HS table. The Pay When Paid feature uses the MANUAL_BILL_HS table.

When should I use this screen?

Enter manual billings after preparing customer and project billings off-line.

FAQs

How can I reverse an incorrect billing?

You can reverse all types of manual bills in this screen including Project Product Bills, Customer Product Bills, and Milestone/Percent Complete Bills.  The recommended way to reverse bills, however, is in the screen of original entry.

Use negative invoice amounts to reverse an incorrect manual bill.  Enter the identical Customer ID, Project ID, and Customer PO fields as were on the original invoice.  

Use the Enter Cash Receipts process to offset the two invoices against each other so that the  Accounts Receivable Aging report will be properly stated.

Use the Reverse Previous Bills process (Projects\Process\Billing) to correct Standard Bills or Progress Payment Bills.

How should I select an invoice number for my bill?

Select any invoice number that you want to use as long as it is unique on a system-wide basis.  

To determine if there is a duplicate invoice number, the system evaluates the accounts receivable history tables, and the Edit Standard Bills, Edit Progress Payment Bills, Enter Milestone/Percent Complete Bills, Enter Customer Product Bills, Enter Project Product Bills, Create Sales Order Invoices, Enter Shipping Transactions, and Print COBRA Coupons /Create Invoice screens when you enter an invoice number.  If a duplicate is found, the system displays an error message and you will be unable to save the record.  

Field Descriptions

Details

Use this block to enter the period that you want to post the invoices, the invoice date, and the due date.  The system will display the entry info and date based on the user ID and the system date.

Use this block before entering data into the table window.  The data entered in this block will define to which period the invoices will be posted as well as their invoice and due dates.

Period Information

Use the fields in this group box to select the period to which the bill should be posted.

Fiscal Year *

Enter, or use Lookup to select, the open fiscal year to  post the manual invoices.

Period *

Enter, or use Lookup to select, the open period to post the manual invoices.

Subperiod *

Enter, or use Lookup to select, the open subperiod to post the manual invoices.

Defaults

Use the fields in this group box to select the invoice date and due date.

Invoice Date

Enter, or use Calendar Lookup to select, the invoice date that will be the default in the table window. You can edit this date in the detail lines in the table window, as needed. If you do not want any date to default to your invoices, leave this field blank.  

The default for this field will be the system date.

Due Date

Enter, or use Calendar Lookup to select, the default due date that will be the default in the table window.  You can edit this date in the detail lines in the table window as needed.  If you do not want a due date to default, leave this field blank.

Entry Info

Use the non-editable fields in this group box to view the user entry information.  

User

This non-editable field displays the entry ID of the user.

Date

This non-editable field displays the date the transaction was entered.

Table Window

Record manual invoices in this table window, which has been designed to allow you to quickly enter multiple invoices. (For example, you can enter a bi-weekly or monthly billing cycle of invoices at one time.)

Invoice Number

This field displays a unique system-generated invoice number created by the system when you enter and save a manual invoice.  If you have an invoice number already selected for your invoice, you should enter that invoice number in this field.

If you enter your own invoice number, the system will check the AR History table to see if that invoice number already exists.  The system will display a warning message if an identical invoice number is found in the history tables.  If you continue and post the invoice, the invoice you are posting will be combined with the one already in the history table. This feature can be used to make corrections to previously posted invoices.

The system also checks the Enter Milestone/Percent Complete Bills, Enter Project Product Bills, Enter Customer Product Bills, Edit Standard Bills, Edit Progress Payment Bills, Create Sales Order Invoices, Enter Shipping Transactions, and Print COBRA Coupons/Create Invoice screens to determine whether a duplicate invoice number exists. If a duplicate is found, the system will display a  warning that a duplicate has been found.  You can elect to post it and have the invoices combine, or you can select a new invoice number.   

Customer ID *

Enter, or use Lookup to select, the customer account to which this invoice should be posted.

Customer Name

This non-editable field displays the name of the customer that is linked to the Customer ID entered in the Customer ID field.  Customer IDs and the related names are entered in the Customers screen (Accounting\Maintain\Customers).

Bill To *

Enter, or use Lookup to select, the address code for the address to which this invoice should be sent. Only those addresses saved for this customer in the Customers screen (Accounting\Maintain\Customers) are allowed.

Remit To

Enter, or use Lookup to select, the address code for the address to which the customer should send payment. Only those remittance addresses saved in the Remittance Addresses screen (Projects\Configure\Billing) are allowed.

Project ID

Enter, or use Lookup to select, the project to which this invoice should be posted. You can enter invoice data by project abbreviation. If you do, this field will automatically display that project.

Project Name

This non-editable field displays the name of the  selected project.

Project Abbreviation

Enter, or use Lookup to select, the project abbreviation for the project you want to bill. You can set up project abbreviations in the Basic Info screen in the Project User Flow (Projects\Maintain\Project).   

The project number will automatically display in the Project ID field when you enter the project abbreviation in this field.

Invoice Date *

Enter, or use Calendar Lookup to select, the date for which the invoice was calculated. If you entered a date in the default Invoice Date field in the header, that date displays in this field and can be edited.

Due Date

Enter, or use Calendar Lookup to select, the due date of the invoice. If you have entered a date in the default Due Date field in the header, that date is displayed in this field and can be edited. The due date is one of the selection criteria for the aging of accounts receivable.

Tax Code

Enter, or use Lookup to select, the sales tax/VAT code for this invoice. You can maintain tax codes in the Sales/Value Added Tax screen.

Tax Amount

Enter the sales tax or value added tax amount for this invoice.

Other Charge Code 1

Enter, or use Lookup to select, a valid other charge code number 1.

You can set up valid other charge codes in the Other Billing Charges screen (Projects\Configure\Billing) to enter miscellaneous billable items. Since manual bills are not printed, the accounts designated to record the other charges appear on the billing journal posting.

Other Charge 1 Description

This column displays the default description of the other charge code number 1. It is shown for informational purposes only and cannot be changed because it does not print on the billing journal posting.

Other Charge 1 Amount

Enter the amount of the other charge.

Other Charge Code 2

Enter, or use Lookup to select, a valid other charge code number 2.

You can set up valid other charge codes in the Other Billing Charges screen (Projects\Configure\Billing) to enter miscellaneous billable items. Since manual bills are not printed, the accounts designated to record the other charges appear on the billing journal posting.

Other Charge 2 Description

This column displays the default description of the other charge code number 2. It is shown for informational purposes only and cannot be changed because it does not print on the billing journal posting.

Other Charge 2 Amount

Enter the amount of the other charge.

Other Charge Code 3

Enter, or use Lookup to select, a valid other charge code number 3.

You can set up valid other charge codes in the Other Billing Charges screen (Projects\Configure\Billing) to enter miscellaneous billable items. Since manual bills are not printed, the accounts designated to record the other charges appear on the billing journal posting.

Other Charge 3 Description

This column displays the default description of the other charge code number 3. It is shown for informational purposes only and cannot be changed because it does not print on the billing journal posting.

Other Charge 3 Amount

Enter the amount of the other charge.

Total Invoice Amount *

Enter the total invoice amount.

Discount Amount Available

Enter the amount of any discounts, if available.

Bill Number

Enter the bill number that you have assigned to this invoice.

Customer PO Number

Enter the corresponding customer PO number, if applicable.

Billing Currency

Your company's default transaction currency will display by default in this field.  

Use the Exchange Rates subtask to change this currency. You can also use this subtask to change the exchange rate(s) for these manual bills. The rows in this table are not required to have the same billing currency, but the total will NOT display when different currencies are used in this table window.

Document Location

Use this field to attach a file to your manual bill. You can use this feature to attach a copy of this bill, the section of the contract that defines the billing requirements, documentation for the bill such as timesheets or vouchers, or other information regarding contract funding.

You must enter manual bills before you can use this field. You should attach documents in this field before you post the bills.

Enter the location of the file that you want to attach to your bill. You can also select the Browse for file pushbutton to the right of this field to open a dialog and navigate your network to locate the file that you want to attach to your bill.

Use the Open file pushbutton to view the attached file. The system displays an error message if no document location has been entered.

Notes

Use this field to attach notes to this invoice.

* A red asterisk denotes a required field.

Exchange Rates

Select this subtask link to open the Exchange Rates subtask, where you can enter information about the billing currency of the invoice.  Use this subtask if you are billing in a currency that is not the functional currency of the database.

Invoice Totals

Select this subtask link to open the Invoice Totals subtask, which contains fields that summarize the invoice amounts, including tax amounts, other charges, total invoice amount, and total discount amounts.  The amounts are displayed in both billing and functional currencies.

Customs Info

Select this subtask link to open the Customs Info subtask, which contains fields that are used for Value Added Taxes (VAT).  If you are not using value added taxes on the invoice, this subtask is not required.

Table Information

Changes to this screen update the MANUAL_BILL_EDIT (Manual Bill Edit) table.

Top of Page