Payables Batch IDs status

[MWC]

We printed a single use check successfully in Dynamics 9.0, but the status in
the Payables Batch IDs window for the print job still shows 'Printing.' Is
there a way to delete or clear this entry from the window?

Thanks!
Mark

[Victoria [MVP]]

I think 'Printing' is a bit of a misnomer, but since the batch is still
there, I would suspect that you did not post the batch. As a control, as
soon as GP prints a check, you are not able to delete it - your choices are:
- reprint
- void
- post

All of these can be accomplished from the Post Payables Checks screen
(Transactions > Purchasing > Post Checks).

--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

"MWC" <M...@discussions.microsoft.com> wrote in message
news:E30822A4-7643-4996...@microsoft.com...

[MWC]

Hi Victoria,
Thanks for responding! We weren't able to see the check in the
Transactions/Purchasing/Post Checks screen or type it in manually because
everything posted through to the GL, applied payments to vendor's records,
and it shows up on a "vendor check register", i.e. everything worked normally
when printing the check.

[Victoria [MVP]]

Sorry, just to make sure I understand, you're saying everything posted fine,
it's showing as posted in the payables and GL inquiry screens, but when you
look at the status of payables batches it still says 'Printing'? If so,
what screen are you looking at to see that?

--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

"MWC" <M...@discussions.microsoft.com> wrote in message

news:B055179C-51FD-4132...@microsoft.com...

[MWC]

Yes, that is correct. The screen we're looking at is the Payables Batch IDs
screen (accessed via Transactions/Purchasing/Batches and then clicking on the
magnifying glass next to the Batch ID field on the Payables Batch Entry
screen).

[Victoria [MVP]]

If you are able to run a SQL query on your data, can look for that batch in
the SY00500 table of your company database and see what the BCHSTTUS is?
Most likely it is something other than zero and if you set it to zero, then
the batch will now be available either in the Print Checks or Post checks
screen. If that is the case, and it's already showing as POSTED in the
payables and GL ledgers, then someone must have re-entered those
transactions.

--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

"MWC" <M...@discussions.microsoft.com> wrote in message

news:E88AABC5-DD8C-4C3F...@microsoft.com...

[MWC]

We ran the SQL query and changed the value of BCHSTTUS to zero (it was set to
5). The batch doesn't show in Post Checks, but does show in Print Checks;
however, it is marked for "posting by another user" and not available to be
selected by anyone. We don't want to print the check again as it already has
been printed and the batch is still in the GL, ready to be posted, but no one
has re-entered the transaction.

The check is listed under Vendors and still shows up on the Check Register.
It doesn't show up in batch reprint and the batch shows up as 'marked', but
marked for posting by another user.

[Victoria [MVP]]

What is the ERRSTATE for that batch in SY00500? If it's not 0, change that
to zero. See if that changes anything for you.

--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

"MWC" <M...@discussions.microsoft.com> wrote in message

news:6EA149A8-55B7-4BF2...@microsoft.com...

[MWC]

The ERRSTATE is zero.

[Victoria [MVP]]

How about MKDTOPST and CHKSPRTD?

--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

"MWC" <M...@discussions.microsoft.com> wrote in message

news:80C32664-7ED3-4954...@microsoft.com...

[hairongshan]

After selecting the batch from Transactions > Purchasing > Post Checks, an error was encountered:

This batch is being edited by aonterh user. Please try later.

There is no other users in the system. Why would this happen?

Thanks.

Victoria [MVP] wrote:

I think 'Printing' is a bit of a misnomer, but since the batch is still there,

13-Dec-07

I think 'Printing' is a bit of a misnomer, but since the batch is still
there, I would suspect that you did not post the batch. As a control, as
soon as GP prints a check, you are not able to delete it - your choices are:
- reprint
- void
- post

All of these can be accomplished from the Post Payables Checks screen
(Transactions > Purchasing > Post Checks).

--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

"MWC" <M...@discussions.microsoft.com> wrote in message
news:E30822A4-7643-4996...@microsoft.com...

Previous Posts In This Thread:

On Thursday, December 13, 2007 7:32 AM
MW wrote:

Payables Batch IDs status

We printed a single use check successfully in Dynamics 9.0, but the status in
the Payables Batch IDs window for the print job still shows 'Printing.' Is
there a way to delete or clear this entry from the window?

Thanks!
Mark

On Thursday, December 13, 2007 9:09 AM
Victoria [MVP] wrote:

I think 'Printing' is a bit of a misnomer, but since the batch is still there,
I think 'Printing' is a bit of a misnomer, but since the batch is still
there, I would suspect that you did not post the batch. As a control, as
soon as GP prints a check, you are not able to delete it - your choices are:
- reprint
- void
- post

All of these can be accomplished from the Post Payables Checks screen
(Transactions > Purchasing > Post Checks).

--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

"MWC" <M...@discussions.microsoft.com> wrote in message
news:E30822A4-7643-4996...@microsoft.com...

On Thursday, December 13, 2007 2:48 PM
MW wrote:

Hi Victoria,Thanks for responding!

Hi Victoria,
Thanks for responding! We weren't able to see the check in the
Transactions/Purchasing/Post Checks screen or type it in manually because
everything posted through to the GL, applied payments to vendor's records,
and it shows up on a "vendor check register", i.e. everything worked normally
when printing the check.

"Victoria [MVP]" wrote:

On Friday, December 14, 2007 7:14 AM
Victoria [MVP] wrote:

Sorry, just to make sure I understand, you're saying everything posted fine,
Sorry, just to make sure I understand, you're saying everything posted fine,
it's showing as posted in the payables and GL inquiry screens, but when you
look at the status of payables batches it still says 'Printing'? If so,
what screen are you looking at to see that?

--

Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

"MWC" <M...@discussions.microsoft.com> wrote in message

news:B055179C-51FD-4132...@microsoft.com...

On Friday, December 14, 2007 10:33 AM
MW wrote:

Yes, that is correct.

Yes, that is correct. The screen we're looking at is the Payables Batch IDs
screen (accessed via Transactions/Purchasing/Batches and then clicking on the
magnifying glass next to the Batch ID field on the Payables Batch Entry
screen).

"Victoria [MVP]" wrote:

On Friday, December 14, 2007 1:04 PM
Victoria [MVP] wrote:

If you are able to run a SQL query on your data, can look for that batch in
If you are able to run a SQL query on your data, can look for that batch in
the SY00500 table of your company database and see what the BCHSTTUS is?
Most likely it is something other than zero and if you set it to zero, then
the batch will now be available either in the Print Checks or Post checks
screen. If that is the case, and it's already showing as POSTED in the
payables and GL ledgers, then someone must have re-entered those
transactions.

--

Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

"MWC" <M...@discussions.microsoft.com> wrote in message

news:E88AABC5-DD8C-4C3F...@microsoft.com...

On Monday, December 17, 2007 10:05 AM
MW wrote:

We ran the SQL query and changed the value of BCHSTTUS to zero (it was set to
We ran the SQL query and changed the value of BCHSTTUS to zero (it was set to
5). The batch doesn't show in Post Checks, but does show in Print Checks;
however, it is marked for "posting by another user" and not available to be
selected by anyone. We don't want to print the check again as it already has
been printed and the batch is still in the GL, ready to be posted, but no one
has re-entered the transaction.

The check is listed under Vendors and still shows up on the Check Register.
It doesn't show up in batch reprint and the batch shows up as 'marked', but
marked for posting by another user.

"Victoria [MVP]" wrote:

On Monday, December 17, 2007 10:57 AM
Victoria [MVP] wrote:

What is the ERRSTATE for that batch in SY00500?

What is the ERRSTATE for that batch in SY00500? If it is not 0, change that

to zero. See if that changes anything for you.

--

Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

On Monday, December 17, 2007 1:48 PM
MW wrote:

Re: Payables Batch IDs status
The ERRSTATE is zero.

"Victoria [MVP]" wrote:

On Monday, December 17, 2007 1:59 PM
Victoria [MVP] wrote:

How about MKDTOPST and CHKSPRTD?
How about MKDTOPST and CHKSPRTD?

--

Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

Submitted via EggHeadCafe - Software Developer Portal of Choice
IIS 7.0 Extensionless UrlRewriting (Short urls)
http://www.eggheadcafe.com/tutorials/aspnet/6592d2d4-bbf4-4ecd-93df-52898c6aa5d7/iis-70-extensionless-url.aspx

[Mohammad R. Daoud]

Make sure that no users are logged in to the application, then perform the
following operations:

1. Delete All Records in Dynamics --> Activity Table
2. Delete All Records in Dynamics --> SY00800 Table
3. Delete All Records in TEMPDB --> Both DEX tables.

This should release the batch.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Mob: +962 - 79 -999 65 85
mohd...@gmail.com
http://mohdaoud.blogspot.com/

"Hairong Shan" wrote:

> .
>

[John Ross]

There is also a little program from customer source called clear dex locks
or something like that , it does basically the same thing.

-John

<Hairong Shan> wrote in message
news:2010413183...@barneyandbarney.com...