GL batches show as open but won't post

[WalterHeisenberg]

Hello,

We have GL batches showing as open but won't post with the message "There are no batches no post". The batches in question appear in GLPOST however. I am currently in the process of running data integrity but does anyone have any ideas?

We are on Accpac 5.6 PU2 on SQL Server 2008R2.

 

[Jay Converse]

Set them as "ready to post

 

[WalterHeisenberg]

With Ready to Post marked Yes and Status of Ready to Post we get the error there are no batches no post. Data integrity did not find any errors.

 

[WalterHeisenberg]

I am wondering when you try to post a batch, what tables does accpac look at? GLBCTL looks fine and has the BATCHSTAT as 9.

 

[WalterHeisenberg]

The other thing that is odd, is GLPOST is listed as Posted Batches and the batches in question appear in that table but do not appear on a G/L transaction listing.

 

[Jay Converse]

Post them from the GL batch list.

 

[WalterHeisenberg]

I get the same error from there.

 

[Jay Converse]

There's some missing info in this thread. Was there a system crash? If GLPOST has data, then something was partially done.

 

[WalterHeisenberg]

No crash - user reported there no error

 

[Jay Converse]

Set GLBCTL.BATCHSTAT to 4 and see what happens.

 

[WalterHeisenberg]

I took a look at how much work was done today and decided to restore last nights backup and reimport all the batches created today. I did make a backup of the corrupted database before the restoration so I will attempt your suggestion our test environment and report back.

 

[Jay Converse]

FWIW, this stuff doesn't happen in Accpac without a client, database, or network crash in the middle of posting.

 

[DjangMan]

Also - G/L batches have a funny switch in GLBCTL - ACTIVESW. That has to be set to 1.