Skip to main content

Stock movements

Issue material to site, take back what was not used, write off wastage, damage and loss, and read the register of every movement in and out of your stores.

Where
  1. Projects
  2. open a project
  3. Materials
Who
  • Company Admin
  • Project Manager
  • Store Keeper

Every change to stock is a numbered movement. Receipts come from goods receipts; everything else โ€” issues, returns and write-offs โ€” is done from a project's Materials tab. Movements are never edited or deleted: a mistake is corrected by another movement in the opposite direction.

๐Ÿ“ท Screenshot spot โ€” a project's Materials tab with the Issue material to site form open, two lines added, one of them linked to a request in Against indent line

Save as static/img/screenshots/procurement-stock-movements.png and replace this box with ![Stock movements](/img/screenshots/procurement-stock-movements.png)

Issue material to siteโ€‹

Who: Store Keeper, Project Manager, Company Admin.

  1. Open the project and go to the Materials tab.
  2. Click Issue to site.
  3. Choose the store in From store โ€” the project's site store, or a central store โ€” and check the Issue date.
  4. In Material available in this store, pick a material (each shows its available quantity) and click Add line. Repeat for everything being handed over.
  5. Enter the Issue quantity for each line.
  6. If the issue meets a material request, choose the request in Against indent line โ€” it lists that material's requests with quantity still pending. Otherwise leave it on No indent.
  7. Add Remarks if useful, and click Issue.

Each line becomes its own movement and posts actual cost to the project at the store's average rate. Linking a line to a request moves that request's Issued column, which is what marks it partly or fully met.

An issue against a request line is refused if it is for more than the line's To issue quantity, for a different material from the one requested, or against a request that was cancelled or rejected.

The rule that matters

Material becomes project cost at the moment it is issued to site โ€” not when it was bought or received. That is why the project's cost and the purchase register rarely agree on a given day, and why both are right.

Return unused materialโ€‹

Who: Store Keeper, Project Manager, Company Admin.

  1. On the Materials tab, click Return from site.
  2. Choose Into store and the Material.
  3. Enter the Quantity and the Return date, and a Reason if useful.
  4. Click Record return.

Material comes back at the store's current average rate, and that value comes off the project's cost. You cannot return more of a material than has been issued to this project and not already returned โ€” the app refuses with "Only โ€ฆ has been issued to this project and not returned; โ€ฆ cannot come back."

Write off wastage, damage or lossโ€‹

Who: Project Manager, Company Admin. A Store Keeper cannot adjust stock โ€” a write-off is the one movement with no document behind it.

  1. On the Materials tab, click Adjust stock.
  2. Choose the Store and the Type.
  3. Pick the Material (for a write-off, only materials in stock in that store are listed) and enter the Quantity. Always enter it as a positive number; the type decides the direction.
  4. Set the Date and enter a Reason.
  5. Click Post adjustment.
TypeUse it forReason
WastageNormal site wastage โ€” cutting, spillageRequired
DamageMaterial spoiled โ€” wet cement, bent barsRequired
LossTheft or material that cannot be foundRequired
ScrapMaterial written off as scrapOptional
Adjustment (reduces stock)A physical count found less than the bookRequired
Opening balance (adds stock)Bringing stock you already hold onto the system. Find the material with the search box, and enter a Rate โ€” it sets the store's averageOptional

Wastage, damage, loss, scrap and adjustments posted from a project's Materials tab put their value on that project's actual cost โ€” the material is gone and the project paid for it.

In the app, an adjustment can only reduce stock. Booking a count that found more than the book is not in the app yet.

Transfers between storesโ€‹

Transfers between stores are not in the app yet. A project can issue straight from a central store and return into one, so in most cases you do not need a transfer.

What each movement doesโ€‹

MovementStockProject cost
Purchase receiptIn, at the order rateNone โ€” stock is an asset
Opening balanceIn, at the rate you enterNone
Site issueOut, at the average rateAdded
Return to storeIn, at the average rateTaken off
Wastage, damage, loss, scrapOut, at the average rateAdded
Adjustment (reduces stock)Out, at the average rateAdded

Only a receipt or an opening balance changes the store's average rate. Everything going out leaves at the current average, which does not move.

Read the movement registerโ€‹

Open Stores from the sidebar and click Stock Movements (or the Movements button on the Stores page).

  • The figures at the top count Movements, Receipts and Issues, and โ€” for roles that can see value โ€” the Value issued.
  • Filter with All types and All warehouses.
  • Columns: Number, Date, Type, Resource, From, To, Quantity, Rate, Value and Reason. Quantities in are shown with + in green, out with โˆ’.
  • Movements are numbered across the company, for example STK/26-27/00311.
  • The Reason column shows the reason you typed, or what caused the movement, such as a goods receipt.

The register shows the most recent 200 movements, and the type filter works within those. For one project's movements, use the list at the bottom of its Materials tab.

Rate and Value show only to the Project Manager, Accountant and Company Admin. For an issue, the value is the cost that was posted to the project.

  • Stores โ€” stock on hand and who can see its value.
  • Material requests โ€” the request lines an issue can meet.
  • Goods receipts โ€” where stock comes in.
  • Costs โ€” where issues, returns and write-offs show up as project cost.