Overall PO Health
PO value and POs over time
PO value POs
PO value this month
PO target for this month
Deeper Dive
Total POs by channel
PO value by channel
Last 4 months in the selected period
Channel summary
Click a channel to see its POs
Needs action
SLA crossed, expiring POs, appointments due, invoiced but not shipped
Pending PO ageing
Open + invoiced POs, days since PO date
Product-wise quantity
Product list
SKU codes used in the PO form. Add a name so reports read clearly.
Channel list
Portals that send you POs
Backup
All data lives in your Google Sheet "PO Desk Data" (tabs: PO Data, Team, Products, Channels, Settings, Waybills) and is shared by every team. To go back to an earlier state use File > Version history in that Sheet. You can also keep an Excel copy here.
Team and access
Who can do what. PO team: create POs, edit PO details and products. Accounts: invoice number, date and copy. Warehouse: appointment, dispatch, tracking, boxes. GRN team: delivery and GRN. Everyone can see all POs. People sign in with their company Google account, so the email here must match it exactly. Admins listed in the server script are always admin.
Email workflow
When something happens on a PO, the tick-marked teams get an email automatically.
SLA and alerts
Days allowed from dispatch to delivery. A PO's own SLA (set in the PO form) overrides these. If a PO has a later appointment date, delivery is due on the appointment date instead.
The check runs when this file is open and every 10 minutes after that.
Google Sheet sync
Every PO you create, edit, mark delivered or delete is copied to your Google Sheet automatically.
Monthly PO target
PO value you aim to receive each month. Shown as a progress bar on the dashboard.
Display
Theme