11 User Guide

Inventory

Inventory keeps the project's warehouse: how much of each material there is, what it is worth, where it came from and where it went.

1. What it is for

Inventory keeps the project's warehouse: how much of each material there is, what it is worth, where it came from and where it went. Cement arrives at the warehouse, rebar goes out to site, a year-end count turns up a difference — each of them is one row here.

The page answers three questions: how much material is in the warehouse, what that material is worth and which material is about to run out. The third one is usually the most pressing: materials with a warning threshold are marked in the list and counted in the summary strip when they fall below it — that figure tells you your next order.

Material purchases reach Accounts: when a purchase is saved it is posted to the supplier's ledger as a payable. Site issues, count adjustments and project transfers are not financial transactions; they do not reach the ledger.

2. How to open it, who can see it

In the sidebar, Logistics & Materials › Inventory.

Your permissionWhat you can do
ViewYou see the list, the summary strip, the chart, the breakdowns and the transaction ledger. You can download Excel and PDF exports and open the delivery tickets and invoices attached to entries. New material, Import, add transaction, transfer and delete buttons are not drawn at all
EditThe same, plus you can define materials, enter and correct transactions, make transfers and delete
No permissionThe module appears dimmed and locked in the menu
NoteDownloading an export and viewing a document do not require edit permission. Neither changes any data; whoever can see the stock should be able to see its delivery ticket too.
NoteSome buttons may be missing for a few seconds while the page opens: the application reads your permissions first and draws the writing buttons afterwards.

3. Anatomy of the screen

Inventory
NoteThe screenshots in this chapter contain no real company data; the project, firm and material names and the figures are examples.

The page has two views and both share the same shell and the same filter. The switch at the right-hand end of the filter bar changes the view:

ViewWhat it shows
Stock LevelsThe current state of the materials — a list grouped by category, with a summary and a breakdown above it
Transaction LedgerThe transactions themselves — a ledger grouped by day

Stock Levels is four layers and follows the same order as Concrete Tracking and Equipment Tracking: first you narrow, then you read the result as figures, then you look at its breakdown, and finally you go down to the rows.

LayerWhat it does
Filter barSearch, category and stock status
Stock summaryTwo headline figures, a chart of the last twelve months, four small measures
BreakdownCategory distribution and supplier distribution
Material listA table grouped by category

In Transaction Ledger the two middle layers are not drawn. A ledger is a ledger: the filter bar and the table. The totals are not lost — the day's total is in the table's group header, and the grand total is in the caption line of the Excel and PDF exports.

All the lower layers are drawn from the rows that pass the filter above. When you make a selection they all change at once and no request goes to the server — the project data came down once.

Title and actions. The title reads Inventory with the description "Material stock levels, transaction ledger and cost analysis." On the right there are five buttons: Refresh, Download PDF, Download Excel and (if you have permission) Import and New material.

Filter bar

Filter bar

There are two rows, and the second one changes with the view.

The top row is the same in both views: the search box, the filters under the Filter by label, and the View switch at the right-hand end.

ControlWhat it does
Search materials / Search transactionsThe name of the box and what it searches change with the view
CategoryNarrows by category; each category shows how many records it holds
Store (if stores are enabled in the project)Narrows by store, Main store included. In Stock Levels the quantity and value become the balance of the chosen stores; in the ledger the transactions written to those stores remain
Supplier (ledger only)Narrows by firm
Transaction type (ledger only)Picks from the six types
ViewStock Levels ↔ Transaction Ledger

In Stock Levels the second row is a four-way switch: All, Low stock, Out of stock, Discrepancy. Each one shows how many materials it holds in brackets.

In Transaction Ledger the second row is the period selection: three ready-made ranges under the Period label (Current month · Last month · Current year) and two date boxes (Start · End). The selected ready-made range is highlighted; pressing it a second time removes it.

While a filter is active a clearing button appears at the end of the bar. If you have only typed in the search box it reads Clear search; if you have also picked a filter, a date or a status it reads Clear filters with the number of active criteria beside it.

NoteThe clearing button only resets the filters of the view you are in. A period you picked in the ledger stays in place even if you clear while in Stock Levels; you will find it when you go back. Search and category are shared and are cleared in both.

Stock summary

Stock summary

Drawn only in the Stock Levels view.

On the left of the card two headline figures sit one above the other:

MeasureWhat it shows
Total Stock ValueWhat the material in the warehouse is worth — each material's stock multiplied by its own unit cost (under the selected costing method, see 5.11) and added up. Excl. tax
Total PurchasesWhat has been paid for these materials to date. Excl. tax

The line below the first normally reads "At weighted average cost, excl. tax"; if there is a material with no priced entry it gives way to the warning "N materials have no priced entry — not included in the value". That line matters: the value does not count material whose cost is unknown, and only that line tells you how many were left out.

The line below the second reads "Paid for these materials to date (excl. tax)" when there are purchases and "No purchase records" when there are none.

On the right is a bar chart of the last twelve months. The Chart measure switch at the top right offers three options:

MeasureWhat it draws
Purchases (currency)The excl.-tax amount of the purchases made that month
Issues (currency)The value of the material issued to site that month
TransactionsThe number of transactions that month
NoteThe issues column shows value, not quantity: every issue is multiplied by its material's average cost. The reason is in section 7: on one project cement is tracked in tonnes, brick in pieces and cable in metres, and those three figures cannot be added up. Money can.
NoteThe twelve months of the chart are counted back not from today but from the month of the most recent transaction in the data. On a project that has stopped, the chart does not fill with empty months. A month with no transactions is not skipped; it stands as an empty column.

Four small measures are lined up below the card:

MeasureWhat it shows
MaterialThe number of materials passing the filter; below it, how many categories they spread across
Low StockThe number of materials that have fallen below their threshold. Drawn even when it is zero
Out of StockThe number of materials whose stock is zero or negative
Ledger DiscrepancyThe number of materials whose recorded stock does not match the total of their transactions

The last measure does not exist in the old program and is explained separately in section 7.

Breakdown

Breakdown cards

Drawn only in the Stock Levels view. Two cards sit side by side and ask two different questions.

Category distribution shows each category's share of the stock value: every row carries the number of materials, the amount and a percentage bar. A category with no amount shows "No priced entry — not included in the share" instead of a bar — a "0%" next to a row that reads "3 materials" would read as if the category were worthless.

Supplier distribution puts the firm with the most purchases at the top; every row carries the firm name, the number of purchases and the amount. For firms whose entries have no amount entered, a dash stands in place of the figure.

NoteThe supplier card counts the purchases of the materials on screen. When you pick a category or type a search, the card narrows with it.

Material list

Material list

The table of the Stock Levels view. The rows are grouped by category; the group header carries the category name, a low-stock badge, the number of materials and that category's total stock value. Materials with no category are collected in the Uncategorised group, at the end.

There are eight columns: Material · Current stock · Reorder point · Status · Avg. cost · Stock value · Last transaction and the action column at the end of the row.

The material name is a button; clicking it opens that material's transaction panel. If the material has a material code or a description, they sit below the name in muted type (CEM-01 · Bagged, 50 kg).

The Status column carries one of four badges: Out of stock (red), Low stock (amber), Discrepancy (blue), Normal (green). The current-stock figure is coloured by the same three states.

Group headers can be collapsed; the Collapse all button in the header folds them all at once. You can sort by clicking the column headers — sorting works within the group, the order of the categories does not change.

NoteMaterials with no threshold fall to the end when sorted by the min. stock column; zero here means "no threshold", not "the lowest threshold".

Transaction ledger

Transaction ledger

The table of the Transaction Ledger view. The rows are grouped by day; the group header carries the name of the day, how many inbound and how many outbound movements there were, and that day's purchase total. Entries with no date stand in their own group, at the end.

There are eight columns: Material · Transaction · Quantity · Unit price · Amount · Supplier / location · Description and the action column.

The quantity is signed: inbound movements are written in green with a plus, outbound ones in red with a minus.

The Amount column is filled only for purchase transactions; the tax rate and the tax-inclusive total sit on a second line below it. Other transactions show a dash. An entry that is a purchase but whose amount has not been entered reads "No amount entered" — these are two different things.

The Supplier / location column carries two roles in one column: for an inbound movement the supplier name with the delivery ticket number below it, for an outbound one the place of use with the person who received it below it.

Below the material name, the material code is shown with the category if there is one. If stores are enabled, the transaction's store is shown under the type in the Transaction column (Main store for older entries without a store).

At the end of the row there is a paperclip button if a document is attached to the entry, and a pencil (Correct transaction) and a bin button if you have permission. The pencil appears only on the three types entered by hand (Manual Entry, Site Issue, Count Adjustment); on a received delivery or a project transfer its place is left empty (5.9).

Transaction panel

Transaction panel

This is the window that opens when you click the material name or the panel button at the end of the row. The material's key figures sit at the top: Current stock, Reorder point, Avg. cost and Stock value. If a threshold is defined, a fill bar and a line such as "Above the threshold · 2,400 m in, 320 m out in total" sit below them.

Below the window title, the material's code, barcode, category and description are shown (those that are filled in).

If stores are enabled, a By store box sits right below the key figures: the main store and each store are listed with their quantity, and a store that has gone negative is shown in red. The Store transfer button on the right of the box opens the window in 5.10.

Below that (if you have permission) there are four buttons: Add transaction, Edit, Transfer and, set apart at the right, Delete material.

At the very bottom, all transactions of that material are listed newest first. Each row carries the transaction type, its date, its context (store, supplier, delivery ticket, place of use, person who received it, counterpart project, description) and, on the right, the signed quantity and the amount. Below the transactions the material's Store transfers are listed: direction (Main store → Container), date, the person who made it, description and quantity; if you have permission each row has a bin button.

NoteThis list ignores the page filter. The panel answers the question "why is this material's stock what it is", and the answer to that is all of its transactions; a filtered ledger would not explain the stock figure above it.

4. Fields

Material definition

FieldWhat it meansRequired
Material nameThe list, search and project transfers all match on this nameYes
Material codeYour company's stock code (SKU), e.g. CEM-425. Shown below the name in the list and found by search. Two materials in a project cannot share a code; upper and lower case count as the sameNo
BarcodeThe product's barcode number; typed in by hand and found by search. Like the code, it is unique within the projectNo
UnitThe measure for quantities and the unit price: tonne, piece, m², m…No
CategoryThe list is grouped by this; materials left empty are collected in the Uncategorised groupNo
Reorder pointOnce the stock falls to this value, the material is shown as low stockNo
DescriptionExtra information about what the material is; appears below the name in the listNo
CautionA threshold of zero does not mean "warn me when it reaches zero", it means "no threshold". Leaving the box empty and typing 0 give the same result: that material is never shown as low stock.

The stock quantity is not on this form and that is deliberate. The quantity changes only through transactions; a box here would create a quantity with no counterpart in the ledger and the page would mark it as a discrepancy.

Three more values are calculated on screen rather than entered:

ValueHow it is calculated
Current stockThe material's recorded quantity. Every transaction raises or lowers it
Avg. costA weighted average: the excl.-tax amounts of the priced entries added up and divided by their quantities. If there is no priced entry at all, a dash is shown
Stock valueCurrent stock × average cost. If the cost is unknown it reads "No price"
Note"No price" and "0.00 ₺" are not the same thing: the first means no price has been entered, the second that the stock has run out.

Stock transaction

There are six transaction types; three are entered by hand on this page, three are the result of other flows.

TypeWhere it comes fromEffect on stock
Manual EntryThis pageRaises it
Site IssueThis pageLowers it
Count AdjustmentThis pageRaises or lowers it according to the sign
Delivery receivedThe Deliveries moduleRaises it
Transfer InA transfer made from another projectRaises it
Transfer OutThe Transfer action on this pageLowers it

Each transaction's fields change with its type:

FieldIn which typeWhat it means
MaterialAllThe material the transaction will change. Required
DateAllThe ledger and the reports are grouped by this. Required
QuantityEntry, issueMust be greater than zero. Required
Adjustment quantityCount adjustmentSigned: positive for an increase, negative for a decrease. Cannot be zero
Unit priceEntryExcl. tax, per the material's own unit
Tax rateEntryA box that takes decimals (e.g. 8.875); the Suggestions buttons below it fill in the usual rates of the company's country (0%, 1%, 10%, 20% in Türkiye)
Supplier (registered)EntryThe firms in the Suppliers module
Supplier nameEntryTyped here if the firm is not in the list; the account is opened under this name
Delivery ticket no.EntryAppears below the supplier name in the ledger
DocumentEntryA delivery ticket, an invoice or a photo. One document
Place of useIssueWhere the material went — Building B, 3rd floor
Received byIssueThe person who took delivery of the material
DescriptionAllFree text
StoreAll (if stores are enabled)The store the transaction is written to. If none is chosen, the main store; inactive stores are not listed. The quantity in the chosen store is shown above the box

5. Step by step

5.1 Defining a material

New material
  1. Press the New material button in the header.
  2. Type the material name; the other four fields are optional.
  3. Save.

Below the title of the window there is a sentence reading "A new material starts with zero stock…" which tells you the next step: enter the quantity you already have in the warehouse as a Count Adjustment transaction after saving. The opening quantity is then written to the transaction ledger too and the stock stays consistent with it.

To edit an existing material, use the Edit button in the transaction panel. In edit mode the description becomes "The stock quantity cannot be changed here; it only changes through transactions."

5.2 Recording a warehouse receipt

New transaction
  1. Press the New transaction button in the Transaction Ledger view, or the + button on a row of the material list. The second one opens with the material selected.
  2. The transaction type comes up as Manual Entry.
  3. Check the Material and the Date; the date opens with today.
  4. Type the Quantity. The material's current stock appears below the box.
  5. In the Purchase details section enter the unit price (excl. tax), the Tax rate, the supplier and, if there is one, the delivery ticket no.
  6. Add the image of the delivery ticket or invoice to the Document field.
  7. Look at the Calculated amount box — what you entered comes to that.
  8. Save.
NoteThe unit price box carries the material's unit in its label: Unit price (currency/t) — the screenshot shows a Turkish company, so it reads ₺/t and VAT rate. Entering the quantity in kilograms and typing the tonne price inflates the amount a thousandfold, and that mistake is caught only in the Calculated amount box. One look at it before you press Save is enough.
NoteIf you are entering several items from the same delivery ticket, use the Save and new button: the window stays open, the material and the date are kept, and the quantity and price are cleared.

The supplier is two boxes. If the firm is registered in the Suppliers module, pick it from the upper list; the selection fills the name box below it as well. If it is not registered, type into the lower box only — the account is opened under that name.

CautionIf the unit price is left empty the entry is saved without an amount: the stock rises but it does not enter the average cost, it is not counted in the totals and it is not written to Accounts. When the price becomes known later, correct the transaction (5.9) and enter the price.

5.3 Recording a site issue

  1. Open the transaction window and set the type to Site Issue.
  2. Enter the Material, the Date and the Quantity; the quantity is written positive, the direction comes from the type.
  3. Fill in the Place of use and Received by.
  4. Save.

An issue is not a financial transaction; the unit price, tax, supplier and document fields are not shown for this type and nothing is written to Accounts.

NoteIf you write an issue larger than the current stock, an amber warning appears in the window saying the stock will go negative. The entry is not blocked — negative stock is deliberately allowed, because while you are correcting a wrongly entered transaction the stock may temporarily go negative. The warning also suggests entering a count adjustment first.

5.4 Entering a count adjustment

Count adjustment

This type does two jobs: entering the opening stock and posting the difference found during a count.

  1. In the transaction window set the type to Count Adjustment.
  2. Type a signed number into the Adjustment quantity box: 2.5 for an increase, -2.5 for a decrease.
  3. Write the reason in the description — Year-end stock count, for example.
  4. Save.
CautionThe difference cannot be zero. An adjustment of zero changes nothing and leaves only a noise row in the ledger.

The same type is used to enter material already sitting in the warehouse: you write the quantity you have as a positive adjustment. The opening quantity then reaches both the stock and the ledger.

5.5 Transferring a material to another project

Transfer
  1. Open the material's transaction panel.
  2. Press the Transfer button.
  3. Pick the Destination project. Only the other projects you have access to are listed.
  4. The Transfer quantity comes up filled with the current stock; reduce it if you need to.
  5. Enter the Transfer date and, if you want, a description.
  6. Transfer.

The rule standing in the window says this: if a material with the same name exists in the destination project the quantity is added to it; otherwise a new material is created with the same unit, category and threshold. The material code and barcode are carried over to the new material too; if another material in the destination project already uses the code or the barcode, that field is left empty and the transfer still goes ahead.

If stores are enabled, the window has two more boxes: From store (the store in this project the material leaves; the quantity in it is shown above) and Store in the destination project. If neither is chosen, both are the main store. If the source store would go negative, an amber warning appears; the entry is not blocked.

One transaction is written in each project — Transfer Out in the source, Transfer In in the destination — and the two are linked: deleting one removes the other.

NoteFor a material whose stock is zero or negative the Transfer button is disabled; hovering over it tells you why.
NoteIf you leave the description empty, a readable line such as "Site A → Site B transfer" is written to both ledgers.

5.6 Deleting transactions and materials

Delete confirmation

To delete a transaction, use the bin button in the ledger or in the panel. The confirmation screen says which entry will be deleted (material, type, quantity) and tells you that the stock will be reversed by that quantity. If the entry is a project transfer it also reminds you that the entry in the counterpart project will be deleted, and if a document is attached, that the document will go too.

CautionThe delivery ticket or invoice attached to the entry is deleted as well. If you want to keep it, open it and save it to your computer first.

Received deliveries cannot be deleted here. On those rows the bin button is not drawn at all; a lock icon stands in its place and hovering over it reads "A received delivery cannot be deleted here; open the shipment on the Deliveries page and delete it from the delivery history." The reason is in section 7.

To delete a material, use the Delete material button in the transaction panel. If the material has transactions, an amber warning appears in the confirmation screen telling you how many will be deleted.

CautionDeleting a material also deletes all of its transactions and, if there are any, the linked purchase entries in Accounts. If you want to keep the history, take the Excel export first.

5.7 Defining materials in bulk from Excel

Import preview

Instead of entering a long material list one by one you can import it from Excel. The process has four steps and no record is created until you confirm.

  1. Press the Import button and choose Download template. The template has two sheets: Materials and Instructions.
  2. Delete the sample rows and enter your own data. The columns are: Material Name · Unit · Category · Reorder Point · Description, plus Material code · Barcode in projects where material codes are enabled. Only the name is required; older templates without the code and barcode columns are still read.
  3. In the same window choose Choose file. The file is read and compared with the project's existing materials.
  4. Read the preview. Five counters sit at the top — To import · Conflicts (will be skipped) · Repeated in the file · Invalid rows · New categories — with a row-by-row result below them. Rows that will not be imported are marked with an amber background and the reason.
  5. Confirm with the Import N rows button. A progress bar fills; a summary appears when it finishes.
Row statusWhat happens
Name emptySkipped
Reorder point could not be read ("ten", for example)Skipped — enter a number or leave it empty
Reorder point negativeSkipped
A material with this name already existsSkipped; the existing record is not changed
The same name appears a second time in the fileThe second row is skipped
The material code or barcode is already used by another material in the project or earlier in the fileSkipped
CautionThe stock quantity is not in this file and cannot be. Every imported material is created with zero stock; you enter the quantities you already have in the warehouse afterwards as Count Adjustment transactions. The Instructions sheet of the template says the same.
NoteThe conflict scan respects Turkish letters: a material written İSKELE counts as the same record as iskele in the file and is not created a second time.

5.8 Searching and narrowing

The search box looks in different places depending on the view:

ViewWhere it searches
Stock LevelsMaterial name, material code, barcode, category, description and unit
Transaction LedgerMaterial, material code, category, supplier, description, delivery ticket no., place of use, person who received it and the name of the transaction type

The search ignores Turkish letters: typing cimento finds Çimento.

There are two ways of picking a period in the ledger. The Current month, Last month and Current year buttons are one click; a range such as 15 March – 2 April is entered in the two date boxes. If you fill in only one of them there is no limit in the other direction.

NoteThe moment you pick a date range, transactions with no date drop out of the list. They are not lost; they come back in their own group when you clear the filter.

The two most-used narrowings are these: Low stock while preparing an order, Discrepancy before a count. Both are one click, and the list, the summary, the chart and the breakdowns narrow at the same time.

5.9 Correcting a transaction

You do not need to delete a wrongly entered transaction and enter it again:

  1. Press the pencil button on the transaction's row in the ledger or in the material's transaction panel. The Correct transaction window opens with the saved values.
  2. Change what is wrong: the material, date, quantity, unit price, tax rate, supplier, delivery ticket, place of use, person who received it, description, document or cost code.
  3. Update.

When you save, the stock, the average cost and the stock value are recalculated; for a purchase the linked line in Accounts is updated to the new amount at the same time (no administrator rights needed). If you changed the material, the quantity comes off the old material and goes onto the new one.

The transaction type cannot be changed. An entry made as a site issue cannot be turned into a receipt; delete a transaction entered with the wrong type and enter it again with the right one. The correction button exists only on the three types entered by hand: correct a received delivery on the Deliveries page, from the shipment's delivery history (the lock icon says so when you point at it); delete a project transfer and make it again.

If the correction would take the stock below zero, the window shows a "Stock will go negative" warning with the quantity after the correction. The entry is not blocked (the rule in 5.3).

Change history sits at the bottom of the window: who changed which field, when, and from what to what (Quantity: 10 bags → 8 bags). The original entry is not listed there; only later changes are recorded. The history is kept by the server, so changes made from older versions of the app or from Deliveries are recorded too. When a transaction is deleted, its history goes with it.

If stores are enabled, the transaction's store is also corrected in this window; the history shows it as "Store: Main store → Container".

5.10 Setting up stores and transferring between them

Material on a project can sit in more than one place: the main store, a container at the block, an open laydown area. This feature is switched on by a server update; until then the Stores button and the store boxes do not appear at all.

Setting up a store

  1. Press the Stores button in the header. The Main store (Default) sits at the top of the window, with the project's stores listed below it.
  2. Choose New store, enter the Store name and, if you want, a description, then Save.

A store name is unique within the project; letter case does not count and the name Main store is reserved. You can close a store with Make inactive: an inactive store cannot be chosen for new transactions or as a transfer destination, but its material can still be moved to another store. Make active opens it again. A store with transactions or transfers cannot be deleted; if you try, the window says so and suggests making it inactive. Anyone with Stock edit permission can set up stores; others can see the list.

What the main store is. Transactions entered without a store, and every entry made before stores were set up, are counted in the main store. You do not need to do anything about older entries.

Transferring between stores

  1. Open the material's transaction panel and press Store transfer in the By store box.
  2. Choose the From store and the To store; the quantity in each is shown above it.
  3. Enter the Quantity, the Date and, if you want, a description, then Transfer.

If the source store would go negative, a "The store will go negative" warning shows the quantity after the transfer; the entry is not blocked. A store transfer cannot be edited; if it is wrong, delete it from the list in the panel and make it again.

NoteA store transfer does not change the stock total, the average cost, the stock value, the supplier account, Financials or the cost report. The material moves within the same project and no money changes hands. That is why the transfer is not written to the transaction ledger; it is kept in the Store transfers list in the material's panel.

5.11 Costing method and stock count

Costing method. Stock value and unit cost are calculated in one of three ways. The choice is a company setting: on the Settings › Stock costing method card only an admin can change it; other users see the selected method. This feature comes with a server update; if it is not on, the card does not appear and stock is valued with today's rule.

MethodHow it calculates
Weighted average (all receipts)The default. The amount of all priced receipts is divided by their quantity; stock is valued at that average
Moving weighted averageThe average is rebuilt with the stock on hand at each priced receipt; an issue goes out at the current average
FIFO (first in, first out)Issues are taken from the oldest receipt; the stock left on hand is valued at the prices of the newest receipts

The method changes the stock value, the unit cost, the category and supplier breakdowns, the Excel and PDF exports and the monthly issue value in the chart. The line under the value on the summary card names the selected method (for example "At FIFO cost (first in, first out), excl. tax").

NoteFinancials, the cost report and supplier accounts do not change. They read stock purchases; the method only chooses how the material in the warehouse is valued.
NoteNo cost is stored. When the method changes, all past transactions are read again with the new method; no old figure stays "frozen".

Example: 100 bags were bought at 180 and 100 bags at 200, and 150 bags were issued to site. With the average the 50 bags left are worth 190 each, 9,500; with FIFO they are valued at the newest receipt's 200, 10,000. The amount paid is 38,000 with either method.

Stock count. When you count what is in the store, you can post the difference without writing adjustments one by one:

  1. Press Stock count in the header (shown to anyone who can edit Inventory).
  2. If stores are on, choose the Store you counted; the system quantity is that store's.
  3. Check the Date. Type in the box to find a material; on the phone you can scan a material's barcode with the camera.
  4. Type what you found in each material's Counted box. The row shows In system, Difference and the difference's value at unit cost. Materials you leave blank are not touched.
  5. Press Save count. A Count Adjustment transaction is written automatically for each material with a difference; its description reads "Count: counted 45 bags, in system 50 bags".

A count difference changes the stock quantity and the stock value and does not go to Financials, the cost report or supplier accounts. A shortage is removed at the current unit cost with an average, or from the oldest receipt with FIFO; a surplus is added at the current average, or at the last priced receipt's price with FIFO. In the example above, finding 45 bags at the count lowers the value by 950 with the average and by 1,000 with FIFO for the 5-bag shortage.

Tip If saving stops halfway, the differences already written show in the list and the window stays open. Saving the same count again writes only the remaining differences.

6. Exports

There are two exports and both put the list you see on screen outside — whichever view you are in is what gets printed, and whatever the filter is, that is what reaches the file. There is no separate export window; you have already made your decision in the filter bar.

The file name changes with the view: it starts with Stock_Levels_ in the stock view and Stock_Transaction_Ledger_ in the ledger, with a date-and-time stamp on the end. If you close the save window nothing happens; when it is saved, a band at the top of the page gives the file's full path.

NoteWhile the list is empty both buttons are disabled. The export of an empty list is an empty file.

Download Excel

The workbook has a single sheet, and the sheet is named after the view.

The Stock Levels sheet carries eleven columns: Material · Category · Unit · Current Stock · Reorder Point · Status · Avg. Cost (currency) · Stock Value (currency) · Total Purchases (currency) · Last Transaction · Description. If any material in the list has a code, a Material code column is added right after Material; if no material has a code, the column is not added.

The Transaction Ledger sheet carries fourteen columns: Date · Material · Category · Transaction · Quantity · Unit · Unit Price (currency) · Net Amount (currency) · Tax % · Tax Incl. (currency) · Supplier / Place of Use · Delivery Ticket · Description · Document. If there are transactions for a material with a code, a Material code column comes after Material here too. If stores are enabled, a Store column is added on the far right. While the store filter is on, the caption's filter line says "Store: …".

A three-line caption sits at the top: the project name; the report date and the totals; and a one-line summary of the filter applied. That last line matters — it is written so that a file taken with one category selected is not mistaken for the whole project when it is sent by e-mail. If there are low-stock materials, materials with no price or purchases with no amount, their counts are noted in the caption too.

Three useful details: the header row comes frozen, so the column names stay on screen as you scroll down; the filter is on, so you can ask your own question; and the dates and all the figures are real cell values — they can be sorted, added up and pivoted. In the ledger the quantity carries a signed raw number (-20), with its unit in the column beside it.

The quantity column in the ledger is coloured: inbound movements are written in green, outbound ones in orange, so the file can be scanned by eye.

Download PDF

An A4 landscape list with eight columns. Some of the columns from the screen and the Excel export are left out.

Stock Levels: Material · Category · Unit · Current · Min. · Status · Avg. (currency) · Value (currency).

Transaction Ledger: Date · Material · Transaction · Quantity · Unit (currency) · Net (currency) · Tax Incl. (currency) · Supplier / Location.

As in Excel, if there is a material with a code, both lists get a Code column next to Material. If stores are enabled, the ledger list shows each transaction's store under its type.

The first page carries the project name, the name of the view, the time it was produced and the filter summary. From the second page on, a thin band is repeated at the top, the column headers are rewritten on every page and a page number sits at the bottom.

The last row is the GRAND TOTAL row. In the stock view only the stock value is added up; in the ledger the net amount and the tax-inclusive total. The quantity column is not added up and a dash stands in its place: a project may hold tonnes and pieces side by side, and adding two units in one cell would be adding apples and oranges. The average cost column is not added up either — an average appearing in a total row would read as a total.

NoteFor a list of more than a thousand rows you are asked to confirm before the PDF is prepared: the window may stop responding for a while during preparation and the process cannot be stopped. The confirmation screen suggests narrowing the filter. The Excel export is fast even at this size.

7. Things worth knowing

Quantities are separated by unit, money is not. On one project cement is tracked in tonnes, brick in pieces and cable in metres; adding those three figures up and saying "1,240 units of stock" would produce a number that stands for nothing. That is why the page's headline measure is the stock value (currency), the chart's measures are money or counts, and the quantity column is empty in the total row of both exports.

The average cost is a weighted average. The excl.-tax amounts of the priced entries are added up and divided by their quantities. Three batches of cement bought at different prices come down to one cost, and the stock value is calculated with it. Entries with no price do not enter the denominator either — they are not counted as free, they are not counted at all.

A material whose price has never been entered does not enter the value. Such a material reads "No price" in the list and does not enter the total stock value; how many materials were left out is written on the line below the summary strip. Writing zero would show a material sitting in a full warehouse as worthless.

What a ledger discrepancy is. Every material has two figures: its recorded stock quantity and the total of its transactions. Normally these match. If they do not, an unrecorded change has happened — a manual correction from the administration screen, or a deletion that stopped halfway. A material with a discrepancy is marked with a blue Discrepancy badge in the list, counted in the summary strip, carries its own segment in the filter and is explained by an amber warning in the transaction panel: what the recorded stock is, what the ledger says, and what size Count Adjustment would close the difference. In the old program this comparison is never made and the gap grows silently.

Purchases are written to Accounts, the others are not. When a manual entry is saved, a transaction is created in the supplier's ledger as a payable: the net amount, the tax and the tax-inclusive total are written separately. Site issues, count adjustments and project transfers do not reach the ledger — the material is already yours, no money has moved.

If the transfer fails an amber band appears at the top of the page and the transaction still counts as saved — the stock has changed, do not enter it a second time. The Resend to Accounts button in the band retries every purchase in the project. Two reasons are written separately:

ReasonWhat to do
The supplier has no account and only administrators can open oneHave an administrator create the firm once in Accounts; later records are sent automatically
The server could not be reachedChoose Resend to Accounts when the connection is back

When a purchase is deleted or changed, the server deletes or updates its linked transaction in Accounts at the same time; this does not need administrator permission.

A purchase with no date is not transferred to the ledger; an account transaction needs a date. It does not happen with entries made on this page, only with undated entries from the old program. Correct that purchase (5.9) and enter its date; once saved it is transferred to the ledger.

Received deliveries cannot be deleted or corrected here. Transactions of this type belong to the Deliveries page: reversing a delivery also changes the shipment's delivered quantity and the order's status. Running half of that chain from this page would split the rules of two modules in two. The lock icon standing in place of the delete button tells you where the entry can be deleted.

Project transfers are double entries. When you delete one, the entry in the counterpart project goes too and that project's stock is corrected. So before you delete a transfer, know that the other side will be affected as well.

Store values use the project average. When you pick a store in the filter, the stock value is the quantity in that store × the material's average cost across the project; stores do not have separate costs. The reorder point also looks at the project total, so the Critical and Discrepancy marks are not shown while the store filter is on. The monthly chart and the breakdown cards do not narrow by store.

Negative stock is not blocked. You can write an issue larger than the current stock; the application warns you but takes the entry. This is deliberate: while you are correcting a wrongly entered transaction the stock may temporarily go negative, and blocking the entry would cut off the correction.

Deleting a material deletes its transactions too. This is behaviour the old program does not have: there only the material definition is deleted, the transactions are left orphaned on the server, appear on no screen but keep counting towards the Financials's cost total. Here the transactions go first and the definition second.

Caution — known defect After saving a transaction, pressing the New transaction button a second time opens the form filled with the fields of the previous entry: the quantity, unit price, supplier and description are still there. The same applies to New material. If you press Save without noticing, the same record is written twice and the stock rises twice. Workaround: look the fields over before starting the second entry, especially the quantity and the delivery ticket number. (The Save and new button is not affected by this; it keeps the fields deliberately and by a rule.) The defect is known and will be fixed.
Caution — known defect In the transaction ledger the second line of the Amount column — the muted line carrying the tax rate and the tax-inclusive total — does not fit the column and covers the start of the second line of the Supplier / location column to its right: instead of "Delivery Ticket 2026-00098" you see "…ivery Note 2026-00098". Both figures are correct; only the first few characters of the neighbouring column are covered. You can read the full delivery ticket number in the Excel export or in the material's transaction panel. The defect is known and will be fixed.
Caution — known defect If a project has materials defined but no transactions at all, switching to the Transaction Ledger shows "No transactions match the filter — The project has 0 transactions, but your filter includes none of them" and draws a Clear filters button. But there is no filter; the ledger really is empty. What you need to do is not clear the filter but enter the first transaction. The defect is known and will be fixed.

The status counters do not see the search box. The bracketed figures on the All / Low stock / Out of stock / Discrepancy switch in the filter bar are calculated against the selected category, not against the text you typed into the search box. The list narrows correctly; only the bracketed figures stay broad.

Inbound and outbound counts follow the sign. The "2 inbound · 1 outbound" figures in the ledger's day header are calculated not from the transaction's type but from whether it raises or lowers the stock. A positive count adjustment appears as "inbound" in that figure.

There is no period filter in Stock Levels. The date boxes are drawn only in the ledger. That is why the chart and the supplier card in Stock Levels cover all time; they narrow with the category and the search, not with a date. Stock is a moment anyway: there is no such figure as "last month's stock", there is today's stock.

Unit and category names are values you typed. The common units are shown in the interface language — ton as t, adet as pcs; any other unit (m², makara) appears exactly as it was written. Material names and categories are never translated — they are data, not interface text.

  • Suppliers — the firms on purchase transactions are defined there. A firm that is not in the list can also be typed as free text; its account is opened under that name.
  • Accounts — material purchases reach the supplier's ledger as a payable from here.
  • Deliveries — taking delivery of ordered material creates a transaction of type Delivery received on this page and raises the stock. Those entries can only be deleted there. If stores are enabled, the delivery window has an optional Store box; if none is chosen, the delivery goes into the main store.
  • Order Management — an order is an intention, it does not change the stock; the material enters the warehouse only when it is delivered. The order window shows the current stock in the warehouse.
  • Financials — the project's material cost is collected there together with the other cost items.
  • Overview — low stock appears as one item in the project summary.