Creating Invoices FAQ

Question: We had six orders, and only two invoices were generated in Invoice Create and Print. There were no returns in this batch. Why were invoices not created for the other four orders?

Answer: This may occur based on the option entered for the customer in the Invoice Consolidation field on the A/R tab in Customer Maintenance. For example, if by Order is entered in that field, an invoice is not generated for an order that has any unconfirmed pick demands. An invoice will generate only when all pick demands for the order have been confirmed and inventory is adjusted.

Question: How are sales invoice reference numbers assigned?

Answer: It depends primarily on the option entered for the customer in the Invoice Consolidation field on the A/R tab in Customer Maintenance, although there are exceptions.

Invoice Consolidation Option

Invoice Number Result

No

The shipment number, assigned during pick demand creation, will be the invoice number; each pick demand will create its own invoice number (unless created at the same time for multiple pick zones, in which case these related pick demands will have the same shipment number).

by Order

The shipment number, assigned during pick demand creation, will be the invoice number.

by Order/Location

The shipment number, assigned during pick demand creation, will be the invoice number; there could be multiple shipment numbers if the order is for multiple locations.

by Shipment

The shipment number can be manually assigned in Pick Demand Shipment Consolidation before invoice creation and it becomes the invoice number. If the shipment number is not manually assigned, the shipment number is assigned during invoice creation.

by Customer

Similar orders for the same customer are consolidated into one invoice during invoice creation. The shipment number is also assigned during invoice creation.

Note Orders must have these same values to consolidate:

  • Accounts receivable and discount general ledger accounts

  • Currency

  • Currency conversion rate

  • Payment terms

  • Primary sales representative

  • Secondary sales representative

  • Billing customer code

  • Paying customer code

  • Credit card approval code

  • Bill-to address

  • Ship-to address

  • EDI trading partner

by Customer/Route

Similar orders for the same customer on the same route are consolidated into one invoice. The shipment number is also assigned during invoice creation.

Note Orders must have the same values listed for the by Customer option and have the same route number.

by BOL/Customer

All confirmed pick demands for a single customer (and trading partner) on a bill of lading are combined automatically to generate a single invoice. The shipment number is assigned during bill of lading completion or for pick demands not on a bill of lading, during invoice creation.

by BOL/CustPO#

All confirmed pick demands from orders for a single customer (and trading partner) with the same customer purchase order number on a bill of lading are combined automatically to generate a single invoice. The shipment number is assigned during bill of lading completion or for pick demands not on a bill of lading, during invoice creation.

by BOL/BillCust

All confirmed pick demands for a single billing customer (and trading partner) on a bill of lading are combined automatically to generate a single invoice. The shipment number is assigned during bill of lading completion or for pick demands not on a bill of lading, during invoice creation.

by BOL/PO/BillCust

All confirmed pick demands from orders for a single billing customer (and trading partner) with the same customer purchase order number on a bill of lading are combined automatically to generate a single invoice. The shipment number is assigned during bill of lading completion or for pick demands not on a bill of lading, during invoice creation.

by BOL/Alt-PO/Bill

All confirmed pick demands from orders for a single billing customer (and trading partner) with the same alternate purchase order number on a bill of lading are combined automatically to generate a single invoice. The shipment number is assigned during bill of lading completion or for pick demands not on a bill of lading, during invoice creation.

Note The exception to the above rules is when the order class has been defined to generate the invoice number during pick demand creation.

Question: How are return (credit memo) invoice reference numbers assigned?

Answer: Return invoice reference numbers are assigned in the same way as reference numbers are generated for sales invoices when No is selected in the Invoice Consolidation field (see the table above).

NOTE Invoice consolidation is not used for return orders.

Question: How do you set up customers to have invoices emailed or faxed to them?

Answer: Perform the following step:

Question: What are the invoice delivery options?

Answer: The following table lists invoice delivery options:

Option Method

Operation / Setup

Comments

Manual

Click the Print button in the ribbon in Invoice Entry (no setup required)

Prints the selected invoice using Crystal Reports and the invoice report definition

EDI (Batch)

EDI Invoice Export (EDI setups required)

No printing done

Print (Batch)

Invoice Print; Printer option

Prints invoices using Crystal Reports and the invoice report definition

Fax (Batch)

Invoice Print (see setup information above); Contact option

Faxes invoices using a fax interface and a Crystal Reports .pdf file

Email (Batch)

Invoice Print (see setup information above); Contact option

Emails invoices using an email interface with a Crystal Reports .pdf attachment

Email copies of invoices

Customer Open Accounts Receivable Management or Customer Open Accounts Receivable Inquiry (no setup required)

Select the check box in the Print column, select the Email option, click the Print button in the ribbon, and select or enter an email address. Copies of invoices are emailed using an email interface with a Crystal Reports .pdf attachment.

Note Invoices allow for multiple contacts with multiple delivery options.

Example Two faxed invoices to two different contacts, or one faxed and one emailed.

Question: How can I set up different invoice forms for different customers?

Answer: You can assign an invoice form to a customer in Customer Maintenance by entering the Crystal Reports form in the Invoice Form Name field on the Sales tab. You also can assign an invoice form to a billing customer, and it is used for all the customers associated with the billing customer. However, if an invoice form is specified for both the customer and billing customer, the customer form is used.

When printing multiple invoices with different forms, invoices using the same form are grouped together in the print run.

For information on customizing Crystal Reports forms, see Crystal Reports FAQ.