Industry Use Cases

How to Find Book Returns Missing From Warehouse Receipts

A bookseller received a credit. The warehouse still shows no receipt. The copies could be in transit or have been destroyed under a return agreement.

What to pull

Use Excel returns, credits and receipts or export return authorizations and credits from accounting and receipts from the warehouse. Keep ISBN, authorization ID, units and disposition.

How to check it

Match by authorization and ISBN. Separate partial receipts, approved destruction and uncredited returns. Allow the documented processing window.

Select the relevant sheets in Jolene.pro and run this check.

Which credited returns lack a receipt or approved disposition? Show units, age and source rows.

What to do with the result

Follow up on older unmatched returns with the warehouse and account team before changing stock.

Verify cutoff dates and approved disposition records.

Try Jolene.pro ยท Follow Jolene.pro on LinkedIn

Leave a comment