|
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.
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)
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
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.