AR Batch Post Fail 1

[ramam1]

Hey there,
We recently generated a recurring invoice batch in AR and it failed on about 5% of the entries (warning: in use by other user); this has happened before and we've simply rerun it at a later time and the skipped invoices get generated. This time posting the small batch worked however when posting the initial batch (95%) we got an error "Tax tracking item already exists" and the big batch didn't post - it is in the "Posting in Progress" state and there is a generic restart record. I ran a backup.
Should I just change the batch status back to RTP and try posting it again or is there some clean up I should do first?

thanks!

 

[Jay Converse]

No. Export the batch to Excel, remove the posted records, import to a new batch, then post. Then mark the original batch as posted.

Then figure out why your installation is screwed up, like missing service packs or inadequate hardware.

 

[ramam1]

Thanks Tuba. We are at 5.6A PU2 which I believe is current.
Plan:
1 mark the partially failed batch as Open so I can export it.
2 create a new batch containing only the un-posted entries from the partially failed batch.
3 mark the partially failed batch as posted.
4 post new batch

Should I export/import the partially failed batch to remove the un-posted entries (which were posted in the new batch)? I'm guessing it doesn't make a difference.

 

[Jay Converse]

No, just mark the old batch as posted. Note that you'll have to renmumber the unposted entries before you import. Or, edit ARIBH on the partial batch to get rid of them.

 

[ramam1]

I think you're saying the invoice numbers have to be either changed in the new batch or removed (??) from the partial batch. I very much don't want to change the invoice numbers that get posted so I suppose I go down the remove from ARIBH path.

For the next guy... I found which entries where posted by comparing IDINVC from ARIBH for that batch with all IDINVC in AROBL, documents in AROBL are posted documents.

Regarding getting rid of them in ARIBH -> you're suggesting I delete the corresponding rows in ARIBD,ARIBDO, ARIBH, ARIBHO and update count in ARIBC for that batch?

 

[Jay Converse]

You can if you want to, but once the ARIBH records are gone, the others are harmless orphans.

 

[ramam1]

It worked on a clone of our DB, doing the real DB now...
thanks a bunch Tuba!