Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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,406 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,406 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans