Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

AP(4.2a): Post in Progress Error

AP(4.2a): Post in Progress Error

AP(4.2a): Post in Progress Error

I have an AP batch stuck in "Post in Progress" status.  When I try to post the batch we get the following error:

**Open Document Sched. Payment.
**Database error (operation=INSERT, error=2).
**Error occurred during posting. No error batch created.

It will not let us delete, open, or print the batch. I delete the restart records and try it again with the same results.  I ran the data integrity tool with the fix option "on".  All modules are error free except AP. The error I get with AP is:

Payment and Adjustment Batches, Payments/Adjustments, Miscellaneous Payments, Applied Payments, Adjustment G/L Distributions
      E: Open Document Sched. Payment.
          Database error (operation=GET, error=2).

  1 Error(s) found in Accounts Payable

I also ran the verify database utility and it says there are no errors anywhere.  

Is there anything I can do besides send the data in to be fixed.  I read somewhere that you can edit the apstrt.dat file and flag the batch "partially posted".  I do not know what database editor to use to do this.  If anyone has any thoughts I would love some suggestions.



RE: AP(4.2a): Post in Progress Error

I think any batch open payment, should be poasted, the other reason, the distributed and applied amount may be different, try to print the check on blank page and post it and then run data integrity, it may work.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close