Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Is there a new require...
Microsoft Dynamics GP (Archived)

Is there a new requirement for taCreateAssetID in GP 2015?

(0) ShareShare
ReportReport
Posted on by Karl Jensen

We have been using our current eConnect message to Add an Asset using taCreateAssetID for quite some time.  

In GP 2015, we receive this error: 

Cannot insert the value NULL into column 'SPECDEPRALLOWAMT', table 'TWO.dbo.FA00200'; column does not allow nulls. INSERT fails.

SPECDEPRALLOWAMT is not part of the supported node.  So that's not the issue.  We have found that this error goes away if we add an element of "Acquisition_Cost" and make it 0.  That will get our transaction to post, but it will create misleading data in GP 2015.  

Has anybody run into this?  

Thanks.  

*This post is locked for comments

  • Suggested answer
    Naga Kiran Profile Picture
    Naga Kiran on at
    RE: Is there a new requirement for taCreateAssetID in GP 2015?

    Hi Karl,

    I just compared the table results in GP2013 R2 and GP2015 specific to the field you mentioned to see if its getting a value updated when I provide Acquisition Cost. And I found with same XML, the  SPECDEPRALLOWAMT field is not updated in GP2013 R2 but updated in GP2015. After that I did some research how its getting updated. So finally concluded there is a change in the Insert statement on FA00200 and not used ISNULL against Acquisition Cost to make it 0 when it doesn't have any value.

  • soma Profile Picture
    soma 24,410 on at
    RE: Is there a new requirement for taCreateAssetID in GP 2015?

    There are many tools are available for decrypting the encrypted stored procedure( eConnect procedure).

  • Karl Jensen Profile Picture
    Karl Jensen on at
    RE: Is there a new requirement for taCreateAssetID in GP 2015?

    Thank you!  

    If I may, how did you find that?  I can't open taCreateAssetID (it says it's encrypted).  It definitely makes sense that you'd look at the stored procedure named for the eConnect node.... I just don't know how to "expose" that.  

    Thanks,

    Karl

  • Verified answer
    Naga Kiran Profile Picture
    Naga Kiran on at
    RE: Is there a new requirement for taCreateAssetID in GP 2015?

    Hi Karl,

    There is no change to the schema but looks like there is a change in insert command on FA00200 in taCreateAssetID, to create Asset Book records. Earlier the 'SPECDEPRALLOWAMT' of table FA00200 was hardcoded to have a '0'. Now its dependent on below two fields to insert the correct value.

    1. Acquisition_Cost

    2. SPECDEPRALLOWPCT of table FA40202 (for a Book ID and the ASSETCLASSID passed).

    Looks like there is no NULL check on Acquisition_Cost causing the issue you are facing. So you may need to pass a  Acquisition_Cost as 0 always.

    Hope this helps.

  • Karl Jensen Profile Picture
    Karl Jensen on at
    RE: Is there a new requirement for taCreateAssetID in GP 2015?

    Thanks!  I'll keep this open in case somebody else has a chance to look into it.  

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at
    RE: Is there a new requirement for taCreateAssetID in GP 2015?

    I couldn't tried this on GP 2015. But, its seems like some functionality added to the GP 2015 fixed asset eConnect schema.

    If I get any findings regarding this eConnect schema, will let you know.

    Hope this helps!!!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans