HomeTallyPrimeInventoryInventory in ManufacturingManage Inventory in Manufacturing

 

Explore Categories

 

 PDF

Manage Inventory in Manufacturing

In a manufacturing business, it is crucial to have a detailed report of the raw materials, components, parts, or anything involved in manufacturing the finished product. By doing so businesses can streamline their manufacturing operations with efficient inventory management, production planning, cost estimation, and so on. In TallyPrime you can use the Stock Journal and Manufacturing Journal vouchers, and the Bill of Materials feature to list the stock items along with their required quantity details that can be allotted for the manufacture of a finished product.

The Bill of Materials (BoM) is highly useful for several reasons including:

  • Inventory Management: Businesses can use BoM to accurately track the quantities of raw materials and components required for manufacturing a finished product. This ensures that the necessary inventory levels are maintained, and businesses never run out of stock or have an overstocking situation.

  • Cost Estimation and Control: Businesses can get an accurate cost estimation for each unit of the finished product by listing all the components and their quantities in a BoM. This information is crucial for pricing decisions and cost control measures.

  • Regulatory Compliance: In industries with strict regulatory requirements, such as food, pharmaceuticals, or electronics, BoM assists in ensuring compliance by accurately documenting the composition of each product.

In TallyPrime, you can create a BoM for a stock item and list down all the raw materials and components along with their quantities required to build or create the stock item. Once you have created the BoM, you can record a Manufacturing Journal to record manufacturing transactions enlisting the raw materials or components and the finished product side by side. TallyPrime also gives you the facility to account for by-product, co-product, and scrap in Manufacturing Journal that may occur during the manufacturing of finished products. You can maintain damaged or scraped stock item details in TallyPrime using the Stock Journal voucher. You can also view the cost estimation reports to know the value of the cost incurred in the manufacturing of finished goods. Cost estimation helps fix the final product’s selling price after adding necessary costs and allowing a certain margin for profits.

Stock Journal

If you are involved in the manufacturing process in which raw materials are consumed and finished goods are produced, you can record it using the Stock Journal voucher.

  1. Press Alt+G (Go To) > Create Voucher > press Alt+F7 (Stock Journal).
    Alternatively, Gateway of Tally > Vouchers > press Alt+F7 (Stock Journal).
    In case the voucher is inactive, you will be prompted to activate the voucher type.
    Select Yes or press Y to proceed.
  2. Press F2 (Date) and change the date, if needed.
  3. Enter the reference number in Reference No. field, if any.
    1. If you do not see this option, press F12 (Configure) > set the option Provide Reference No. and Date as Yes.
    2. If you need to use this option only for the current voucher, press Ctrl+I (More Details) > type or select Provide Reference No. and Date > and press Enter.
  4. Provide the details of the goods at the source.
    1. Source (Consumption): Select the items consumed as raw material.
    2. Specify Quantity.
      The Rate and Amount field gets prefilled if you have specified it for the goods selected.
  5. Provide the details of the goods at the destination.
    1. Destination (Production): Select the items delivered as finished products.
    2. Specify Quantity.
      The Rate and Amount field gets prefilled if you have specified it for the goods selected.
  6. Provide Narration, if needed.
    STOCK JOURNAL
  7. As always, press Ctrl+A to save.

Bill of Materials for a Stock Item

Bill of Materials (BoM) is a list detailing the components and quantities needed to produce a product. It helps streamline stock reduction by automatically updating inventory. In TallyPrime, you can enable the BoM feature to create these lists. BoMs are necessary for items assembled in-house, not for trading items. They are used when creating or modifying stock items.

You can create single or multiple BOMS for an item depending on the business use case. For example, ou can create a single Bill of Materials (BoM) for a stock item when you use a consistent set of inputs to manufacture finished goods. Similarly, you can create multiple Bills of Materials (BoMs) for a stock item to accommodate varying component lists needed to manufacture specific finished goods. This feature allows you to select the appropriate BoM in the manufacturing voucher. It’s beneficial when you use different components based on customer requirements.

For example, if Customer A requests a cooker with specific rubber components, you can create a BoM tailored to their specifications. Meanwhile, you can maintain a standard BoM for other customers without specific requirements. This flexibility ensures efficient manufacturing processes based on customer needs.

In this section

Single/multiple bill of materials for a stock item

  1. Create a stock item.
  2. Enable BOM for the stock item and specify the BOM and component details.
    1. In the Stock Item Creation screen, set the option Set Components (BOM) to Yes and press Enter.
    2. Stock Item Multi Components (M BOM) screen appears as shown below.

      The Set Components (BOM)  option will not displayed in Stock Item master if the unit of measure in the Units field are not selected.

  3. Specify the BOM name and details.
    1. Under the Name of BOM specify the name as Standard and press Enter.
      BOM
       The Stock Item Components (BOM) screen appears.
  4. Specify the stock item components of the BOM.
    1. Unit of manufacture: Specify the appropriate number of finished products that will be manufactured by using the components entered in the component list.
    2. Item: In this field the raw materials that are required to manufacture the finished goods.
    3. Godown: Select the godown from which the item will be taken.
    4. Quantity: In this field, mention the quantity of stock item required to manufacture the finished goods.
      BOM WITHOUT ITEM TYPE
  5. Accept the screen. As always, you can press Ctrl+A to save.

If you want to add one more BOM for this item, enter the new BOM name under the Standard BoM and press Enter.
MULTIPLE BOM

Single/multiple bill of materials with type of item

In TallyPrime, you can create Bills of Materials (BoMs) for manufacturing processes and account for co-products, by-products, or scrap as well.

For example, in the manufacturing process of sugar, you can create a BoM that includes the main ingredients consumed to produce sugar, along with any co-products such as molasses or by-products such as bagasse or scrap generated during the process. This allows for comprehensive tracking and management of all components involved in the manufacturing process.

  1. On Stock Item Components (BOM) screen, press F12 (Configure) > set Define Type of Component for BOM to Yes to define the type of components.
    On enabling this option, a new column Type of Item will appear in the Stock Item Components (BOM) screen.
  2. Specify the stock item components of the BOM with the type of item.
    1. Item: In this field the raw materials that are required to manufacture the finished goods.
    2. Type of Item: In this field select the appropriate type for the item selected.
      • By-Product: Select this classification for the stock items which are produced as By-Product of finished goods.
      • Component: Select this classification for the Raw materials /inputs which are used or consumed for the production of finished goods.
      • Co-Product: Select this classification for the stock items which are produced as Co-product of finished goods.
      • Scrap: Select this classification for the stock item produced as scrap in the process of manufacture of finished goods.
    3. Quantity: Mention the quantity of stock items required to manufacture the finished goods.
    4. Rate (%): In this field, you can specify the percentage of the cost of components to be considered to determine the cost of production of Co-products/By-Products/Scrap.

      If the Component Type selected is Co-product/By-Product or Scrap, the cursor will move to the Rate (%) column to define the percentage of cost of production of Co-product/By-Product or Scrap.

  3. Press Enter to save the Stock Item components.
  4. Specify other required details in the stock item master.
  5. Accept the screen. As always, you can press Ctrl+A to save.

Copy components of BOM

In TallyPrime, you can copy the components of one BOM to another BOM. Instead of recreating similar BoMs from scratch, copying allows for quick replication of existing structures, saving time and effort.

For example, for the stock item Television, you have 2 BOM – Customer A and Standard. Now, Customer B wants the Television to be manufactured with a specific brand of Picture Tube – Picture Tube LG. Except Picture Tube, the components used to manufacture the Television will be the same as defined in Standard BOM. Hence, you can copy the components of standard BOM to Customer B BOM and only change the specific tube.

  1. Select the stock item to add a BOM.
    1. Press Alt+G (Go To) > Alter Master > type or select Stock Item > and press Enter.
      Alternatively, Gateway of Tally Alter > type or select Stock Item > and press Enter.
    2. Select the stock item from the List of Stock Items.
  2. In the Stock Item Alteration screen, enable the option Alter Components (BOM) to add a new BOM required to manufacture the television.
  3. In the Stock Item Multi Components (M BOM) screen, enter the name of the new BOM and press Enter.
  4. In the Stock Item Components (BOM) screen, press Ctrl+C (Copy BoM). 
  5. In the Copy BoM Details screen, select the stock item and component of BoM.
    1. Stock Item: Select the Stock Item from which the BOM is to be copied, You can select a different stock item from the list of Items, in which BOM is defined.
    2. Component of BOM: Select the BOM from which the components are to be copied for the selected Item.

      The components of Standard BoM will get copied to Customer B BoM.
    3. Unit of ManufactureSpecify the appropriate number of finished products that will be manufactured by using the components identified in the component list.
    4. Item: Select the Picture Tube – LG and Retain other items/components.

      Copy BOM option copies only the components of one BOM to another. Users have to define the Unit of Manufacture and Quantity of inputs (components).

  6. Accept the screen. As always, you can press Ctrl+A to save.

Record Manufacturing Journal Voucher

You can create a manufacturing journal and enter details of the components used to produce the finished goods along with the co-products/by-products/scrap produced during the manufacture of the finished goods.

In this section

Manufacture of finished goods without by-product/co-product/scrap

  1. Press Alt+G (Go To) > Create Voucher > press Alt+F7 (Stock Journal Journal).
    Alternatively, Gateway of Tally > Vouchers > press Alt+F7 (Stock Journal).
  2. Press Ctrl+H (Change Mode) and select Manufacturing Journal.
  3. Select the product, BOM and enter the quantity.
    1. Name of product: Select the products that is to be manufactured.
    2. Select the bill of material in the Name of BOM field.
      If there are multiple BOMs created for the product, then the BoM List will appear.
    3. Enter the quantity to be manufactured.
      The components used to manufacture the finished goods appear automatically.
      Since there are no Co-Products/By-Products/Scrap produced then the % of Cost allocation will be 100%.
  4. Under the Type of Additional Cost select the additional cost ledger, if any, and enter the Percentage.
    The total Cost of components and Type of Additional Cost incurred to manufacture the finished goods is displayed in the Effective Cost field.
    The per-piece cost of the primary item manufactured (finished item) is displayed in Effective rate of primary item field.
    The manufacturing journal appears as shown below:
    Manufacturing Journal
  5. Enter Narration, if required. As always, press Ctrl+A to save the journal.

Click here to see the F12 configurations for Manufacturing Journal voucher.

Options

Description

Skip the Date field
during voucher creation

By default, the cursor skips the Date field during Voucher creation. If you do not
want to skip the date field then set this option to No for faster Voucher entry.

Provide Reference No.
and Date

Enable this option to add the voucher reference field in Stock Journal also.

Provide  Additional
Descriptions for Stock Items

Can Provide the additional description for the stock Item in the transactions

Show message on negative
Stock Balance

By default, a warning message is displayed for negative stock balance. If you set it to No , the error message will not be displayed.

Use Expired Batches
for Stock items

By default, the expiry batches in the list of active batches during voucher entry are displayed. If you set it to No , expiry batches will not be displayed in the List of Active batches.

Show Batches with Zero
Quantity

It will display the zero quantity batches for the stock item

Show Balance as on Voucher
Date

By default, the ledger current balance up to last voucher entry date are displayed. If you set it to Yes , it will display the ledger balance up to current voucher entry date

Skip Co-product/By-Product/Scrap
details

When the option Skip Co-Product/By-Product/Scrap Stock Item is set to Yes , and while recording a manufacturing journal for a stock item
for which the BoM is created by capturing the details of Co-Products/ By-Products /Scrap ; then the configuration is ignored and the details of Co-Products/ By-Products /Scrap are captured. You can also modify the details in Co-Products/By-Products/Scrap section.

(For Manufacturring Journals only)

Show Compound Unit based
on Rate

Enable this option to show the compound unit of item based on the unit provided in the Rate Per column

Show details of Compound
Unit

Enable this option to display details of compound unit in the Quantity field. If Kgs is typed in Rate Per field, the Quantity field will display as 12 Kgs.250 grms

 

Manufacture of finished goods with by-product/co-product/scrap

  1. Press Alt+G (Go To) > Create Voucher > press Alt+F7 (Stock Journal Journal).
    Alternatively, Gateway of Tally > Vouchers > press Alt+F7 (Stock Journal).
  2. Press Ctrl+H (Change Mode) and select Manufacturing Journal.
  3. Select the product, BOM, and enter the quantity.
    1. Name of product: Select the products that is to be manufactured.
    2. Select the bill of material in the Name of BOM field.
      If there are multiple BOMs created for the product, then the BoM List will appear.
    3. Enter the quantity to be manufactured.
      The components used to manufacture the finished goods appear automatically along with the co-product/by-product/scrap.
      Since there are Co-Products/By-Products/Scrap produced then the % of Cost of allocation to the primary item = Total cost – Cost allocated to co-product/by-product/scrap.
  4. Under the Type of Additional Cost select the additional cost ledger, if any, and enter the Percentage.
    The total Cost of components and Type of Additional Cost incurred to manufacture the finished goods is displayed in the Effective Cost field.
    Allocation to Primary Item Effective Cost – Total cost of co-products/by-products/scrap.
    The per-piece cost of the primary item manufactured (finished item) is displayed in Effective rate of primary item field.
    The manufacturing journal appears as shown below:

  5. Enter Narration, if required. As always, press Ctrl+A to save the journal.

Generate Purchase Requisition for Manufacturing

You can create a user-defined optional voucher type under the Stock Journal voucher and record the requisition of items for manufacturing or consumption.

  1. Create a voucher type for purchase requisition under Stock Journal.
    1. Press Alt+G (Go To) > Create Master Voucher Type.
      Alternatively, Gateway of Tally > Create Voucher Type.
    2. Enter the Name of the voucher type.
    3. Select Stock Journal under the Select type of voucher.
    4. Enable the options Mark this voucher type as ‘Optional’ by default and Use as a Manufacturing Journal.
  2. Record the purchase requisition voucher.
    1. Press Alt+G (Go To) > Create Voucher F10 (Other Vouchers) > select Purchase Requisition > and press Enter.
      Alternatively, Gateway of Tally > Vouchers F10 (Other Vouchers) > select Purchase Requisition > and press Enter.
    2. To learn how to record a manufacturing journal voucher, refer to the Record Manufacturing Journal Voucher section. 

      The purchase requisition appears as shown below:

By following the outlined steps, you can streamline your requisition processes and improve inventory accuracy.

Maintain Damaged or Scrapped Stock Item Details

You can maintain damaged or scraped stock item details in TallyPrime by using the Stock Journal voucher.

  1. Create a Godown to maintain scrap items.
    To know how to create a godown in TallyPrime, refer to the Create Godowns/Locations section in the Manage Inventory Storage Using Godowns/Locations in TallyPrime.
  2. Create a Stock Journal voucher and enter the scrap details.
    1. Press Alt+G (Go To) > Create Voucher > press Alt+F7 (Stock Journal Journal).
      Alternatively, Gateway of Tally > Vouchers > press Alt+F7 (Stock Journal).
    2. Press Ctrl+H (Change Mode) and select Manufacturing Journal.
  3. Under Source (Consumption) enter the Name of Item.
  4. Select the Godown created for scrap items and enter the Rate and Quantity.

  5. Accept the screen. As always, press Ctrl+A to save.

    In stock journal, maintain the Destination (Production) column blank.

View damaged/scrapped Stock Item details

  1. Press Alt+G (Go To) > type or select Godown Summary > and press Enter.
    Alternatively, Gateway of Tally > Display More Reports > Inventory Books > Godowns.
  2. Select the Godown created for scrap items under Primary from the List of Godowns.

The damaged/scrapped item details are displayed.

Stock Cost Estimation

Cost Estimation gives the value of the cost incurred in the manufacturing of finished goods. To view the cost estimation of a particular finished product, select the relevant Stock Group which will display the stock consumption details and the cost thereof for each of the stock items falling under that Group.

Cost estimation helps fix the final product’s selling price after charging appropriate overheads and allowing a certain margin for profits. It also helps in Inventory Reports concluding the cost of production and determining the necessity to introduce cost-reduction techniques to improve the manufacturing process.

In this section

View Cost Estimates report

Press Alt+G (Go To) > type or select Cost Estimation > and press Enter.

Alternatively, Gateway of Tally > Display More Reports > Statements of Inventory > Cost Estimation.

The Item Estimates screen appears shown below:

Press F12 (Configure) to enable the options and view the required details.

  • Show Quantity: Displays the quantity of each stock item.
  • Show Alternate Units: Displays alternate units of measurement, if any.
  • Show Cost: Displays the cost of the stock item.
  • Show Amount: Displays the amount of the stock item.
  • Format of Report: Choose between Condensed or Detailed view.
  • Display name for Stock Items: Controls the appearance of stock item names.
  • Display name for Stock Items: 
  • Sorting Method: Sorts stock items alphabetically or by amount, quantity, or rate in increasing or decreasing order.

Rate per unit in Cost Estimate report vs Manufacturing Journal

The Item Estimate report shows the total cost of stock items including all expenses from purchase to sale. In contrast, the effective rate per unit in a manufacturing journal only considers expenses during manufacturing. Consequently, the per-item cost in the manufacturing journal may differ from the cost in the Item Estimate report.

TallyHelpwhatsAppbanner
Is this information useful?
YesNo
Helpful?