---
id: post/mohana-blog/tag-blogger-com-1999-blog-1492436440038408053-post-6634996257036493772--55ed189793
type: post
title: You can't see your stale documents, and that's why they're stale
summary: A Business Central extension called Unposted Document Aging provides a single list combining sales quotes, orders, and unposted invoices organized into priority bands by age and status. Instead of manual Excel reports, it shows which documents are stale and who owns them, with automated daily email digests per salesperson.
tier: community
language: en
tags:
  - document aging
  - stale documents
  - pipeline management
  - sales orders
  - quotes
  - invoices
  - reporting
system: sales
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:46:34.210Z"
  flags: []
generated:
  at: "2026-10-07T22:42:12.892Z"
  pipeline: 0.2.0
  prompts:
    extract-post: 1
  input_hash: 8e5de66b8efca678501c15b4ca1793cc939902b4c89c1838bc8f8c4f52c16530
evidence:
  - kind: blog
    url: http://mohana-dynamicsnav.blogspot.com/2026/09/you-cant-see-your-stale-documents-and.html
    title: You can't see your stale documents, and that's why they're stale
    date: "2026-09-11"
    commit: null
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
post_id: tag:blogger.com,1999:blog-1492436440038408053.post-6634996257036493772
source_id: mohana-blog
source_name: Mohana's Dynamics NAV & BC blog
url: http://mohana-dynamicsnav.blogspot.com/2026/09/you-cant-see-your-stale-documents-and.html
published_at: "2026-09-11T12:28:34.000Z"
author: Mohana Yadav
full_text: false
words: 888
quotes: []
code_objects_mentioned:
  - page Unposted Document Aging
  - other Email Scenario
systems:
  - sales
  - finance
  - reporting
versions_mentioned:
  - BC 26
preview:
  embeddable: true
  frame_url: null
  image: https://blogger.googleusercontent.com/img/a/AVvXsEj2rypWHrDHn8zWTMXqOTMhP8ZTo-jEGTYjmGIG5N8FS01lvoZqOqaMeaUGrrulYdVJkzYzx4JIYQLsrx6wIjsDTIZk7eIOssB13hgjenbFIWEq99s5NZ6G7o-9R-j71w6I_t1TRMjfQAcsyFJWJD5e1s8oAsP2Iqb1jycuT_y05y46cAfXFSIna3lwm0SP=w1200-h630-p-k-no-nu
  image_alt: null
  image_w: null
  image_h: null
  site_name: null
  favicon: https://mohana-dynamicsnav.blogspot.com/favicon.ico
  probed_at: "2026-10-07T11:50:10.999Z"
---

# You can't see your stale documents, and that's why they're stale

[Read the post](http://mohana-dynamicsnav.blogspot.com/2026/09/you-cant-see-your-stale-documents-and.html) · Mohana's Dynamics NAV & BC blog (Mohana Yadav) · 2026-09-11 · 888 words · tier community · reviewed (checked by Opus)

> A Business Central extension called Unposted Document Aging provides a single list combining sales quotes, orders, and unposted invoices organized into priority bands by age and status. Instead of manual Excel reports, it shows which documents are stale and who owns them, with automated daily email digests per salesperson.

## Key points

- Consolidates sales quotes, orders, and unposted invoices into one read-only view with ownership and age information
- Organizes documents into six priority bands (Shipped Not Invoiced, Quote Expired, Invoice Unposted, Order Stale, Quote Stale, Other) to highlight money sitting uninvoiced
- Uses configurable date thresholds (30 days for quotes, 14 for orders, 7 for invoices) based on either Document Date or Created date
- Sends personalized daily email digests to each salesperson showing only their stale documents
- Built entirely on temporary buffers with no stored data, using SetFilter for SQL-level performance optimization

## AL objects mentioned

As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.

- page "Unposted Document Aging"
- other "Email Scenario"

Not found in BC28-30: page "Unposted Document Aging".

## Context

- Features: Consolidated stale document list, Priority-based document banding, Configurable aging thresholds, Document Date vs Created date switching, Daily salesperson email digests, Multi-currency support with LCY conversion, Performance optimization via SQL filtering, Calculate Amounts toggle
- Versions: BC 26

Source: Mohana's Dynamics NAV & BC blog, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.