How to set up the account segment ID per site ID in Inventory in Microsoft Dynamics GP

How to set up Inventory Control to select the account segment ID for sites

To set up Inventory Control to select the segment ID for sites, follow these steps:

1. Open the Inventory Control Setup window. To do this, use the appropriate step:

   • For Microsoft Dynamics GP 9.0 and Microsoft Business Solutions - Great Plains 8.0, point to Setup on the Tools menu, point to Inventory, and then click Inventory Control.
     
     

   • For Microsoft Dynamics GP 10.0, point to Tools on the Microsoft Dynamics GP menu, point to Setup, point to Inventory, and then click Inventory Control.
     

2. Enter an account segment ID in the Segment ID for Sites field. The name of the account segment that you specify in the Segment ID for Sites field is displayed as the label in the Site Maintenance window.
   
   For example, you have a four-segment account number, Location-Department-Account-Subaccount. If you select Department as the segment ID, the Department is displayed as the label for the account segment ID in the Site Maintenance window.

How to set up Site Maintenance to select the account segment for the site

Select an account segment to represent each site. You can enter a segment number to represent each site. When you sell an inventoried item from a particular site, the account segment ID that is specified for that site is substituted into the account number. To enter an account segment ID for each site, follow these steps:

1. On the Cards menu, point to Inventory, and then click Site.
   

2. In the Site Maintenance window, select the site ID in the Site ID field, and then select the correct account segment ID in the Account Segment ID field.
   

Note The account that is created by the account segment ID substitution must already be created in General Ledger. Otherwise, the transaction uses the default account. To set up a new account, use the Account Maintenance window. To open the Account Maintenance window, point to Financial on the Cards menu, and then click Account.

Consider the following example. The default inventory account is 000-1300-00. The North site ID has department 200 defined as the account segment ID in the Site Maintenance window. Site 200 is substituted for site 000 for the inventory account. The account 200-1300-00 must be set up in General Ledger. Otherwise, the transaction is posted to account 000-1300-00.

How to verify the substitution for accounts

The following types of transactions use site substitution:

• Inventory (IV)

• Sales Order Processing (SOP)
  

• Purchase Order Processing (POP)
  

• Bill of Materials (BOM)
  

Note Other modules that are not in this list do not have the Account Segment ID per Site functionality.

To verify the substitution for accounts of these types, follow these steps:

1. On the Transactions menu, point to Sales, and then click Sales Transaction Entry.
   

2. In the Sales Transaction Entry window, click the expansion button in the Item Number field.
   

3. In the Sales Item Detail Entry window, click Distributions.

4. In the Sales Line Item Distribution Entry window, you can verify the substitution for accounts of these types.