Operations and inventory

Inventory and warehouse management

ArkanERP Inventory is cloud software for managing items and warehouses in Saudi businesses with several branches: it records every receipt, issue, transfer and count and values it at moving average cost. Every approved movement posts to the accounts by itself, and a transfer between two warehouses only lands once the receiving storekeeper takes it in.

  • Transfers wait for the receiving storekeeper
  • Moving average cost with automatic entries
  • Retail, wholesale and floor prices per warehouse
  • Barcodes, serials, IMEI and batches

What Inventory and warehouses does

  • Numbered warehouses tied to branches

    Warehouses and their sub-warehouses are numbered in a tree (1, 11, 12…), and the number shows in every field and report. Each warehouse belongs to a cost center, so a branch's staff see only their branch's warehouses.

  • Item codes built from the group

    Groups are numbered up to five levels deep, and an item's code starts with its group's number (01000001, 01010001), so two people adding items at the same moment never get the same code. Each item has an Arabic and an English name, several units with their conversions, and size and colour variants.

  • Transfers that are received, not assumed

    A transfer goes into a goods-in-transit warehouse, and the receiving warehouse's storekeepers and its tills' cashiers are told to receive it; the reminder repeats every 48 hours until they do. A transfer never sends more than the sending warehouse holds.

  • Valuing transfers between branches

    A transfer is valued at cost, at the last supply price, at the selling price of the receiving warehouse, or at the last purchase price; the difference from cost goes to the company's transfer difference account.

  • Receipts and issues with their counterpart

    A stock receipt and a stock issue name their account and party (a supplier, customer, employee, cash box or bank) with the cost center and execution project. An issue may be priced above cost, the difference booked as a gain of its own.

  • Supply requests from the storekeeper

    A storekeeper asks for what a warehouse needs in a supply request; the stock manager turns it into a receipt, issue or transfer with its items and quantities in one step, and the request follows the quantities supplied until it is complete.

  • Stock counts and adjustments

    A quantity adjustment takes the surplus, the shortage or the counted quantity; a cost adjustment reprices what is there without touching its quantity. Opening stock has its own screen, apart from adjustments.

  • Bringing stock in from Excel

    Opening stock and item prices are imported from an Excel file with Arabic, English or no headings, into one warehouse or several. Each row is matched to an item by its code (even with the zeros Excel dropped), its barcode or its name.

  • Barcodes, serials and batches

    A barcode's type is read from its length (EAN-13, UPC-A, EAN-8), and barcode labels print with the item's price. Serial numbers, IMEI numbers and batches are tracked, and quantities can be reserved for an order.

  • An item's movement in full

    An item's card lists every movement by kind (invoice, return, receipt, issue, transfer, adjustment, assembly…) with its quantity, cost and the balance after it, by day or by month. The stock ledger shows items that didn't move at zero, with their last purchase price and average cost.

How the work flows

  1. 1

    Setting up

    Warehouses are made with their cost centers, groups and items with their codes, and opening stock is imported from Excel.

  2. 2

    Receiving

    A purchase invoice receives the goods straight into the branch's warehouse, or a stock receipt is recorded from its source.

  3. 3

    Transfer and receipt

    A branch sends goods to another; they stay in transit until the receiving storekeeper takes them in.

  4. 4

    Selling and issuing

    Quantities leave through invoices, tills and issues at their average cost, and the cost of sales posts by itself.

  5. 5

    Counting and review

    The warehouse is counted and differences adjusted, and balances and movements are read in reports per warehouse and group.

Questions about Inventory and warehouses

Does it handle several warehouses and branches?

Yes, with no limit on warehouses. Each warehouse belongs to a cost center, so a branch's staff are kept to their own warehouses while managers see all of them.

How is stock valued?

At moving average cost: a sale goes out at the item's average cost at the time, a sales return comes back at that average, and a purchase return leaves at its invoice's price.

Can I move my stock from my current program?

Yes. Opening stock and prices are imported from Excel; items are matched by code, barcode or name, and anything uncertain is shown to you before it is saved.

What happens to a transfer that isn't received?

It stays in goods in transit and doesn't count in the receiving branch's stock, and the storekeepers are reminded every 48 hours with how long it has waited.

Can a stock movement be changed after approval?

A movement that moved stock is never cancelled or deleted; a mistake is put right with an adjustment or a return. Someone given the edit role can correct it in place.

Does it track serial numbers for phones and devices?

Yes. Each serial or IMEI number is traced from receipt to sale, and once its item has moved the number can't be edited, so its trail stays whole.