Inventory · สินค้า

This chapter covers menu 4 Inventory: the products and services you buy and sell, how Panya values stock and posts cost of goods sold, the stock documents (adjustments, opening stock and transfers), and the screens that show what is in stock. Purchases and sales move stock too; those documents are explained in Purchasing and Sales, and this chapter explains only their effect on stock and cost.

The Inventory menu#

สินค้า · Menu: 4 Inventory

Inventory is included in every Panya plan, like every other module (see Organization administration).

What each role can do in this menu:

Products and services#

สินค้า/บริการ · Menu: 4 Inventory → Products & services

Every line you sell or buy by code is a product: stocked goods, goods you do not keep in stock, and services. A product carries the default price, unit, VAT flag and accounts that Panya fills in when you pick it on a quotation, order, invoice or purchase. For a stocked item it also shows the quantity on hand, the average cost and the stock value.

Products are master data, like customers and suppliers. Set them up before you enter documents, either one by one or by importing an Excel or CSV file, such as Express's item list (see Importing products from a file). The units and categories they use are kept in 7 Setup → Units & categories; see Setup.

The product list#

The list shows active products in code order, 50 to a page.

In the demonstration company, KB-01 คีย์บอร์ดไร้สาย has 28 ชิ้น on hand at an average cost of 516.82, worth 14,471.00. SV-INSTALL ค่าบริการติดตั้งระบบ is a service, so it shows no stock.

To find products:

• Search code, name or barcode — type part of a code or name, or the full barcode (a barcode must match exactly, so you can scan it into the box).
• All kinds — show only inventory items, non-stock items or services.
• Include inactive — also list deactivated products (shown faded).

Other buttons on the page:

• Stock on hand → opens Stock on hand.
• Import (CSV, Excel) imports products from an Excel or CSV file.
• New product (Alt+A) opens an empty product form.

Click a row to open the product. You need the Manage master data permission (Staff and above) to open, add or import products.

Item kinds#

The Kind decides whether Panya keeps stock for the product and which accounts its lines post to.

The account codes are the company defaults of the standard chart; a category or the product itself can name other accounts (see Which accounts are used).

A service behaves like a non-stock item in the books, with one difference on a credit sale (IV) or credit purchase (RR): when the first line of a new document is a service and the document has VAT, Panya ticks VAT due on payment (services) on a sale, or Input VAT claimable on payment (services) on a purchase, unless you have already changed that box yourself. Withholding tax is not set on the product; you deduct it when you receive or pay, see Finance.

Only inventory items can be used on stock adjustments, opening stock and transfers, and only they appear on the stock screens.

Fields#

Click New product (Alt+A) or click a product in the list. The form title is New product or Edit product followed by the code.

For an existing inventory item, a strip at the top shows On hand, Avg cost and Value, with a Stock card → link.

You can type amounts with or without thousands separators. A price or reorder level that is not a positive number shows "Enter a positive number" under the field when you save.

Account overrides#

Most companies leave these blank and let the company default accounts (7 Setup → Default accounts) or the category's accounts apply. Use an override when one product must post somewhere else, for example a product sold as service revenue 4200 instead of 4100.

The section shows only the accounts that apply to the product's kind. Each box is blank by default; the blank choice says where the posting goes instead: "Category default — …" when the category names an account, otherwise "Company default".

If you change the kind, overrides that do not apply to the new kind are cleared when you save.

Adding a product#

1. Open 4 Inventory → Products & services and press Alt+A (or click New product).
2. Type the Code / SKU and press Enter to move to Name. Enter moves from field to field.
3. Enter the barcode and English name if you use them.
4. Choose the Kind. For goods you keep and count, choose Inventory item.
5. Choose the Category and Unit.
6. Enter the Sale price and Purchase price.
7. For an inventory item, enter the Reorder level if you want reorder warnings.
8. Untick Subject to VAT if the product is VAT-exempt.
9. Open Account overrides only if this product must post to accounts other than its category's or the company's.
10. Click Save. Panya shows "Product KB-01 saved" and closes the form. Press Esc or click Close to leave without saving.

A new inventory item has no stock. Its stock starts with opening stock, a purchase or goods receipt, or a stock adjustment.

Changing, deactivating and deleting a product#

Open the product, change the fields and click Save. Changes apply to documents you enter from then on; posted documents keep what they recorded. Two changes are refused once a product has history:

• The Kind cannot change after the product appears on a sales or purchase document or has stock movements.
• The Category cannot change to a category with a different costing method after the product has stock movements.

To remove a product, open it and click Delete, then confirm. A product with stock movements or used on documents cannot be deleted; Panya shows the reason and a Deactivate instead button, which unticks Active and saves.

Importing products from a file#

Use Import (CSV, Excel) on the product list to bring in a product list from Express or another program. Express's item list (4.4 รายละเอียดสินค้า, under F12 พิมพ์รายงาน › 4 สินค้าคงคลัง) works as it is. Import Express's service items (4.4 รายละเอียดสินค้าบริการ) as a second file with a kind column set to service.

1. Export the list to an Excel or CSV file.
2. Click Import (CSV, Excel), choose the file and click Import.
3. Panya checks every row first. If any row is wrong, nothing is imported and the message lists the rows and problems (up to 20). Fix the file and import again.
4. When all rows are accepted, Panya shows "Imported N products." and how many rows it read.

The example shown in the import window:

code,name,kind,unit,sale_price,purchase_price
KB-02,คีย์บอร์ด,inventory,PCS,890,520
SV-02,ค่าบริการ,service,HR,1500,

The import does not set categories or account overrides; open the products afterwards to set them. It does not bring in quantities either: enter what you have in stock as opening stock. See Setup for every accepted column name.

Messages#

How cost is calculated#

Panya keeps a perpetual inventory: every document that moves stock is valued and posted to the general ledger when you post it, so the inventory account always equals the value of the stock on the stock cards. Cost is calculated per product, company-wide: quantities are kept per warehouse, but a product has one cost for the whole company. Moving stock between warehouses therefore never changes its value.

Each product category uses one of two costing methods:

• Moving weighted average — the default.
• FIFO — first in, first out.

A product without a category uses moving average.

Moving weighted average#

Panya keeps, for each product, the total quantity on hand and the total value of that stock. The average cost is value ÷ quantity.

• A receipt adds its quantity and its cost:
  • purchases (RR, HP) and goods receipts (GN) at their net amount after discounts, excluding VAT that you can claim (non-creditable VAT becomes part of the cost);
  • stock adjustments and opening stock at the unit cost you enter (an adjustment without a cost comes in at the current average);
  • goods returned by a customer on a credit note (SR) at the cost at which they left.
• An issue (a sale, a delivery note, an adjustment out, a purchase return) takes quantity × value ÷ quantity on hand, rounded to the satang. The issue that empties the stock takes all the remaining value, so rounding differences never build up.
• A purchase return (GR) leaves at the current average cost. The difference between that and the supplier's credit goes to Inventory cost variance 5120 ผลต่างต้นทุนสินค้า.
• A transfer moves quantity only.

KB-01 คีย์บอร์ดไร้สาย in the demonstration company shows how the average moves:

Issues do not change the average; only receipts at a different cost do. The current average is shown on the product, the stock card and the inventory valuation report.

FIFO#

For a product in a FIFO category, each receipt forms a cost layer (its quantity and value). Issues take from the oldest layers first; an issue that takes part of a layer takes the same share of its value.

• A cancelled sale or other issue brings its goods back, at the cost they left with, as the oldest layer, so they go out first again.
• Goods a customer returns on a credit note come back at their original issue cost as the newest layer.
• A purchase return takes from the oldest layers; the difference from the supplier's credit goes to 5120.
• A transfer moves quantity only.
• FIFO stock can never go below zero, whatever the company's negative-stock setting, because there would be no layer to cost the issue from.
• A purchase (or any receipt) can be cancelled only while its own layer still holds all its goods. Otherwise Panya refuses with "the goods of this receipt have already been issued (FIFO); return them to the supplier instead" — record a purchase return instead.

Choosing the method for a category#

The costing method belongs to the product category: 7 Setup → Units & categories, then New category or Edit on a category (see Setup). The field is Stock costing:

• Moving weighted average
• FIFO

The Costing column of the categories list shows Average or FIFO. A new company starts with one category, GEN ทั่วไป, using moving average. Choose the method before the category's products have any stock movements: after that the method is fixed ("products in this group already have stock movements; the costing method cannot change"), and a product with movements cannot move to a category with the other method.

Which accounts are used#

For every line, Panya takes each account from the first place that names one:

1. the product's own account override;
2. the product's category (7 Setup → Units & categories);
3. the company default (7 Setup → Default accounts, groups Inventory & COGS and Sales & purchases).

When cost of goods sold is posted#

Cost of goods sold is posted at the moment the goods leave stock, in the same journal entry as the document. The table shows the stock effect of each document for inventory-item lines, with the default accounts.

Non-stock items and services never post cost of goods sold. The sales and purchase documents themselves are explained in Sales and Purchasing.

Negative stock#

The company setting Negative stock in 7 Setup → Company decides what happens when a document would take more out of a warehouse than it holds:

• Block (recommended, the default) — posting is refused when an issue would take the product's quantity below zero, either in that warehouse or for the company as a whole. Panya shows a message such as "insufficient stock of KB-01 in warehouse MAIN: on hand 3, requested 5", or in all warehouses when the company as a whole holds too few.
• Allow — the issue is posted. The part beyond what is on hand is costed at the last receipt cost. When the next receipt arrives, Panya revalues the remaining quantity at the incoming cost and posts the difference to Inventory cost variance 5120.

FIFO products never go below zero, whichever option you choose.

Back-dated documents#

A stock document is back-dated when its date is earlier than the latest stock movement of one of its products, for example a purchase invoice dated 11/10/2569 entered after a sale dated 13/10/2569 was posted. Panya accepts it and recalculates instead of editing posted documents:

1. The back-dated document is costed on the product's quantity and value as of its own date. It is placed after any other movements of that same date.
2. Panya then replays every later movement of the product in date order:
   • issues (sales, delivery notes, adjustments out, purchase returns) are re-priced at the new average or from the new FIFO layers;
   • receipts keep their cost; only a negative-stock variance can change;
   • transfers move as they were posted;
   • cancellations follow the movement they reverse.
3. Each later movement whose cost changes gets a Cost recalculated line on the stock card, with quantity 0 and the change in value.
4. For each re-priced document and date, Panya posts a cost adjustment journal entry dated on that document's date (general journal, numbered GJ…, memo "cost recalculated document (back-dated document)"). Inventory moves by the change in value; the other side goes to the account that took the cost: cost of goods sold for a sale or delivery, the offset account for an adjustment, cost variance for a purchase return.

The stock card of KB-01 shows an example. IV69100003 (13/10/2569, 5 ชิ้น) was first posted at 512.00 a unit, 2,560.00. Then GN69100001 (dated 11/10/2569) and IV69100004 (dated 10/10/2569) were entered, both dated before it. Each changed the average at 13/10/2569 and re-priced the sale: two Cost recalculated lines of -15.38 and -9.62. The sale now costs 2,585.00 (5 × 517.00), and the two cost adjustment entries each posted Dr 5110 / Cr 1140 on 13/10/2569.

A back-dated document is refused:

• when the recalculated path would leave stock short for a later movement and negative stock is not allowed: "dated …, this leaves product KB-01 short for stock movements posted after it: …";
• when a later movement that must be re-priced is in a closed period.

Cancelling stock documents#

Panya never edits a posted document. Cancelling one (with the reverse documents permission and a reason) reverses its stock movements and its journal entry:

• goods that went out come back at the cost they left with;
• goods that came in are removed at their own value; if that empties the product or would leave a negative value, the leftover is posted to 5120 in the reversing entry;
• the document's cost adjustment entries, if any, are reversed too.

The cancellation date defaults to the document date. It must be in an open period and cannot be earlier than the latest stock movement of the document's products: Panya refuses with "product KB-01 already has stock movements up to … ; date this on or after it". Choose a later date in that case. Cancelling goods that have since been sold or moved is refused with an insufficient-stock message; record a new adjustment, return or transfer instead.

Stock adjustments (AJ)#

ปรับปรุงสินค้า · Menu: 4 Inventory → Stock adjustments

A stock adjustment changes the quantity of products in one warehouse without a purchase or sale: differences found in a stock count, damaged or lost goods, samples given away, goods found. Each line adds (+) or removes (−) stock. The value is posted between the inventory account and an offset account, by default 5130 สินค้าขาด/เกินจากการตรวจนับ.

The same menu holds Opening stock (OS), which records what you have on hand when you start using Panya.

The adjustment list#

The newest documents come first, with drafts at the top of each date. Filter the list with:

• Search number, reference or memo…
• All types — Adjustments or Opening stock.
• All statuses — Draft, Posted or Cancelled.
• The two date boxes — from and to.

Click a row to open it; a draft opens in the form so you can continue. The buttons at the top:

• Opening stock opens a new opening stock document (shown only if you may post journals).
• New adjustment (Alt+A) opens a new stock adjustment.

Fields#

Header:

Lines:

The footer shows Total, or Estimated total when any line is estimated. The × at the end of a line removes it.

Entering a stock count adjustment#

1. Open 4 Inventory → Stock adjustments and press Alt+A.
2. Check the Date and choose the Warehouse.
3. Leave Offset account blank to post to 5130, or choose another account.
4. Enter a Reference if you have one, and press Enter to reach the first line.
5. In Product, type the code (e.g. MS-01) and press Enter to pick it.
6. In Qty (+/−), type the difference: -1 for one missing or damaged unit, 2 for two units found.
7. For an addition, type the Unit cost, or leave it blank to use the average.
8. Press Enter on the unit cost of the last line to add another line. Repeat for each product.
9. Type a Memo, e.g. "ตรวจนับประจำเดือน: เมาส์ชำรุด 1 ชิ้น".
10. Press F9 (Save & post) to post, or ⌘S / Ctrl+S (Save draft) to keep it as a draft without a number or any effect on stock.

When it posts, Panya assigns the number, shows "Posted AJ69100001" and opens the posted document.

Adding stock with and without a unit cost#

• With a unit cost — the stock comes in at that cost and changes the average like a purchase. Use this for goods received without a purchase document, at a cost you know.
• Without a unit cost — the stock comes in at the current average, so the average does not change. Use this for goods found in a count. If the product has no stock (and so no average), Panya uses the cost of its last receipt; a product that has never been received comes in at zero cost, and the adjustment then posts no journal entry. Enter a unit cost in that case.

Removals are always valued at the current cost (moving average, or the oldest FIFO layers).

What posting records#

Panya numbers the adjustment AJ + Buddhist year + month + a running number, e.g. AJ69100001 for the first adjustment of October 2569 (the format can be changed in 7 Setup → Document numbering). It posts one journal entry in the inventory journal, numbered IJ…, and one stock movement per line. There are no VAT or withholding tax records.

The adjustment AJ69100001 dated 15/10/2569 removed one damaged MS-01 เมาส์ไร้สาย from คลังสินค้าหลัก at the average cost of 199.72:

For an addition, the entry is the other way round. Two KB-01 found in a count without a unit cost, at the average of 516.8214:

If you chose an offset account, it replaces 5130. If the product's quantity was negative before an addition (only possible when negative stock is allowed), part of the cost goes to 5120 as a cost variance. After posting, each line shows its actual unit cost and value.

After posting#

The posted document shows:

• Lines — product (the code links to its stock card), quantity in green (+) or red (−), unit cost and value, with the total.
• Details — date, type, warehouse, offset account ("Inventory adjustment (default)" when you left it blank), reference, total value and memo.
• Attachments — click Attach file or drop a scan or PDF (up to 10 MB), e.g. the signed count sheet.
• Journal entry — the entry number (click it to open the entry) and its lines. When the adjustment had no value, the page says "No journal entry: the adjustment had no value."

Buttons: New adjustment starts another one; Cancel document cancels it (see below). A posted adjustment cannot be edited.

Cancelling an adjustment#

1. Open the posted adjustment and click Cancel document.
2. Enter the Reason (recorded in the audit trail). It is required.
3. Check the Reversal date. It defaults to the document date; it cannot be earlier, and it must be in an open period and not before later movements of the same products.
4. Click Cancel document.

Panya reverses the stock movements, posts a reversing journal entry (shown in a Reversal card) and marks the document Cancelled: "Cancelled: reason. The stock movements were reversed and a reversing journal entry was posted; the original document is kept for the audit trail." See Cancelling stock documents for how the values are reversed. Cancelling an addition whose stock has since been used is refused; record a new adjustment instead.

To delete a draft, open it and click Delete draft. Only drafts can be deleted.

Messages#

Opening stock (OS)#

สินค้ายกมา · Menu: 4 Inventory → Stock adjustments → Opening stock, or 5 Accounting → Opening balances → New opening stock

Opening stock records the quantity and cost of what you have on hand when you start using Panya, per warehouse. It starts the product's cost (moving average or FIFO layer) and posts the stock value against Opening balance equity 3900, which balances against your other opening balances. The whole opening-balance procedure, including the general ledger openings and customer and supplier openings, is in Setup.

You need the journal-posting permission (Accountant, Admin or Owner) to enter opening stock. Without it the form shows "Opening stock needs the journal-posting permission."

Entering opening stock#

The form is the stock adjustment form with these differences:

• The title is New opening stock, and an information box explains what opening stock records.
• There is no Offset account: opening stock always posts to opening balance equity.
• The reference is labelled Reference (e.g. count sheet).
• Qty must be positive.
• Unit cost is required on every line.

1. Click Opening stock on the stock adjustments list.
2. Set the Date on or before your go-live date, normally the first day of your first fiscal year in Panya. The date must be in an open period.
3. Choose the Warehouse. Enter a separate opening stock document for each warehouse.
4. For each product, enter the Qty and Unit cost from your closing stock count and valuation.
5. Check the Total against the inventory balance in your previous books.
6. Press F9 to post, or ⌘S / Ctrl+S to save a draft.

Messages specific to opening stock: "Line N: opening stock quantities must be positive" and "Line N: opening stock needs a unit cost".

What posting records#

Opening stock is numbered OS + Buddhist year + a running number for the year, e.g. OS6900001. It posts a journal entry in the opening journal (numbered OJ…). The demonstration company's OS6900001, dated 01/01/2569 in คลังสินค้าหลัก, is worth 18,000.00, of which KB-01 is 20 × 500.00 = 10,000.00:

The stock card shows it as an Adjustment receipt. You can attach files and cancel an opening stock document like any adjustment.

Importing opening stock from a file#

For many products, use 5 Accounting → Opening balances → Import stock (CSV, Excel) instead. Enter the Opening date (the first day of your first fiscal year in Panya) and choose an Excel or CSV file with these columns. Express's stock on hand (4.2 สินค้าคงเหลือ) works as it is, also when it is grouped by warehouse: the warehouse in each group's heading applies to the products under it.

product,warehouse,qty,unit_cost
MS-01,MAIN,120,250
KB-02,,40,180.50

A product may appear once per warehouse. The whole file is checked first; if any row is wrong nothing is posted. Panya posts one opening stock document per warehouse, with the reference "Imported opening stock", and reports the total value and the number of documents. See Setup.

Stock transfers (TF)#

โอนย้ายสินค้า · Menu: 4 Inventory → Stock transfers

A stock transfer moves quantities of products from one warehouse to another, for example from the main store to a shop. Because cost is company-wide, a transfer does not change the value of stock and posts no journal entry. It only changes where the stock is.

The transfer list#

Filter with Search number or memo…, All statuses and the from–to dates. Click a row to open the transfer. New transfer (Alt+A) starts a new one.

Fields#

You need at least two active warehouses. With fewer, the form shows "You need at least two active warehouses to transfer stock." with a Set up warehouses link, and the save buttons are disabled.

Transferring stock#

1. Open 4 Inventory → Stock transfers and press Alt+A.
2. Check the Date, and choose From warehouse and To warehouse.
3. On each line, pick the Product and type the Qty. Watch At source: a red figure means the source does not have enough today.
4. Press Enter on the quantity of the last line to add another line.
5. Type a Memo, e.g. "ส่งสินค้าไปหน้าร้าน".
6. Press F9 (Save & post), or ⌘S / Ctrl+S to save a draft.

What posting records#

The transfer is numbered TF + Buddhist year + month + a running number, e.g. TF69100001. For each line Panya records two stock movements: out of the source warehouse and into the destination warehouse, with the same quantity and the same value at the current cost. Nothing is posted to the general ledger, and there are no tax records.

The transfer TF69100001 dated 16/10/2569 moved 5 KB-01 and 10 MS-01 from คลังสินค้าหลัก (MAIN) to หน้าร้านสาขาลาดพร้าว (SHOP):

On the stock card of KB-01, it appears as 5 out of MAIN and 5 into SHOP, both at 516.82 a unit (2,584.11). The company-wide balance stays 28 units worth 14,471.00.

The posted transfer shows its lines with the total quantity, the Details (date, reference, from, to, memo) and Attachments. New transfer starts another one.

Cancelling a transfer#

Open the posted transfer, click Cancel document, enter the reason and the Reversal date, and confirm. The quantities move back to the source warehouse and the transfer is marked Cancelled: "Cancelled: reason. The quantities were moved back; the original document is kept for the audit trail."

If the goods have since been sold or moved on from the destination, the cancellation is refused. Enter a new transfer in the other direction instead. The reversal date cannot be before the transfer's date, nor before a later movement of its products. Cancelling moves quantities only: the products' cost does not change.

Messages#

Stock on hand#

สินค้าคงเหลือ · Menu: 4 Inventory → Stock on hand

Stock on hand shows the quantity of each inventory item in each warehouse on a date, from posted stock movements. Use it before a stock count, to see what a shop holds, or to check stock on a past date. It also opens from Stock on hand → on the product list and from the Stock on hand link of each warehouse.

Filters:

• As of — defaults to today. Movements up to and including this date are counted.
• All warehouses or one warehouse.
• Search code or name…

The table has Code, Product, one column per warehouse that holds stock (headed by the warehouse code; hover for its name), and Total when more than one warehouse is shown. Negative quantities are red. Products with zero stock everywhere are left out; the count of products with stock is shown on the right.

Click a row to open the product's stock card (for the chosen warehouse, if you picked one).

Stock on hand shows quantities only, because value is kept company-wide. For average cost and value, see the product list or the inventory valuation report.

Stock card#

บัตรสินค้า · Menu: 4 Inventory → Stock card

The stock card lists every stock movement of one product, with the running quantity and value, like a perpetual inventory ledger card. Open it from the menu, from Stock card on the product list or product form, by clicking a row of Stock on hand, or by clicking a product code on a stock document.

Choosing what to show#

The page address keeps your choices, so you can bookmark a stock card or send the link to a colleague.

Below the filters, Panya shows the product code and name, its kind, its unit, and Now on hand · avg cost · value for the whole company today.

Reading the stock card#

The five boxes summarise the selection:

With All warehouses, a transfer counts in both Received and Issued (it goes out of one warehouse and into another), so those two totals include transfers; the closing quantity is not affected. In the KB-01 example, Received 76 and Issued 48 each include the 5 units of TF69100001.

The table has one row per movement, in date order, starting with Opening balance and ending with Totals:

A Cost recalculated row has no quantity and no unit cost. It follows the movement it re-prices, and its value is the change in that movement's cost; a movement re-priced more than once has one such row per recalculation.

When you choose one warehouse, the balance columns are headed (all) and still show the company-wide balance, because cost is company-wide; use Whse qty for the warehouse's own quantity. A transfer appears as two rows, out of one warehouse and into the other, at the same unit cost.

The KB-01 card above shows the opening stock OS6900001, purchases RR69100001 and GN69100001, sales IV69100001, IV69100003, IV69100004 and delivery DO69100001, the two cost recalculations of IV69100003 (explained in Back-dated documents), the credit note SR69100001 returning one unit at its sale cost of 512.00, and the transfer TF69100001. It ends with 28 units worth 14,471.00, the same as the product list and the inventory valuation report.

Warehouses#

คลังสินค้า · Menu: 4 Inventory → Warehouses

Warehouses are the places where you keep stock: a store, a branch, a shop. Panya tracks the quantity of each product in each warehouse. Every new company starts with one warehouse, MAIN คลังสินค้าหลัก. Add more if you keep stock in several places; the demonstration company also has SHOP หน้าร้านสาขาลาดพร้าว.

The list shows Code, Name, Address, an Inactive badge for deactivated warehouses, and a Stock on hand link that opens Stock on hand for that warehouse. Click a row to edit; New warehouse (Alt+A) adds one.

When a company has more than one warehouse, sales and purchase documents show a Warehouse field, defaulting to the first active warehouse; the stock lines of the document move in that warehouse.

Fields#

Click Save. If the code or name is missing, Panya shows "Code and name are required".

To remove a warehouse, open it and click Delete. A warehouse used by documents cannot be deleted; Panya shows "this record is in use by documents; deactivate it instead" with a Deactivate instead button. Move any remaining stock out with a transfer before you deactivate a warehouse.

Inventory reports#

Two reports in 6 Reports → All reports, group Inventory, read the stock data. They are described in full in Reports.

Inventory valuation#

Inventory valuation lists each product's quantity, average cost and value on a date, for all warehouses or one. It compares the total with the balance of the inventory control accounts in the general ledger and shows reconciled when they agree. In the demonstration company the stock is worth 26,454.34, the same as account 1140.

For one warehouse, a product's value is its quantity in that warehouse at the company-wide average cost. The reconciliation is always company-wide.

Reorder report#

Reorder report lists active inventory items whose quantity on hand in all warehouses is at or below their Reorder level, with the shortfall. Products without a reorder level are not checked. In the demonstration company nothing needs reordering.

At month end, also run 6 Reports → Integrity checks, which confirms that the stock value agrees with the inventory account; see Month-end and tax filing.