CenterPoint® Accounting for Agriculture - Display Last Purchase Cost when Entering Accounts Payable Invoices

Related Help

View or Print as PDF

To display the Last Purchase Cost of an item when entering an Accounts Payable invoice for inventory items, follow the steps below to edit the Accounts Payable template to display the Last Purchase Cost of the item and assign the modified template to the Inventory account category.

  1. Select Setup > General > Data Entry Templates.
  2. Select the Purchase Inventory "Item" (Enter Qty & Amt) template.
  3. Click Copy.
  4. In the Abbreviation box, enter a new abbreviation, for example, PrchInvItemCost.
  5. In the Name box, enter Purchase Inventory "Item" (Enter Qty & Cost).

  1. Select the Detail tab.
  2. Open the AP / Bank section by clicking on the +.
  3. Select Amount and change the Type to Calculated.
  4. Click .
  5. In the Calculate screen, select #AP / Bank_UNITCOST, click Add, click , select #AP / Bank_Q1, click Add, and then click OK.

  1. In the AP / Bank section, select Unit Cost and change the Type to Input By User, and then change the Default to @LastCost.
  1. Click Save.

  1. Select Setup > Accounts > Account Categories.
  2. Select the Inventory account category.
  3. Select the Templates tab.
  4. Select Payments and New Payables, and then select Inventory Item Selected.
  5. In the Change To box, select Purchase Inventory "Item" (Enter Qty & Cost).
  6. Click Save.

Document: 3464