--- title: "Purchased Item Record: Item Cost Tab" slug: "purchased-item-record-item-cost-tab" description: "Configure the cost update method and view inventory cost details on the Item Cost tab of a purchased item record." updated: 2025-07-24T17:06:11Z published: 2025-07-24T17:06:11Z canonical: "docs.restaurant365.com/purchased-item-record-item-cost-tab" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt > Use this file to discover all available pages before exploring further. # Purchased Item Record: Item Cost Tab This article covers Item Cost tab of the [Purchased Item Record](/doc/docs/purchased-item-record-overview-security). The Item Cost tab is the default tab. When a Purchased Item Record is opened, it will open to the Item Cost tab. From this tab, users can see where cost for an item is derived. --- ## Item Cost Tab ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image(280).png) | | **Field** | **Description** | | --- | --- | --- | | **1** | Location Selector | Select a Location to view the Cost Summary for that Location | | **2** | Inventory Cost | The inventory cost for the selected Location along with Inventory details. This will be a weighted average of any transaction costs based on the cost method. This includes the following information about the item: - [**Usage per 1000**](https://docs.restaurant365.com/docs/usage-per-1000#usage-per-1000) - The inventory usage rate per $1000 of sales - [**Theo on Hand**](https://docs.restaurant365.com/docs/usage-per-1000#theoretical-on-hand) - The theoretical amount of the item on hand in inventory based on the Usage per 1000 | | **3** | Cost Method | The cost update method. This shows the method of which the item cost is updated and the transactions that are being considered. Only transactions that occurred **within the last year** are factored into the cost update. If any of the transactions listed are older than a year, the transaction will not be factored into the cost of the item. **Weighted Avg (Last 3 Days or Last Count)** When a 'Weighted Avg.' is selected, this section will show the last transactions based on the selection (Ex. 3 Weighted Avg. 3 Days). Click **Cost Transaction Details** to view more details. This will extend the Cost Summary section. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/6af10a2e-ef7f-4233-9fc8-17c1aa049b50.png) What users will see will vary based on the Cost Updated Method, which can be changed from the [Settings Tab](/doc/docs/purchased-item-record-settings-tab). **Manual** ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/ea939ecf-de98-45d7-a825-c150e0493959.png) **Last Received** Last Received' will display a single transaction card if the item cost change was due to a single last transaction. If the item cost change is a result of more than one transaction, this card will reflect a weighted average of those transactions. Users will be able to expand the card to view the individual transactions ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/aec328f3-673f-4e6d-8e0e-68bcf1bed06c.png) | | **4** | Location Costing Table | The item costs listed by location. From this grid, users can edit the reporting costs. Read additional details about the location costing table below. | --- ## Location Costing Table The location costing table lists all the item's costs by location. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image(281).png) | | **Field** | **Description** | | --- | --- | --- | | **1** | Edit | Click this button to enable manual editing for **reporting costs**. When clicked, each reporting cost field will be available to edit. > Users can also bulk edit reporting costs. Read more below. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/374bd8a2-92ba-4758-8037-b4a980e9c83c.png) Users must click the enabled **save** button in order to save any changes to the table. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/297da4b1-ae5d-4fc7-8dce-3c477e3b61f2.png) | | **2** | View Full Details | Click to only view the the location costing table on the page. This will also open up the table functions, which users can use to **export** the table, **filter** the results, and edit the available **columns**. Click **done** to return to the default item cost tab screen. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/3fc2d2c8-0552-4758-9c38-c48cc8c87a98.png) | | **3** | Location Cost Entry | The individual location cost entry. Each entry will include the following information: - **Location** - All of the locations that use this purchased item - **Inventory Cost** - The cost for the Item at the specified location based on the inventory UofM - **Inventory UofM** - The unit of measure used for Inventory for the specified location - **Reporting Cost** - The cost for the Item at the specified location based on the Reporting UofM - **Reporting UofM** - The most common way the Item is compared across multiple locations - **Commissary Status** - Indicates whether an Item is 'Received from Commissary' or not. A 'yes' indicates that the Item is assigned to a Commissary Order - **Theo on Hand** - The theoretical dollar amount (based on the usage per $1000) of the product on hand and the reporting UofM. This value is calculated at the end of each night - **Usage Per 1000** - The inventory usage rate per $1000 of sales and the reporting UofM. This value is calculated at the end of each night | ### Bulk Editing Report Cost Report costs can be edited for a location by clicking the edit button at the top of the table, enabling the reporting cost editor for each location cost entry. However, users can also use the **bulk edit** function to edit the **reporting cost** for multiple locations all at once. To bulk edit reporting costs, follow these steps: | **1** | Select the **locations** that need their reporting cost edited. Do this by clicking the **checkbox** in the first column for the corresponding entry. To select all the locations, click the checkbox in the column header. | ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/ed957f50-05cd-4747-91e8-027e0c3f2ec2.png) | | --- | --- | --- | | **2** | From the bulk edit options, click the edit icon![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/86046be5-6203-4bfe-97c3-57a9f124d90c.png). | | **3** | From the bulk edit prompt, ensure the attribute selected is **reporting cost**. | ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/fe77617b-280c-47a9-b510-9f62bc5d8666.png) | | **4** | **Enter the value** of the new reporting cost. | | **5** | Click **Update # Items** to update all the locations with the new reporting cost. | The locations will now be updated with the new reporting cost.