Are nested routings possible in a way that does not cause a cost composition issue when hitting the GL upon invoicing?

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