Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / PM Trx accidentally po...
Microsoft Dynamics GP (Archived)
Answered

PM Trx accidentally posted to GL with batch date

(0) ShareShare
ReportReport
Posted on by jackson456687 150

Hi all, 

I have a situation where some batches of PM transactions were posted, and the posting setup was set to take the batch date rather than the transaction date.  The resulting GL transactions are still unposted as a GL batch.  Is there an easy way to change the GL dates of these entries to match the original document date in PM?  

Categories:
Financial Management
  • Verified answer
    jackson456687 Profile Picture
    jackson456687 150 on at
    RE: PM Trx accidentally posted to GL with batch date

    UPDATE for anyone who may later be in this situation:

    Since my SQL skills are limited, I used smartlists of the GL and PM Trxs and then Vlookups to get the PM Doc date and GL info in one Excel sheet.  I then imported this into SQL as a table and wrote a simple update statement against the GL10000 table to change the TrxDate of any journal entries that required it.   As Harry and Richard said, the data is in SQL, and the correct JOIN statements probably could have done this easier and without needing Excel smartlists.

  • jackson456687 Profile Picture
    jackson456687 150 on at
    RE: PM Trx accidentally posted to GL with batch date

    There are quite a few in this case.  Any idea what the sql script should look like?  What is the common field that links the trx in the GL10000 with PM20000 tables?

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: PM Trx accidentally posted to GL with batch date

    How many transactions are there in this GL batch? If it just a few, I would manually change the dates. If there are many you will need to go into SSMS and create a script to update the GL10000 with dates from the PM20000 table.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: PM Trx accidentally posted to GL with batch date

    The PM20000 table and the GL10000 table house these transactions, but there doesn't seem to be a simple way to link these transactions to make such a change.

  • jackson456687 Profile Picture
    jackson456687 150 on at
    RE: PM Trx accidentally posted to GL with batch date

    I'm sorry, I should mention that there are 1000 transactions that may need to be changed.  So I was hoping to see if the originating document date is stored in the open GL table and could be changed by code rather than by hand.

  • Verified answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: PM Trx accidentally posted to GL with batch date

    You should be able to open Financial > Transactions > Batches, then look up the batch in question.  Select the Transactions button, then browse through the transactions at set the Transaction dates to the required date.  Major Caveat - your PM sub-ledger will not tie to your GL...  This will be especially problematic if any of your transaction dates crossed over into another period because of the setting.

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 284,876 Super User

#2
Ludwig Reinhard Profile Picture

Ludwig Reinhard Microsoft Employee

#3
Martin Dráb Profile Picture

Martin Dráb 225,425 Super User

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans