Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you try to post a journal entry that contains Analytical Accounting assignments in Microsoft Dynamics GP: "Cannot insert the value NULL into column 'aatrxsource' table"

Error message when you try to post a journal entry that contains Analytical Accounting assignments in Microsoft Dynamics GP: "Cannot insert the value NULL into column 'aatrxsource' table"

View products that this article applies to.

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.

↑ Back to the top

Symptoms

When you try to post a journal entry that contains Analytical Accounting assignments in Microsoft Dynamics GP, you receive the following error message: 


Cannot insert the value NULL into column 'aatrxsource' table TRIAL.dbo. AAG30000 column does not allow nulls. Insert fails.

The stored procedure aagCreateRecordsInaaGL returned the following results: DBMS: 515.

↑ Back to the top

Cause

This problem occurs because an Analytical Accounting record is missing in the SY01000 table for the Transaction Source code.  

↑ Back to the top

Resolution

To resolve this problem, insert the missing record in each company database. To do this, follow these steps:
  1. First, make a backup copy of the company database: 
    1. On the File menu, click Backup.
    2. In the Back Up Company dialog box, click the company that you want to back up in the Company Name list.
    3. In the Select the backup file list, click the location where you want to save the backup file, and then click OK.
  2.  Next, run the following script in SQL Server Management Studio against the company database to insert the missing record: 
    insert into SY01000 VALUES (0,2,0,'Analytical Accounting','AATRX',1,'')

    Note
    • If you are using Microsoft SQL Server, run the script in SQL Server Management Studio against the company database. To open it, click Start, point to Programs, point to Microsoft SQL Server XXXX (where xxxx is the SQL Server version), and then click SQL Server Management Studio. Click on the New Query button in the top menubar, and select the company database from the drop-down list at the top. Copy in the script above and click the Execute button (or press F5) to run the script.

↑ Back to the top

Keywords: kbprb, kbmbsmigrate, kbtshoot, kberrmsg, kbmbspartner, kbexpertiseinter, kb, kbnosurvey, kbexpertisebeginner

↑ Back to the top

Article Info
Article ID : 936298
Revision : 1
Created on : 3/3/2017
Published on : 8/24/2015
Exists online : False
Views : 213