Good day i am having challenges with great plains 10 since we experienced a power failure while users were posting in batches.
1. some transactions go missing from the trial balance and can only be seen in the inquiry screen they don't show on reports or anywhere else but if the transaction is reposted the figures double.
2. there are part payments that have been entered can be seen in the applied screen but the invoice has a zero balance even though there is a balance.
3. some invoices showing a zero balance on the invoice but in the applied screen there is no information about that payment even though it was posted.
4. transactions that are completed are still showing as open.
Please assist me with this challenge.
*This post is locked for comments
Thanks for the response. I am currently testing the solution you proposed
This problem occurs with both payables and receivables batches
I agree wholeheartedly with Mahmoud and Tim. It sounds like you have some significant data corruption. However, prior to doing table surgery, I would restore the production database to a test company and run Check Links in the test company to see if it fixes any of the issues. That would at least reveal whether you can pull this patient through with minimally invasive surgery :)
This is the situation where; unfortunately, there is no quick fix since the damages can not be simply evaluated. The possibilities are quite too many and definitely requires the involvement of a specialized consultant.
In Dynamics GP, data go through multiple stages as it is saved and posted. Several tables and values are stored according to the type of the transaction and its associated details.
Calling Microsoft for a support ticket would be a good option
Although, let us know if there is any useful thing we could provide
If you are unable to restore from a backup prior to the power failure for business reasons then my experience with similar situations is that you will need an experienced consultant with GP table knowledge to right this situation.
When GP posts a batch it will first copy records from work to open (those that are 'post-able'), then print posting reports, then clean-up the work records. Based on your description you have one or more batches that have multiple transactions in both the work and open tables at the same time. Here you need to decide what is really posted, have summary tables been updated, are all records in work posted or do some still need to be posted etc... Is status correct for the documents in RM00401 ...
Not simple or easy but quite fixable by the proper resource. It's not something I've ever seen checklinks address, I don't see a quick fix here unless you can roll back.
Are these accounts payable or accounts receivable batches?
Some of the transactions might corrupted please do the following and before doing this please take a backup and logout everyone out of GP.
SELECT * FROM DYNAMICS..ACTIVITY
SELECT * FROM DYNAMICS..SY00800
SELECT * FROM DYNAMICS..SY00801
SELECT * FROM TEMPDB..DEX_LOCK
SELECT * FROM TEMPDB..DEX_SESSION
If you get answers / results to any of the above, make sure everyone is in fact logged out of GP and then run the following scripts to clear the tables.
Then run the following against the company database if you have any specific batch which you couldn't access.
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB=’XXX’
(Where ‘XXX’ is the batch ID of the batch that is stuck in posting / Reeiving / Busy / Marked etc.)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional