SOP SQL Optimized Integration fails if segment ID is defined

1.

You must have two complete copies of the chart of accounts. To create the copies, run Lesson Company, click Cards , click Financial , and then click Mass Modify .

2.

Copy all the accounts. Change the new account mask to AAA-????-?? . This will create all our AAA account numbers. Repeat step 1, and then create a set of accounts that use the account mask BBB-????-?? .

3.

Create two sites in inventory. To do this, click Cards , click Inventory , and then click Site . Name one site "SITEA" and then name the other site "SITEB". In the lower left part of the dialog box, under Account Segment ID, click AAA for SITEA, and then click BBB for site SITEB.

4.

Create two items, TEST ITEM A and TEST ITEM B. After you create the items, click Accounts and assign an account number to each line in the dialog box. You may use any one of the accounts. You can also select the same one for every row. After the items are created, click the Quantities/Sites list and assign TEST ITEM A to SITEA and TEST ITEM B to SITEB.

5.

Check your SOP Setup options. These are Setup, Sales, and Sales Order Proc. Click to select the Posting Accounts check box to pull data from the Item.

6.

Manually enter an SOP invoice transaction. To do this, click Transactions , click Sales , and then click Sales Trx Entry for each customer.

7.

Click Line Item Expansion for each customer, and then change the default site to SITEA.

8.

Click Distributions . All the accounts in the Line Item Distribution dialog box should now start with "AAA". This is the expected result if you integrate the same item.

9.

Create an SOP SQL Optimized Integration by using the same Item number and the same Site ID . Run the integration.

Note The item should integrate without error, but you should confirm that the operation was successful. To do this after you run the integration, open the invoice in the SOP Transaction Entry dialog box, and then click Line Item Details Expansion . Notice that only the first account distribution ("Inventory") has been changed. The remaining distributions are using the default account numbers that were originally assigned to the item.