Setting Up Segment Substitution for Bill of Materials by Warehouse

                        

Expand/Collapse all Show/Hide All

Segment substitution allows you to determine whether postings for certain general ledger accounts are applied to default accounts, or to substituted accounts based on warehouse or division. A substituted account is an account you define by selecting an account segment and an associated sub account to replace the default account number.

If segment substitution is set up to post by warehouse, default general ledger accounts defined for certain accounts are replaced by substituted accounts based on the warehouse entered. If segment substitution is set up to post by division, default general ledger accounts defined for certain accounts are replaced by substituted accounts based on the division entered.

Segment substitution occurs in various data entry windows and during the updating of various journals and registers. Segment substitution by warehouse occurs in the following modules:

  • Bill of Materials

  • Purchase Order

  • Work Order

  • eBusiness Manager

  • Return Merchandise Authorization (RMA)

  • Sales Order

  • Inventory Management

Note For a default account number to be replaced by a substituted account, the substituted account must be a valid general ledger account created in General Ledger Account Maintenance.

The following examples show how segment substitution is set up to post by warehouse for transactions entered in Production Entry. Although segment substitution can be set up to post by warehouse in the modules listed above, the default and substituted accounts for those modules are not shown in these examples.

Expand/Collapse item  Segment substitution is set up to post substituted accounts to the general ledger (by warehouse)

In the Inventory Management Options window, in the G/L Segment for Whse Postings field, the following segment is selected to determine the account segment that serves as a substitute:

  • Location

In the Inventory Management Warehouse Code Maintenance window, for warehouse codes 000 and 001, in the Post to field, the following sub accounts areselected for the segment to determine the substituted account for posting:

  • 300 (Warehouse Code000)

  • 400 (Warehouse Code 001)  

 

Expand/Collapse item  Default account numbers are set up for inventory items and a miscellaneous charge

In the Inventory Management Product Line Maintenance window, default accounts are set up for each of the following accounts, and the Post by Whse check box is selected for each corresponding account:

  •  Inventory   115-000-000

  •  Mfg Variance Adjustment 965-000-000

In the Miscellaneous Item Maintenance window, the default account is set up for the following miscellaneous charge account:

  •  Charge Account   400-016-000

 

Expand/Collapse item  Segment substitution is performed for inventory items and a miscellaneous charge

In the Production Entry window, a transaction is entered for the following warehouse and inventory item, including a miscellaneous charge:

Entry Number:

0000173

Bill Number:

DSKTP-00300

Parent Warehouse:

000

Component Warehouse:

001

The default accounts for inventory items and miscellaneous charge are replaced with the following substituted accounts and posted to the general ledger.

Inventory items:

  •  Inventory(Parent)   115-000-300

  •  Inventory (Component)   115-000-400

  •  Mfg Variance Adjustment(Parent) 965-000-300

Miscellaneous charge:

  •  Charge Account*   400-016-400

*A substituted account is posted only if a miscellaneous charge exists on the bill entered.