Problems occur when you reconcile inventory accounts to general ledger accounts in Microsoft Dynamics GP

SYMPTOMS

If you change the segment ID for a site in Inventory Control Maintenance in Microsoft Dynamics GP, problems occur when you reconcile inventory accounts to general ledger accounts. Problems also occur if you print reports that are sorted by a site's segment name or segment ID.

CAUSE

This problem occurs because the general ledger accounts that you posted to old site segments do not match the relevant accounts in Inventory Control Maintenance for the new site segment.

RESOLUTION

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs. 

To resolve this problem, change the segment ID for sites in Inventory Control Maintenance in Microsoft Dynamics GP. To do this, follow these steps: 

1. Delete all sites from the Item Site Setup (IV40700) table. To do this, follow these steps: 

a. Start the Support Administrator Console, Microsoft SQL Query Analyzer, or SQL Server Management Studio. To do this, use one of the following methods depending on the program that you are using. 


     Method 1: For SQL Server 2005 If you are using SQL Server 2005, start SQL Server Management Studio. To do this, click Start , point to All Programs , point to Microsoft SQL Server 2005 , and then click SQL Server Management Studio . 

     Method 2:  For SQL Server 2008 (or higher versions) If you are using SQL Server 2008, start SQL Server Management Studio. To do this, click Start , point to All Programs , point to Microsoft SQL Server 2008 , and then click SQL Server Management Studio . 


 b. Run the following statement to move your site information from the Item Site Setup (IV40700) table into a temporary table that is named SITES. 
select * into SITES from IV40700 

 c. Run the following statement, and then verify that the information exists in the SITES table: 
Select * from SITES 

 d. Run the following statement against your company database to delete the contents of the IV40700 table: 

delete IV40700 


 2. Change the segment IDs for sites in the Inventory Control Setup window. To do this, follow the appropriate step: 

 • In Microsoft Dynamics GP 10.0: 
a. On the Microsoft Dynamics GP menu, point to Tools , point to Setup , point to Inventory , and then click Inventory Control
b. In the Inventory Control Setup window, change the segment number in the Segment ID for Sites field, and then click Save

 • In Microsoft Dynamics GP 2010: 
a. On the Microsoft Dynamics GP menu, point to Tools , point to Setup , point to Inventory , and then click Inventory Control
b. In the Inventory Control Setup window, change the segment number in the Segment ID for Sites field, and then click Save

 3. Run the following statement to insert the site information from the temporary SITES table into the IV40700 table: 
insert into IV40700 (LOCNCODE,LOCNDSCR,NOTEINDX,ADDRESS1,ADDRESS2,ADDRESS3, CITY,STATE,ZIPCODE,COUNTRY,PHONE1,PHONE2, PHONE3,FAXNUMBR,Location_Segment,STAXSCHD,PCTAXSCH,INCLDDINPLNNNG,PORECEIPTBIN,PORETRNBIN,SOFULFILLMENTBIN,SORETURNBIN, BOMRCPTBIN,MATERIALISSUEBIN,MORECEIPTBIN,REPAIRISSUESBIN, WMSINT,PICKTICKETSITEOPT,BINBREAK,CCode,DECLID) select LOCNCODE, LOCNDSCR,NOTEINDX,ADDRESS1,ADDRESS2,ADDRESS3,CITY,STATE, ZIPCODE,COUNTRY,PHONE1,PHONE2,PHONE3,FAXNUMBR,Location_Segment, STAXSCHD,PCTAXSCH,INCLDDINPLNNNG,PORECEIPTBIN,PORETRNBIN,SOFULFILLMENTBIN,SORETURNBIN,BOMRCPTBIN, MATERIALISSUEBIN,MORECEIPTBIN,REPAIRISSUESBIN,WMSINT,PICKTICKETSITEOPT,BINBREAK,CCode, DECLID from SITES 


4. Update the account segment number for the sites. To do this, follow these steps: 

 a. On the Cards menu, point to Inventory , and then click Site
 b. In the Site Maintenance window, select a site in the Site ID field. 
 c. Under Account Segment ID , update the account segment number in the Segment 1 field for the site. 
 d. Repeat steps 4b and 4c to update the account segment number for all sites that you want to update. 

 Note This change does not update transactions in the Sales Order Processing module, in the Inventory module, or in the Invoicing module.
Properties

Article ID: 855409 - Last Review: 15 Feb 2017 - Revision: 1

Microsoft Dynamics GP 10.0, Microsoft Dynamics GP 2010, Inventory, Inventory, Inventory Control

Feedback