The starting point
Points of sale return unsold newspapers and magazines to the press wholesaler and receive a credit note for them. At PDG every return was already captured by scan in the warehouse. The real work started after that.
The back office compared scan data with the reports from the points of sale by hand. If the count differed, every case was resolved individually, even when the difference was a single copy. Credit notes were only issued after this matching and were often delayed. Return rates per title and point of sale were only available after the weekly or monthly close.
The solution
Nothing changed about the scan in the warehouse. Behind it, STRUKTUR built matching logic that works with PDG's inventory management system. Every count is automatically compared with the point of sale's report and with the delivered quantity.
Nobody resolves small differences by hand any more. With a difference of one copy per title, or up to 2 % of the reported quantity for large volumes, the count is booked. Larger differences and returns above the delivered quantity go onto a review list. There the back office sees only the open cases, each with report, count, delivered quantity and the point of sale's history so far.
Every automatic booking is logged and can be corrected. Points of sale that use up the tolerance conspicuously often in a month show up in the reporting.
Credit note on the day of receipt.
Consistent cases generate the credit note for the point of sale automatically, together with the record for publisher billing. An overview shows return rates per title, point of sale and route, plus conspicuous differences, all updated daily.
One return, step by step
- A driver brings a point of sale's returns crate to the warehouse on the morning route.
- A warehouse worker scans the point of sale's label and then the barcode of each title. They count the copies and confirm the quantity.
- The system compares the count with the report and the delivered quantity. If everything matches, it is booked.
- If the difference is within the tolerance, it is booked as well, using the counted quantity.
- If more copies were counted than delivered, the case goes onto the review list with all details.
- For the consistent titles the credit note is issued the same day, and the return rate in the reporting is updated.
Result
- Manual matching of scan and report is gone.
- The back office only resolves real differences.
- Credit notes are issued on the day of receipt instead of after the matching.
- Return rates per title, point of sale and route are updated daily instead of only at the weekly or monthly close.
Approach
The project followed the four phases STRUKTUR uses to set up every automation.
- Phase 1, audit: Spend a day alongside the warehouse and the back office and measure the time spent on matching and resolving.
- Phase 2, plan and quote: Set the tolerance rules, clarify the data transfer from the scan capture, fixed-price quote.
- Phase 3, build and test: Build the matching, review list and reporting and test them in parallel with the existing process, comparing the results daily.
- Phase 4, operation: Full switchover, staff training, measuring the time spent again and fine-tuning the tolerances.
