Bill Create

Bill Create (27.3.2.1) enables you to select invoices according to customer billing schedules and create bills that contain those invoices. The functionality on the Bill Create screen is similar to the Set Bill Date screen, but Bill Create creates a bill record for the selected invoices when you click Save.

Note: A bill can contain any number of invoices, as long as they are for the same customer and in the same currency.

You can create several bills for different customers simultaneously. The bill records contain the invoices you select and the bills are grouped first by customer, then by currency, then by bill date, and then by entity.

Use the lookup to select a customer or customers. You can create bills for all your customers by leaving this field blank.

Select an invoice reference date. This date refers to the Invoice Date or Invoice Due Date, depending on the billing scheduling settings. You can view these settings in the Select Invoice Based On field in Billing Schedule View. If you select a date range for which holidays have not yet been set up, a warning is displayed.

Specify the bill collector for the invoices. The default bill collector is set on the Payment tab in Customer Modify.

Select this field when you want to recalculate to the date in the Billing Schedule or when you have a Set Fixed Bill Date field entry you want to apply.

Select this field when you want to search for customer invoices in multiple entities with the same customer shared set.

To set a fixed bill date, choose a day from the calendar and click Search. This date updates the Bill Date for all invoices to the new date in the Bill Date column. However, you can clear the Selection field for any invoices you do not want to bill on the new date.

When you click Search, the grid displays all invoices that fall within the search criteria, except for invoices with staged credit terms. The Invoice Date column displays all the invoices that fall in this period that are not yet assigned to a bill. The Bill Date and Bill Due Date display the bill dates as defined in the Billing Schedule settings. If a bill due date falls on a holiday or at the weekend, it is moved to the next available day.

When you perform a search for invoices, the invoices are grouped by Bill Group by default, as displayed in Bill Create. All the invoices that belong to the same bill based on the customer billing schedule and the currency are displayed in the same group. For each bill group, summary information is displayed, including the balance. You can remove any invoice that you do not want to include on the bill by clearing the selection column.

You can also choose to group the invoices using another criteria such as currency, customer, or entity. Drag and drop the Bill Group column header into the header row to ungroup the invoices and drag the relevant column into the area above.

To display the opening balance for each bill group, use the Open Balance TC column. Use the right-click menu to open the Columns and set the Summary Type for Open Balance TC to Sum. The opening balance summary is then displayed below each group.

When you click Save, a bill is generated for each group and each invoice is assigned a bill number.

A bill can have one of three possible statuses:

• Initial is the status assigned when you create a bill in Bill Create. You can modify or delete a bill with this status.

• Confirmed is the status assigned to a bill when you do a confirm print in Bill Print. You can then no longer modify or delete the bill.

• Closed is the status assigned to a bill when a full payment is received. When one of the invoices is reopened with Open Item Adjustment (25.13), the bill status is automatically reset to Confirmed.