The SII Doc. Upload State table is the master ledger of every SII submission tracked by Microsoft's standard SII module. The Spain localization extends it with three retail-specific fields so that you can identify and filter documents that came from the POS rather than from back-office invoicing.
In this article
Filter retail documents on the page
The three retail fields
| Field | Meaning |
|---|---|
| Store No. | The store from which the originating POS transaction was posted. Populated only for retail documents. |
| POS Terminal No. | The POS terminal from which the originating POS transaction was posted. Populated only for retail documents. |
| Is Retail Transaction | A boolean flag set to Yes when the document originates from an LSC Transaction (POS sale or credit memo), and No for back-office invoices. |
Filter retail documents on the page
From the SII Doc. Upload State page you can filter on these fields to isolate retail documents:
- Click the
icon, enter SII Doc. Upload States and select the relevant link. - Open the filter pane.
- Filter Is Retail Transaction = Yes to show only POS-originated documents.
- To narrow further to a specific outlet, add Store No. = S0001 (or the relevant store code).
- To investigate a specific till, add POS Terminal No. = T01 (or the relevant terminal code).
Tip: Combine these filters with the standard Status = Failed filter when triaging post-go-live SII issues - it produces a per-store, per-terminal failure list ordered by Posting Date.