UNPOSTED ITEMS REPORT SHOWS UNPOSTED QUICK CASH

Problem Description:
===================
You have rows on the 'Unposted Items Report.'   The legend says that 'This
receipt is part of an unposted quick cash batch.' There are no quickcash
batches that show ready to import.

Problem Explanation:
===================
Receipts are showing on the 'Unposted Items Report'.
Message 'This receipt is part of an unposted quick cash batch'
is on the bottom of the page.  The credit column is blank.

There are no quick cash batches showing on the form, which is used to post
quick cash batches.

These records exist on the ar_interim_cash_receipts table.  There are no rows
on ar_cash_receipts for the same cash_receipt_id.  The batch_id of the receipts
is obtainable from ar_interim_cash_receipts.  The batch may have a
batch_applied_status of 'POST BATCH WAITING' and a status of 'OP', but not
always.

Use these scripts to look at the data:

Select cash_receipt_id,batch_id
From ar_interim_cash_receipts_all
Where receipt_number = &receiptnumber;

See if the cash_receipt_id exists on ar_cash_receipts;

Select cash_receipt_id
From ar_cash_receipts_all
Where cash_receipt_id = &cashrecid;

If it dosen't exist, then what probably happened is that the post quick cash
batch process abended.  See solution.

Solution Description:
====================
If the cash_receipt_id does not exist on AR_CASH_RECEIPTS_ALL, then the post
quick cash process probably abended.   You need to reset the request_id and the
operation_request_id to null for that batch_id;

Solution Explanation:
====================

Step 1.
-------

Obtain the batch_id from ar_interim_cash_receipts_all for this receipt_number.

Select batch_id,cash_receipt_id,receipt_number
From ar_interim_cash_receipts_all
Where gl_date between '01-MAR-98' and '31-MAR-98';

(use the date range for your GL period)

Select batch_id,batch_applied_status,status,operation_request_id
From ar_batches
Where batch_id =&batchid;

Step 2.
-------

If the batch_applied_status is not = 'POSTBATCH_WAITING' 
and the cash_receipt_id does not exist on ar_cash_receipts_all, then: 

Update ar_batches
Set request_id = null,
    batch_applied_status = 'POSTBATCH_WAITING',
    status = 'OP',
    operation_request_id = null
Where batch_id = &batch_id;
commit;

Step 3.
-------
Select your batch for Quick Cash Posting.

Step 4.
-------
Run your General Ledger Posting.




Search Words:
============
Post Quick Cash Unposted ARGLTP Unposted Receipt Receipts
failed terminated abended killed stopped postbatch post
batch interim lockbox