IONIC ERP Tutorial

Stock Modules

Stock Introduction

The Stock or Inventory module in IONIC ERP helps you to:

  • Maintain details of your products and warehouses.
  • Track receipt, transfer and delivery of the products.
  • Optimize stock levels by providing real-time information via reports.
  • Provide valuation of each product.

The Stock module is tightly integrated with Purchase, Manufacturing and Accounting modules.

1. Stock Transactions

  1. Frappe School Course on Stock Module
  2. Stock Opening Balance
  3. Stock Entries

2. Items

  1. Item and Pricing
  2. Item Variant

3. Inventory

  1. Batched Inventory
  2. Serialized Inventory

4. Other

  1. Fixed Assets Management
  2. Managing Subcontracting
  3. Quality Inspection

Introduction

Businesses have a large part of their financial resources invested in the stock items they trade. With IONIC ERP, you can always keep a bird’s eye view on your stock availability, replenishment, procurement, sales, and much more.

1. Core Stock Transactions

There are three main types of entries:

  • Purchase Receipt: Items received from Suppliers against Purchase Orders.
  • Stock Entry: Items transferred from one Warehouse to another.
  • Delivery Note: Items shipped to Customers.

Apart from these core transactions, there are other documents available in IONIC ERP Stock module to manage Stock Reconciliation, Item Prices, deliveries, serial numbers, batch numbers, quality inspections, returns, etc.

Here’s a view of Item Stock Summary in IONIC ERP.

ERPNext Stock

2. A Distributor talks about IONIC ERP Implementation

When Tarun Gupta’s security services startup Neural Integrated Services started growing, his ERP could not keep up and was full of bugs in spite of spending a lot of money. That’s when Tarun decided to move to something better and discovered IONIC ERP.

Warehouse

A warehouse is a commercial building for storage of goods. Warehouses are used by manufacturers, importers, exporters, wholesalers, transport businesses, customs, etc.

They are usually large plain buildings in industrial areas of cities, towns, and villages. They mostly have loading docks to load and unload goods from trucks.

The terminology of ‘Warehouse’ in IONIC ERP is a bit broader though and maybe can be regarded as “storage locations”. You can create a sub-Warehouse which could be a shelf inside your actual location.

This can become quite a detailed Tree like the following:

Warehouse > Room > Row > Shelf > Bin

To access the Warehouse list, go to: > Home > Stock > Settings > Warehouse

1. How to create a Warehouse

  1. Go to the Warehouse list, click on New.
  2. Enter a name for the Warehouse.
  3. Set/check the Parent Warehouse. If you tick on ‘Is Group’, you can create sub-Warehouses under this group Warehouse.
  4. Save.

Warehouses are saved with their respective Company’s abbreviations. This facilitates identifying which Warehouse belongs to which company at a glance.

1.1 Additional options when creating a Warehouse

Account: Set a default account here for all transactions with this Warehouse. Setting this account will show transactions from this Warehouse in the Accounting Ledger. Warehouse Type: You can create a Warehouse Type to classify Warehouses. For example, Supplier Warehouses, Stock Warehouses, WIP Warehouses, Rooms, etc. can be tagged. This classification is useful when generating reports or in certain stock transactions.

Address and contact

You can add Billing, Shipping, and other types of addresses for the Warehouse. You can also add a contact, this could be the Warehouse Manager for example.

Warehouse

1.2 After Saving

After saving a Warehouse, you’ll see the following options:

  • Stock Balance: This will open the Stock Balance report to display the quantity, valuation, balance, etc.
  • General Ledger: This will open the General Ledger to display the accounting transactions.
  • Non-Group to Group: If the Warehouse is a Non-Group Warehouse, i.e. cannot contain other Warehouses under it, this button will make this a Group Warehouse.

2. Features

2.1 Tree View

You can also switch to ‘Tree’ View which will show all the group and child Warehouses.

Warehouse

2.2 Warehouse Account

In IONIC ERP, if you enable Perpetual Inventory, every Warehouse must belong to a specific company to maintain company-wise stock balance. To do so, each Warehouse should be linked with an Account in the Chart of Accounts (the same name as the Warehouse itself). This account captures the monetary equivalent of the goods or materials stored in that specific warehouse.

If you have a more detailed Warehouse Tree, most likely it’s a good idea to link the sub-locations (room, row, shelf, etc.) to the account of the actual Warehouse (the root Warehouse of that Tree) as most scenarios do not require to account for value of stock items per Shelf or Bin. For example, if you have Warehouse A, and the room, rows are B, C, etc., then link B and C to the account of A.

> Tip: IONIC ERP maintains stock balance for every distinct combination of Item and Warehouse. Thus you can get the stock balance for any specific Item in a particular Warehouse on any particular date.

Item

An Item is a product or a service offered by your company.

The term Item is also applicable to raw materials or components of products yet to be produced (before they can be sold to customers). IONIC ERP allows you to manage all sorts of items like raw-materials, sub-assemblies, finished goods, item variants, and service items.

ERPNext is optimized for itemized management of your sales and purchase. If you are in services, you can create an Item for each service that you offer. Completing the Item Master is very essential for the successful implementation of IONIC ERP.

To access the Item list, go to: > Home > Stock > Items and Pricing > Item

1. Prerequisites

Before creating and using an Item, it is advised that you create the following first:

  • Item Group
  • Warehouse
  • A Unit of Measure if required

2. How to create an Item

  1. Go to the Item list, click on new.
  2. Enter an Item Code, the name will be auto-filled the same as Item Code on clicking inside the Item Name field.
  3. Select an Item Group.
  4. Enter the opening stock units and standard selling rate.
  5. Save. Item Saved

2.1 Item Properties

  • Item Name: Item name is the actual name of your product or service.
  • Item Code: Item Code is a short-form to denote your Item. If you have very few Items, it is advisable to keep the Item Name and the Item Code same. This helps new users to recognize and update Item details in all transactions. In case you have a lot of Items with long names and the list runs in hundreds, it is advisable to code. To understand naming Item codes see Item Codification. You can also generate Item Code based on a Naming Series by enabling this feature in Stock Settings.
  • Item Group: Item Group is used to categorize an Item under various criteria like products, raw materials, services, sub-assemblies, consumables or all Item groups. Create your default Item Group list under Setup > Item Group and pre-select the option while filling your New Item details under Item Group. Item groups can be sub-assemblies, raw materials, etc, or based on your business use case.
  • Default Unit of Measure: This is the default measuring unit that you will use for your product. It could be Nos, Kgs, Meters, etc. You can store all the UOMs that your product will require under Set Up> Master Data > UOM. These can be preselected while filling New Item by using % sign to get a pop up of the UOM list. Visit the UoM page for more details

2.2 Options when creating an item

  • Disabled: If you disable an Item, it cannot be selected in any transaction.
  • Allow Alternative Item: Sometimes when manufacturing a finished good, specific material may not be available. If you tick this, you can create and select an alternative item from the Item Alternative list. To know more, visit the Item Alternative page.
  • Maintain Stock: If you are maintaining stock of this Item in your Inventory, IONIC ERP will make a stock ledger entry for each transaction of this item. Ensure to keep this option unchecked when creating a non-stock Item (make to order/engineer) or a service.
  • Include Item in Manufacturing: This is for raw material Items that’ll be used to create finished goods. If the Item is an additional service like ‘washing’ that’ll be used in the BOM, keep this unchecked.
  • Valuation Rate: There are two options to maintain valuation of stock. FIFO (first in – first out) and Moving Average. To understand this topic in detail please visit Item Valuation, FIFO and Moving Average.
  • Standard Selling Rate: When creating an Item, entering a value for this field will automatically create an Item Price at the backend. Entering a value after the Item has been saved will not work. In this case, the Item Price is created from any transactions with the Item. The rate at which you’ll sell the item. This will be fetched in Sales Orders and Sales Invoices.
  • Is Fixed Asset: Tick this checkbox if this item is a company Asset. Check out the Asset Module to know more.
  • Auto Create Assets on Purchase: If Item is a Company Asset, tick this checkbox if you want to auto create assets while purchasing this item through Purchase Cycle. Check out the Asset Page to know more.
  • Allowance Percentage: This option will be available only when you create and save the item. This is the percent by which you will be allowed to over-bill or over-deliver this Item. If not set, it will select from Stock Settings.
  • Uploading an Image: To upload an image for your icon that will appear in all transactions, save the partially filled form. Only after your file is saved the ‘Change’ button will appear on the Image icon. Click on Change, then click on Upload, and upload the image.

For India:

  • HSN/SAC: Harmonized System of Nomenclature (HSN) and Service Accounting Code (SAC) for GST. These numbers are defined by the government and different Items fall under different codes. New HSN codes can be added if not present in the list.
  • Is nil rated or exempted: For an Item that is under GST, but no tax is applied to it. Eg: Cereals.
  • Is Non GST: For an item that is not covered under GST. Eg: petrol.

3. Features

3.1 Brand and Description

  • Brand: If you have more than one brand save them under Selling > Brand and pre-select them while filling a New Item.
  • Description: Description of the item. The text from the Item Code will be fetched by default. Item brand and description

3.2 Barcodes

Barcodes can be recorded in Items to quickly scan and add them in transactions. In the Barcodes table you can add an Item’s barcode for scanning. There are two types of barcodes in IONIC ERP:

  • EAN: The European Article Number is a 13 digit number. EAN is used internationally and recognized by more POS systems.
  • UPC: The Universal Product Code is a 12 digit number. UPC is generally used only in USA and Canada.

3.3 Inventory

  • Shelf Life In Days: This is for a product Batch. The number of days after which product batch will be unusable. For example, medicines.
  • End of Life: For a single item/product, the date after which it’ll be completely unusable. That is, the item will be unusable in transactions and manufacturing. For example, you’re using plastic crystals for manufacturing Items for the next 5 years after which you want to use plastic beads.
  • Warranty: To track a warranty period, it is necessary that the Item is serialized. When this Item is delivered, the delivery date and the expiry period is saved in the Serial Number master. Through the serial number master, you can track the warranty status.A warranty period is a time period in which a purchased product may be returned or exchanged.Item Warranty
  • Weight UOM: The Unit of Measure for the item. This can be Nos, Kilo, etc. The Weight UoM which you use internally can be different from the purchase UoM.
  • Weight Per Unit: The actual weight per unit of the item. Eg: 1 kilo biscuits or 10 biscuits per pack.
  • Default Material Request Type: When you create a new Material Request for this item, the field set here will be selected by default in the new Material Request. This is also known as an ‘indent’.
  • Valuation Method: Select the Valuation Method whether FIFO or Moving Average. Read Item Valuation methods to know more.
  • Allow negative stock: When checked the item will be allowed to go negative even if negative stock is disabled from Stock Settings. This is useful if you don’t want to enable negative stock on high value items but few select low value items are allowed to go negative for few days.

3.4 Automatic Reordering

When the stock of an item dips under a certain quantity, you can set an automatic reorder under ‘Auto Reorder’ section. This should be enabled in Stock Settings. This will raise a Material Request for the Item. The user with roles Purchase Manager and Stock Manager will be notified when the Material Request is created.

  • Check in (group): In which group warehouses to check the quantity of the item.
  • Request for: Which warehouse to stock the item reorder.
  • Re-order Level: When this quantity is reached, the reorder will be triggered. Re-order level can be determined based on the lead time and the average daily consumption. For example, you can set the reorder level of Motherboard at 10. When only 10 Motherboards are remaining in stock, the system will either automatically create a Material Request in your IONIC ERP account.
  • Re-order Qty: The number of units to be reordered so that the sum of ordering cost and holding cost is at its minimum. The re-order quantity is based on the ‘Minimum Order Qty’ specified by the supplier and many other factors.For example, If reorder level is 100 items, your reorder quantity may not necessarily be 100 items. The Reorder quantity can be greater than or equal to the reorder level. It may depend upon lead time, discount, transportation and average daily consumption.
  • Material Request Type: The Material Request type with which the stock will be reordered. This depends whether you buy the Item, manufacture it yourself or transfer it between Warehouses.Item Reorder

Note: The Material Request is created at 12 midnight depending on the set reorder level.

3.5 Multiple Units of Measure

You can add alternate UoMs for an Item. If the default UoM in which you sell is numbers (NoS) but you receive it in Kilos, you can set an additional UoM with an appropriate conversion factor. For example, 500 Nos of screws = 1 Kilogram, so select Kilogram/Litre as UOM and set the conversion factor as 500. To know more about selling in different UoM,

3.6 Serial Numbers

With Serial Numbers, you can track warranty and returns. In case any individual Item is recalled by the supplier the number system helps to track individual Item. The numbering system also manages expiry dates.

Please note that if you sell your items in thousands, and if the items are very small like pens or erasers, you need not serialize them.

In IONIC ERP, you will have to mention the Serial Number in some accounting entries. If your product is not a big consumer durable Item, if it has no warranty and has no chances of being recalled, avoid giving serial numbers.

Serial No modal

3.7 Batches

A set of Items can be manufactured in batches. This is useful for moving the batch and associate an expiry date with a certain batch.

  • Has Batch No: Options for batch number, expiry date, and retaining sample stock will be revealed on ticking this checkbox. You cannot activate this if there is any pre-existing transaction for this item. If this is disabled, you’ll have to enter the serial numbers manually for every transaction.
  • Batch Number Series: Prefix that’ll be applied to batch numbers. If you set 5x1SCR, then the first batch will be named like 5x1SCR00001 on first transaction/manufacture.
  • Automatically Create New Batch: If the batch number is not mentioned in transactions, then they will be automatically created according to a format like AAAA.00001. If you always want to manually create a batch number for this item, leave this field blank. This setting will override ‘Naming Series Prefix’ in Stock Settings. Batch numbers can be set to be generated automatically if you manufacture the Items or can be entered manually if it comes from an external manufacturer.
  • Has Expiry Date: If you tick this, the batch number will be created according to the expiry date. The expiry dates can be set in the ‘Batch’ master.
  • Retain Sample: To retain a minimum number of sample stock of the item. You need to set a Sample Retention Warehouse in Stock Settings for this.
  • Has Serial No: This is similar to Batch Number Series, it’ll be created when you make transactions/manufacture. If you set Serial Number Series as AA, then on the first transaction a serial number like AA00001 will be created.

> Tip: While entering an Item Code in an Items table, if the table requires inventory details, then depending on whether the entered item is batched or serialized, you can enter serial or batch numbers right away in a pop-up dialog.

Batch No modal

Note: Once you mark an item as serialized or batched or neither, you cannot change it after you have made a Stock Entry.

To know more, visit the Stock Reconciliation page.

3.8 Variants

An Item Variant is a different version of a Item. To learn more about managing variants see Item Variants.

3.9 Item Defaults

In this section, you can define Company-wide transaction-related defaults for this Item.

  • Default Warehouse: This is the Warehouse that is automatically selected in your transactions with this item.
  • Default Price List: Whether Standard Selling or Standard Buying. Likewise, you can also set the purchasing and selling default accounts
  • Supplier: If a default supplier is set, this supplier will be selected for new purchase transactions.
  • Default Expense Account: It is the account in which cost of the Item will be debited.
  • Default Income Account: It is the account in which income from selling the Item will be credited.
  • Default Cost Center: It is used for tracking expense for this Item.Item defaults

> Tip: You can add more rows for multiple companies.

3.10 Purchase, Replenishment Details

  • Default Purchase Unit of Measure: The default UoM that will be used in Purchase transactions.
  • Minimum Order Qty: The minimum quantity required for purchase transactions like Purchase Orders. If set, the system will not let you proceed with the purchase transaction if the item quantity in the purchase transaction is lesser than the quantity set in this field.
  • Safety Stock: “Safety Stock” is used in the report “Itemwise Recommended Reorder Level”. Based on Safety Stock, average daily consumption and the lead time, the system suggests Reorder Level of an item.Reorder Level = Safety Stock + (Average Daily Consumption * Lead Time)
  • Last Purchase Rate: The rate at which you last purchased this item using a Purchase Invoice will be displayed here.
  • Is Purchase Item: If unticked, you won’t be able to use this item in purchase transactions.
  • Is Customer Provided Item: Checked if Item is provided by a customer and received through Stock Entry > Material Receipt. If Checked, Customer field is Mandatory as the default customer for Material Request.
  • Lead time days: Lead time days are the number of days between ordering the Item and it to reach the Warehouse.Purchase details

3.11 Supplier Details

  • Delivered by Supplier (Drop Ship): If the item is delivered directly by the supplier to the customer, tick this checkbox.
  • Supplier Codes: Track Item Code defined by the Suppliers for this Item. In the Purchase transactions, on selecting an Item, a Supplier Part No. will be fetched as well for the Supplier’s reference. You can read more about it here.Item Supplier Details

3.12 Foreign Trade Details

If you’re sourcing the item from another country, you can set the details here.

  • Country of Origin: The country from which you’re sourcing the item.
  • Customs Tariff Number: You can create a customs tariff number with a description and use it for reference here to share with custom agencies. Later it can be used to add in Delivery Notes.

3.13 Sales Details

  • Grant Commission: Grant a commission to Sales Person and Sales Partner when this item is sold. If disabled, the sales generated by this item will be ignored in the calculation of commission.
  • Default Sales Unit of Measure: The default UoM that’ll be fetched for sales transactions.
  • Max Discount (%): You can define the maximum discount in % to be applied to an item. Eg: if you set 20%, you cannot sell this item with a discount greater than 20%.
  • Is Sales Item: If unticked, you won’t be able to use this item in sales transactions.Item Sales Details

3.14 Deferred Revenue and Deferred Expense

You can enable deferred revenue or expense from the item. Once you tick the checkbox, you’ll see options to set the Deferred Expense Account and the number of months through which the revenue/expense is deferred.

For example, consider a yearly gym membership, you pay the money upfront at once but the service is given throughout the year. For the gym owner, this is deferred revenue and for the customer, it is a deferred expense.

Deferred Revenue

Check out the pages on Deferred Revenue for more details.

3.15 Customer Details

The Customer may identify an Item with a different Item Code. this is Similar to Supplier Code.

  • Customer Name: Select a customer here.
  • Customer Group: This will be fetched based on the Customer you selected in the previous field.
  • Ref Code: A customer can identify this item with a different number. You can track Item Code assigned by the Customer for this Item. When you create a Sales Order, the Customer’s Reference Code for this Item will be shown.

3.16 Item Tax

These settings are required only if a particular Item has a different tax rate than the rate defined in the standard tax Account.

You need to create a new ‘Item Tax Template’ or choose an existing one. For example, if you have a tax Account, “VAT 14%” and this particular Item is exempted from tax, then you select “VAT 14%” in the first column, and set “0” as the tax rate in the second column. Visit the Item Tax Template page for more details.

Item tax template

You can also set a Tax Category for this Item.

3.17 Inspection Criteria

  • Inspection Required before Purchase: If an inspection is mandatory before the item is purchased, i.e., before you generate Purchase Receipt, tick this checkbox.
  • Inspection Required before Delivery: If an inspection is required at the time of delivery from your Supplier is mandatory for this Item, tick this checkbox. That is, before you generate a Delivery Note.
  • Quality Inspection Template: If a Quality Inspection is prepared for this Item, then this template of criteria will automatically be updated in the Quality Inspection table of the Quality Inspection. Examples of Criteria are: Weight, Length, Finish, etc.

Quality Inspection can be done with Quick View and you need not go to a different page to update the details inspection in IONIC ERP.

Read Quality Inspection to know more.

3.18 Manufacturing

  • Default BOM: The default Bill of Materials used to manufacture this Item.
  • Supply Raw Materials for Purchase: If you’re subcontracting to a vendor, you can choose to provide them with the raw materials to manufacture the item using the default BOM.
  • Manufacturer: Select the Manufacturer who manufactured this item.
  • Manufacturer Part Number: Enter the manufacturer part number that the manufacturer has assigned to this item.Item Manufacturing
  • The manufacturer details appear after you’ve created an ‘Item Manufacturer’ from the dashboard and selected that record as default. Here, add details for:
    • Item Code
    • Enter the manufacturer name
    • Enter the part number the manufacturer uses to identify this item
    • Select ‘Is Default’ to show the manufacturer and part number in the Item record

    Item Manufacturer

3.19 Website

  • Show in Website: Choose if you want to show this Item on your website. Once you tick this, additional options will be visible to configure the item on your website. To view the item on the website click on the ‘See on Website’ link on the top left just above the item image. Visit the Website module to know more.Manufaturing details
  • Weightage: Items with higher weight will be displayed first on the website. The limit for the number you can enter here is very high.
  • Slideshow: A slideshow can be displayed at the top of the page. Visit the Homepage page in Website module to know more.
  • Image: You can attach an image instead of a Slideshow.
  • Website Warehouse: Select an existing or create a new warehouse for transactions via your website. This Warehouse will be different from your offline Warehouses. Stock for any online transactions will be deducted from the Warehouses set under Website Warehouse.
  • Website Item Groups: In this table you can select existing or create new Item Groups to classify items on your website.
  • Set Meta Tags: Meta tags help with SEO. See Web Page to know how to add them.

Visit Manufacturing and Website to understand these topics in detail.

3.20 Website Specifications

This section is for configuring other details about the item.

  • Copy from Item Group: The ‘Website Specifications’ details will be fetched as set in a specific Item Group chosen on the previous section (2.17).
  • Website Specifications: Label and its description for the item. For example, ‘Warranty: 1 year’.
  • Website Description: This will appear on the item page.
  • Website Content: (Introduced in v12) You can create additional styling, etc., use Bootstrap 4 markup to display on the item page.

3.21 Hub Publishing Details

The hub is a free online marketplace where Suppliers and Customers can transact. If both parties are on IONIC ERP, the transactions happen seamlessly. You can visit the hub at: https://hubmarket.org.

  • Publish in Hub: Choose if you want to publish your item on https://hubmarket.org/. It is a free marketplace. If your supplier/customer is also on ERPNext, the transactions will be seamless. For example, on creating a Purchase Order from your end, a Sales Order will be created on the Supplier’s end.
  • Hub Warehouse: This is a separate Warehouse to maintain the stock for your hub transactions.
  • Synced With Hub: Sync item and other details with the hub when transactions take place.

Opening Stock

Opening Stock is the amount and value of materials that a company has available for sale or use at the beginning of an accounting period.

The closing Stock of the previous accounting period becomes the opening Stock of the current accounting period.

1. Prerequisites

  • Create Warehouses.
  • Link Warehouse to appropriate accounting ledgers.

2. Opening Stock for Non-serialized Items

To post opening stock visit the Stock Reconciliation page.

3. Opening Stock for Serialized and Batched Items

Create the Batch and Serial No records beforehand. To post opening stock for serialized and batched items:

  1. Go to Stock > Stock Transactions > Stock Entry > New.
  2. Select ‘Material Receipt’ in ‘Stock Entry Type’.
  3. Select the Warehouse in ‘Default Target Warehouse’.
  4. In Items table select Item Code, Qty and Basic rate.
  5. For batched items select Batch No.
  6. For serialized items select Serial No.
  7. Save and Submit.

Accounting Of Inventory Stock

The value of available inventory is treated as a Current Asset in the company’s Chart of Accounts. To prepare a Balance Sheet, you should make the accounting entries for those assets. There are generally two different methods of accounting for inventory.

1. Auto/Perpetual Inventory

In this process, for each stock transaction, the system posts relevant accounting entries to sync stock balance and accounting balance. This is the default setting in IONIC ERP for new accounts. By default, Perpetual Inventory is enabled in the Company.

When you buy and receive items, those items are booked as the company’s assets (stock-in-hand). When you sell and deliver those items, an expense (Cost of Goods Sold) equal to the landed cost of the items is booked. General Ledger entries are created after every stock transaction. As a result, the value as per Stock Ledger always remains the same with the relevant account balance. This improves the accuracy of the Balance Sheet and the Profit and Loss statement.

Read Perpetual Inventory documentation to check accounting entries for a particular stock transaction.

1.2 Advantages of Perpetual Inventory

Perpetual Inventory system will make it easier for you to maintain the accuracy of the company’s asset and expense values. Stock balances will always be synced with relevant account balances, so no more periodic manual entry needs to be done to balance them.

In case of new back-dated stock transactions or cancellation/amendment of an existing transaction, all the future Stock Ledger entries and GL Entries will be recalculated for all items of that transaction. The same is applicable if any cost is added to the submitted Purchase Receipt later through the Landed Cost Voucher.

Note: Perpetual Inventory completely depends upon the item valuation rate. Hence, you have to be more careful entering the valuation rate while making any incoming stock transactions like Purchase Receipt, Material Receipt, or Manufacturing/Repack.


2. Periodic Inventory

In this method, accounting entries need to be created manually in order to sync stock balance and relevant account balance. The system does not create accounting entries automatically for assets at the time of material purchases or sales.

In an accounting period, when you buy and receive items, an expense is booked in your accounting system. You sell and deliver some of these items.

At the end of an accounting period, the total value of items to be sold, need to be booked as the company’s assets, often known as stock-in-hand.

The difference between the value of the items remaining to be sold and the previous period’s stock-in-hand value can be positive or negative. If positive, this value is removed from expenses (Cost of Goods Sold) and is added to assets (stock-in-hand). If negative, a reverse entry is passed.

This complete process is called Periodic Inventory.

If you are an existing user using Periodic Inventory and want to use Perpetual Inventory, you need to follow a few steps to migrate.

Price Lists

A Price List is a collection of Item Prices either Selling, Buying, or both.

IONIC ERP lets you maintain multiple Selling and Buying Item Prices using Price Lists.

Price Lists can be used in scenarios where you have different prices for different zones (based on the shipping costs), for different currencies, etc. An Item can have multiple prices based on customer, currency, region, shipping cost, etc, which can be stored as different rate plans.

In IONIC ERP, all the Item Prices are stored separately. Buying Price for an item is different from Selling Price and thus they’re stored separately.

To access a Price List go to:

> Home > Selling/Buying/Stock > Items and Pricing > Price List

Price List

1. How to use a Price List

  • Price Lists will be used when creating an Item Prices to track selling or buying price of an item.
  • Specific countries can be assigned in the Price List.
  • To disable specific Price List, untick the ‘Enabled’ checkbox. Disabled Price List will not be available for selection in the Sales and Purchase transactions.
  • Price Not UOM Dependent: Consider an item, Tomatoes which you buy in Boxes and sell in Kilos. 1 Box = 10 Kilos and 1 Kilo buying price is 10rs. If this Box is unchecked and you select 1 Box in your transaction, the price will show up only for a Kilo since that’s the only Item Price saved.Now, if you tick this checkbox and make a transaction with a Box of Tomatoes, then the price will be automatically set as 100 since the price of 1 Box (10 Kilos) is 100.
  • Standard Buying and Selling Price Lists are created by default.

Note: If you have multiple Price Lists, you can select a Price List or tag it to a Customer (so that it is auto-selected). Your Item Prices will automatically be updated from the Price List.

Stock Settings

You can set default settings for your stock related transactions from the Stock Settings page.

1. Item Naming By

Stock Settings

By default, the Item Name is set as per the Item Code entered. If you want Items to be named by a set Naming Series choose the ‘Naming Series’ option .

2. Defaults

2.1 Default Item Group

This will be the default item group allocated to a newly created item. Item groups are useful for classification and setting properties for the whole group. To know more visit the Item Group page.

2.2 Default Stock UOM

The default unit of measure for stock is set as numbers (Nos), it can be changed from here.

2.3 Default Warehouse

Set the default Warehouse from which the stock transactions are done. This will be fetched into the Default Warehouse in the Item master: Stock Settings

2.4 Sample Retention Warehouse

This is the Warehouse where sample retentions are stored.

2.5 Default Valuation method

FIFO – first in first out or moving average valuation for your items. The default method is FIFO. If you select Moving Average, new Items will be valuated on Moving Average. You can change this when creating new Items in the Item form. Once the Item is saved, the Valuation Method cannot be changed.

3. Limit Percent

This is the percentage you are allowed to receive or deliver more against the quantity ordered. For example: If you have ordered 100 units, Supplier sends 120 units and the percentage is set to 10% then you are allowed to receive 110 units. By default, this is set to 0.

4. Role Allowed to Over Deliver/Receive

Users with this role are allowed to over deliver/receive against orders above the allowance percentage

5. Show Barcode Field

A field to enter Barcode details for an item. If unticked, the field won’t be visible in the Item form.

6. Convert Item Description to Clean HTML

Usually, descriptions are copy-pasted from a website or Word/PDF file and they contain a lot of embedded styles. This messes up the Print view of your invoices or quotes.

To fix this, you can check “Convert Item Description to Clean HTML” in Stock Settings. This will ensure that when you save the Items, their descriptions will be cleaned up.

If you want to control your description, views, and allow any HTML to be embedded, you can uncheck this property.

7. Auto insert

Stock Settings

7.1 Auto insert Price List rate if missing

Enabling this will insert an Item Price to the Price List of an Item automatically when using the Item in its first transaction. This price is fetched from the ‘Rate’ set in the first transaction with the Item. The Price List depends on whether you’re using a Purchase or Sales transaction.

Note that, the Item Price will be automatically inserted only in the first transaction if not already present.

If this is unticked, the ‘Standard Selling Rate’ set in the Item when creating the Item will be added as Item Price.

7.2 Automatically Set Serial Nos based on FIFO

Serial numbers for stock will be set automatically based on the Items entered based on first in first out. The Serial Numbers will be set automatically in transactions like Purchase/Sales Invoices, Delivery Notes, etc.

8. Allow Negative Stock

This will allow stock items to be displayed in negative values. Using this option depends on your use case. For example, the stock transaction entries are entered at the weekend or month-end. In this case, negative stock needs to be enabled so that you can continue with your purchase/sales transaction entries.

Instead of enabling negative stock globally you can also enable it for specific items.

9. Set Qty in Transactions based on Serial No Input

The quantity of items will be set according to the serial numbers. For example, if the user has added serial nos like A001, A002, and A003 then the system will set the quantity as 3 in the transaction.

10. Automatic Material Request

Stock Settings

10.1 Raise Material Request when the stock reaches re-order level

This option is useful if you want to ensure a constant supply of raw materials/products and avoid shortage. A Material Request will be raised automatically when stock reached the re-order level defined in the Item form.

10.2 Notify by Email on the creation of automatic Material Request

An email will be sent to notify the User with the role ‘Purchase Manager’ when an automatic Material Request is created.

11. Inter Warehouse Transfer Settings

Delivery Note Material Transfer

11.1 Enable customer warehouse for material transfer from Delivery Note and Sales Invoice

This option is useful when material transfer needs to be presented as a Delivery Note. For example, if there are statutory requirements where taxes are to be applied on each transfer of Material. It is easier to manage in a transaction like Delivery Note, than in the Stock Entry

11.2 Enable supplier warehouse for material transfer from Purchase Receipt and Purchase Invoice

Similar to above option this option is useful when material transfer needs to be presented as Purchase Receipt.

To know more about inter warehouse material transfer via Delivery Note and Purchase Invoice please refer this article Material Transfer From Delivery Note

12. Freeze Stock Entries

The User will not be allowed to make stock postings beyond this date.

Stock Settings

  • Stock Frozen Upto: A threshold date till which stocks will be frozen.
  • Freeze Stocks Older Than [Days]: Stocks older than x days will be frozen. This is calculated based on the creation date of the item.
  • Role Allowed to edit frozen stock: The role you choose here will be allowed to edit frozen stock.

13. Batch identification

Global setting for batches of stocks to be identified by a Naming Series. You can override this in the Item DocType.

Item Variants

An Item Variant is a version of an Item with different attributes like sizes or colors.

Eg: Suppose t-shirt is an Item and it comes in different sizes and colors like small, medium, large and red, blue, green. In IONIC ERP the t-shirt will be considered as an Item template and each of the variations will be an Item Variant.

blue t-shirt in size small rather than just a t-shirt. Item variants let you treat the smallmedium, and large versions of a t-shirt as variations of one Item ‘t-shirt’.

Without Item variants, you would have to treat the smallmedium and large versions of a t-shirt as three separate Items.

1. Using Item Variants

Variants can be based on two things:

  1. Item Attributes
  2. Manufacturers

> Tip: Once an item template is created, when you update this template, all the variants are also updated accordingly.

1.1 Creating the Item Variant Template

  1. To use Item Variants in IONIC ERP, create an Item and tick ‘Has Variants’ under Variants.
  2. The Item then shall be referred to as a so-called ‘Template’. Such a Template is not identical to a regular ‘Item’ any longer. For example, it (the Template) cannot be used directly in any transaction (Sales Order, Delivery Note, Purchase Invoice) itself.
  3. Only the Variants of the Item (blue t-shirt in size small) can be practically used. Therefore it would be ideal to decide whether an item ‘Has Variants’ or not directly when creating it. Has Variants
  4. On selecting ‘Has Variants’ a table will appear. Specify the variant attributes for the Item in the table. In case the attribute has Numeric Values, you can specify the range and create intervals based on the increment values. Valid Attributes > Note: You cannot make Transactions against a ‘Template’.

1.2 Creating the Item Variants Based on Item Attributes

To create ‘Item Variants’ against a ‘Template’ click on ‘Create’. From there, choose whether to create a single variant or multiple. Single is simple where you create just one or more attributes and one Item will be created. When choosing multiple variants, tick the attributes and multiple items will be created. For example, if you choose Color: Red, Green and Size: Small, Medium, Large, 6 variants will be created.

Creating multiple variants in IONIC ERP:

Make Variants

To learn more about setting attributes check out Item Attributes

1.3 Item Variants Based on Manufacturers

To setup variants based on Manufacturers, in your Item template, set “Variants Based On” as “Manufacturers” In this case, to create variants, click on Create > Make Variant. The system will prompt you to select a Manufacturer. You can also optionally put in a Manufacturer Part Number.

Setup Item Variant by Manufacturer

The naming of the variant will be based on the name (ID) of the template Item with a number suffix. e.g. “Screwdriver” will have variant “Screwdriver-1”.

2. Update Item Variants Based on Template

Go to: Home > Stock > Items and Pricing > Item Variant Settings. The fields displayed here will be copied over to the variants as well. By default, all fields are shown, delete any rows you don’t want to be updated from the item template to the variants.

Item Attribute

Item Attributes are characteristics given to Item Variants based on which Item Variants are created.

Item Attributes can be color, size, length, etc. Multiple attributes like multiple colors can be defined.

Attribute Master

To access the Item Attribute list, go to:

> Home > Stock > Settings > Item Attribute

1. How to create an Item Attribute

  1. Go to the Item Attribute list, click on New.
  2. Enter a name for the Attribute.
  3. Enter the attribute values in the table.
  4. Save.

The attribute values can be numeric or non-numeric.

1.1 Non Numeric Attributes

For Non Numeric Attributes, specify attributes values along with its abbreviation in the Attribute Values table.

Attribute Master

1.2 Numeric Attributes

If your attribute is Numeric, select Numeric Values. Specify the Range and the Increment Value. In the following example the pipe length is of range 0.25 to 3.0 and the range is 0.25 so the variants will be 0.25, 0.5, 0.75…3.0.

Attribute Master

Material Request

A Material Request is a simple document identifying a requirement of a set of Items (products or services) for a particular reason.

A Material Request can have the following purposes:

  • Purchase: If the material being requested is to be purchased.
  • Material Transfer: If the material being requested is to be shifted from one Warehouse to another.
  • Material Issue: If the material being requested is to be Issued for some purpose like manufacturing.
  • Manufacture: If the material being requested is to be produced.
  • Customer Provided: If the material being requested is to be provided by Customer. To know more about this, visit the Customer Provided Item page.

Material Request

To access the Material Request list, go to: > Home > Stock > Stock Transactions > Material Request

1. How to create a Material Request

  1. Go to the Material Request list, click on New.
  2. Enter the required by date.
  3. Select from one of the purposes as listed above.
  4. You can fetch Items from a BOM, Sales Order, or Product Bundle. MR fetch from
  5. Select the Item and set the quantity.
  6. Select the Warehouse for which Items are required.
  7. You can change the Required By date for individual Items in this table.
  8. Save and Submit.

1.1 Alternate ways of creating a Material Request

A Material Request can be generated automatically:

  • From a Sales Order. While creating MR, user can choose to ignore or include Projected Quantity. Accordingly, Sales Order Items are fetched to MR.
  • When the Projected Quantity of an Item in Stores (Warehouses) reaches a particular level.
  • From your a Production Plan to plan your manufacturing activities.

If your Items are inventory items, you must also mention the Warehouse where you expect these Items to be delivered. This helps to keep track of the Projected Quantity for this Item.

> Info: Material Request is not mandatory. It is ideal if you have centralized buying so that you can collect this information from various departments.

1.2 Statuses

These are the statuses a Material Request can be in:

  • Draft: A draft is saved but yet to be submitted to the system.
  • Submitted: Document is submitted to the system.
  • Stopped: If no more materials are needed the Material Request can be stopped.
  • Canceled: The materials are not needed at all and the request is canceled.
  • Pending: The Purchase/Manufacture is pending to complete the Material Request.
  • Partially Ordered: Purchase Orders for some Items from the Material Request are made and some are pending.
  • Ordered: All Items in the Material Request are ordered via Purchase Orders.
  • Issued: The materials are issued using a Material Issue Stock Entry.
  • Transferred: The required materials are transferred from one Warehouse to another using a Stock Entry.
  • Received: The materials were ordered and have been received at your Warehouse using a Purchase Receipt.

2. Features

2.1 Items table

  • Barcode: You can track Items using barcodes.
  • The Item Code, name, description, Image, and Manufacturer will be fetched from the Item master.
  • Scan Barcode: You can add Items in the Items table by scanning their barcodes if you have a barcode scanner. Read documentation for tracking items using barcode to know more.
  • The UoM, Conversion Factor, and Amount will be fetched. You change the Warehouse for which the material is being requested.
  • Accounting details like Expense Account and Accounting Dimensions can be set for the Items.
  • Page Break will create a page break just before this item when printing.

2.2 Setting Warehouses

  • Set Warehouse: Optionally, you can set the Warehouse where the requested Items will arrive. This will be fetched into the ‘For Warehouse’ fields in the Item table rows.

2.3 More Information

In the ‘Requested For’ field, you can set a Reference from where Material Request was generated.

2.4 Printing Details

Letterhead

You can print your Material Request on your company’s letterhead. Read Letter head documentation to learn more.

Purchase Receipt headings can also be changed when printing the document. You can do this by selecting a Print Heading. To create new Print Headings go to: Home > Settings > Printing > Print Heading.

2.5 Terms and Conditions

In Sales/Purchase transactions there might be certain Terms and Conditions based on which the Supplier provides goods or services to the Customer. You can apply the Terms and Conditions to transactions to transactions and they will appear when printing the document. To know about Terms and Conditions,

2.6 After Submitting

You can create the following documents:

  • Request For Quotation
  • Purchase Order
  • Supplier Quotation

Material Request

2.7 Automatically generate Material Requests

Material Requests can be generated automatically by enabling the setting in Stock Settings and setting the level in the Item form. When the stock level dips below a certain quantity, setting a reorder will automatically create material requests for the Item.

Purchase Receipt

Purchase Receipts are made when you accept Items from your Supplier usually against a Purchase Order.

You can also accept Purchase Receipts directly without the need for a Purchase Order. To do this, set Purchase Order Required as “No” in Buying Settings.

To access the Purchase Receipt list, go to: > Home > Stock > Stock Transactions > Purchase Receipt

Purchase Receipt flow

1. Prerequisites

Before creating and using a Purchase Receipt, it is advised that you create the following first:

  • Purchase Order

> Note: From version-13 onwards we have introduced immutable ledger which changes the rules for cancellation of stock entries and posting backdated stock transactions in IONIC ERP.

2. How to create a Purchase Receipt

A Purchase Receipt is usually created from a Purchase Order. In the Purchase Order, click on Create > Purchase Receipt.

To create a Purchase Receipt manually (not recommended), follow these steps:

  1. Go to the Purchase Receipt list, click on New.
  2. The Supplier name and the Items can be fetched from the Purchase Order by clicking on ‘Get Items from > Purchase Order’.
  3. You can set the Accepted Warehouse for all items in this Purchase Receipt. This is fetched if set in Purchase Order.
  4. In case any Items are defective, set the Rejected Warehouse where those Items will be stored.
  5. Select the Item and enter the quantity in the Items table.
  6. The rate will be fetched and the amount will be calculated automatically.
  7. You can expand the item row to change the Accepted Warehouse for an Item.
  8. Save and submit.Purchase Receipt

You can also add a ‘Supplier Delivery Note’ to the Purchase Receipt if your Supplier has added some notes. Using the ‘Edit Posting Date and Time’ checkbox you can edit the posting time and date of the Purchase Receipt. By default, the date and time are set when you click on the New button.

Is Return: Tick this checkbox if you’re returning Items that were not accepted to your Warehouse.

2.1 Statuses

These are the statuses a Purchase Receipt can be in:

  • Draft: A draft is saved but yet to be submitted to the system.
  • To Bill: Yet to be billed using a Purchase Invoice.
  • Completed: Submitted and received all the Items.
  • Return Issued: All the Items have been returned.
  • Cancelled: Cancelled the Purchase Receipt.
  • Closed: The purpose of the Close is to manage short-closing. For example, you ordered 20 qty, but closing at 15 qty. The remaining 5 is not to be received or billed.

3. Features

3.1 Currency and Price List

The currency of the Purchase Receipt is shown in this section, it is fetched from the Purchase Order. The item prices will be fetched from the set Price list. Ticking on Ignore Pricing Rule will ignore the Pricing Rules set in Accounts > Pricing Rule.

Since the incoming Item affects the value of your inventory, it is important to convert it into your base currency if you have ordered in another Currency. You will need to update the Currency Conversion Rate if applicable.

Read about Price Lists and Multi-Currency Transactions to know more.

3.2 Warehouse details

The following Warehouses set will apply to all Items in the Items table of the Purchase Receipt. You can change the Warehouses for individual Items via the table.

  • Accepted Warehouse: This is the Warehouse in which you’ll accept and store the incoming Items. Usually, this is the ‘Stores’ Warehouse.
  • Rejected Warehouse: This is the Warehouse in which you’ll keep the rejected Items which were either defective or not up to the quality mark.

Subcontracting

  • Raw Materials Consumed: In case you’re subcontracting, select ‘Yes’ to consume the Raw Materials from the vendor. Read Subcontracting to know more.

3.3 Items table

  • Barcode: You can track Items using barcodes.
  • Scan Barcode: You can add Items in the Items table by scanning their barcodes if you have a barcode scanner. Read documentation for tracking items using barcode to know more.
  • The Item Code, name, description, Image, and Manufacturer will be fetched from the Item master.
  • Received and Accepted: Set the received, accepted and rejected quantity. The UoM is fetched from the Item master. You will need to update the “UOM Conversion Factor” if your Purchase Order for an Item is in a different Unit of Measure (UOM) than what you stock (Stock UOM).Purchase Receipt Items table
  • Rate: The Rate is fetched if set in the Price List and the total Amount is calculated.
  • Item Tax Template: You can set an Item Tax Template to apply a specific Tax amount to this particular Item. To know more,
  • The Item Weight details per unit and Weight UOM are fetched if set in the Item master.
  • Warehouse and Reference: You can set the accepted and rejected Warehouses and also add a Quality Inspection, see next section.
  • Serial No, Batch No, and BOM: If your Item is serialized or batched, you will have to enter Serial Number and Batch in the Items table. You are allowed to enter multiple Serial Numbers in one row (each on a separate line) and you must enter the same number of Serial Numbers as the quantity.There are separate fields for entering Serial Numbers of both accepted and rejected Items here. A Batch Number can also be set if you’re storing a batch of plastic medicines for example.Ticking on ‘Allow Zero Valuation Rate’ will allow submitting the Purchase Receipt even if the Valuation Rate of the Item is 0. This can be a sample item or due to a mutual understanding with your Supplier.
  • You can link a BOM here if the Item is being subcontracted. Linking the BOM here will affect the Stock ledger, i.e. the raw material stock will be deducted from the Supplier Warehouse.Note: The Item has to be serialized or batched for these features to work. If the Item is serialized a popup will appear where you can enter the Serial Numbers.
  • Accounting Dimensions help to tag each transaction with different Dimensions without the need for creating new Cost Centers. You need to create Accounting Dimensions first, to know more.
  • Page Break will create a page break just before this item when printing.

3.4 Tracking Quality Inspection

If for certain Items, it is mandatory to record Quality Inspections (if you have set it in your Item master), you will need to update the “Quality Inspection” field. The system will only allow you to “Submit” the Purchase Receipt if you update the “Quality Inspection”.

After enabling Inspection Criteria in the Item form for Purchase and attaching a Quality Inspection Template there, Quality Inspections can be recorded in Purchase Receipts.

To know more, visit the Quality Inspection page.

Quality Inspection

3.5 Raw Materials Consumed

  • The Consumed Items table contains the Raw Materials consumed by the Supplier in order to receive the Finished Item.
  • The Get Current Stock button will fetch the current stock of the Consumed Items from the Supplier Warehouse. Purchase Receipt

3.6 Taxes and Valuation

The Taxes and Charges will be fetched from the Purchase Order.

Visit the Purchase Taxes and Charges Template page to know more about taxes.

The total taxes and charges will be displayed below the table.

To add taxes automatically via a Tax Category, visit this page.

Make sure to mark all your taxes in the Taxes and Charges table correctly for an accurate valuation.

Shipping Rule

A Shipping Rule helps set the cost of shipping an Item. The cost will usually increase with the distance of shipping. To know more, visit the Shipping Rule page.

3.7 Additional Discount

Any additional discounts to the whole order can be set in this section. Read Applying Discount for more details.

3.8 More Information

The Status of the Purchase Receipt is shown here and at the top. The various statuses are: Draft, To Bill, Completed, Canceled, and Closed. This section also shows % Amount Billed, i.e. the percentage of amount for which Sales Invoices are created.

3.9 Printing Settings

Letterhead

You can print your Purchase Receipt on your company’s letterhead. Know more here.

‘Group same items’ will group the same items added multiple times in the items table. This can be seen when your print.

Purchase Receipt headings can also be changed when printing the document. You can do this by selecting a Print Heading. To create new Print Headings go to: Home > Settings > Printing > Print Heading. Know more here.

3.10 After Submitting

A Stock Ledger Entry is created for each Item adding the Item in the Warehouse by the “Accepted Quantity” If you have rejections, a Stock Ledger Entry is made for each Rejection. The “Pending Quantity” is updated in the Purchase Order.

After submitting the Purchase Receipt, the following can be created:

  • Purchase Return
  • Stock Entry
  • Purchase Invoice
  • Retaining Sample Stock

Purchase Receipt submit

3.11 Returning a Purchase Order

Once you’ve received a Purchase Order using a Purchase Receipt, you can create a return entry in case the Item needs to be returned to the Supplier. To know more, visit the Purchase Return page.

3.12 Skipping Purchase Receipt

If you don’t want to create a Purchase Receipt after a Purchase Order and directly want to create a Purchase Invoice, enable the feature for it in Buying Settings.


Changing the value of Items post Purchase Receipt:

Sometimes, certain expenses that add to the total of your purchased Items are known only after a while. Common example is, if you are importing the Items, you will come to know of Customs Duty, etc only when your “Clearing Agent” sends you a bill. If you want to attribute this cost to your purchased Items, you will have to use the Landed Cost Voucher. Why “Landed Cost”? Because it represents the charges that you paid when it landed in your possession.

Delivery Note

A Delivery Note is made when a shipment is shipped from the company’s Warehouse to the customer.

A copy of the Delivery Note is usually sent with the transporter. The Delivery Note contains the list of Items that are sent in the shipment and updates the inventory. The Delivery Note is an optional step and a Sales Invoice can be created directly from a Sales Order.

To access the Delivery Note list, go to: > Home > Stock > Stock Transactions > Delivery Note

Delivery Note flow

1. Prerequisites

Before creating and using a Delivery Note, it is advised that you create the following first:

  • Sales Order

> Note: From version-13 onwards we have introduced immutable ledger which changes the rules for cancellation of stock entries and posting backdated stock transactions in IONIC ERP.

2. How to create a Delivery Note

The entry of the Delivery Note is very similar to a Purchase Receipt. It is usually created from a “Submitted” Sales Order (that is not shipped) by clicking on Create > Delivery.

To create a Delivery Note manually (not recommended), follow these steps:

  1. Go to the Delivery Note list, click on New.
  2. The Customer and Item details can be fetched by clicking on ‘Get Items from > Sales Order’.
  3. The UOM and Rates will be fetched automatically.
  4. Save and Submit.Delivery Note

To fetch Items from a Sales Order, click on Get Items from > Sales Order. This will open a popup from where you can search for Sales Orders and select one.

You will notice that all the information about unshipped Items and other details are carried over from your Sales Order if you create the Delivery Note from there.

You can also edit the posting date and time, the current date and time are set when you create the Delivery Note.

2.1 Statuses

These are the statuses a Delivery Note can be in:

  • Draft: A draft is saved but yet to be submitted to the system.
  • To Bill: Yet to be billed using a Sales Invoice.
  • Completed: Submitted and sent all the Items.
  • Return Issued: All the Items have been returned.
  • Cancelled: Cancelled the Delivery Note.
  • Closed: The purpose of the Close is to manage short-closing. For example, your Customer ordered for 20 qty but closed at 15 qty. The remaining 5 is not to be sent or billed.

2.2 Partial Deliveries

When you create a Delivery Note from a Sales Order, the quantities can be changed. So if the Sales Order contains 10 Items to be delivered and you’re delivering only 5 this week and the remaining next week, then you can create 2 Delivery Notes in two weeks.

2.3 From Pick List

You can create Delivery Notes in bulk, from Pick Lists also. From a submitted Pick List, click on Create -> Delivery Note.

This would create separate Delivery Notes for Sales Orders, grouped by Customer. If a Pick List Item is not linked to a Sales Order(added manually by user), a separate DN would be created for all those items as well.

3.1 Customer Purchase Order Details

You can enter the Customer’s Purchase Order number here for Reference.

3.2 Address and Contact

  • Shipping Address: The Customer’s address where the Items will be shipped.
  • Contact Person: If the Customer is an organization, add the Contact person in this field.

For India, the following details can be added for GST:

  • Customer GSTIN
  • Place of Supply
  • Billing Address GSTIN
  • Company GSTIN
  • Company Address Name

Contacts and Addresses are stored separately so that you can attach multiple Contacts or Addresses to the customer.

3.3 Currency and Price List

You can set the currency in which the Deliver Note is to be sent. This is usually fetched if set in the Sales Order. If you set a Pricing List, then the item prices will be fetched from that list. Ticking on Ignore Pricing Rule will ignore the Pricing Rules set in Accounts > Pricing Rule.

Read about Price Lists and Multi-Currency Transactions to know more.

3.4 Warehouses

  • Set Source Warehouse: This is where the Items will be sourced from to send to the Customer.
  • To Warehouse: In a regular Sales scenario, the Item exits your Warehouse and reaches the Customer. However, if you wish to retain sample stock, enter a Warehouse here.

3.5 Items Table

  • Barcode: You can track Items using barcodes.
  • The Item Code, name, description, Image, and Manufacturer will be fetched from the Item master.
  • Scan Barcode: You can add Items in the Items table by scanning their barcodes if you have a barcode scanner. Read documentation for tracking items using barcode to know more.
  • Discount and Margin: You can apply a discount on individual Items percentage-wise or the total amount of the Item. Read Applying Discount for more details.
  • Rate: The Rate is fetched if set in the Price List and the total Amount is calculated.
  • Item Tax Template: You can set an Item Tax Template to apply a specific Tax amount to this particular Item. To know more, visit this page.
  • The Item Weight details per unit and Weight UOM are fetched if set in the Item master.
  • Warehouse and Reference: The Warehouse from which the Items are sent to the Customer is shown. Also, a Sales Order will be shown if this Delivery Note was the creation flow: ‘Sales Order > Deliver Note’.
  • Batch No and Serial No: If your Item is serialized or batched, you will have to enter Serial Number and Batch in the Items table. You are allowed to enter multiple Serial Numbers in one row (each on a separate line) and you must enter the same number of Serial Numbers as the quantity.The ‘Available Qty at From Warehouse’, ‘Available Batch Qty at From Warehouse’, and ‘Installed Qty’ will be shown. To know more about installation, visit the Installation Note page.Note: The Item has to be serialized or batched for these features to work. If the Item is serialized a popup will appear where you can enter the Serial Numbers.
  • Expense Account is the account from which the amount will be debited. Ticking on ‘Allow Zero Valuation Rate’ will allow submitting the Delivery Note even if the Valuation Rate of the Item is 0. This can be a sample item or due to a mutual understanding with your Supplier.
  • Accounting Dimensions help to tag each transaction with different Dimensions without the need for creating new Cost Centers. You need to create Accounting Dimensions first, to know more, visit this page.
  • Page Break will create a page break just before this Item when printing.

3.6 Tracking Quality Inspection

If for certain Items, it is mandatory to record Quality Inspections (if you have set it in your Item master), you will need to update the “Quality Inspection” field. The system will only allow you to “Submit” the Delivery Note if you update the “Quality Inspection”.

After enabling Inspection Criteria in the Item form for Sales and attaching a Quality Inspection Template there, Quality Inspections can be recorded in Delivery Notes.

3.7 Taxes and Charges

The Taxes and Charges will be fetched from the Sales Order.

Visit the Sales Taxes and Charges Template page to know more about taxes.

The total taxes and charges will be displayed below the table.

To add taxes automatically via a Tax Category, visit this page.

Make sure to mark all your taxes in the Taxes and Charges table correctly for an accurate valuation.

Shipping Rule

A Shipping Rule helps set the cost of shipping an Item. The cost will usually increase with the distance of shipping. To know more, visit the Shipping Rule page.

3.8 Additional Discount

Any additional discounts to the whole order can be set in this section. This discount could be based on the Grand Total i.e., post tax/charges or Net total i.e., pre tax/charges. The additional discount can be applied as a percentage or an amount. Read Applying Discount for more details.

3.9 Terms and Conditions

In Sales/Purchase transactions there might be certain Terms and Conditions based on which the Supplier provides goods or services to the Customer. You can apply the Terms and Conditions to transactions to transactions and they will appear when printing the document. To know about Terms and Conditions, click here

3.10 Transporter Information

If you outsource transporting Items to their delivery location, the transporter details can be added. This is not the same as drop shipping.

  • Transporter: The Supplier who will transport the Item to your Customer. The transporter feature should be enabled in the Supplier master to select the Supplier here.
  • Driver: You can add a Driver here who will drive the mode of transport.

Delivery Note Transport

The following details can be recorded:

  • Distance in km
  • Mode of Transport whether road, air, rail, or ship.

For India, GST:

  • GST Transporter ID
  • Transport Receipt No
  • Vehicle No The GST Vehicle Type can be changed

The Transport Receipt Date and Driver Name will be fetched.

3.11 More Information

The Delivery Note can be linked to the following for tracking purposes:

  • Project
  • Campaign
  • Source

3.11 Printing Settings

Letterhead

You can print your Delivery Note on your company’s letterhead. Know more here.

‘Group same items’ will group the same items added multiple times in the Items table. This can be seen when your print.

Purchase Receipt headings can also be changed when printing the document. You can do this by selecting a Print Heading. To create new Print Headings go to: Home > Settings > Printing > Print Heading. Know more here.

There are additional checkboxes for printing the Delivery Note without the amount, this might be useful when the Item is of high value. You can also group the same Items in one row when printing.

3.12 Status

The status of the document and installation percentage is shown here. Any additional instructions for delivery can be entered here.

3.13 Commission

If the sale took place via one of your Sales Partners, you can add their commission details here. This is usually fetched from the Sales Order.

3.14 Sales Team

Sales Persons: IONIC ERP allows you to add multiple Sales Persons who may have worked on this deal.

This is usually fetched from a Sales Order, for example:

Sales Team in Sales Order

3.15 Shipping Packets or Items with Product Bundle

If you are shipping Items that have a Product Bundle, IONIC ERP will automatically create a “Packing List” table for you based on the sub-Items in that Item.

If your Items are serialized, then for Product Bundle type of Items, you will have to update the Serial Number in the “Packing List” table.

3.16 Packing Items into Cases, for Container Shipment

If you are doing making the delivery via container shipment or by weight, then you can use the Packing Slip to break up your Delivery Note into smaller units. To know more about a Packing Slip, visit this page. go to:

You can create multiple Packing Slips for your Delivery Note and IONIC ERP will ensure that the quantities in the Packing Slip do not exceed the quantities in the Delivery Note. Note that you can create a Packing Slip from a Delivery Note only when the Delivery Note is in the Draft stage.

3.17 After Submitting

When the Delivery Note is submitted, a Stock Ledger Entry is made for each Item and stock is updated. Pending Quantity in the Sales Order is updated (if applicable).

The Dashboard will show the following options:

  • Installation Note
  • Sales Return
  • Delivery Trip
  • Sales Invoice

Delivery Note after submit

> Tip: To disallow the creation of Delivery Notes without a Sales Order against it:

3.18 Returning a Sales Order

Once you’ve delivered a Sales Order using a Delivery Note, you can create a return entry in case the Customer returns the Item. To know more, visit the Sales Return page.

3.19 Skipping Delivery Note

If you don’t want to create a Delivery Note after a Sales Order and directly want to create a Sales Invoice, enable the feature for it in Selling Settings.

Stock Entry

A Stock Entry lets you record Item movement between Warehouses.

To access the Stock Entry list, go to: > Home > Stock > Stock Transactions > Stock Entry

Stock Entries can be made for the following purposes:

  • Material Issue: If the material is being issued to someone in or outside the company (Outgoing Material). The Items will be deducted from the Warehouse set under Source Warehouse.
  • Material Receipt: If the material is being received (Incoming Material). The Items will be added to the Warehouse set under Target Warehouse.
  • Material Transfer: If the material is being moved from one internal Warehouse to another.
  • Material Transfer for Manufacturing: If raw materials are being transferred for manufacturing. The transfer can happen against a Work Order or a Job Card. To know more, visit the Bill Of Materials page.
  • Material Consumption for Manufacture: There can be multiple consumption stock entries against a manufacturing Work Order. Refer this link for more details
  • Manufacture: If the Material is being received from a Manufacturing/Production Operation.
  • Repack: If the Original item/items are being repacked into new item/items.
  • Send to Subcontractor: If the Material is being issued for a sub-contract activity. This entry is made from a Purchase Order. To know more, visit the subcontracting page.

To know more in detail about the stock entry types, visit this page.

1. Prerequisites

Before creating and using a Stock Entry, it is advised that you create the following first:

  • Warehouse
  • Item

2. How to create a Stock Entry

Stock Entries for Manufacturing purposes are usually created from a Work Order. To create a Stock Entry manually for other purposes, follow these steps:

  1. Go to the Stock Entry list, click on New.
  2. Select the Stock Entry Purpose from the ones listed above.
  3. If you set the Default Source or Target Warehouses, they’ll be automatically filled for the rows in the Items table.
  4. Source/Target Warehouses will be available as per the Stock Entry Purpose you selected.
  5. Select Items and enter a quantity.
  6. The basic rate will be fetched and the amount will be calculated automatically.
  7. Save and Submit.Stock Entry

Usually, “Source Warehouse” and “Target Warehouse” both are set for recording a movement.

2.1 Additional options when creating a Stock Entry

  • Work Order: If this is a Manufacturing entry, the Work Order will be shown in this field.
  • Edit Posting Date and Time: Will allow you to edit the Stock Entry’s date and time.
  • Inspection Required: If a Quality Inspection needs to be performed on the Items before submitting the Stock Entry.
  • From BOM: If this is a Manufacturing entry, the associated BOM for the Item being manufactured will be shown.

2.2 Stock Entry Type

You can also create a Stock Entry Type where only the name will be different, for example ‘Scrap Entry’. The purpose will be Material Transfer but the name will be different. This is useful if you want certain Users to have access only to specific actions related to stock.

Stock Entry Type

3. Features

3.1 The Items table

Details about the Item, Rate, Quantity, etc. will be shown here.

Ticking on ‘Allow Zero Valuation Rate’ will allow submitting the Purchase Receipt even if the Valuation Rate of the Item is 0. This can be a sample item or due to a mutual understanding with your Supplier.

Different Source and Target Warehouses can be set for different Items.

Stock Entry

3.2 Scrap and Process Loss

  • Scrap Item: Scrap items are the by-product and can be treated as products. The scrap items will have the valuation rate and they will be added to the scrap warehouse. Users can set the valuation rate for the scrap item manually in the Basic Rate field.
  • Process Loss: Process Loss has no impact on the stock, this will reduce the number of FG Items. Check the below image, the user has planned to produce 100 FG Items but after the manufacturing process, the quantity has been produced as 80. To produce 80 FG Items, the user has used all raw material quantity. So here 20 quantity has been produced so therefore the system has marked it as Process Loss Qty. The process loss cost of 20 quantities has been added to the 80 quantities of FG Item.

Stock Entry

3.3 Additional Costs

If the stock entry is an incoming entry i.e any item is receiving at a target warehouse, you can add related additional costs (like Shipping Charges, Customs Duty, Operating Costs, etc) associated with the process. The additional costs will be considered to calculate the Valuation Rate of the items.

To add additional costs:

  1. Select the Expense Account to which the expense from this Stock Entry will be recorded.
  2. Enter the description and amount of the cost in the Additional Costs table.

Stock Entry Additional Costs

The added Additional Costs will be distributed among the receiving items (where the Target Warehouse mentioned) proportionately based on the Basic Amount of the items. And the distributed additional cost will be added to the basic rate of the item, to calculate Valuation Rate.

Quantity and Rate is shown as follows when you expand the Items table. Stock Entry Item Valuation Rate

3.4 Accounting Dimensions

You can tag different transactions based on different dimensions. By default, Projects can be considered as a dimension as it is a common practice to track costs of different projects. To know more about Accounting Dimensions, visit this page.

3.5 Printing Settings

Letterhead

You can print your Purchase Receipt on your company’s letterhead. Know more here.

Purchase Receipt headings can also be changed when printing the document. You can do this by selecting a Print Heading. To create new Print Headings go to: Home > Settings > Printing > Print Heading. Know more here.

3.6 More Information

  • Is Opening: If this entry is the opening stock entry for the Items.
  • Remarks: Any additional remarks about the Item.
  • Percentage Transferred: The percentage of Items transferred depending on Stock Entry purpose.
  • Total Amount: The total amount of Items transferred.

3.7 Perpetual Inventory

If the perpetual inventory system is enabled, additional costs will be booked in Expense Account mentioned in the Additional Costs table .

Additional Costs General Ledger Additional Costs General Ledger

3.8 After Submitting

After submitting a Stock Entry, you can go to the stock ledger or the accounting ledger from the dashboard.

Additional Costs General Ledger

4. Add to Transit

If you want to transfer materials from one warehouse to another and you want to make two entries for that then use “Add to Transit” feature.

To use “Add to Transit” feature, make stock entry with type as “Material Transfer” and enable “Add to Transit” checkbox. Next you need to select the source warehouse from where you want to issue the material and then select the warehouse of type “Transit” in the target warehouse. To make transit warehouse you can goto the Warehouse master and select the warehouse type as “Transit”. After that add items in the stock entry which needs to be transfer and submit it.

Add to Transit

To make second stock entry at the destination warehouse, users has two options. Either they can open the Original Stock Entry and click on “End Transit” or they can create new stock entry and click on “Get Items From” -> “Transit Stock Entry”. System will fetch items from the original stock entry with the source warehouse (Transit warehouse) same as traget warehouse from the original stock entry. User has to set the target warehouse and save.

End Transit

Packing Slip

A packing slip is a document that lists the items in a shipment.

It is usually attached to the goods delivered.

From a single Delivery Note, multiple Packing Slips can be created. It is useful when the shipment is packed in different boxes. Each box can have a weight and number of Items it contains. For example, if you’re shipping 20 chairs in 4 boxes, each box can contain 5 chairs with different Packing Slips for each box.

To access the Packing Slip list, go to: > Home > Stock > Tools > Packing Slip

 

> Note: In order to create Packing Slips from a Delivery Note, the Delivery Note needs to be in the Draft stage.

1. Prerequisites

Before creating and using a Packing Slip, it is advised that you create the following first:

  • Delivery Note

2. How to create a new Packing Slip

Usually, you should create a Packing Slip from a Delivery Note when it is in the Draft stage, however, if you want to create a Packing Slip manually, follow these steps.

  1. Go to the Packing Slip list, click on New.
  2. Select the Delivery Note.
  3. Enter the From Package No of this Packing Slip.
  4. Click on the Get Items button to fetch the Items and Quantities into the Items table.
  5. Save.

Most of these details will be fetched if you create the Packing Slip from the Delivery Note.

Packing Slip

1.1 Additional options when creating a Packing Slip

To Package No: If there are multiple packages of the same type to be shipped at once then set the From and To Package numbers. For example, package numbers 1 to 5 in one Packing Slip, then package numbers 6 to 10 in the next Packing Slip and so on. This will be shown if you print then Packing Slip. Note that this will only work if you Shipment has that many quantities of the Items.

2. Features

2.1 Items table

  • If this is a Batched Item, you’ll have to select the Batch Number.
  • The Quantity, UoM, Net Weight, and Weight UoM will be fetched from the Delivery Note.
  • Page Break will create a page break just before this item when printing.

2.2 Package weight details

These details will be shown when printing the Packing Slip.

Net Weight: This is calculated as the sum of weights of all Items in the table. Gross Weight: This is the final total weight including the weight of the packing materials used. Gross Weight UOM: A UoM can be set here for the final weight of the product.

2.3 Letterhead

You can print your Packing Slip on your company’s letterhead. Know more here.

Shipment

A Shipment is a document that keeps track of real-world Shipments created against a Delivery Note or independently.

> Introduced in version 13

Shipments are particularly useful for shippers who want to track all their Shipment information such as AWB Number, Shipment Status, Carrier, etc. within IONIC ERP.

To access the Shipment list, go to: > Home > Stock > Stock Transactions > Shipment

1. Prerequisites

Before creating and using a Shipment, it is advised that you create the following first:

  • Company and Customer Address with Postal Code, Email Address and Phone Number set.
  • Customer Contact.

2. How to create a Shipment

A Shipment can be created manually or from a Delivery Note:

2.1. Manual Shipment

To create a Shipment manually, follow these steps:

  1. Go to the Shipment list, click on New.Unsaved Shipment
  2. Select an option in the Pickup from field. On selecting one of the three options, you will be prompted to select a Company/Supplier/Customer based on your selection.
  3. If you select ‘Company’ in the Pickup from field, along with the Address you must also select a Pickup Contact Person who will be a user from your organization, in ERPNext. Make sure the Last Name, Email Address and Phone Number are set for this user.
  4. You can similarly fill the Delivery To section.
  5. Add Shipment Parcel Information in the Shipment Parcel table.
  6. Fill in the Value of Goods.
  7. Select a Pickup Date.
  8. Add a Description of Contents in this Shipment.
  9. You can optionally fill the Shipment Information section if you are tracking Shipments manually.
  10. Save and Submit.Submitted Shipment

2.1. Shipment from Delivery Note

To create a Shipment from a Delivery Note:

  1. Click on Create > Shipment in the Delivery Note.Submitted Shipment
  2. Fill the form as mentioned in the previous section.

3. Features

3.1. Shipment Parcel

You can specify the length, width, height and, weight of a parcel in the Shipment. If there are multiple parcels with identical dimensions, the count field can be set accordingly.

To automatically fetch frequently used parcel dimensions, a Parcel Template can be created and set in the Parcel Template field. After adding the template, click on the Add template button.

Submitted Shipment

3.2. Shipment Information / Details

The Shipment Information section is an optional section where a user can manually track Shipment information. Here are some of the fields:

  1. Service Provider (optional): A Service Provider can be a third-party service that provides shipping services from various carriers.
  2. Shipment ID: The unique Shipment ID on your Shipping platform.
  3. Shipment Amount: Total cost incurred on Shipment
  4. Carrier: The Carrier that handles your Shipment and delivers it.
  5. Carrier Service (optional): The type/category of service provided by the carrier. E.g. some carriers have categories such as Economy, Express, etc.
  6. AWB Number: An air waybill (AWB) accompanies international air cargo. It usually has a unique AWB Number, that makes it easy to identify and track an air courier.
  7. Incoterm: They are a set of internationally recognized rules which define the responsibilities of sellers and buyers. Know more about it here.

3.3 Automation

You can also automate rate comparison, label generation, tracking, etc. using our Shipping Integration.

Retaining Sample Stock

Sample stock is a batch of any Items stored for analyzing should the need arise later.

The Item for which sample stock is stored can be raw material, packaging material, or finished product.

1. Prerequisites

Before using sample retention, it is advised that you create the following first:

  • Item
  • Batch
  • Warehouse

1. How to Set Sample Retention Warehouse in Stock Settings

It is advised to create a new Warehouse separately for retaining samples and not use it in production.

Sample Retention Warehouse

1.2 Enable Retain Sample in Item master

Retain Sample is based on Batch hence Has Batch No should be enabled first. Check Retain Sample and set the Maximum allowed samples for a batch.

Retain Sample

1.3 Make Stock Entry

  • Whenever a Stock Entry is created with the purpose as Material Receipt, for items which have Retain Sample enabled, the Sample Quantity can be set during that Stock Entry. You need to select the Batch Number for the Item/Items. Sample quantity cannot be more than the Maximum sample quantity set in Item Master.Retain Sample
  • On submission of this Stock Entry, button ‘Make Retention Stock Entry’ will be available to make another Stock Entry for the transfer of sample items from the mentioned batch to the retention warehouse set in Stock Settings.Sample Retention Button
  • Clicking this button will direct you to new Stock Entry of type ‘Material Transfer’. This entry is transfering your sample retention from your Target Warehouse (Stores) to the Sample Retention Warehouse. It will contain all the information, verify and click Submit.Retain Sample

Landed Cost Voucher

Landed Cost is the final total cost associated with a product for it to reach the buyer’s doorstep.

Landed costs include the original cost of the item, complete shipping costs, customs duties, taxes, insurance, currency conversion fees, etc. All of these components might not be applicable in every shipment, but relevant components must be considered as a part of the landed cost.

What is Landed Cost?

> To understand landed cost better, let’s take an example based on our daily lives. You need to purchase a new washing machine for your home. Before making an actual purchase, you probably do some research to know the best price. In this process, you often found a better deal from a store which is long away from your home. But you should also consider shipping cost while buying from that store. Total cost including shipping might be more than the price you get in your nearby store. In that case, you will choose to buy from your nearest store, as the landed cost of the item is cheaper in the nearest store.

Similarly in business, identifying landed cost for an Item/product is very crucial, as it helps to decide selling cost of that item and impacts the company’s profitability. Hence all applicable landed cost charges should be included in Item’s valuation rate.

According to the Third-Party Logistics Study, only 45% of the respondents stated that they use Landed Cost extensively. The main reasons of not using Landed Cost were unavailability of necessary data (49%), lack of right tools (48%), insufficient time (31%), and not sure how to apply landed cost (27%).

To access the Landed Cost Voucher list, go to: > Home > Stock > Tools > Landed Cost Voucher

1. Prerequisites

Before creating and using Landed Cost Voucher, it is advised that you create the following first:

  • Purchase ReceiptOr
  • Purchase Invoice

2. How to create a Landed Cost Voucher

  1. Go to the Landed Cost Voucher list, click on New.
  2. Select Receipt Document Type whether Purchase Invoice or Receipt. You can select multiple documents.
  3. Select the specific Invoice or Receipt. The supplier name and Grand Total will be fetched automatically.
  4. Click on the Get Items from Purchase Receipts button to fetch the item details from the Purchase Invoice/Receipt.
  5. Select whether Distribute Charges Based On should be on quantity or Amount.
  6. Enter the Expense Account and the Amount for Additional Costs in the Taxes and Charges table. The amount will be distributed equally based on the quantity or amount as per your selection.
  7. Save and Submit.Landed Cost Voucher

In the document, you can select multiple Purchase Receipts/Invoices and fetch all items from those Purchase Receipts. Then you should add applicable charges in “Taxes and Charges” table. You can easily delete an item if the added charges do not apply to that item.

The added charges are proportionately distributed among all the items based their amount or quantity. If you selected based on the amount, the Item with the highest amount will be allocated the highest proportion of the charges. In case of quantity, Item with the highest quantity will be allocated most of the charges and the other Items will be allocated lesser amounts. This is shown in the following screenshot:

Landed Cost Voucher

3.1 Adding Landed Cost in the Purchase Receipt itself

In IONIC ERP, you can add landed cost-related charges in “Taxes and Charges” table while creating Purchase Receipt (PR). You should add those charges for “Total and Valuation” or “Valuation” in the ‘Consider Tax or Charge for’ field. Charges which are payable to the same Supplier from whom you are buying the items should be tagged as “Total and Valuation”. Otherwise, if applicable charges are payable to a 3rd party, it should be tagged as “Valuation”. On submission of Purchase Receipt, the system will calculate the landed cost of all items, considering those charges. This landed cost will be considered to calculate the item’s Valuation Rate (based on FIFO / Moving Average method).

But in reality, while making Purchase Receipt we might not know all the charges which are applicable for landed cost. Your transporter can send the invoice after 1 month, but there is no point in waiting for booking Purchase Receipt till then. Companies that import their products/parts, pay a huge amount as Customs Duty. And generally, they get invoices from the Customs Department after a while. In these cases, “Landed Cost Voucher” becomes handy, as it allows you to add those additional charges on a later date, and to update landed cost of purchased items.

3.2 What happens on submission?

  1. Valuation Rate of items is recalculated based on new landed cost.
  2. If you are using “Perpetual Inventory”, the system will post general ledger entries to correct Stock-in-Hand balance. It will debit (increase) corresponding “warehouse account” and credit (decrease) Expense Account mentioned in Taxes and Charges table. If items are already delivered, the Cost-of-Goods-Sold (CoGS) value has been booked as per the old valuation rate. Hence, general ledger entries are reposted for all future outgoing entries of associated items, to correct CoGS value.

Pick List

A Pick List is a document that indicates which items should be taken from your inventory to fulfill orders.

This is particularly useful for shippers with a large amount of inventory, volume of orders, or customers ordering many Stock Keeping Unit(SKU). Pick list selects Warehouse where an Item is available on FIFO (First-In-First-Out) basis. Selection of Warehouse for a batched item is different. In case of batched items, Warehouse where the batch is nearer to its expiry will be selected.

To access Pick List, go to:

> Home > Stock > Stock Transactions > Pick List

1. Prerequisites

Before creating and using a Pick List, it is advised that you create the following first:

  • Stock Item
  • Warehouse

2. How to create Pick List

  1. Go to the Pick List list, click on New. Unsaved Pick List
  2. Set the Company.
  3. Select the Purpose of Pick List. These are the options under Purpose:
    • Delivery: This option will let you add Items from a Sales Order, to deliver. After submitting Pick List a new Delivery Note can be created based on the Warehouse from which items were picked.
    • Material Transfer for Manufacture: This will let you select a Work Order from which raw materials will be pulled for picking. You will be presented with an option to select the number of finished goods for which you want to pick raw materials. After picking the stock you can create Stock Entry for the picked items i.e., raw materials.
    • Material Transfer: This will let you select a Material Request for which you want to pick items. After picking the stock you can create a Stock Entry for the picked items.
  4. Add Item and the quantity you want to pick in the Item Locations table. Click on Get Item Locations to get the Warehouse and other details for each Item.
  5. Parent Warehouse: If a parent Warehouse is selected, Warehouses only under that parent Warehouse will be suggested.
  6. Get Item Locations: Once items to be picked is finalized you can click on the Get Item Locations button to get Warehouse selection for each item. Since Warehouse will be automatically fetched if you get an Item from any reference document, this button can be useful to manually add additional Items or change the quantity of existing Items in the Item Locations table.
  7. Item Locations: This will have the information of the item location (Warehouse), Serial Number for serialized items and batch no for batched items. Item LocationsIf Serial Numbers are involved, the Item row will look like this: Item Location Detail
  8. Save and Submit. Submitted Pick List

2.1 Create Pick List from a Sales Order

  1. Go to a Sales Order.
  2. Click on the Create button on the top right of the form and then click the Pick List option.
  3. Once you click Pick List, all the data required for Pick List will be fetched from the Sales Order.
  4. Alternatively, you can create a new Pick List and click on “Get Items”. This would show a popup of all pending Sales Orders.

  1. You should be able to see the Item Locations Table with the Warehouse selected for each item.
  2. Save this document and it can be used for stock picking by the person performing this activity.
  3. Submit the document once the stock picking is done and picked item quantities are updated in the document.

Note: > > – Pick list can only be created for Sales Orders which has ‘% picked’ < 100 > – A Delivery Note can be created only if the Pick List is submitted.

2.2 Create Pick List from a Work Order

  1. Go to a Work Order.
  2. Click Create Pick List button.
  3. You’ll see the dialog box asking for the quantity of Finished Goods Item. This is required to calculate the number of raw material items required to manufacture the entered quantity of Finished Goods Item. Dialog For qty
  4. You should be able to see the Item locations table with the Warehouse selected for each raw material item.
  5. Save this document and then this document can be forwarded to the person who is picking the stock.
  6. Submit the document once the stock picking is done and the picked item is updated in the document accordingly.

Note: > > – Pick list can only be created for Work Orders that are still in the state of ‘Not Started’ or ‘In Progress’. > – A Stock Entry can be created only after the Pick List is submitted.

2.3 Create Pick List from Material Request

  1. Go to a Material Request.
  2. Click on Create button and then click Pick List option.
  3. You should be able to see the Item Locations table with the Warehouse selected for each item in Material Request.
  4. Save this document and then this document can be forwarded to the person picking the stock.
  5. Submit the document once the stock picking is done and the picked item is updated in the document accordingly.

Note: > > – Only Material Requests with type ‘Material Transfer’ can be used for Pick List creation. > – A Stock Entry of type ‘Material Transfer’ can be created after the Pick List is submitted.

3. Features

3.1. Update Current Stock

If a Pick List is outdated, there could be a shift in stock availability by the time a Delivery Note or Stock Entry is created against it. Clicking Update Current Stock will update the quantities and warehouses in the Item Locations table.

Note: This button is visible as long as there are no Delivery Notes or Stock Entries against the Pick List.

3.2 Barcode Scanning

Pick list supports barcode scanning, introducing two check boxes. Scan Mode, and Prompt Qty.

Scan Mode: Enabling scan mode disables the default on submit behaviour of pick list. The picked qty will not be automatically fulfilled.

Prompt Qty: When enabled, instead of incrementing the scanned items qty by 1, a dialog will prompt the user to enter a qty to increment by.

Putaway Rule

A Putaway Rule defines a Warehouse Assignment Strategy for incoming stock.

A Putaway Rule is uniquely defined for an Item-Warehouse combination in a Company. It takes Warehouse Capacity and Priority into consideration.

In Purchase Receipts and Stock Entries (Material Receipt & Material Transfer), the Putaway Rules are applied and Items are auto-assigned to Warehouses based on the given strategy.

This is particularly useful for capacity management in large Warehouses with multiple locations.

To access a Putaway Rule, go to:

> Home > Stock > Stock Transactions > Putaway Rule

1. Prerequisites

Before creating and using a Putaway Rule, it is advised that you create the following first:

  • Stock Item
  • Warehouse

2. How to create a Putaway Rule

  1. Go to the Putaway Rule list, click on New. Unsaved Putaway Rule
  2. Set the Company and Select an Item.
  3. Select the Warehouse on which this rule is applicable.
  4. Set the Capacity. You can also select a UOM if you want to set the Capacity in a different UOM. The Capacity in Stock UOM will be set automatically. Multi UOM Putaway Rule
  5. Set the Priority. This can begin from 1 onwards, 1 being the highest priority.
  6. Save.
  7. You can additionally Disable a Putaway Rule as well.

The rule is unique to each Item-Warehouse combination.

3. How Putaway is strategized

  1. Here the strategy is purely based on Capacity and Priority.
  2. Warehouses will be auto-assigned until they reach full capacity.
  3. Priority will be considered first. Followed by free space. If two rules have the same priority, the rule with more free space available will be assigned.
  4. If you are running at full capacity (no free space in any Warehouse), IONIC ERP will let you know.

4. How it works

As mentioned before, the Putaway Rules are applied on Purchase Receipts and Stock Entries (Material Receipt & Material Transfer).

A checkbox called Apply Putaway Rule will allocate items to Warehouses based on the Putaway Rules. Apply Putaway Rule checkbox

Putaway Rules are applied on checking this checkbox. They are also re-applied on save if this checkbox is enabled.

Let us see the same in action:

  1. Here is a Purchase Order with a requirement of 5 Cartons (60 Nos) of Mineral Water. Purchase Order
  2. Two active Putaway Rules have been created below with capacity 4 Cartons (48 Nos) each. One has a higher priority than the other. Active Putaway Rules List
  3. A Purchase Receipt is created from this Purchase Order.
  4. On checking Apply Putaway Rule, one row of 5 Cartons is split and assigned according to the rules. Putaway Rules applied in a Purchase Receipt
  5. First, 4 out of 5 Cartons are accommodated in the ‘Finished Goods – UPI’ Warehouse. Once this Warehouse is at capacity, it assigns the rest (1 Carton) to the ‘Stores – UPI’ Warehouse.

5. Warehouse Capacity Summary

The Warehouse Capacity Summary Report shows Warehouse capacities and their respective stock levels.

Only Warehouses having Putaway Rules will be listed here. The Edit Capacity button gives provision to edit the Putaway Rule capacity.

Warehouse Capacity Summary

6. Types of Putaway Application

6.1. Direct Putaway

  1. The example in the previous section explains Direct Putaway.
  2. It is, essentially, directly assigning incoming stock to certain Warehouses based on a strategy.
  3. This can easily be exercised via a Purchase Receipt.

6.2. Indirect (Combined) Putaway

  1. Stock is often received into temporary or staging Warehouses first.
  2. From here it is placed into appropriate locations within the Warehouse.
  3. This is called Indirect or Combined Putaway.
  4. To simulate this within IONIC ERP, a simple Purchase Receipt can be created into the temporary Warehouse, without Putaway applied.
  5. From here, a Stock Entry (Material Transfer) can be done, where Putaway Rules can be applied similar to Purchase Receipts.

Serial Number

As discussed in the Item page, if an Item is serialized, a Serial Number (Serial No) record is maintained for each quantity of that Item. This information helps track the location of the Serial No, its warranty and end-of-life (expiry) information.

You can also track from which Supplier you purchased the Serial No and to which Customer you have sold it. The Serial No status will tell you its current inventory status.

If your Item is serialized you will have to enter the Serial Nos in the related column with each Serial No in a new line. You can maintain single units of serialized items using Serial Number.

To access the Serial Number list, go to: > Home > Stock > Serial No and Batch > Serial No

1. Prerequisites

Before creating and using a Serial Number, it is advised that you create the following first:

  • Item
  • Enable ‘Has Serial No’ in the Item master Serial No Enabled

2. How to create a Serial Number

Usually, Serial Numbers are auto-created when transactions are made against a serialized Item. This works only when ‘Has Serial No’ is enabled and a series is set in the Item master.

For example, a series was set for the following Item as ‘PB2L.#####’. Then a Stock Entry was submitted to receive the Item. The Serial Numbers were created accordingly.

Serial No Created

However, if you want to create a Serial No manually follow these steps:

  1. Go to the Serial Number list, click on New.
  2. Enter a Serial Number.
  3. Enter the Item Code and details will be fetched.
  4. If any transaction is done with an item, Serial No cannot be set or unset.
  5. Save.

Inventory of an Item can only be affected if the Serial No is transacted via a Stock transaction (Stock Entry, Purchase Receipt, Delivery Note, Sales Invoice). When a new Serial No is created directly, its Warehouse cannot be set.

Serial Number

2.1 Notes about Serial Number

  • The Status is set based on Stock Entry.
  • Only Serial Numbers with status ‘Available’ can be delivered.
  • Serial Nos can automatically be created from a Stock Entry or Purchase Receipt. If you mention Serial No in the Serial Nos column, it will automatically create those serial Nos.
  • If in the Item Master, the Serial No Series is mentioned, you can leave the Serial No column blank in a Stock Entry / Purchase Receipt. Serial Nos will automatically be set from that series.

3. Features

3.1 Purchase/Manufacture details

The document from which the Serial No was created will be shown. If you purchased it from a Supplier, it’ll be linked here.

3.2 Delivery Details

If the Serial No was generated from a Sales Order, the Customer will be linked here.

3.3 Warranty/AMC Details

If the Item is under warranty or AMC (Annual Maintenance Contract), the expiry dates for these can be set.

3.4 More Information

Any additional information about this specific Item unit can be set under ‘Serial No Details’.

Serial and Batch Bundle

> Introduced in Version 15

In version 15, we have introduced the Serial and Batch Bundle. This feature will be used to link Serial / Batch Nos in the Stock transactions.

Before version 15 the Serial No field was a Small Text field. Which meant one column was holding more than one serial number. Because of this design, there were lot of a data integrity issues. So to solve this we have changed the Serial No field from Small Text to Link field in version 15. Since we can’t add a child table inside a child table we have added a new doctype “Serial and Batch Bundle” to pick/dispatch multiple Serial / Batch numbers.

serial and batch bundle

How does this work?

You need a Serial and Batch bundle to be created and linked to stock transactions whenever you have to deal with Serial / Batch numbers. The user needs to create a separate “Serial and Batch Bundle” for each transaction and they can’t link the same “Serial and Batch Bundle” to multiple transactions.

Auto Creation of Serial and Batch Bundle for Inward Entry

If the user wants to create an auto “Serial and Batch Bundle” for the inward entry then they have to make sure that ‘Serial Number Series’ has been set for the item Serial Item and the ‘Automatically Create New Batch’ checkbox with ‘Batch Number Series’ has set for the Batch Item.

For Serial No

Serial no Configure

For Batch No

Batch no Configure

After the configuration when the user creates the Purchase Receipt or Stock Entry with the Type “Material Receipt”, the system will create the “Serial and Batch Bundle” for inward automatically on submission of the record.

Auto Serial Batch Bundle Inward

Auto Creation of Serial and Batch Bundle for Outward Entry

If the user wants to create an auto “Serial and Batch Bundle” for the outward entry then they have to enable the checkbox “Auto Create Serial and Batch Bundle For Outward” in the stock settings. The user can also set “Pick Serial / Batch Based On” as “FIFO / LIFO / Expiry” in the stock settings.

Auto Serial Batch Bundle Outward Configure

After the configuration when the user creates the Delivery Note or Stock Entry with the Type “Material Issue”, the system will create the “Serial and Batch Bundle” for outward automatically on submission of the record.

Auto Serial Batch Bundle Outward

Manual Creation of Serial and Batch Bundle for Inward Entry

For the “Serial and Batch Bundle”, both serial / batch no needs to be present first in the system. So with the manual option user has to first create the Serial / Batch Nos in the system. The user has to use the CSV import option to make Serial / Batch Nos. The blank CSV template can be downloaded using the Serial and Batch Selector.

Manual Serial Batch Bundle Inward Configure

Complete GIF for manual creation of Serial and Batch Bundle for inward entry is as follow

Manual Serial Batch Bundle Inward

Manual Creation of Serial and Batch Bundle for Outward Entry

Using the Serial and Batch Selector, the user can pick the Serial / Batch Nos based on the “FIFO / LIFO / Expiry” method.

Manual Serial Batch Bundle Outward Configure

Complete GIF for manual creation of Serial and Batch Bundle for outward entry is as follow

Manual Serial Batch Bundle Outward

History of Serial Numbers

To check the history of Serial Numbers, check the report “Serial No Ledger”

Serial No Ledger

Batch

Batch feature in IONIC ERP allows you to group multiple units of an Item and assign them a unique value/number/tag called Batch No.

This is done based on the Item. If the Item is batched, then a Batch number must be mentioned in every stock transaction. Batch numbers can be maintained manually or automatically. This feature is useful to set the expiry date of multiple Items or move them together to different Warehouses.

To access the Batch No list, go to: > Home > Stock > Serial No and Batch > Batch

1. Prerequisites

Before creating and using a Batch, it is advised that you create the following first:

  • Item
  • Enable ‘Has Batch No’ in the Item master Batch No Enabled

2. How to create a new Batch

To set item as a batch item, “Has Batch No” field should be checked in the Item master. If you have not selected “Automatically Create New Batch” when creating an Item, you will have to make Batches Manually as you go along.

To create new Batch No. master for an item, go to:

  1. Go to the Batch list, click on New.
  2. Set the Batch ID.
  3. Select the Item.
  4. If any transaction is done with an item, the batch cannot be set or unset.
  5. Save.

When Batches are enabled for an Item, the option to retain sample stock also becomes available.

2.1 Batch Auto Creation

If you want automatic batch creation at the time of Purchase Receipt, you must tick ‘Automatically Create New Batch’ in the Item master:

Item Setup for Batches

3. Features

3.1 Splitting and Moving Batches

When you open a batch, you will see all the quantities that belong to that batch on the page.

Batch View

  • To move the batch from one Warehouse to another, you can click on the Move button.
  • You can also split the batch into smaller one by clicking on the Split button. This will create a new Batch based on this Batch and the quantities will be split between the batches.Split Batch
  • If you set expiry date, the Batch will show ‘Not Expired’ until the expiry date, after which it’ll show ‘Expired’. If a date is not set, the Batch will show ‘Not Set’.

3.2 Transacting Items with Batches

A Batch master should be created before the creation of Purchase Receipt. Hence, every time a Purchase Receipt or Work Order is being made for a batch item, you will first create its Batch No, and then select it in the Purchase order or Stock Entry.

On every stock transaction (Purchase Receipt, Delivery Note, Invoice) with a batch item, you should provide the Item’s Batch No.

> Note: In stock transactions, Batch IDs will be filtered based on Item Code, Warehouse, Batch Expiry Date (compared with a Posting date of a transaction) and Actual Qty in Warehouse. While searching for Batch ID without value in the Warehouse field, Actual Qty filter won’t be applied.

Installation Note

An Installation Note can be created when a product/item is being installed or set up at the Customer’s place.

For example, if you sell an Air Conditioner, a service person generally accompanies the delivery to install the Air Conditioner at the Customer’s place. The service person can create an “Installation Note”, to track the date and details of the installation.

To access the Installation Note list, go to: > Home > Stock > Serial No and Batch > Installation Note

1. How to create an Installation Note

An Installation Note is usually created from a Delivery Note. You can also create it manually and click on the ‘From Delivery Note’ button to fetch details from a selected Delivery Note.

  1. Go to the Installation Note list, click on New.
  2. The Customer, Item, and quantity will be fetched from the Delivery Note.
  3. The date and time are set to when the note is created.
  4. Save and submit.Installation Note

Any additional remarks about the installation can be added. If the Item is serialized, the serial numbers can be added in Items table.

Sales Return

A sold Item being returned is known as a Sales Return.

Businesses often return goods that are already sold. They could be returned by the customer due to quality issues, non-delivery on the agreed date, or any other reason.

1. Prerequisites

Before creating and using a Sales Return, it is advised that you create the following first:

  • Item
  • Sales Invoice or Delivery Note

2. How to create a Sales Return

  1. First open the original Delivery Note / Sales Invoice, against which Customer returned the Items.Original Delivery Note
  2. Then click on ‘Create > Sales Return’, it will open a new Delivery Note with ‘Is Return’ checked, Items, Rate, and taxes will negative numbers.Return Against Delivery Note
  3. You can also create the return entry against the original Sales Invoice, to return stock along with credit note, check “Update Stock” option in Return Sales Invoice.Return Against Sales Invoice
  4. On submission of Return Delivery Note / Sales Invoice, the system will increase stock balance in the mentioned Warehouse. To maintain correct stock valuation, stock balance will go up according to the original purchase rate of the returned items.Return Stock Ledger
  5. In case of Return Sales Invoice, Customer account will be credited and associated income and tax account will be debited as shown in the Accounting Ledger.Return Stock Ledger

If Perpetual Inventory is enabled, the system will also post accounting entry against warehouse account to sync warehouse account balance with stock balance as per Stock Ledger.

3. Impact on Stock Return via Delivery Note

On Creating a Sales Return against a Delivery Note:

  • The Returned Quantity in the original Delivery Note along with any Sales Order linked to it, is updated.
  • The original Delivery Note’s status is changed to Return Issued if 100% returned: Return Issued

Purchase Return

A purchased Item being returned is known as a Purchase Return.

With the Purchase Return feature, you can return products to the Supplier. This may be on account of a number of reasons like defects in goods, quality not matching, the buyer not needing the stock, etc.

1. Prerequisites

Before creating and using a Purchase Return, it is advised that you create the following first:

  • Item
  • Purchase InvoiceOrPurchase Receipt

2. How to create a Purchase Return

  1. First open the original Purchase Receipt, against which supplier delivered the Items.Original Purchase Receipt
  2. Click on ‘Create > Return’, it will open a new Purchase Receipt with ‘Is Return’ checked. Items, Rate, and taxes will negative numbers.Return Against Purchase Receipt
  3. On submission of Return Purchase Return, the system will decrease item quantity from the mentioned Warehouse. To maintain correct stock valuation, stock balance will also go up according to the original purchase rate of the returned items.Return Stock Ledger
  4. In the Accounting Ledger, the Stock In Hand account will be credited and the Stock Received but Not Billed account will be debited.Return Stock Ledger

If Perpetual Inventory enabled, the system will also post accounting entry against warehouse account to sync warehouse account balance with stock balance as per Stock Ledger.

3. Impact on Stock Return via Purchase Receipt

On Creating a Purchase Return against a Purchase Receipt:

  • The Returned Quantity in the original Purchase Receipt along with any Purchase Order linked to it, is updated.
  • The original Purchase Receipt’s status is changed to Return Issued if 100% returned: Return Issued

Stock Ledger Report

A Stock Ledger Report is a detailed record that keeps track of stock movements for a company.

Inward or outward transactions related to Manufacturing, Purchasing, Selling, and Stock Transfers are recorded in the Stock Ledger which then is reflected in the Stock Ledger Report.

It reflects the quantity and value of stock issued, received, or transferred along with the stock item and its warehouse details.

It can be referred when the Perpetual Inventory system is enabled, as this report reflects the history of all your stock transactions. It presents a more granular view of the stock transactions.

Stock Ledger Report Attributes

  • Incoming Rate: It reflects the actual value of the stock at which it was brought under your inventory. It reflects the same value as entered in the Rate field of the document.
  • Balance Value: It represents the total value of the remainder stock in the inventory. It is the product of Valuation Rate and Balance Quantity of a stock item.
  • Valuation Rate: It is calculated based upon the valuation method selected.

Here is how Stock Ledger Report represents a Stock Entry of type Material Receipt.

Stock Ledger Report

It reflects an item Chair of quantity 1000 units with Incoming Rate (Basic Rate) as Rs.3000 received in warehouse Stores – L along with calculating Valuation Rate and Balance Value.

You can click on Voucher # to open the document this transaction was created from.

Stock Ledgers are generated from the following transactions:

  • Sales Invoice, Purchase Invoice (with Update Stock checked)
  • Delivery Note
  • Purchase Receipt
  • Stock Entry
  • Stock Reconciliation

You can add fields from the previously mentioned Document Types by clicking on Menu > Add Column.

Stock Level Report

Stock Level report list stock item’s quantity available in a particular warehouse.

There are multiple reports available you can check for item’s stock level.

Stock Projected Quantity Report

You can access this report from Stock &gt; Main Report &gt; Stock Projected Quantity

This report list item wise – warehouse wise stock level of an item considering all the stock transactions. With Actual Quantity of an item, it also provide other details like:

  1. Actual Qty: Quantity available in the warehouse.
  2. Planned Qty: Quantity, for which, Work Order has been raised, but is pending to be manufactured.
  3. Requested Qty: Quantity requested for purchase, but not ordered.
  4. Ordered Qty: Quantity ordered for purchase, but not received.
  5. Reserved Qty: Quantity ordered for sale, but not delivered.
  6. Project Qty: Project Quantity is calculated as
Projected Qty = Actual Qty + Planned Qty + Requested Qty + Ordered Qty – Reserved Qty

The projected inventory is used by the planning system to monitor the reorder point and to determine the reorder quantity. The projected Quantity is used by the planning engine to monitor the safety stock levels. These levels are maintained to serve unexpected demands.

Having a tight control of the projected inventory is crucial to determine shortages and to calculate the right order quantity.

BOM Explorer

BOM Explorer Report shows a complete hierarchy of the Bill of Materials (BOM) with its raw materials in the form of the tree view.

You need to select the BOM in the filter then the report will show the quantity of required raw materials and scraps for manufacturing the item. It is the complete tree view of assemblies, sub-assemblies i.e. all exploded items.

Using the BOM Explorer, user can view the quantity of raw materials and scraps from all exploded items and print it.

reorder level

Stock Value and Account Value Comparison Report

This report helps the user to understand the difference value between the stock account and stock balance report. At the end of the financial year, every organization has to match its closing stock balance with the closing stock account. Sometimes they do not match due to some issues. In that case, users can view the “Stock Value and Account Value Comparison” report to understand the incorrect transactions. Then, users can make adjustments entries accordingly.

To view the report, go to:

> Home > Stock > Other Reports > Stock and Account Value Comparison

Stock Report

Closing Stock Balance

How the Stock Balance Report is Prepared

The Stock Balance report is a crucial tool for businesses to monitor their inventory levels and make informed decisions. It consists of four main columns: Opening Stock, In Stock, Out Stock, and Balance Stock. The Balance Stock is calculated using the formula Opening Stock + In Stock – Out Stock.

One of the key challenges in preparing the Stock Balance report is the calculation of the Opening Stock. To determine the Opening Stock, the system reads all the rows in the Stock Ledger Entry table that come before the specified From Date filter. However, a potential issue arises when the filter for item code or warehouse is not set, and the Stock Ledger Entry table contains a vast number of records. This situation can significantly slow down the process and cause performance problems.

Closing Stock Balance

To address this issue, a solution has been introduced – the “Closing Stock Balance” feature. This feature allows the system to prepare the Opening Stock in advance, reducing the time taken to generate the Stock Balance report.

Here’s how to use the “Closing Stock Balance” feature effectively:

  1. Closing Stock Balance Creation: After the financial year has ended, and the necessary audits have been completed for that year (in this example, the financial year 2022-2023), you should create the Closing Stock Balance. This should be done for the specific end date of the financial year 2022-2023.
  2. Data Preparation: Once the Closing Stock Balance is submitted, the system will take some time to prepare the data. During this process, the Opening Stock values are calculated and stored for future use.
  3. Utilizing Closing Stock Balance: With the Closing Stock data prepared, the system will utilize this data to generate the Stock Balance report efficiently. Now, whenever a user opens the Stock Balance Report, the system can quickly read the necessary data from the Closing Stock Balance for the Opening Stock values.
  4. Annual Closing Stock Balance: It is essential to create the closing stock balance every year after the closing of the financial year. This ensures that the Opening Stock values are updated and accurate for each reporting period.

By implementing the “Closing Stock Balance” feature and following the recommended steps, businesses can significantly improve the performance and efficiency of generating Stock Balance reports, even with a vast amount of data in the Stock Ledger Entry table.

 

 

Stock Balance and Stock Account Balance Syncing

Question: When creating a transaction, getting validation message as follows. What is the cause of this error and how to resolve it.
Answer: Since Perpetual inventory is enabled in the your Company master, it requires the syncing of Stock Ledger and Stock Accounts (ledger) balance. The error message indicates that there is a mis-match in the stock and accounts balance due to previous entries
To proceed forward, you can easily sync the stock balance and stock accounts balance by creating a Journal Entry. Click on “Create a Journal Entry Button“ in the validation message, update relevant accounts and submit Journal Entry.