How this portal works
You are signed in as . This page explains everything you can do
with that access.
What you are looking at
This is the shared inventory record for the Dillon Yarn stock held at Wound About. Every business evening
it is rebuilt from scratch out of Dillon's Sage 100 system, so what you see always reflects Dillon's books —
nobody edits the figures by hand.
Two warehouses are covered: WOR is raw yarn and WOF is finished goods. Quantities are pounds.
Two dates, two meanings
| Reporting through | The date of the most recent stock movement Sage has for
these warehouses. It only moves when something is actually posted, so it can sit still for days. |
| Last refreshed | When this page was last rebuilt. It should never be more than a day old — the
banner at the top of the Overview turns red and says so if a nightly run was missed. |
The tabs
| Overview | Headline quantities, the twelve-month trend for both warehouses,
the most recent validations and the largest balances on hand. |
| Monthly Validation | Month by month, Dillon's book quantity against the physical count, with the
variance in pounds and per cent. The chart shows the variance history against the agreed ±1.5% allowance. |
| Enter Physical Count | Where the month-end count is entered. See below. |
| Monthly Inventory | Every item and month: opening balance, movement split by transaction type,
closing balance. |
| Transaction Detail | Every individual Sage posting — one line each, nothing aggregated. |
| Item Master | All tracked products grouped by description, with the current stock of each.
Groups covering several Sage item codes expand to show them. |
Transaction codes
Every movement Sage records carries one of seven codes. They are the columns on
Monthly Inventory and the Type column on Transaction Detail; hovering a column
heading shows the same explanation.
| Code | Description | Purpose / inventory impact |
| IT | Inventory Transfer |
Moves stock between warehouse locations. Total stock on hand is unchanged — only where it sits. |
| PO | Purchase Order Receipt |
Stock received from a supplier against a purchase order. Increases stock on hand. |
| BI | Bill of Materials Issue |
Raw material (yarn) issued from stock to a production order. Decreases raw material. |
| BR | Bill of Materials Receipt |
Finished goods received into stock when a production order completes. Increases finished goods. |
| SO | Sales Order Shipment |
Stock shipped to a customer. Decreases stock on hand and recognises the inventory sold. |
| IR | Inventory Receipt |
Stock added without a purchase order — adjustments, found inventory, other manual receipts. |
| II | Inventory Issue |
Stock removed without a sales order — adjustments, scrap, waste, samples, other manual issues. |
In one line each
- IT — move stock between warehouses.
- PO — receive purchased stock.
- BI — consume raw material in production.
- BR — receive finished goods from production.
- SO — ship or sell stock to a customer.
- IR — manual addition (adjustment or found inventory).
- II — manual removal (adjustment, scrap or waste).
What every column means
Monthly Inventory
| Month | The calendar month the movement was posted in. |
| Wh | Warehouse — WOR raw yarn, WOF finished goods. |
| Item / Description | The Sage item code and its description. |
| Begin | Balance carried in from the previous month. |
| IT … II | Total movement in that month for each transaction code above. |
| Net | All of that month's movement added together. |
| Ending | Begin + Net — the closing book balance, which becomes next month's Begin. |
Transaction Detail
| Date | When Sage posted the movement. |
| Type / Activity | The code and its plain-language name. |
| Ref. Date | The date on the underlying document, which can differ from the posting date. |
| Qty (lbs) | Signed pounds — positive into the warehouse, negative out. |
Item Master
| Description | The product. Rows are grouped by it; a group may cover several Sage item codes. |
| Denier / Filament / Color | Yarn attributes read from the description. |
| Item Code | The Sage code, or how many codes the group holds. |
| Current Stock | The latest book balance — the same figure the count sheet compares against. |
Monthly Validation
| Dillon Book Qty | What Dillon's books say was on hand at that month-end. |
| Partner Physical | What Wound About counted. |
| Variance / Variance % | Counted minus book, in pounds and as a share of the book quantity. |
| Status | Pending not counted yet · Reconciled they agree · Variance they do not. |
Working with the tables
- Sort — click a column heading; click again to reverse it.
- Filter — use the row of boxes under the headings. Text matches anywhere; number columns also accept
> 100, < 0, >= 50;
date columns accept a range such as 2026-06-01..2026-06-30.
- Totals — the bar at the bottom sums each column for the rows currently shown, so it follows
your filters. Percentage columns show an average instead.
- Follow a row — click it to keep it highlighted while you read across; ↑
↓ move the highlight.
- Expand a group — rows with a small triangle hold several item codes; click to see them.
- Export — ⤓ Excel saves exactly what is on screen, filters and sort included.
⤓ Full workbook in the header saves all four sheets unfiltered.
Submitting the month-end physical count
Open Enter Physical Count and type your counted pounds against each product.
- Only products Dillon currently shows stock for are listed — there is nothing to count against the rest.
If you are holding something the list shows as zero, switch to All items and enter it; that difference
is exactly what the reconciliation is for.
- Use the warehouse selector to work through WOR (raw yarn) and WOF (finished goods) separately.
- Products are grouped by description. Where a group covers several Sage item codes, click it to expand and
count each code separately — the group total adds up for you.
- Most products sit at zero. Set remaining to 0 fills every still-empty row with zero so you only type
the ones you actually have.
- The chips at the top (All, To count, Counted, In stock) narrow the list, and the
bar shows how far along you are. Rows stay put while you type.
- Enter or ↓ jumps to the next box.
- The two boxes at the bottom compare your running total with Dillon's book quantity for each warehouse.
- Fill in your name and the validation date, then Submit count.
The 1.5% allowance. A difference inside ±1.5% of the book quantity is treated as normal
waste and shows green. Above that the figure turns red and an explanation is required before the
submission goes through — say what you believe happened (timing, scrap, a pallet found later, and so on).
Your work is saved in this browser as you type, so closing the tab by accident will not lose it. After you
submit, the count appears on the Monthly Validation tab following the next nightly rebuild.
Signing in and your password
- There is no user name — your password is unique and identifies you on its own.
- Every sign-in, successful or not, is recorded.
- Dillon Yarn cannot read your password back; if it is lost a new one is issued.
- The report can only be opened over its https address. A copy saved to disk will not unlock.
Administration admin only
The ⚙ Admin tab is visible to you because you signed in with the administrator
password. It has four sections.
Portal users
Because a password identifies the person, every password must be unique — the
portal refuses a duplicate and tells you who already holds it. Use Generate for a safe one and note it
down before saving: passwords are stored hashed and can never be displayed again.
- Set Active to no to suspend someone without deleting their history; Remove deletes
the account. Both take effect immediately — no rebuild needed.
- Last login and the sign-in count tell you whether an account is actually being used.
- Give the role admin only to Dillon staff — it exposes this whole section.
Sign-in log
Every attempt with its result, plus administrative changes such as creating a user or saving mail settings.
Filter and export it like any other table.
Submitted counts
- Statement opens a fixed record of one submission — month, who submitted it, when it was received,
the totals with variances, and every counted item. Print it to PDF to archive it; it is the document of
record.
- E-mail sends the same statement to the recipients configured below.
E-mail delivery
Enter the sending address, a display name, the recipient list and the SMTP2GO API key. The key is stored on
the server and never shown again — leaving that box untouched keeps the saved one.
Where things are kept
| Physical counts | counts.json on the automation host, one entry
per reporting month with the per-item detail. Also visible here and included in every backup. |
| Users | users.json — names, roles and hashed passwords. |
| Sign-in log | login_log.json — the most recent 800 events. |
| Mail settings | settings.json. |
| The report itself | Rebuilt nightly and republished; nothing to preserve, it always comes back
from Sage. |
Operational detail — how the nightly job runs, how to redeploy it and how to restore any of the above — is
in the Deployment Handbook held by Dillon Yarn IT.
If something looks wrong
| The banner says the report may be out of date | A nightly rebuild was missed.
The figures shown are still valid for the date given, but tell Dillon Yarn IT. |
| “This page did not load completely” | Reload with Ctrl+Shift+R. |
| Your password stops working | The account may have been deactivated or the password reissued —
contact Dillon Yarn. |
| A figure looks wrong | Check the item on Transaction Detail to see the postings behind it,
then raise it with Dillon Yarn — the portal only reports what Sage holds. |