As you journey through your NetSuite implementation, one important consideration may be deciding which costing method to use for your items. NetSuite offers a multitude of costing methods which, when properly configured, help you maintain accurate costs and costs of goods sold. One such costing method we will review today is Group Average Costing. Traditionally, Average Costing in NetSuite has been one average cost per location. However, NetSuite also offers Group Average Costing as a way to maintain a single average cost across multiple locations. How do we set this up? Read on to find out.
Prerequisites and Considerations for Group Average Costing
The idea behind Group Average Costing is to track a single average cost across multiple locations. As such, one of the prerequisite features is having Multi-Location Inventory enabled. Additionally, keep in mind the following considerations:
-
- Inventory Adjustment Worksheets do not yet support items set up with Group Average costing.
- Once the Costing Method is set on an item and saved, it cannot be changed.
Enabling the Feature:
-
- Navigate to Setup > Company > Setup Tasks > Enable Features.
- Navigate to the Items & Inventory subtab and check the Group Average Costing
- Save.
Once enabled, the next step is to set up a location costing group. A location costing group is simply the group of locations that will share the same average cost.
Location Costing Group Setup:
-
- Navigate to Setup > Accounting > Location Costing Groups > New.
- Enter a Name for the Costing Group.
- Set the Costing Group Currency.
- Note: All Locations within a Costing Group must share the same base currency.
- Optionally, enter a Memo.
- Select the Locations you would like to include in this Costing Group.
- Note: You can also forego assignment at this point, and instead assign it later through the Location record.
- Save.
Adding New Items and Maintaining the Average Cost
After performing the initial setup, adding new items will allow you to choose the Group Average Costing Method. As you transact with the item, NetSuite will maintain a single average cost within the location groups you have specified in the costing group. You can have multiple costing groups with distinct locations.
As always, assessing the process is key to understanding the full system behavior. Where possible, I recommend enabling and evaluating the feature in a Sandbox environment and walking through all GL impacting transactions to assess impact and behavior.
About Us
Concentrus is a leading provider of innovative cloud-based enterprise resource planning (ERP) solutions, including NetSuite. Our team of NetSuite experts offers a range of services, including NetSuite price analysis, NetSuite training, and NetSuite integration services.
Our goal is to help businesses of all sizes maximize their investment in NetSuite by providing expert NetSuite cost optimization and implementation strategies. With years of experience as a NetSuite partner, our NetSuite administrators and NetSuite consultants are well equipped to help businesses of all sizes with their NetSuite consulting needs.
Whether you're looking for a NetSuite consultant to help with your NetSuite implementation or you need ongoing NetSuite support, Concentrus is here to help.
Read About Our Implementation Methodology
Want more NetSuite Tips and Tricks? Check out our Short & 'Suite videos