Thanks to everyone for reading ahead of time!
Question
- Is there a Sage, E2B, or other third part plugin, configuration, hotfix, or other solution that would allow for creating routings that nest other routings to help allow for machining of parts on a single piece of material to reduce waste while not causing issues with how labor, outside, variable, and material costs hit GL?
Current Nested Routing Workaround Overview
- Our production division has been using a workaround to produce a nested routing that includes other routings in a way to easily track manufacturing processes that combine different parts into a single piece of raw material so that there is not excessive scrap produced. The workaround is to deselect the "Standard Routing" option within the routings combined into the single nested routing. The nested routing is then set as the standard routing and the others are left unchecked as only a single routing may be selected
Resulting GL Issue Due to Workaround
- Upon posting an invoice, the system directs costs associated with an item by determining if the "Standard Routing" is checked or not:
- If it is checked then it places labor, variable costs, and materials into the correct buckets.
- If the "Standard Routing" is not checked then it puts 100% of all labor, variable, and material costs all into the materials cost bucket.
- When invoicing against the top level nested routing with the "Standard Routing" checked, all goes well, but if production has to produce one of the item contained within the nesting then they are no longer marked as a "Standard Routing" so end up hitting the GL improperly.
Current Environment
- Sage 500 ERP 2013 7.5 (upgrading to latest in 2020)
- Sage Modules:
Advanced Manufacturing
Accounts Payable
Accounts Receivable
Business Insights – Analyzer
Business Insights – Explorer
Cash Management
Customizer
Data Import Manager
Data Migrator
Business Insights Dashboard
Fixed Assets Link
General Ledger
Inventory Management
Intercompany Transactions
Inventory Replenishment
Manufacturing
Material Requirements Planning
National Accounts
Project Accounting
Purchase Order
Shop Floor Control
Sales Order
Warehouse Management
-
Add-On E2B Tek Modules:
Batch Process Production Entry
Engineering Change Orders
Enhanced Costing
Enhanced Labor Entry
Anytime 500 Manufacturing Suite
Enhanced MRP
Progress/Production Entry Returns
Routing Copy Steps
Sub Work Orders
Work order Allocations
Work Order Splitting