14,849
Dear
I am running integration manager eConnect to migrate fixed Assets and I am getting the below error
Opening source query...
Establishing source record count...
Beginning integration...
DOC 1 ERROR: Cannot insert the value NULL into column 'FAYEAR', table 'dbo.FA00902'; column does not allow nulls. INSERT fails.
The statement has been terminated.
can you please advise which field is missing so I can place it as constant in the integration manager ,
thank you
*This post is locked for comments
Which FA integration are you trying to run? The FAYEAR in FA00902 shouldn't get populated until the FA Book record is created but you mentioned Acquisition Date which is part of the FA General window.
From what I can tell, the FAYEAR in FA00902 is based on the Depreciated To Date from when the FA Book is created.
If the Fixed Asset setup is set to Auto Add Book Info when the FA General record is created then the Depreciated To Date will get set to whatever the Acquisition Date is. Are you bringing anything in for Acquisition Date?
I am trying to find the field that you are referring to in the integration mapping but all i can locate is the acquisition date,
i am using integration manager , and i am hoping to know which field this is so that i can put as constant
I edited my first post. It's a little small but if you click on it, it will open it larger. I would just put a constant of the year of the transaction you are trying to migrate.
Dear Matt
thank you for your reply , for some reason i am not able to see the screen shot which you posted, can you kindly post it again , thank you
or just let me know which field i should put as constant
regards
FA00902 is the Financial Detail Master and the FAYEAR field looks like it's just the year for the transaction. So if you are migrating transactions for 2015, you should just be able to do 2015 as the constant, transactions in 2014, put 2014, etc.
Here's an example of what the data looks like in the table:
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (