CenterPoint® Accounting - Enter a Vendor Invoice for Inventory Items

Related Help

Entering A/P Invoices for Inventory Items Video - Duration: 6 min 34 sec

View or Print as PDF


When inventory is purchased but not yet paid for, the information is entered into CenterPoint as a Vendor Invoice. When the vendor invoice is saved, the on hand quantities and costs for the inventory items are updated. The transaction will normally increase the accounts payable (a/p) account and an inventory (asset) account. When vendor invoices are paid, the accounts payable (a/p) and cash/checking accounts are decreased. Both inventory and non inventory items can be added to the same vendor invoice.  When inventory items are purchased, the amounts will increase the inventory account assigned to the item (Setup > Inventory > Items > Accounts tab).

Prerequisite

You must have the Inventory module purchased and registered in the module configuration manager (File > Administration > Module Configuration Manager) prior to entering any vendor invoices for 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.

Enter a Vendor Invoice

  1. On the Processes menu, point to Purchases,and then select Vendor Invoices (A/P).
  1. In the Company box, enter the company name that this accounts payable is for.
  2. In the Vendor box, enter the vendor name that this accounts payable is due to. The name and default address for this name will display. If you enter a name into the Vendor box and it does not exist, the Lookup screen automatically displays, from this screen you can either Create a New Name or Create a One-Time Use Name.
  • Create a New Name - If you enter a name into the Vendor box and it does not exist, the Lookup screen automatically displays. Click New . The Names Setup screen displays with the name that you entered automatically displaying in the Company box. Complete the additional details to create the name and then click Save. When creating a new name through the Name Setup screen, you can identify a name as a customer, vendor, employee, or salesperson. Doing so determines which data entry screen that name will be visible on. If a name is not marked as a vendor, it will not appear on the Payments screen. Likewise, if a name is not marked as a customer, it will not appear on the Receipts screen.
  • Create a One-Time Use Name - If you enter a name into the Vendor box and it does not exist, the Lookup screen automatically displays. Click New One Time Use. The New One Time Use screen displays with the name that you entered automatically displaying in the Name box. Complete the additional details to create the one time use name and then click Save (the one time use name will be automatically marked as a vendor and customer). When creating a new name through the New One Time Use screen, the name is automatically saved as an inactive name in all companies so it does not appear in Name lookups (unless you chose to lookup inactive names).

This box also contains a Recurring icon . The Recurring button will display with a yellow background if a name has an applicable recurring transaction. The button also allows you to determine the action that will be taken when this name is used on any one of our four main transaction screens; Payments, Receipts, Customer Invoices, and Vendor Invoices.

The actions that can be set for the selected name are:

  • Leave Transaction Empty – Basically, when this is set on a name and the name is selected in a transaction, no special action will take place. The user simply enters in the details of the transaction.
  • Recall the Last Transaction for this Name – When this option is set and the name is selected in a transaction, the details of the last previously entered transaction for this name will be filled into the screen. This allows you to use the same setup for this new transaction without having to re-enter all of the details.
  • Load the Default Recurring Transaction for this Name – When a transaction is entered for a name, it can be saved as a recurring transaction. This means that there might be future transactions to the same name that are likely to have the same details filled in each time. Multiple recurring transactions can be setup for one name, but only one can be loaded by default and that is the one marked as the default recurring transaction. If there is only one recurring transaction for a name, it is the default.

If your FilePreferences > GeneralLookup SettingsLookup Field Settings are set to Use Auto-Complete, and you change a name after detail is entered on the lines of a transaction, the transaction is cleared and any transaction action (leave the transaction empty, recall the last transaction, or load the default recurring transaction) for the new name will occur.

If your File > Preferences > General > Lookup Settings > Lookup Field Settings are set to Allow To Query for Items On Multiple Fields, and If you change a name after detail is entered on the lines of a transaction, you will be asked if you would like to clear the information for the current transaction. If you select Yes, the transaction will be cleared and any transaction action (leave the transaction empty, recall the last transaction, or load the default recurring transaction) for the new name will occur. If you select No, the detail lines from the transaction will remain and if the new name was assigned a transaction action (leave the transaction empty, recall the last transaction, or load the default recurring transaction), the transaction action will not occur.
  1. To review transactions in a Transaction Search screen for the selected name, entry screen, and current year, right-click in the Vendor box, and select Review Transactions.
  2. To select a different address for this name, click the Lookup icon in the Vendor Address box, select the address, and then click OK.To create a new address, right-click in the Vendor Address box, select New, enter the address details, and then click Save. To edit an existing address, right-click in the Vendor Address box, select Edit, enter your changes, and then click Save.
  1. The AP Account will display. If the Push Pin icon toggle is "pinned" (), the AP Account displays from the previous entry. When the Push Pin is not "unpinned" (), if available, the vendor default AP Account displays from the Setup > Vendors > General tab or if not available the default Accounts Payable account set up in File > Preferences > Vendor Invoices > Default Accounts displays. This AP Account can be changed.

Note: If you are entering a credit card purchase, change the AP Account to a Credit Card Liability account.

  1. Select the On Hold check box if you do not want this invoice available to be selected for payment. Invoices can be placed on hold if you do not want the invoice selected for payment in the Payments or Pay Invoices Due screens (for example, the quantity has been received, but was at a higher cost than was originally quoted and you don't want the accounts payable department to accidentally pay this invoice until your dispute has been resolved or you only received partial shipment and your policy is not to pay invoices until an entire shipment is received). Held invoices are not added to the vendor balance and display on the Vendor Ledger, Accounts Payable Open Invoices, and Accounts Payable Aging reports. The On Hold Status of a held invoice can be changed (using the Processes > Purchases > Place Invoices On Hold button) to reactivate i t .
  1. In the Current Batch box, leave the No Batch selection to update balances in real-time (immediately) or enter a batch name to update balances at a later time. For more information, see the Batch vs. Real-Time Transactions topic.
  2. The Vendor Balance box displays the current balance in the AP Account if the AP Account is in the Accounts Payable account category and the Credit Card Balance box displays the credit card balance if the AP Account is in the Credit Card account category.
  3. In the Reference #box, enter the vendor credit memo number. If you want the value you enter in this box to automatically be copied to the Invoice/Ref # box each time an Account is entered in the Data Entry Grid, click the Options button and select Copy Reference # to Invoice/Ref #.
  4. In the Date box, enter the date from the credit memo.
  5. In the Amount box, enter the amount of the entire credit memo.
  6. If applicable, select a payment term in the Terms box. The terms will calculate a due date for the transaction. Terms is an optional field.
  7. The Date Due box will display the date calculated from the payment term selected. You can also manually overwrite the date due.
  8. The Discount Date box will display the calculated discount date from the payment term selected. You can change the discount date.
  9. Enter information into the Vendor Invoices (A/P) Entry grid for each inventory item purchased:
  • In the Account field select the appropriate inventory item.  
  • If the item is a lotted or serialized item, the Lotted/Serialized Item detail screen will automatically be displayed. Specify the appropriate cost and quantity for each lot/serial number.
  • For all other inventory items, specify the quantity purchased in the Quantity 1 field and the appropriate Unit of Measure. The system will automatically display this items default purchasing unit of measure. All other units of measure assign to this item will be available to choose from.
  • Enter the total Amount for that inventory item. The system will calculate the Unit Cost based on the quantity and amount entered.
  • The Quantity Available (quantity in inventory prior to this transaction being entered) for this item will be displayed.
  • To display what entries will be created for each line on the invoice, simply click on the + button to the left of each line.
Note: If you prefer to enter a Quantity and a Unit Cost (instead of entering the Quantity and Amount), please refer to the document Enter a Vendor Invoice with Unit Costs
  1. Enter additional lines in the grid for each item purchased. If non-inventory items were purchased on the same invoice, an account can be selected instead of an inventory item in the Account field. If you want to repeat the previous line's Invoice/Ref# entry, right-click in the Invoice/Ref # column and select Repeat Previous Value.
  2. The Vendor Invoices (A/P) Entry grid can be customized for your specific data entry situation. If an account is entered with an amount that did not have a distribution previously set up, the Distribution column displays None in the transaction entry grid in the color Gray. If an account is entered with an amount that had a distribution previously set up, the Distribution column displays the name of the distribution in the color Orange. If you want to display the details of a distribution click the Orange Distribution button. If you decide that this entry should not be distributed, you can remove the check mark in the Use Distribution check box on the Account Distributions screen or select another distribution. Distributions allow you to assign transaction amounts to several profit centers, production centers, projects, production years, production series, or production center detail combinations by percentage.
  3. 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 and profit center.
  4. 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. In the Memo Line 1 box, enter a memo line that you want to print immediately after the date when the check is printed for this invoice.
  2. In the Memo Line 2 box, enter a memo line that you want to print immediately after Memo Line 1 on the check.
Note: If you'd prefer to display Freight and Sales Tax fields in place of the Memo fields, click the Options button and select Show Other Charges Fields. These fields will work with the File > Preferences > Transactions > Accounts Payable preference that includes the default Freight Expense and Sales Tax Expense accounts so you do not have to enter freight or sales tax as a line item on the invoice, you will just need to enter the amounts. To redisplay the Memo fields, click Options and select Show Memo Fields.
  1. The Total Amount box displays the total of all of the lines in the Vendor Invoices (A/P) Entry grid. If this amount is different than the Amount box, click Adjust Amount.
  2. The Available Terms Discount box displays the discount amount calculated by adding all of the invoice detail lines together and then multiplying the result by the payment term discount percentage. If you want to change the available term discount amount, enter the new amount. The Override check box will automatically be selected when the available terms discount amount is changed. If you clear the Override check box, the available terms discount amount will be recalculated. If you subsequently edit the invoice and make changes to the detail lines, the discount will not be recalculated if you previously overrode the available terms discount amount.
Note: If you want to attach a document to this transaction, see the Attach Documents to Transactions topic for detailed information.
  1. When the transaction is complete, click Save.
Note: If any of the inventory items on this invoice had a negative quantity available, the system will also create a purchase price variance transaction that debits or credits Inventory and the Purchase Price Variance account assigned to the inventory item. This adjustment will correct the cost of goods sold transaction that was created when the item was sold into the negative.
Note: When posting a transaction for any account assigned to an Inventory account category that has a positive quantity and negative amount or a negative amount and a positive quantity, a warning message will display and the transaction will not be posted.

Document: 3139

Concept Link IconSee Also