Collapse AllExpand All

2.1.1.  New Invoice

When you post a Sales Order that has been selected for billing, an Invoice is created for that Order. This is the standard flow for creating Invoices tied to Sales Orders. However, you also have the option of creating miscellaneous Invoices—that is, Invoices which are not tied to Sales Orders. For example, you might use a miscellaneous Invoice to bill for non-Inventory Items you have sold. To create a miscellaneous Invoice, select the "Create Invoice" option. The following screen will appear:

Create New Invoice

When creating an Invoice, you are presented with the following options:

Invoice #

Next available Invoice Number will automatically display, unless your system requires you to enter Invoice Numbers manually. Default values and input parameters for Invoice Numbers are configurable at the system level.

Order #

Will display the relevant Sales Order Number for Invoices generated from the Select for Billing process flow. If the Invoice is miscellaneous and was not generated by the Select for Billing process, then use this field for informational or reference purposes. Possible references might include Sales Order Number or Customer Purchase Order Number.

Invoice Date

By default, the current day's date will be entered.

Order Date

By default, the current day's date will be entered.

Ship Date

By default, the current day's date will be entered.

Customer #

Enter the Customer Number of the Customer to be billed. The lookup feature located to the right of the field leads to a searchable Customers list. You may also access this list using the keyboard shortcut "CTRL + L". Once a Customer Number is entered, the Customer name and billing address will display. Select the "?" or "$" symbol to view Customer information for the specified Customer. If a Customer's credit is "In Good Standing," the button will feature a black question mark ("?") icon. If the icon turns to an orange dollar sign ("$"), the Customer's credit Status is "On Credit Warning." A red dollar sign ("$") indicates the Customer's credit Status is "On Credit Hold."

Note

A valid Customer Number must be entered in the "Customer #" field before Line Items can be added to an Invoice. If no valid Customer Number is entered, you will not be able to add Line Items to the Invoice.

Billing Address

Enter the Customer address where bills should be sent. By default, the billing address defined on the Customer master will be entered here.

Copy to Ship-to

Select to copy contents of billing address into Ship-To address field. This option is enabled if the Customer master for the specified Customer indicates that free-form Ship-To's are allowed.

Sales Rep.

Specify the Sales Representative for the Invoice. By default, the Customer's designated Sales Representative will appear in the field.

Commission

By default, the commission percentage recorded on the Customer master will be automatically entered in this field. If for some reason you select a non-default Sales Representative at Order entry, the commission rate will not change. To adjust the commission rate, you must make the change manually.

Tax Zone

Specify the Tax Zone for the Invoice. By default, the main Tax Zone for the Customer will appear in the field. The Ship-To Address Tax Zone will be shown if a Ship-To Address is being used.

Terms

Specify the billing Terms for the Invoice. By default, the Customer's standard billing terms will appear in the field.

Ship-To #

Enter the number of the preferred Ship-To Address. Customers may maintain multiple Ship-To Addresses. If the Customer master for the specified Customer indicates that free-form Ship-To's are allowed, then any address may be entered. If free-form Ship-To's are not allowed, then the Ship-To Address must be entered using the browse button located to the right of the field. The lookup feature leads to a searchable Ship-To Addresses list.

Cust. PO #

PO #: Enter a Customer Purchase Order Number, as needed.

F.O.B.

Enter free on board (FOB) terms for the Invoice.

Ship Via

The preferred Ship Via method for the Customer will appear in the field. You may change the Ship Via using the list.

Tip

The Ship Via field supports free-form Ship Vias. If you want to enter a free-form Ship Via, simply type the name of the Ship Via into the field.

Shipping Chgs.

Specify the Shipping charges associated with the Invoice. The preferred Shipping Charges Type for the associated Sales Order will appear in the field.

Project #

If your system is configured to use Projects, select a Project Number to associate with the Invoice. If the Invoice was created from a Sales Order—and the Sales Order had a Project Number associated with it—then the Project Number from the originating Sales Order will automatically be entered here.

When you have the xTuple Project Accounting package installed—and you link a Project to the Invoice (or it was linked from the original Sales Order)—the Project Number will be added as the final segment of affected G/L Account Numbers when the Invoice is posted.

Post on Save

Select if you want to post the Invoice automatically as soon as you hit the SAVE button. If not selected, the Invoice will need to be posted in another step. This option is "sticky," meaning the screen will remember your choice the next time you create an Invoice.

To create or modify Invoice Line Items, select the "Line Items" tab at the top of the "Invoice" screen. The following screen will appear:

Miscellaneous Invoice Line Items

When creating or modifying Invoice Line Items, you are presented with the following options:

Line Items

Display lists Line Items for this Invoice. A valid Customer Number must be entered in the "Customer #" field before Line Items can be added to the Order.

Misc. Charge Description

Enter a description to identify the miscellaneous charge.

Misc. Charge Sales Account

Enter a Sales Account to assign the miscellaneous charge to.

Allocated Credit

Displays the monetary value of any Credit Memos and/or Credit Card charges which have been specifically allocated to the Invoice. To allocate Credit Memos to the Invoice, select the "Allocated C/M's" link.

Outstanding Credit

Displays the total monetary value of all unallocated Credit Memos for the Customer.

Authorized CC Payments

Displays the monetary value of any credit card pre-authorizations for the Order. Credit Card charges may be pre-authorized using the options found under the "Payment" tab. When a Credit Card charge is pre-authorized, the authorization is stored and may later be posted as a completed charge using the Receivables Workbench.

Freight Weight

Displays the combined weight of all Sales Order Line Items. Freight weight represents the sum of an Item's product weight and packaging weight, both of which are defined on the Item master. The per unit freight weight multiplied by the quantity per gives you the Line Item freight weight. The sum of all Line Item freight weights is the combined weight for the Order.

Subtotal

Displays the subtotal for the Invoice Line Items.

Misc. Charge Amount

Enter the amount of any miscellaneous charge. Examples of miscellaneous charges include palletization costs, co-op refund, etc. Before entering a miscellaneous charge amount, you must first assign the charge to a Sales Account and also enter a description of the charge.

Freight

Enter the amount of freight charge to be added to the Invoice.

Tax

Tax is not calculated automatically when creating a miscellaneous Invoice—as it is when an Invoice is generated from a Sales Order. You must manually enter a Tax amount if you want to add Tax to a miscellaneous Invoice. To get a detailed view of the Tax calculation, click on the Tax link using your mouse.

Total

Displays total amount of the Invoice.

Outstanding Balance

Displays the open balance of the Invoice, which is equal to the total minus any allocated Credit Memos.

Invoice Characteristics are user-defined definitions which may be used to provide additional layers of description about Invoices. These descriptions are static and not processed by the system, but are useful for informational purposes. To enter Characteristics associated with an Invoice, select the "Characteristics" tab. The following screen will appear:

Invoice Characteristics

When creating a new Invoice Characteristic, you are presented with the following options:

Characteristic

Select a Characteristic from the list of Characteristics designated as being available for use as Invoice Characteristics.

Value

Enter a description for the Invoice Characteristic.

To add Notes to an Invoice, select the "Notes" tab at the top of the "Invoice" screen. If the Invoice was created from a Sales Order, any Sales Order Notes will be transferred to the Invoice. The following screen will appear:

Invoice Notes

When adding Notes to an Invoice, you are presented with the following options:

Notes

This is a scrolling text field with word-wrapping for entering Notes related to the Invoice. Notes entered on this screen will follow the Invoice through the billing process. For example, you may view notes associated with a posted Invoice within the Invoice Information report.

When processing Sales Orders or Invoices, you have the option to allocate open A/R Credit Memos to the document. To allocate open Credit Memos, select the "Allocate" link on the Line Items tab. The following screen will appear:

Attach a Document

When allocating Credit Memos, you are presented with the following options:

Document Total

Displays the total amount of the document being applied to.

Unallocated Balance

Displays the open balance of the document being applied to. When Credit Memos are allocated to the document, the open balance will go down by the amount of the allocations. The balance will go back up if those allocations are cleared.

Credits

Display lists the Customer's open Credit Memos. When a Credit Memo is applied to the document, the list will indicate the relationship between the two. If the allocation is cleared, the list will update to remove the relationship.

The following buttons are unique to this screen:

ALLOCATE

Highlight a Credit Memo and then select this button to allocate the Credit Memo to the document. Partial Credit Memo amounts may be allocated if the document's open balance is less than the full Credit Memo amount.

CLEAR

Highlight a Credit Memo and then select this button to clear the Credit Memo allocation.

To create recurring Invoices, select the "Advanced" tab. The following screen will appear:

Recurring Invoices

When creating a recurring event, you are presented with the following options:

Recurring

Check this box if you want the event to repeat itself at regular intervals, using the frequency settings you specify below. Recurring events are generated when you run the recurring items utility, which is described in more detail here: Section 9.2, “Create Recurring Items”.

Every

Enter a number and select a unit of time to describe how frequently you want the event to occur. You can choose any regular schedule, ranging from once every 1 minute to once every 99 years.

From

Enter a date and time at which to start the first event. The default value is the time the screen opened. The "From" option only appears on some screens.

Until

Enter a date and time after which the event should no longer occur.

Create no more than

Enter the maximum number of future copies of this event you want the system to maintain. Whenever the Create Recurring Items screen is run, it will create up to the number you enter here.

Warning

If you delete all copies of a recurring event, the event will stop repeating even if the "Until" date has not yet been reached. xTuple recommends setting this to at least 2 to reduce the likelihood of deleting all copies of the event.

2.1.1.1. Invoice Item

To add a new Invoice Line Item, select the NEW button. The following screen will appear:

Create Invoice Line Item

When creating a new Invoice Line Item, you are presented with the following options:

Invoice #

Displays the Invoice Number specified in the "Invoice" screen.

Line #

Displays the Line Item Number for the current Line Item.

Item Type

Indicate the Item Type for the Invoice Line Item, by selecting one of the following options:

Item

The lookup feature located to the right of the field leads to a searchable list of Inventory Items. The list will contain sold Items available for purchase by the specified Customer. The list of available Items may vary from Customer to Customer, depending on how Pricing Schedules are implemented at your site. Once an Item Number is entered, the Inventory Unit of Measure and Item description will automatically appear. Additionally, you may also specify the Item's supplying Site. Items may be supplied from multiple Sites. Sites designated as "Sold from" Sites in the Item Site master for an Item are considered "Supplying Sites" on this screen. By default, the Item Site with the highest Ranking will be selected as the supplying Site. If more than one Item Site share a Ranking of "1", the default supplying Site will be selected in alphabetical order. Item Sites are ranked using the Ranking mechanism on the Item Site master.

Miscellaneous

Enter a name and description for the miscellaneous, non-Inventory Item you are billing the Customer for. The name and description fields are free-form, meaning they accept unlimited alphanumeric characters. You must also select a Sales Category. Sales Categories are used to identify the General Ledger (G/L) Accounts to be used when non-Inventory Sales transactions take place.

Alternate Revenue Account

Specify an alternate Account to be used as the Revenue Account. This account will be used instead of the typical Accounts pre-defined in the Receivables Assignments.

Customer P/N

If applicable, enter a Customer Part Number to further identify the Item you are billing the Customer for. In the case of Inventory Items, the Customer Part Number will display automatically if you enter an Item Alias in the Item Number field. To enter an Item Alias, place the cursor in the Item Number field and then use the keyboard shortcut "CTRL + A". After you have entered a valid Item Alias, hit the TAB key. A list of Items that use the specified Item Alias will be displayed. Select the desired Item from the list. The Item Alias will display as the Customer Part Number. Item Aliases are defined on the Item master.

Qty. Ordered

Enter the quantity of the Item you are billing for. The quantity ordered for Inventory Items is measured in the Item's Inventory UOM.

Note

The Quantity Ordered for Inventory Items is based on the Inventory UOM. But the Price is based on the Price UOM. Whenever these two UOMs are not identical, the Extended Price for a Line Item will be based on the following formula:

(Qty. Ordered) x (Price/Inv. Ratio) x (Net Unit Price)

If for some reason the Prices don"t look correct, check the Item master for the Line Item in question. It may be that the Inventory and Price UOMs do not exist in a 1:1 relationship.

Qty. Billed

Specify the quantity of ordered Items you are billing for.

Update Inventory

Select if you want the quantity billed to be removed from Inventory when you post the Invoice. If not selected, your Inventory will not be updated.

Qty. UOM

Specify the Unit of Measure to be used when selling the Line Item. Sold Items may be assigned multiple Selling UOMs. These alternate UOMs may be defined on the Item master. If a Line Item has no Selling UOM defined, then the Inventory UOM will be used here by default.

Net Unit Price

Displays the Unit Price for the Invoice Item. By default, the system will choose the lower of the following two Prices: A) The most-specific Pricing Schedule Assignment or B) any Sale in effect at the time of Order entry. The specificity of Pricing Schedule Assignments is determined in the following descending order: By Customer Ship-To Address (most specific), by Customer, by Customer Type, by Customer Type pattern, by all Customers. The lookup feature located to the right of the field leads to a Price List screen.

Note

For Inventory Items having assigned Pricing Schedules, the Net Unit Price will be automatically calculated using the information provided above. For miscellaneous Items, the Net Unit Price must be entered manually.

If your Pricing Schedule has multiple Units of Measure (UOM) on it (or if several Pricing Schedules share the same level of Price specificity, but they have different UOMs) then the UOM which matches the selected UOM will be chosen—that is, as long as the quantity break does not exceed the quantity being priced. If no entry matches the UOM with a quantity break less than the quantity being priced, then the lowest value Price for any UOM will be chosen. To make sure a specific UOM is always chosen at the desired level of Price specificity, then your Pricing Schedules should include at least one UOM with a quantity break of 0.

Tip

The system can be configured to prevent users from editing the Net Unit Price. If your system is configured that way, the Net Unit Price field will not be editable.

Pricing UOM

The Price Unit of Measure is the same as the Selling UOM. If an Item has Selling UOMs defined, then the Item may be sold and priced in these alternate UOMs. If no Selling UOMs are defined, then the Inventory UOM will be used here by default.

Extended Price

Displays the Extended Price. The Extended Price for a Line Item is based on the quantity ordered multiplied by the Net Unit Price.

To view Costing and Tax information related to the Invoice Item, select the "Detail" tab. You will be presented with the following options:

Unit Cost (Inv. UOM)

Displays the Standard Cost per unit in the Item's Inventory Unit of Measure.

List Price

Displays the Item's List Price per Inventory UOM.

Customer Price

Displays the Price (per Inventory UOM) given to the specified Customer for the specified Item. Special Customer Prices can be set for individual Customers or Customer Groups by using a Pricing Schedule.

Tax

The following Tax-related information is available:

Type

Specify the Tax Type for the Invoice Item. If the Item master does not have a Tax Type for the Invoice's Tax Authority, then no Tax will be charged.

Tax

Displays the amount of Tax to be charged for the Invoice Line Item quantity. To get a detailed view of the Tax calculation, click on the Tax link using your mouse.

To add Notes to an Invoice Line Item, select the "Notes" tab at the bottom of the screen. If the Invoice was created from a Sales Order, any Sales Order Line Item Notes will be transferred to the Invoice. The following screen will appear:

Invoice Line Item Notes

When entering Invoice Line Item Notes, you are presented with the following options:

Notes

This is a scrolling text field with word-wrapping for entering general Notes related to the Invoice Item.