Add a new idea Subscribe
Status Already exists
Workspace Reckon Accounts Business
Categories Desktop & Hosted
Created by Guest
Created on Nov 1, 2019

RELATED IDEAS

Backorder Report

I would like to run a report which easily shows products customers have on backorder. The current method of searcing each individual part number is to time consuming

  • ADMIN RESPONSE
    Nov 11, 2019

    The Open Sales Order by Customer report (Under the sales report menu) is designed for this purpose. By default it is a summary report, however by modifying the report you can change this to a detail report.

    By then selecting additional columns like ITEM, DESCRIPTION, QTY you have a detailed backorder report grouped by customer.

    Furthermore these detail reports can be exported to Excel where functions like pivot tables and column filters really come into their own.

    image.png
    image.png
    Open full size
    image.png
  • Attach files