Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / inserting Zero date in...
Microsoft Dynamics GP (Archived)

inserting Zero date in Beginning Period in GP Dynamics GP Fixed Assets

(0) ShareShare
ReportReport
Posted on by Blue Smart 110

Hi all,
i think i have big big problem in our fixed assets module
my case as following ;
after i retired one card of our fixed assets ( Class Vehicles) as a regular & normal transactions from" Retire Maintenance Window "
 and when i was going to complete that process by using "Fixed Assets General Ledger Posting Window"

i forgot to insert date in beginning period (it was Zero ) but in ending period i inserted specific date ( 2018-003) and transction date in 31-03-2018
but after i progressed Geneal Ledger i found that retired GL Jornal Entry including not only entries for retired card but also other entries related to other classes

( please show attached screen shot of generated jornal entry )

i don't know why & What happened to other Classes ... ???
   how i could solve and settle this problem,..................?

Fixed-Assets.2.png

*This post is locked for comments

  • Verified answer
    Jeff Grant Profile Picture
    Jeff Grant on at
    RE: inserting Zero date in Beginning Period in GP Dynamics GP Fixed Assets

    Hi Blue Smart,

    Full SQL scripting recommendation for this method would be:

    -- insure you have a good backup in place of the erring company db prior to running.

    -- Insure you are logged out of Dynamics GP when running the SQL scripting.

    -- Insure you are replacing 'XXX' with the complete name of the erring GL Posting Batch (note: should be similar in format to 'FATRX00000123').

    declare @BatchName char(15)

    set @BatchName = 'XXX'

    UPDATE FA00902 SET GLINTBTCHNUM = '', GLINTTRXDATE = '1900-01-01 00:00:00.000' WHERE GLINTBTCHNUM = @BatchName

    DELETE FA15000 WHERE GLINTBTCHNUM = @BatchName /*This table is the holds the user activity for Fixed Assets*/

    DELETE FA00905 where GLINTBTCHNUM = @BatchName /* We need to remove these records in order to allow the problem FA trx to be pulled into a new batch */

    DELETE FAINDEX /*This table holds the index numbers for Fixed Assets, but will be recreated automatically upon next log-in*/

    Best Regards,

    Jeff

  • Verified answer
    Jeff Grant Profile Picture
    Jeff Grant on at
    RE: inserting Zero date in Beginning Period in GP Dynamics GP Fixed Assets

    Hi Blue Smart,

    This would be expected performance if there was no 'start' date as all financial detail transactions for FA from the FA00902 table before 2008-003 would be included in the batch.  As suggested prior, restoring from the backup after the posting would be your best option.  

    If not able to do so you can void the resulting GL batch and make the FA00902 entries available again for re-posting again by removing the batch assignment from the GLINTBTCHNUM field with SQL

    For instance, if the FA batch # was 'FATRX00000001', the SQL scripting to use would be:

    update FA00902 set GLINTBTCHNUM='' where GLINTBTCHNUM='FATRX00000001'

    After the FA00902 update you would need to reset the FAINDEX table by deleting it:

    delete FAINDEX

    This table will get reset upon next log-in when the system will review posted FA00902 entries to fill the table content for new depreciation activity.

    As with any SQL work, please insure you have a good backup of the erring company db in place prior to performing any SQL work upon it and try the option in a TEST company prior to performing in LIVE so you can insure the outcome is what you are expecting:

    871973 - Set up a test company that has a copy of live company data  

    support.microsoft.com/.../set-up-a-test-company-that-has-a-copy-of-live-company-data-for-microso

    Best Regards,

    Jeff

  • Suggested answer
    Blue Smart Profile Picture
    Blue Smart 110 on at
    RE: inserting Zero date in Beginning Period in GP Dynamics GP Fixed Assets

    i think it's too late

    but already we have a copy of  year end closing backup for all modules ,,

    i don't konw if there is a way to restore only fixed assets to date 31-12-2017 and keep others modules as it is ...

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: inserting Zero date in Beginning Period in GP Dynamics GP Fixed Assets

    Is it too late to restore from backup? Perhaps you can do that before everyone shows up for work on Monday.

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