Bulk Update Costs for Manufacturing Charges in NetSuite

TL;DR

This article provides an overview of the bulk update feature for manufacturing charges in NetSuite, which allows users to update costs accurately across transactions. This feature is essential for maintaining precise production costing and financial accuracy.

Overview of Bulk Updates for Manufacturing Charges

NetSuite has introduced a method to bulk update costs associated with manufacturing charge items on production transactions. This functionality enables users to streamline their production costing by either utilizing the current purchase price from the item record or setting a custom unit cost. This ensures that all production transactions reflect the most accurate costs.

Supported Manufacturing Charge Types

You can update costs for manufacturing charge items of the following types:

• Service
• Non-Inventory
• Other Charge

Note: Only item subtypes labeled Purchase or Resale are supported. Items classified under Outsourcing Charge, Landed, or Service cost categories cannot be updated.

Important Considerations

To utilize this feature, ensure the Allow Bulk Update Costs for Production Charges preference is enabled. Refer to the Manufacturing Preferences for additional configuration options.

Steps to Bulk Update Costs

1. Navigate to Lists > Mass Update > Update Costs for Manufacturing Charges.
2. Select a Subsidiary from the dropdown.
3. (Optional) Choose one or more Locations to further refine your selection.
4. (Optional) Use the Charges filter to narrow down specific items.
5. (Optional) Set a Transaction Date Range that applies to your updates.
6. (Optional) Apply additional filters, such as:
   • Posting Period
   • Transaction Type (e.g., Work Order Completion, Work Order Issue, Assembly Build)
   • Work Order
   • Cost Category
7. Under the Update Costs section:
   • Keep the Item's Purchase Price option selected to use the current purchase price or
   • Deselect and enter your Custom Unit Cost and specify how the cost is applied:
     • Cost per Base Unit - applies based on base units with conversions for other units.
     • Fixed Cost - applies a consistent cost per unit, irrespective of unit measure.

With these steps, you can efficiently manage production costs and ensure your accounting is up-to-date.

Who This Affects

• Administrators: Responsible for setting preferences and managing updates.
• Manufacturing Managers: Use the feature to ensure accurate costing.
• Accountants: Benefit from precise production cost data for financial reporting.

Key Takeaways

• Bulk updates for manufacturing charges streamline cost management.
• The feature supports various item types, enhancing flexibility.
• Custom unit costs can be defined for granular control over pricing.
• It is essential to enable specific preferences to utilize the feature correctly.
• Understanding filters allows for targeted cost updates, increasing efficiency.