AR invoice batch's status "post in progress"

[winstz]

Dear all,

I am using ACCPAC 5.3A running under Windows XP.

When i posted a AR Invoice, the system hang and inside the AR Invoice batch list, the batch's status is "Post in progress".

I can't delete this batch and cannot post another batches.

I have restarted the database server but the status is the same.

How do i solve this problem?

Need assistance please.

Thanks

 

[wangui1981]

You'll need to open the database and in the APIBC table change the batchstat column of that particular batch to 1 a batch in progress normally has 8 so change it and try posing again.

 

[ettienne]

You can post the post in progress batch again, no need to change the batch status. Run RVSpy to see what is causing the error, if any.

 

[winstz]

Dear all,

i have edited ARIBC table and change the status to 1.

now i can open the invoice batch and i export the batch.

but when i try to repost it again, i get this error message : Description: Incorrect procedure. There are no batches ready for processing in the specified range.

then i delete the batch.

then i make new invoice entry batch and i import the exported batch.

then i post the new batch and i get this error message : Description: Incorrect procedure. Restart record already exists. Cannot post other records until batch 260 is posted.

any solution ?

thanks.

 

[ettienne]

Edit ARRSTRT and delete the restart record.

 

[winstz]

Hi ettienne,

This is the following step i do :

1. Edit batch status in ARIBC table to 1

2. Delete record in ARRSTRT

3. Post the batch again (my batch has 3 entries), when i repost it, entry 1 and 2 is ok, when entry 3 i got these error messages :

- Description: Open Document Sched. Payment. Database error (operation=GET, error=9100). [Microsoft][ODBC SQL Server Driver][SQL Server]Possible index corruption detected. Run DBCC CHECKDB. Please refer this error to your database administrator or see your database documentation for further assistance.

- Description: Invalid input. Cannot apply Credit note CN081003, as apply-to document FPLK08090057 does not exist.

- Description: Invalid input. Date 11/ 8/2008 is not in the fiscal calendar.

4. And the batch status is "post in progress" again

Any solution ?

Thanks.

 

[ettienne]

You have corrupted data somewhere.
Run a database verify and run a data integrity check on AR.
From the error message it looks like AROBP has a problem.
Also run DBCC CHECKDB in SQL.

 

[winstz]

@ettienne
Thanks for the help
i do database dump and load and shrink database

now it's normal.