You’re offline. This is a read only version of the page.
Hi,
I have an issue with my TWO company. It is out of sudden as i have no idea since when and how it came about.
There are many lines in AAG30000 table having NULL value in aaTRXSource field.
Everytime when i triggered any posting, system will prompt the error message of cannot insert NULL value to AAG30000 table.
I have tried checklink, rebuild index and rebuild store procedure and still can't resolve it.
Anyone have a solution for it?
Thank you.
*This post is locked for comments
Cause:
This problem occurs because an Analytical Accounting record is missing in the SY01000 table.
Solution:
Run the following script in an appropriate SQL query tool against the company database.
insert into SY01000 VALUES (0,2,0,'Analytical Accounting','AATRX',1,'')
Wish it will help.
BR,
Mohammed Tohamy
Hi,
It is strange. aaTRXSource AAG30000 table can have empty values but table structure does not allow null values in this column. As long as Not Null constraint is there on column, null value could not been added in table.
Did you use any custom application to import Analytical Accounting data?
Rubal,
Hi,
I would rather interested to know what and how this can be caused. Resolving in TWO is pretty simple. However, i do foresee this could happen in other company as well.
Does anyone encounter this with a resolution besides of readd sample company data?
thank you.
Hi Pui,
Recreate the TWO company using Dynamics GP Utilities. Use the Re-add Sample Company Data option.
Marco Alcala
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (