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
Already expired but still pending
Product list
SKU codes used in the PO form. Add a name so reports read clearly. If Uniware uses a different code for a SKU (for example Nykaa codes), put the Uniware code in the third column so the stock check and the Uniware download use it.
Channel list
Portals that send you POs
Backup
Backend: every PO, team member, product and setting is saved in one backend (the PO Desk Google Sheet). Nothing is kept in this browser, so every person always sees the same data. A save or delete shows "saved to backend" only after the backend has it.
Backups: 1) Automatic copy of the full backend every night in the Drive folder "PO Desk backups". Backups are never deleted. 2) Every change is in the backend's version history, so any earlier state can be restored. 3) Invoice, PO copy and POD files stay in the Drive folder "PO Desk invoices" and are kept even when a PO is deleted. 4) You can download an Excel copy any time from the Export tab.
Add missing POs: sends every PO that this browser still has from the old version (or that is in a backup .json file) but is not in the backend yet. POs already in the backend are skipped. Open this page on each computer where POs were entered and click once.
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