sales invoice

 

Sales invoices can only be created from order shipments that have been marked as 'Completed' and posted. The sales order must be in 'Approved status. Multiple shipments can be made for each order so that each shipment will be invoiced separately. In the Business Usages tab of the Customers document, there is an invoice consolidation option that will consolidated the shipments for the bill-to customer for all ship-to locations that have the Consolidated flag marked. For example, if there were three shipments for the same bill-to customer with three different ship-to locations and the Consolidated flag is marked, all shipments will be created on one invoice.

 

The sales invoice details cannot be modified. All details default from the pricing details established on the sales order and the quantity shipped. There is an option in the registry to determine how the invoice date is defined:

 

The following procedures are outlined in the Sales Invoice document:

Create a Sales Invoice

  1. In General>Sales, select Invoices.

  2. In the Sales Invoices index, click to create a new sales invoice.

  3. The Invoice Shipment dialog box will display all orders that have been posted, and the sales order is marked as 'Approved'.

  4.  

     

  5. Click on the sales orders that are to be invoiced and then click 'OK'. Use the Options>Select All feature from the toolbar to select all available shipments for invoice. If the Consolidated Invoice option is selected, shipments will be grouped on invoices for those customers that are consolidated.

  6. Open the required invoice from the Sales Invoices Index.

Sales Invoice Header

The sales invoice header contains the base data to outline the sales invoice. The header is divided into four sections to group the data. With the exception of the Invoice Information tab, all of the information in the fields is derived from the sales order.

 

Bill-To

The Bill-To tab contains the base data for the bill-to customer. The fields in the Bill-To tab default from the sales order and cannot be modified.

 

  1. Bill-To No indicates the number of the bill-to customer.
  2. Bill-To Name displays the name of the bill-to customer.
  3. Bill-To Address 1-4 fields display the address details of the bill-to customer.
  4. Bill-To City identifies the city in which the bill-to customer is located.
  5. Bill-To Country displays the name of the country in which the bill-to customer is located.
  6. Bill-To State identifies the state in which the bill-to customer is located.
  7. Bill-To Zip displays the zip or postal code of the bill-to customer.
  8. Selecting the Void flag will cancel the invoice.
  9. Creation Date indicates the date the invoice was created.
  10. Last Mod Date indicates the date the invoice was last modified.
Ship-To

The Ship-To tab contains the base data for the bill-to customer. The fields in the Bill-To tab default from the sales order and cannot be modified.

 

  1. Ship-To No identifies the customer that received the product.
  2. Ship-To Name displays the name of the receiving customer.

  3. Ship-To Address 1-4 fields display the address details of the ship-to customer.
  4. Ship-To City identifies the city in which the ship-to customer is located.
  5. Ship-To Country displays the name of the country in which the ship-to customer is located.
  6. Ship-To State identifies the state in which the ship-to customer is located.
  7. Ship-To Zip displays the zip or postal code of the ship-to customer.
  8. Delivery-To Customer No identifies the deliver-to customer.
  9. Delivery-To Customer Name displays the name of the deliver-to customer.
Invoice Information

The Invoice Information tab contains the base details for the sales invoice.

  1. Invoice Type defaults to Order Invoice.

  2. Invoice No is assigned based on the next number available in Counters.

  3. Invoice Date is calculated based on the registry option defined in System>Sales Invoice Date Mode. The invoice date can be established based on Ship Date, Delivery Date or Current Date. Payment terms are calculated based on this date.

  4. Invoice Amount indicates the amount that must be paid by the bill-to customer. The invoice amount will be a total of all of the invoice lines including product, add-ons and taxes.

  5. Delivery Date displays the date that the product was delivered to the customer.

  6. Ship Date displays the date that the product was shipped to the customer.

  7. Currency defaults based on the currency assigned to the sales order as defined.

  8. Selecting the Void flag will nullify the sales invoice. The order shipment lines will be available for selection on a new invoice.

  9. In the Notes field, enter any additional comments related to the invoice.

  10. In the Attachment field, any type of accompanying file can be attached. For example, a Word document, picture, music, or video clip.

  11. Print Counter displays the number of times that the invoice has been printed.

  12. Last Print Date displays the last date that invoice was printed.

  13. Print User Id indicates the person responsible for printing the invoice.

Payment Details

The Payment Details tab outlines the details related to payment. The details in the Payment tab default from the sales order and cannot be modified.

  1. Payment Terms No indicates the payment terms assigned to the invoice. Payment terms are defined in Admin> Business> General> Definitions> Payment Terms.
  2. Payment Terms No displays a description of the payment terms assigned to the invoice.
  3. Due Date indicates the date that the invoice is due to be paid.
  4. Discount Date is a calculated field based on the selected payment terms and discount days defined on the payment term. Discount Date is a reference field and there is no associated logic to calculate the discount.
  5. C/D Memo Invoice is only populated for Credit and Debit Memo invoice types and references the source invoice that the credit or debit memo was created from.
  6. The Currency Rate Override flag can be selected if the currency rate should be overridden.
  7. Currency Exchange Rate is an optional field to enter any applicable currency exchange rate.

Sales Invoice Details

The Details grid contains additional details related to the creation of the sales invoice. The fields will default from the sales order and cannot be modified.

 

 

  1. Cost Center No identifies the cost center that shipped the product.
  2. Cost Center Name defaults from Cost Center No and displays the name of the selected cost center
  3. Complex Order No indicates the sales order number.
  4. Sales SKU No identifies the product that is being sold. The sales SKU must be defined on the product before the sales order can be created.
  5. Sales SKU Name defaults from Sales SKU No and displays a description of the product sold.
  6. Invoice Units represents the number of invoice units being sold. The value is derived from the order shipment.
  7. Free Units displays the amount of any applicable free units that are allocated to the invoice. Free Units is calculated using a premium add-on with Transaction Basis set to Free Percentage. The quantity is derived from the order shipment.
  8. Total Units displays the number of Free Units + Invoice Units on the invoice.
  9. Unit Price indicates the per unit price as defined on the sales order.
  10. Amount is a calculated field representing the selling amount of the product before add-ons and taxes. Amount = Invoice Units x Unit Price.
  11. Total Premiums calculates the total premium add-ons assigned to the sales invoices. Premium add-ons must be defined on the sales order to be available on the invoice. Only transaction add-ons will transfer to the sales invoice. Add-on details can be viewed and defined on the Premiums tab of the child grid.

  12. Total Discounts calculates the total discount add-ons assigned to the sales order. Discount add-ons must be defined on the sales order to be available on the invoice. Only transaction add-ons will transfer to the sales invoice.

  13. Total Tax indicates the total amount of applicable taxes based on the tax codes assigned to the sales order.

  14. Total Amount represents the total value of the invoice (Amount + Total Premiums - Total Discounts + Total Tax).

  15. Currency Effective Date displays the date for the rate that is applicable to the sales invoice.

  16. Currency Exchange Rate automatically sets to the current exchange rate based on the rate that is in effect on the invoice date.

  17. The Approved flag is a read-only field that defaults from the Approved flag on the sales order.

Additional Details

Within the Details tab, there is a child grid with additional tabbed details relating to the invoice. The details in the child grid will default from the sales order with no option to modify.

 

 

Premiums and Discounts
  1. Click  to display the child grid for the Line Item No.


  2. Product No displays the code of the selected add-on that transfers from the sales order line.
  3. Product Name will default from Product No and displays a description of the premium/discount.

  4. Transaction Basis is a read-only field that defaults from the selected add-on and determines how the add-on is calculated on orders. Only Transaction type add-ons will be transferred from the order to the invoice.

  5. Payment Type is a read-only field and determines when the premium or discount payment is made.  

  6. The Payee Type field is an optional field that indicates the source type for the premium or discount.

  7. Transaction Entity ID is not applicable to the sales invoice as only add-ons invoiced to the bill-to customer will transfer to the invoice,

  8. Taxable identifies if the item is taxable or non-taxable when the item is sold.

  9. If the Print on Invoice flag is selected, the premium or discount is to be printed on the default system invoice. This option is defined either on the sales sku in the product or the price master.

Taxes

If the product and/or premiums/discounts are taxable, the tax code must be assigned on the Taxes tab. The tax amount will then be calculated based on the taxable order amounts.

 

 

  1. Tax No identifies the tax code to be applied to the product and premiums/discounts for the selected line item. The Taxable flag must be selected in the product and premiums/discounts for taxes to calculate.

  2. Tax Name describes the selected tax code.

  3. The Rate will display the tax rate percentage that is in effect on the date that the product is shipped. The receiving transaction will be recorded based on the tax rate that is in effect on the receiving date. The calculated amounts will be displayed on the product detail line to display a total value of the product being purchased.

 

Instructions

The Instructions tab contains instructions relating to the premium (s) or discount (s).

 

 

  1.  Instruction No indicates the instruction code.
  2. Instruction Name defaults from Instruction No and displays a description of the instruction.
  3. If the Print on Invoice flag is selected, the premium/discount  is to be printed on the default system invoice. This option can be further defined in price lists.

 

Post a Sales Invoice

Once the sales invoice has been created and saved, the invoice needs to be posted. The posting process locks the sales invoice to prevent edits, and creates the journal transaction to record the liability. The UnPost option unlocks the invoice and reverses the journal transactions.

 

  1. In the Purchase Invoice index, select the required purchase invoice and right-click to select 'Post'.

Journal Transaction

The posting process creates the journal transaction. The journal will reverse the accounts payable accrual that was incurred when the product was received and record the payable amount to the vendor.

 

DEBIT Sales Revenue Accrual
CREDIT Accrued Receivables
DEBIT Sales Revenue
CREDIT Accounts Receivable

 

 

 

Create a Debit or Credit Memo

Once the invoice has been saved and posted, a debit or credit memo can be created.

 

  1. In the Sales Invoice main menu, select the required invoice, right-click and select Debit Memo or Credit Memo. *Note: Multiple lines of the same invoice can be selected to create one debit or credit memo.

  2. The Sales Invoice will open with the C/D Memo Invoice referencing the source invoice that the credit or debit memo was created from.

  3. Click the   button to save.