Difference between revisions of "FrontAccounting/C2/Items-and-Inventory/English"

From Script | Spoken-Tutorial
Jump to: navigation, search
(Created page with "'''Title of the Script :''' '''Items and Inventory''' '''in FrontAccounting''' '''Author: Sheetal Prabhu''' '''Keywords: Items, Inventory, Units of Measure, Item Category, Sal...")
 
 
(5 intermediate revisions by 3 users not shown)
Line 47: Line 47:
 
| style="border:1pt solid #000000;padding:0.097cm;"| '''Slide Number 5'''
 
| style="border:1pt solid #000000;padding:0.097cm;"| '''Slide Number 5'''
  
−
| style="border:1pt solid #000000;padding:0.097cm;"| '''What is Items?'''
+
'''What is Items?'''
  
 +
| style="border:1pt solid #000000;padding:0.097cm;"|
 
* '''Items '''are the things which you can buy or sell in the business.
 
* '''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.
+
* We have to keep a record that lists key information about an '''inventory item'''.
 
|-
 
|-
 
| style="border:1pt solid #000000;padding:0.097cm;"| '''Slide Number 6'''
 
| style="border:1pt solid #000000;padding:0.097cm;"| '''Slide Number 6'''
  
−
| style="border:1pt solid #000000;padding:0.097cm;"| Now, let us see the meaning of Inventory.
+
'''What is Inventory?'''
 +
| style="border:1pt solid #000000;padding:0.097cm;"| Now, let us see the meaning of '''Inventory'''.
 +
 
 
It is a complete listing of  
 
It is a complete listing of  
 
* Stock in hand,  
 
* Stock in hand,  
Line 66: Line 69:
 
|-
 
|-
 
| style="border:1pt solid #000000;padding:0.097cm;"| Click on''' browser''' >>'''localhost/account''' >> Press '''Enter'''
 
| style="border:1pt solid #000000;padding:0.097cm;"| Click on''' browser''' >>'''localhost/account''' >> Press '''Enter'''
−
| style="border:1pt solid #000000;padding:0.097cm;"| Click on the browser, type''' localhost/account'''
+
| style="border:1pt solid #000000;padding:0.097cm;"| Click on the browser.
 +
 
 +
Type''' localhost/account'''
 +
 
 
and press''' Enter.'''
 
and press''' Enter.'''
  
Line 75: Line 81:
 
| style="border:1pt solid #000000;padding:0.097cm;"| The''' login''' page appears.
 
| style="border:1pt solid #000000;padding:0.097cm;"| The''' login''' page appears.
  
−
Here, type the username as''' admin''' and the password.
+
Here, type the '''username''' as''' admin''' and the '''password'''.
  
 
Click on '''Login''' button.
 
Click on '''Login''' button.
Line 129: Line 135:
  
 
Point the option under '''Pricing and Costs''' panel
 
Point the option under '''Pricing and Costs''' panel
−
| style="border:1pt solid #000000;padding:0.097cm;"| '''Pricing '''and''' Cost '''panel''' '''is used for selecting the pricing level of '''items '''or '''inventory'''.
+
| style="border:1pt solid #000000;padding:0.097cm;"| '''Pricing and Costs '''panel is used for selecting the pricing level of '''items '''or '''inventory'''.
  
 
For this, we have to use the option:
 
For this, we have to use the option:
  
 
* '''Sales Pricing'''
 
* '''Sales Pricing'''
−
 
 
|-
 
|-
 
| style="border:1pt solid #000000;padding:0.097cm;"| Narration
 
| style="border:1pt solid #000000;padding:0.097cm;"| Narration
Line 151: Line 156:
  
 
* '''Physical quantity measured'''
 
* '''Physical quantity measured'''
−
* '''Base unit and '''
+
* '''Base unit''' and
−
* '''SI abbreviation'''
+
* '''SI''' abbreviation
 
|-
 
|-
 
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding:0.097cm;"| Point to the '''substance''' under physical quantity measured.
 
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding:0.097cm;"| Point to the '''substance''' under physical quantity measured.
  
 
Point to the '''Scale''' under physical quantity measured.
 
Point to the '''Scale''' under physical quantity measured.
−
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding:0.097cm;"| We can see the '''Base unit''' of a substance is '''mole''' and the SI unit abbreviation is '''mol'''.
+
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding:0.097cm;"| 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.'''
 
Likewise, base unit of '''scale''' is '''meter''' and the abbreviation is '''m.'''
Line 165: Line 171:
  
 
|-
 
|-
−
| style="border-top:0.75pt solid #000000;border-bottom:1pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding:0.097cm;"| Click on the''' Units of''' '''Measure''' option.
+
| style="border-top:0.75pt solid #000000;border-bottom:1pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding:0.097cm;"| Click on the''' Units of Measure''' option.
 
| style="border-top:0.75pt solid #000000;border-bottom:1pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding:0.097cm;"| Click on '''Units of Measure''' option.
 
| style="border-top:0.75pt solid #000000;border-bottom:1pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding:0.097cm;"| Click on '''Units of Measure''' option.
  
Line 175: Line 181:
 
* '''Decimal Places'''
 
* '''Decimal Places'''
  
−
| style="border:1pt solid #000000;padding:0.097cm;"| '''Here, we are prompted to fill in all the necessary information pertaining to the Units of Measure.'''
+
| style="border:1pt solid #000000;padding:0.097cm;"| Here, we are prompted to fill in all the necessary information pertaining to the '''Units of Measure.'''
  
 
|-
 
|-
Line 202: Line 208:
  
 
'''“New unit has been added.”'''
 
'''“New unit has been added.”'''
−
| style="border:0.75pt solid #000000;padding:0.106cm;"| Click on the '''Add''' '''new''' button to '''add''' this unit.
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| Click on the '''Add''' '''new''' button to '''add''' this '''unit'''.
  
−
The pop up message shows that we have successfully added a new unit.
+
The pop up message shows that we have successfully added a new '''unit'''.
  
 
|-
 
|-
Line 231: Line 237:
  
 
We can also create a new '''Item''' as required.
 
We can also create a new '''Item''' as required.
 +
  
 
I will demonstrate.
 
I will demonstrate.
Line 245: Line 252:
 
* '''Units of Measure'''
 
* '''Units of Measure'''
  
−
| style="background-color:#ffffff;border:0.75pt solid #000000;padding:0.106cm;"| '''Here, we are prompted to fill in all the necessary information pertaining to the items.'''
+
| style="background-color:#ffffff;border:0.75pt solid #000000;padding:0.106cm;"| Here, we are prompted to fill in all the necessary information pertaining to the '''items'''.
  
 
|-
 
|-
Line 276: Line 283:
 
Pls fill the details likewise.
 
Pls fill the details likewise.
  
−
Make sure that you give the unique code for each item you fill.
+
 
 +
Make sure that you give the unique code for each '''item''' you fill.
  
 
|-
 
|-
Line 283: Line 291:
  
 
'''“A new item has been added.”'''
 
'''“A new item has been added.”'''
−
| style="border:0.75pt solid #000000;padding:0.106cm;"| Scroll down and then click on the '''Insert New Item''' button.
+
| style="border:0.75pt solid #000000;padding:0.106cm;"| Scroll down.
  
−
The pop-up message shows that we have successfully added a new item.
+
 
 +
And then click on the '''Insert New Item''' button.
 +
 
 +
 
 +
The pop-up message shows that we have successfully added a new '''item'''.
  
 
|-
 
|-
Line 295: Line 307:
 
| style="border-top:0.75pt solid #000000;border-bottom:1pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding:0.097cm;"| <nowiki><<PAUSE>></nowiki>
 
| style="border-top:0.75pt solid #000000;border-bottom:1pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding:0.097cm;"| <nowiki><<PAUSE>></nowiki>
  
−
Scroll down and click on the '''Back''' option to return back to the '''Frontaccounting''' interface.
+
Scroll down.
 +
 
 +
 
 +
And click on the '''Back''' option to return back to the '''Frontaccounting''' interface.
 
|-
 
|-
 
| style="border:1pt solid #000000;padding:0.097cm;"| Narration
 
| style="border:1pt solid #000000;padding:0.097cm;"| Narration
Line 384: Line 399:
 
'''“A new item has been added.”'''
 
'''“A new item has been added.”'''
  
−
| style="border:1pt solid #000000;padding:0.097cm;"| Click on '''Add''' '''New''' button to save the entry made.
+
| style="border:1pt solid #000000;padding:0.097cm;"| Click on '''Add New''' button to save the entry made.
  
−
The pop up message shows that we have successfully added a new unit.
+
 
 +
The pop up message shows that we have successfully added a new '''item'''.
  
 
|-
 
|-
Line 396: Line 412:
 
| style="border:1pt solid #000000;padding:0.097cm;"| <nowiki><<PAUSE>></nowiki>
 
| style="border:1pt solid #000000;padding:0.097cm;"| <nowiki><<PAUSE>></nowiki>
  
−
Scroll down, click on the '''Back''' option to return back to the '''Frontaccounting''' interface.
+
Scroll down.
 +
 
 +
 
 +
Click on the '''Back''' option to return back to the '''Frontaccounting''' interface.
  
 
|-
 
|-
Line 404: Line 423:
 
|-
 
|-
 
| style="border:1pt solid #000000;padding:0.097cm;"| Point on the '''Sales Pricing''' option
 
| style="border:1pt solid #000000;padding:0.097cm;"| Point on the '''Sales Pricing''' option
−
| style="border:1pt solid #000000;padding:0.097cm;"| This option is used to assign '''sales prices''' to individual '''sales''' '''item'''.
+
| style="border:1pt solid #000000;padding:0.097cm;"| This option is used to assign '''sales prices''' to individual '''Sales item'''.
  
 
|-
 
|-
Line 414: Line 433:
 
| style="border:1pt solid #000000;padding:0.097cm;"| Click on the dropdown box.
 
| style="border:1pt solid #000000;padding:0.097cm;"| Click on the dropdown box.
  
−
Select the '''item''' for which we want to assign the Sales Price.
+
Select the '''item''' for which we want to assign the '''Sales Price'''.  
−
 
+
−
I will demonstrate.
+
  
 
|-
 
|-
 
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding:0.097cm;"| Select the '''Item''' as '''cement''' from the dropdown box.
 
| style="border-top:1pt solid #000000;border-bottom:0.75pt solid #000000;border-left:1pt solid #000000;border-right:1pt solid #000000;padding:0.097cm;"| Select the '''Item''' as '''cement''' from the dropdown box.
−
| style="border:1pt solid #000000;padding:0.097cm;"| I will select the Item as '''Cement.'''
+
| style="border:1pt solid #000000;padding:0.097cm;"| I will select the '''item''' as '''Cement.'''
  
−
This is because we will use this '''item '''for Sales purpose in next tutorial named '''Sales in Frontaccounting.'''
+
This is because we will use this '''item '''for Sales purpose in the '''Sales in Frontaccounting''' tutorial.
  
 
|-
 
|-
Line 442: Line 459:
 
* '''Retail '''and
 
* '''Retail '''and
 
* '''Wholesale'''
 
* '''Wholesale'''
−
How to setup the '''Sales''' '''Type''' option is explained in the '''Sales in Frontaccounting''' tutorial.
+
 
 +
How to setup the '''Sales Type''' option is explained in the '''Sales in Frontaccounting''' tutorial.
 +
 
 
So, here I will select '''Wholesale'''.
 
So, here I will select '''Wholesale'''.
  
Line 458: Line 477:
 
'''“The new price has been added.”'''
 
'''“The new price has been added.”'''
 
| style="border:1pt solid #000000;padding:0.097cm;"| Click on '''Add''' '''New''' button.
 
| style="border:1pt solid #000000;padding:0.097cm;"| Click on '''Add''' '''New''' button.
−
The pop up message shows that we have successfully added a sales price against the '''item Cement'''.
+
 
 +
The pop up message shows that we have successfully added a '''Sales price''' against the '''item Cement'''.
  
 
|-
 
|-
Line 480: Line 500:
 
* '''Units of Measure'''
 
* '''Units of Measure'''
 
* '''Items'''
 
* '''Items'''
−
* '''Item Category'''
+
* '''Item Category''' and
 
* '''Sales Pricing'''
 
* '''Sales Pricing'''
 
|-
 
|-
Line 488: Line 508:
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| As an''' Assignment.'''  
 
| style="border:0.75pt solid #000000;padding:0.106cm;"| As an''' Assignment.'''  
  
−
* Add a new '''item '''as''' Steel '''with an '''unique''' '''code 46 '''in the '''Items''' '''& Inventory''' tab.
+
* 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'''.
 
* Create a new '''Item Category''' using the above added '''item'''.
  

Latest revision as of 09:49, 19 July 2016

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

Retrieved from "https://script.spoken-tutorial.org/index.php?title=FrontAccounting/C2/Items-and-Inventory/English&oldid=27426"