Inventory Cost Accounting Workbook
The Inventory Cost Accounting workbook template includes a table view of items with incomplete cost calculations. It displays only inventory and assembly items that have the following cost accounting statuses: Pending, Processing, or Failed. For more information about cost accounting statuses, see Cost Accounting Status on Item Records.
You can refer to this workbook when reviewing the period close checklist. Before you complete the checklist's Review Inventory Cost Accounting task, in particular, you can check if there are items that haven't completed their cost calculation run. For more information, see Inventory Tasks on the Period Close Checklist.
Workbook Template Configuration
The source data used in the Inventory Cost Accounting workbook template is the Items with Incomplete Cost Accounting Dataset. Using available fields from this dataset, you can add columns, sort the data, or apply filters on the workbook. You can also show or remove columns or data by editing the dataset itself. For more information about workbooks, see Navigating SuiteAnalytics Workbook.
Items with Incomplete Cost Accounting Dataset
This dataset forms the data source for the Inventory Cost Accounting Workbook. It provides a list of inventory and assembly items from existing posting transactions and with the following cost accounting statuses: Pending, Processing, and Failed. Depending on the features you use, this dataset includes details about the location, lot number, or serial number and identifies vendor consigned items.
Editing the Dataset
Consider the following information before you edit the Items with Incomplete Cost Accounting dataset:
You can add fields to a dataset's Data Grid to make them available for use on workbooks that use the dataset as source data. Fields that you remove remain hidden from workbooks.
-
If you use the Consigned Inventory Management feature, you can view the Consigned field value, which indicates whether items are vendor consigned. If you don't use this feature, you can remove the corresponding column from the list.
-
If you use the Multi-location Inventory feature, you can view the status per location. If you don't use this feature, you can remove the corresponding column from the list.
-
If you use the Lot Tracking feature or Serialized Inventory feature, you can add the Inventory Number column to view lot or serial numbers, respectively.
-
If you use features for Multi-Book Accounting, you can add the Accounting Book column to view the primary or secondary book used for period closing.
-
The Transaction Date displays the date of transaction creation for both the Processing and Failed cost accounting statuses. It displays the date of the latest costing run for the Pending status.
To edit a dataset, see Defining a Dataset.
Dataset Configuration
The Items with Incomplete Cost Accounting dataset combines fields shown on the following table:
|
Root Record Type |
Joined Record Type |
Custom Formula Fields |
Data Grid |
Criteria Filters |
|---|---|---|---|---|
|
Items with Incomplete Cost Accounting |
(none) |
(none) |
The following fields are included in the dataset:
|
(none) |
Related Topics
- Item Costing
- Selecting a Default Cost of Goods Sold (COGS) Account
- Inventory Costing and Assembly Items
- Consigned Inventory Management
- Multi-Location Inventory
- Viewing Inventory Reports
- SuiteAnalytics Workbook Overview
- Data Refresh in SuiteAnalytics Workbook
- Creating a Workbook
- Workbook and Dataset Templates
- Customizing Inventory SuiteAnalytics Workbooks