CenterPoint® Fund Accounting - Enter an Unpaid Sales Invoice or Return with Inventory

Related Help

Customer Sales Invoice with Inventory Items - Duration: 14 min 30 sec

View or Print as PDF

 

Customer Invoices are used to record a sale of goods or services. If the invoice is entered without a payment, the invoice will increase the customer's balance and the accounts receivable account. A return is entered using the same process, but negative quantities are used instead of positive. In this scenario we will explain the process of entering the sale of inventory items.

Prerequisite

You must have the Inventorymodule purchased and registered in the module configuration manager (File > Administration > Module Configuration Manager) prior to entering customer invoices with inventory items.

CenterPoint offers multiple ways to customize the transaction entry screens. This customization will enable you to enter transactions more efficiently. Click here to view a document that describes the customization you can perform. Click here for an overview of transaction entry.

Entering a Sale or Return of Inventory Items:

  1. To begin entering a sale or return, select Processes > Sales >Customer Invoices from the main CenterPoint Accounting screen.

  1. Enter the Customer by typing in a portion of the customer’s name or abbreviation or click on the lookup button to display a list of your existing customers. Once the customer is selected, the Shipping Method(if a shipping method isn't assigned for this customer, it will display from the default set in File > Preferences > Customer Invoices> Defaults), Salesperson, Terms, Due Date, and Discount Date, Sales Tax and Accounts Receivable fields will be populated automatically from the information assigned to the customer.
  2. Complete all other needed fields on the Select tab. Most fields are optional – complete only those that are pertinent to your business.
  3. Click on the Shipping Address button to specify a different address for the shipping address.
  4. The system will automatically bring you to the Invoice tab when you enter/tab off of the last field on the Select tab. Otherwise one can click on Invoice tab manually. 

  1. Select the first Item sold to the customer by either typing in a portion of the item abbreviation or the item description or click on the lookup button to display a list of items.If you click the Detail button in the data entry grid, you can enter additional details about the transaction, for example for some of the fields you chose not to display on the data entry grid such as associated account, notation, and department. You can also display an Account Balances screen by clicking in the Account box on the Detail screen. This screen will display the latest period balances for the account entered on the grid. If the account is not a balance sheet account, a balance will not display.
Note: If you have the Show Information Grid on (Options button > Show Information Grid), you will see that when entering items on invoices, the Quantity Assigned, On Hand, Available and On Order reflect changes currently in process for the current transaction and others within the system that have not yet been saved. 
  1. If the item specified is a lotted or serialized item, the Lotted/Serialized Item screen will automatically be displayed. Specify the Quantity for each serial or lot number that is being sold. A quantity of 1 is the only acceptable quantity for a serialized item.
Note: if the customer is returning a serialized or lotted item, select the Include lot or serial numbers with 0 Quantities and then specify negative quantities for the return.
  1. For all other inventory items; once the Item is selected the system will automatically display the Description and Sales Price. This information will pull from the information that has been setup on the item. The Quantity Available (for the specified Unit of Measure) is also displayed. The Quantity Available is the quantity in inventory at the time this item was added to the invoice.
  2. The default selling Unit of Measure for this item will be displayed. Additional units of measure that have been assigned to this item can also be used for the sale.
  3. Specify the Quantity sold. A positive quantity is used for a sale, a negative quantity for a return. The Description and Sales Price can also be modified, if needed. The Amount will be calculated automatically (Quantity * Sales Price).
  4. If you set the File > Preference > Accounts > Personal Accounts preference and marked accounts as personal accounts and have a company marked with company type = Personal, you can add a Company column to the data entry grid that will allow you to identify personal vs farm transactions by selecting a company for each line on the data entry grid. This will allow to easily repare consolidated or separate financial reports for your personal/farm companies.
  5. The Substitutes button will be highlighted in red if there is not enough quantity available from the item/location combination and the item has a substitute. Click the button to display the Substitutes Locations/Items screen. The Inventory Locations tab allows you to view the quantity on hand, assigned, available at the locations available in the system. The Substitutes tab lists any substitute items, inventory locations, quantity on hand, assigned, available, on order, and unit of measure.
  6. Continue entering additional lines on the Invoice for each item that is sold to or returned by this customer.
    • If you click the Comments button on the data entry grid, a Line Comments screen displays that allows you to type a 3200 character comment for each line in the data entry grid.
    • If you click the Price Level button in the data entry grid, the Price Levels screen displays the price levels for the pricing method for the item being entered and allows you to select a different price level for the item.
    • If you click the Additional Description button on the data entry grid, the Sales Item Additional Description screen displays that allows you to type in a 3200 character additional description for each line item in the data entry grid.
    • The Taxed check box allows you to indicate if a sales item is taxable or non-taxable on each line of the invoice. If an exemption id is required for this customer, it can be entered in Setup > Customers > Accounting in the Exemption Id box.
    • A Notation can also be entered if you'd like to specify a description of what was purchased. If the sales item has an additional description, it will display in the Notation column. The Notation field is optional.
  7. If you want to reorder the lines you entered on the transaction in a particular order, include the Line Sequence column in your data entry grid. Each line will automatically be assigned a line sequence number. The first line is assigned 10, the second 20, and so on. To reorder the lines, change the sequence number to the order in which you want the lines to print or display. For example, if you want the second line to print before the first line, change the line sequence to be 5, 6, 7, 8 or 9. To view the reordered lines, click Options, and then select Refresh.
Note: It is not necessary to view the lines, if you click Save after the transaction is complete your lines will be reordered. When you assign a line sequence number, it will automatically be renumbered after the lines are reordered back to 10, 20, and so on to make it easy for future reordering.
  1. To specify management details to be posted for the freight or miscellaneous charges, for example profit center, location, project, etc. or a notation specific to these charges, click the Freight or Miscellaneous buttons and enter the information on the Details screen.
  2. If you entered a weight for your inventory items in Setup > Inventory > Items, the Total Weight will display the sum of each line item's weight multiplied by the Quantity Ordered (converted to Stocking Units). You can add an optional Weight column to the data entry grid to display the weight of each item multiplied by the Quantity Ordered (converted to Stocking Units) by right-clicking and selecting Add/Remove columns.
  3. The Sales Tax will be calculated automatically based on the Sales Tax selected.
Note: If you want to attach a document to this transaction, see the Attach Documents to Transactions topic for detailed information. Attached files (for example, pictures of a product, specifications of a product, warranty information, etc.) can be emailed with customer invoices.

  • Save as a customer deposit invoice (refundable credit) - When a negative customer invoice is entered and you click Save, the negative invoice will be saved as a Customer Deposit (Refundable Credit) that posts to Customer Deposits instead of an Accounts Receivable account. The customer deposit can then be refunded or applied to a future invoice. You will not see the Credit Invoice Save Options screen when this preference is set.
  • Save as negative invoice - When a negative customer invoice is entered and you click Save, the negative invoice will be saved as a negative invoice that posts to your Accounts Receivable account. This amount shows as a credit on the customer's account that can be applied against an outstanding balance on the Receipts screen. You will not see the Credit Invoice Save Options screen when this preference is set.
  • Always Show me the Save Options - When a negative customer invoice is entered and you click Save, the Credit Invoice Save Options screen will always display for you to determine if you want the negative invoice saved as a Customer Deposit (Refundable Credit) that posts to Customer Deposits instead of an Accounts Receivable account or Negative Invoice that posts to your Accounts Receivable account. You also have the opportunity to save your selection as your preference in File > Preferences > Customer Invoices and not display this screen again.
  1. Click OK. The invoice and other selected form types selected in File > Preferences > Printing > Customer Invoices or Customer Invoices (Detail) will be printed if the Print button had a green check mark on it or e-mailed if the E-mail button had a green check mark on it.

Please refer to the Shortcuts/Time Savers in Transaction EntryShortcuts/Time Savers in Transaction Entry document for tips on how to enter transactions efficiently and customize the screens.

Document: 3140

Concept Link IconSee Also