ANTE User ManualOpening Stock Value
Stock quantities live in Assets; stock value lives in accounting. Stock that reached Assets without a costed receipt — an opening count, a data migration, demo data — has no cost in accounting, so every stock-out of it is costed at zero. Opening Stock Value lists those items and posts their opening value, so accounting holds the same stock as Assets at a real cost. You reach it at Treasury → Accounting → Opening Stock Value.
What the Screen Shows
The screen compares, item by item, the stock on hand in Assets with what accounting holds. An item is listed when Assets holds more than accounting — that extra stock has no cost yet. When nothing is missing, the screen reads Every item with stock has its opening cost.
| On each row | What it means |
|---|---|
| SKU and name | The item. |
| In stock | The quantity on hand in Assets. |
| … already went out at zero cost | Shown when accounting's quantity is below zero: stock that was issued before it had a cost. |
| Opening qty | On hand in Assets minus what accounting already holds — the quantity that makes accounting match Assets. It can't be edited. |
| Unit cost | Prefilled; see the field below. |
| Value | Opening qty × unit cost, worked out as you type. |
Posting the Opening Value
- Pick the opening dateOpening datedateThe date the opening value is posted on. Default: today.
- Check each unit costUnit cost*number0 or more. Prefilled from Assets' stock value for the item (stock value ÷ on hand); if there is none, from the item's buy price. The hint under the box says which: From the stock value in Assets, From the item's buy price, or No cost on file — that row also shows a No cost on file — enter one badge, and the cost starts at 0.
- Post
Check the Total and click Post opening value. The button stays disabled while any row has an opening quantity of zero or a negative unit cost.
| In stock (Assets) | 100 | |
|---|---|---|
| Accounting holds20 went out before the item had a cost | −20 | |
| Opening qty | 100 − (−20) | 120 |
| Unit costFrom the stock value in Assets | ₱50.00 | |
| Opening value | 120 × ₱50.00 | ₱6,000.00 |
| Journal | DR Inventory ₱6,000.00 / CR Opening Balance Equity ₱6,000.00 |
After posting, a summary reads Opening value posted for 1 item(s): ₱6,000.00. The earlier stock-outs of the item that went out at zero cost are then re-costed at the new average cost, and each one is listed as Stock-out #… re-costed: ₱0.00 → …. The re-costing reverses the zero-cost entry and posts it again at cost; both stay on the books.
Only value is posted — stock quantities in Assets are never changed. Use Beginning Balance to load opening quantities into a warehouse.
If a goods receipt was posted in the last few minutes, wait for it to reach accounting before posting here — otherwise that stock is counted twice.
When Posting Is Refused
Posting is checked again at the moment you click Post opening value, so the same stock can never be valued twice. Nothing is posted when it is refused, and the reason appears as an error message:
| Message | What it means and what to do |
|---|---|
| The opening quantity must match the stock on hand (SKU: qty) | The quantity differs from what makes accounting equal Assets — for example, stock changed in Assets after you opened the screen. Reload the screen. If the stock in Assets is wrong, correct it there first. |
| N item(s) are not missing an opening value | An item has no stock in Assets any more, or was already costed (for example by someone who posted it a moment ago). Reload; it drops off the list. |
| The stock in accounting changed while this was being posted — reload and post again | Stock moved in accounting between your opening the screen and posting (a receipt or stock-out was booked). Reload and post again with the refreshed quantities. |
| These items were re-costed or posted by someone else meanwhile — reload and post again | Another user posted or re-costed the same items at the same time. Reload and check what is still listed. |
| Too many stock-outs to re-cost in one go | The items had too many zero-cost stock-outs to re-cost together. Post fewer items at a time. |
You need Treasury Accounting access to open the screen and post.
How It Connects
Set up first
- GL Account Mapping — the Inventory and Opening Balance Equity accounts the journal posts to.
Gets its data from
- Beginning Balance — stock loaded into Assets without a cost is what this screen lists.
- Global Inventory — the on-hand quantities and stock value compared here.
Feeds into
- Journal Entries — the opening-value journal and any re-costed stock-outs appear here.
- Balance Sheet — inventory and opening balance equity include the posted value.