News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) taPATimeSheetLineInser...

Microsoft Dynamics GP (Archived)

taPATimeSheetLineInsert error 1227

(0) Share

Report

Report

Posted on by Austin Williams

25

I would first like to apologize for my lack of understanding. I'm just a developer who got Great Plains thrust on him and am trying to get some stuff figured out.

We are in the process of adding a new company to GP and I'm really close to getting this done. However we have a stored procedure that calls taPATimeSheetLineInsert and it is returning an error code 1227, 'Unable to retrieve Cost of Goods Account' and I don't know how to tell what it's looking for and how my data is incorrect. We've tried comparing against existing companies and thing seem to line up.

Can anyone suggest something more?

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Austin Williams 25 on at

Like (0)

Report

Re: Re: taPATimeSheetLineInsert error 1227

Well that shed some light on incorrect setups for sure. Everything was set as Cost Category rather then project, however after changing all the accounts to match one of our current companies, I'm still getting the same error.
Ron Draganowski 1,575 on at

Like (0)

Report

Re: taPATimeSheetLineInsert error 1227

The message leads me to believe that the Project Accounting posting setup has issues in the new company.

Go to Tools>>Setup>>Project>>Project, click on the Accounts button. This opens the Project Setup Cost Budget Accounts window.

In that window, you need to specify where the posting accounts are pulled from. Make sure to compare the window to the old one.

Good luck!

Ron Draganowski

www.dynamicsmn.com

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans