Dynamics Community Forum Thread Details

I have "unposted" general ledger transactions that show in a smartlist GLTRX query. Can these be posted?

In this instance the underlying transactions were initiated in the purchasing module. The transctions appear to be okay in the purchasing module. The GLTRX smartlist show the general ledger transactions to be in a "print" status. I would like to post the "unposted" general ledger transactions, or delete them and post manual entries.

If they are in 'print' status then that means the posting process never completed. You need to check Batch Recovery to see if they are there. if they don't appear in Batch Recovery then you'll need to do the following -

In SQL Management Studio -

1. Run the following script against the company database. Replace XXX with the batch number or the name of the batch that you are trying to post.

UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'

Note The value of BACHNUMB is the same as the value of the Batch ID window in Great Plains.

2. View the contents of the SY00800 table that is located in the DYNAMICS database to determine the value of the DEX_ROW_ID field for the batch that you are trying to unmark. You can view the contents of this table by running the following script.

SELECT * FROM DYNAMICS..SY00800

Note If no results are returned, go to step 5.

3. Run the following delete script that is based on the results that you received in step 3. Replace XXX with the DEX_ROW_ID value of the batch that you are trying to unmark.

DELETE DYNAMICS..SY00800 where DEX_ROW_ID= 'XXX'

4. Verify the accuracy of the transactions.

5. Verify that you can edit and post the batches.

Hope this helps,

Quick Links

Leaderboard