Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GL Voucher not posting...
Microsoft Dynamics GP (Archived)

GL Voucher not posting after Depreciation / retirement Run and GL Post Performed

(0) ShareShare
ReportReport
Posted on by GPTech 16

Hi,

Seen many similar thread  but unfortunately none is solved and closed ,

I am at GP 2013 R2 (12.0.2084 ) with an upgrade offcourse from 2010 , everything perfect prior to upgrade ,  

here is the problem -

I Run the depreciation - (making sure that the period is not run before) process run properly , Book value, ytd depreciation , ltd depreciation , and other data looks good , 

GL Posting Process - it is obvious that their is no data even to see and complete the process of GL Posting

once typed - Batch Id , Posting date & Book ID - Process - ( error messaged reads)

"there are no transaction matching these restrictions . Modify your restrictions and process the batch again "

and No data for GL Posting in FA Depreciation to post  for GL ,

note : no modification or any addon products , I created a fresh new Asset and run depreciation one asset, the problem remain same .

 

 

 

*This post is locked for comments

  • GuruDofGP Profile Picture
    GuruDofGP 240 on at
    RE: GL Voucher not posting after Depreciation / retirement Run and GL Post Performed

    I have a client with this same issue.  Is/Was any resolution found or what the issue is to try and fix it?

    Thank you!

  • GPTech Profile Picture
    GPTech 16 on at
    RE: GL Voucher not posting after Depreciation / retirement Run and GL Post Performed

    BOOKINDX BOOKID BOOKDESC DEPRPERIOD CURRFISCALYR YEAR1 Auto_Add_Book_Info NOTEINDX LASTMNTDDATE LASTMNTDTIME LASTMNTDUSERID PTGENLED Ledger_ID CALNDRID DEX_ROW_ID

    1 ABCTCO           ABCTCO                           1 2015 2015 1 6861.00000 2016-08-18 00:00:00.000 1900-01-01 17:23:08.000 sa             0 0 DEFAULT         1

  • GPTech Profile Picture
    GPTech 16 on at
    RE: GL Voucher not posting after Depreciation / retirement Run and GL Post Performed

    FA40200 contains 1 row which correct book id setup , i think book setup is fine because i can see Assets book values and other infor at inquiry are correct and aligned ,

    The only problem simce It is not throwing data into perticular thable which makes GL Voucher Process Available I believe may any missing / corrupted SQL procedure of depreciation Action.

  • GPTech Profile Picture
    GPTech 16 on at
    RE: GL Voucher not posting after Depreciation / retirement Run and GL Post Performed

    FA40200 contains 1 row which correct book id setup , i belive

  • RogerRogerATX Profile Picture
    RogerRogerATX 1,515 on at
    RE: GL Voucher not posting after Depreciation / retirement Run and GL Post Performed

    Hmmm what Asset Books do you have setup?   FA00905 should have generated at the same time as FA00902 so I'm wondering if it's a book/book setup issue.

  • GPTech Profile Picture
    GPTech 16 on at
    RE: GL Voucher not posting after Depreciation / retirement Run and GL Post Performed

    FA15000

    (0 row(s) affected)

    FA00905

    (0 row(s) affected)

    FAINDEX

    INDXNAME INDXFILENAME INDXVALUE DEX_ROW_ID

    4 4 1 3

    9 9 1 5

    18 18 1 6

    12 12 5 7

    17 17 7 14

    3 3 7 8

    5 5 7 10

    1 1 18 4

    15 15 95 1

    11 11 154 13

    14 14 280 12

    10 10 1196 2

    2 2 3479 9

    6 6 109593 11

    (14 row(s) affected)

  • RogerRogerATX Profile Picture
    RogerRogerATX 1,515 on at
    RE: GL Voucher not posting after Depreciation / retirement Run and GL Post Performed

    What do you have in these tables:

    FA15000

    FA00905

    FAINDEX

  • GPTech Profile Picture
    GPTech 16 on at
    RE: GL Voucher not posting after Depreciation / retirement Run and GL Post Performed

    Hi Roger ,

    I ran the command and I can see the transction

    FA_Doc_Number(FADEP00000000013 & FADEP00000000014 ,

    SOURCDOC (FADEP & FADEP-O)

    and all other columns data is correct and as it suppose to be in the form of JV to be.

    but their is no trace of such entry at GL10000 or GL100001 , or GL20000 tables.

    Thanks ,

  • RogerRogerATX Profile Picture
    RogerRogerATX 1,515 on at
    RE: GL Voucher not posting after Depreciation / retirement Run and GL Post Performed

    Do you have access to SQL Server Management Studio?

    If so, run these queries against the company database:

    SELECT * FROM FA00902 WHERE GLINTBTCHNUM=''

    If you get no results, can you run this:

    SELECT TOP 25 * FROM FA00902 ORDER BY DEX_ROW_ID DESC

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans