Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Transactions stuck in GL10000
111 views
Skip to first unread message
irishjamr
Feb 5, 2010, 2:16:01 PM2/5/10
to
We've got a group of transactions that posted through from Purchasing
Receipts that are stuck in GL10000 and GL10001. I can see the entries in
those tables but the batch does not show up in financial batches nor in batch
recovery. I've tried running checklinks on financial transaction work and
also tried a GL reconcile but neither returned any results.
Receipts that are stuck in GL10000 and GL10001. I can see the entries in
those tables but the batch does not show up in financial batches nor in batch
recovery. I've tried running checklinks on financial transaction work and
also tried a GL reconcile but neither returned any results.
We're on GP10, SP3. The posting settings for Purchase Receipts are to post
through GL and normally that's what happens. Any suggestions on how to
correct these entries? One option is to make a manual GL entry for them and
then delete from these two tables, but I'd rather not do that.
Mariano Gomez
Feb 5, 2010, 2:21:01 PM2/5/10
to
Just post the transactions in GL. Was your receiving transaction a
multicurrency receipt? These will not post through.
--
Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
multicurrency receipt? These will not post through.
--
Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
Frank Hamelly, MCP-GP, MCT, MVP
Feb 5, 2010, 3:25:57 PM2/5/10
to
Does the batch appear in SY00800? Do the transactions in the GL
tables have a batch ID associated with them? If no to the first
question, I'd be tempted to add a new batch then go into the tables
and associate that batch ID with the existing transactions. If no to
the second question only, I'd try going into the GL tables and
associating the existing batch with the transactions. I'd try this in
a test environment first, of course :)
tables have a batch ID associated with them? If no to the first
question, I'd be tempted to add a new batch then go into the tables
and associate that batch ID with the existing transactions. If no to
the second question only, I'd try going into the GL tables and
associating the existing batch with the transactions. I'd try this in
a test environment first, of course :)
Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com
get your GPtip42today at www.gp2themax.blogspot.com
irishjamr
Feb 9, 2010, 10:15:02 AM2/9/10
to
The batch does not appear in SY00800 but the transactions in the GL tables do
reference a batch number. After refreshing our test company I added the
batch manually to SY00800 but still could not see it within GP financial
batches to post. The batch does exist in SY00500.
Are there additional steps to associate the batch with the transactions
after adding it to SY00800? Any other thoughts?
reference a batch number. After refreshing our test company I added the
batch manually to SY00800 but still could not see it within GP financial
batches to post. The batch does exist in SY00500.
Are there additional steps to associate the batch with the transactions
after adding it to SY00800? Any other thoughts?
> .
>
Frank Hamelly, MCP-GP, MCT, MVP
Feb 9, 2010, 10:55:13 AM2/9/10
to
I'm sorry irish, I meant SY00500 in the company database, not SY00800
in the DYNAMICS db. My bad. Delete that batch from SY00800. SY00800
shows batch activity.
in the DYNAMICS db. My bad. Delete that batch from SY00800. SY00800
shows batch activity.
You say the batch is in SY00500 and the transactions in GL10000 and
GL10001 have that batch ID asociated with them? If so, what are the
values in the MKDTOPST (Marked to Post), POSTTOGL (Post to GL), and
BCHSTTUS (Batch Status)columns in SY00500?
0 new messages