FrontAccounting/C2/Items-and-Inventory/English

From Script | Spoken-Tutorial
Jump to: navigation, search

Title of the Script : Items and Inventory in FrontAccounting Author: Sheetal Prabhu Keywords: Items, Inventory, Units of Measure, Item Category, Sales Pricing

Visual Cue
Narration
Slide Number 1

Title Slide

Hello everyone,

Welcome to this tutorial on Items & Inventory in FrontAccounting.

Slide Number 2 In this tutorial, we will learn to set:
  • Units of Measure
  • Items
  • Item Category and
  • Sales Pricing
Slide Number 3

System Requirements

To record this tutorial, I am using
  • Ubuntu Linux OS version 14.04
  • FrontAccounting version 2.3.25
Slide Number 4

Pre -requisites

To practise this tutorial you should have
  • Knowledge of Higher Secondary Commerce or
  • Knowledge of Accounting
Narration Before we start let us understand the meaning of Items.
Slide Number 5

What is Items?

  • Items are the things which you can buy or sell in the business.
  • We have to keep a record that lists key information about an inventory item.
Slide Number 6

What is Inventory?

Now, let us see the meaning of Inventory.

It is a complete listing of

  • Stock in hand,
  • Work in progress,
  • Raw Materials and
  • Finished goods in hand.
Narration Let us start by opening the Frontaccounting interface.
Click on browser >>localhost/account >> Press Enter Click on the browser.

Type localhost/account

and press Enter.

Enter Username and Password >>

Click on the Login button

The login page appears.

Here, type the username as admin and the password.

Click on Login button.

Narration

Point and click on the >> Items and Inventory Tab>>

Frontaccounting window opens.

Click on the Items and Inventory tab.

Point to the page and various panels. The page opens, and we can see various panels.
Point to the Transactions panel. Under Transaction panel, we can see the options:
  • Inventory Location Transfers and
  • Inventory Adjustments
Point to the Inquiries and Reports

Point to the options under Inquiries and Reports.

Inquiries and Reports panel is used for making reports and inquiries.

Here, we have the options:

  • Inventory Item Movements
  • Inventory Item Status and
  • Inventory Reports
Point to the Maintenance panel.
  • Items
  • Units of Measure
  • Item Categories
Maintenance panel is used for setup of Items and Inventory details.

To do the setup, we have to make use of the following options:

  • Items
  • Units of Measure and
  • Item Categories
Point to Pricing and Costs Panel

Point the option under Pricing and Costs panel

Pricing and Costs panel is used for selecting the pricing level of items or inventory.

For this, we have to use the option:

  • Sales Pricing
Narration Let us see how to set Units of Measure.
Point to the Units of Measure Units of Measure option has to be specified for each Item.
Slide Number 7
Units of Measure chart
Here, we can see the chart which represents the Units of Measure.

The chart shows:

  • Physical quantity measured
  • Base unit and
  • SI abbreviation
Point to the substance under physical quantity measured.

Point to the Scale under physical quantity measured.

We can see the Base unit of a substance is mole and the SI unit abbreviation is mol.


Likewise, base unit of scale is meter and the abbreviation is m.

Return back to the Frontaccounting interface. Now, switch back to the Frontaccounting interface.
Click on the Units of Measure option. Click on Units of Measure option.
Fill in the appropriate fields:
  • Unit Abbreviation
  • Descriptive Name
  • Decimal Places
Here, we are prompted to fill in all the necessary information pertaining to the Units of Measure.
Pause the tutorial here and fill in all the details
  • Unit Abbreviation
  • Descriptive Name
  • Decimal Places

Resume the tutorial

Point to the filled boxes
  • Unit Abbreviation
  • Descriptive Name
  • Decimal Places
I have filled these details here.

Pls fill the details likewise.

Click>> Add new>> button

Point to the message prompted

“New unit has been added.”

Click on the Add new button to add this unit.

The pop up message shows that we have successfully added a new unit.

Highlight with red box showing the entry updated in the table. We can also see the table with the updated entry.
Click on the Back option. <<PAUSE>>

Click on the Back option to return back to the Frontaccounting interface.

Narration Let us now set the Items.
Click on the Items option under Maintenance panel. Click on the Items under Maintenance panel.
Click>> Dropdown box>>

Narration

You may see the default Items in the list.

We can also create a new Item as required.


I will demonstrate.

Fill in the appropriate fields:
  • Item Code
  • Name
  • Description
  • Components
  • Item tax type
  • Item type
  • Units of Measure
Here, we are prompted to fill in all the necessary information pertaining to the items.
Pause the tutorial here and fill in all the details
  • Item Code
  • Name
  • Description
  • Components
  • Item tax type
  • Item type
  • Units of Measure

Resume the tutorial

Highlight with a red box
  • Item Code
  • Name
  • Description
  • Components
  • Item tax type
  • Item type
  • Units of Measure
I have filled these details here.

Pls fill the details likewise.


Make sure that you give the unique code for each item you fill.

Click>> Insert New Item button>>

Point to the message prompted

“A new item has been added.”

Scroll down.


And then click on the Insert New Item button.


The pop-up message shows that we have successfully added a new item.

Click on the Dropdown box showing the added new item in the list. Click on the dropdown box, we can see the new item is added.
Click on the Back option. <<PAUSE>>

Scroll down.


And click on the Back option to return back to the Frontaccounting interface.

Narration

Click on the Item Categories option.

Let us now set the Item Categories to which item belongs.

Click on it.

Point to the Item Category option
    • Item tax type,
    • Item Type and
    • Units of Measure.
Scroll down to see the details.

We have to create our own Item category, which defines.

    • Item tax type,
    • Item Type and
    • Units of Measure.
Highlight with red box
  • Category Name
  • Item Tax Type
  • Item Type
  • Units of Measure
  • Exclude from Sales
  • Sales Account
  • Inventory Account
  • C.O.G.S Account
  • Inventory Adjustments Account
  • Item Assembly Costs Account
Here, we are prompted to fill in all the necessary information pertaining to the Item Category.
Pause the tutorial,
  • Category Name
  • Item Tax Type
  • Item Type
  • Units of Measure
  • Exclude from Sales
  • Sales Account
  • Inventory Account
  • C.O.G.S Account
  • Inventory Adjustments Account
  • Item Assembly Costs Account

fill in all the details in the corresponding field. Resume the tutorial

Point the options in the Item Category.
  • Category Name
  • Item Tax Type
  • Item Type
  • Units of Measure
  • Exclude from Sales
  • Sales Account
  • Inventory Account
  • C.O.G.S Account
  • Inventory Adjustment Account
  • Item Assembly Costs Account
I have filled these details here for-
  • Category Name
  • Item Tax Type
  • Item Type
  • Units of Measure
  • Exclude from Sales
  • Sales Account
  • Inventory Account
  • C.O.G.S Account
  • Inventory Adjustment Account
  • Item Assembly Costs Account

I will keep it as it is.

Pls fill the details likewise.

Click on Add new button

Point to the message prompted

“A new item has been added.”

Click on Add New button to save the entry made.


The pop up message shows that we have successfully added a new item.

Point to the above table with the updated entry being made. We can see the above table with the details updated here.
Click on the Back option. <<PAUSE>>

Scroll down.


Click on the Back option to return back to the Frontaccounting interface.

Narration Let us see the Sales Pricing.
Point on the Sales Pricing option This option is used to assign sales prices to individual Sales item.
Click on the Sales Pricing under Pricing and Costs panel. Click on the Sales Pricing option.
Point and click on the dropdown box Click on the dropdown box.

Select the item for which we want to assign the Sales Price.

Select the Item as cement from the dropdown box. I will select the item as Cement.

This is because we will use this item for Sales purpose in the Sales in Frontaccounting tutorial.

Click>>Currency>> dropdown box.

Select the Rupees option from the dropdown box

Now, click on the Currency dropdown box.

I will select the currency as Rupees.

Click>>Sales Type>> dropdown box.

Select the drop down box showing the two options.

Narration Select >> Wholesale>> from the drop down box

Click on the Sales Type dropdown box.

There are two options:

  • Retail and
  • Wholesale

How to setup the Sales Type option is explained in the Sales in Frontaccounting tutorial.

So, here I will select Wholesale.

Click>>Price>> dropdown box.

Type the amount for the Item.

Click on the Price field.

I will type the Price against the Item as 5,000 per Kg.

Click on Add new button

Point to the message prompted

“The new price has been added.”

Click on Add New button.

The pop up message shows that we have successfully added a Sales price against the item Cement.

Point to the above table with the updated entry being made. We can also see the table here which we have updated.
Click on the Back option. <<PAUSE>>

Click on the Back option to return back to the Frontaccounting interface.

Narration Let us summarize.
Slide Number 8 In this tutorial, we have learnt to create,
  • Units of Measure
  • Items
  • Item Category and
  • Sales Pricing
Slide Number 9

Assignment

As an Assignment.
  • Add a new item as Steel with an unique code 46 in the Items & Inventory tab.
  • Create a new Item Category using the above added item.
Slide Number 10

Acknowledgement

Acknowledgement

This video summarizes the Spoken Tutorial project. Please download and watch it.

Slide Number 11 We conduct workshops using Spoken Tutorials and give Certificates.

For more information, please contact us.

Slide Number 12 The Spoken Tutorial Project is funded by NMEICT, MHRD Government of India.

This tutorial has been contributed by Sheetal Prabhu from IIT Bombay. Thank you for joining.

Contributors and Content Editors

Nancyvarkey, Sandhya.np14, Sheetal