Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

AR invoice batch's status "post in progress"

Status
Not open for further replies.

winstz

MIS
Oct 20, 2008
44
ID
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 :)
 
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.
 
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.
 
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.
 
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.
 
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.
 
@ettienne
Thanks for the help
i do database dump and load and shrink database

now it's normal.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top