FrontAccounting-2.4.7/C2/Items-and-Inventory-in-FrontAccounting/English

From Script | Spoken-Tutorial
Revision as of 11:30, 6 November 2019 by Nirmala Venkat (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Visual Cue Narration
Slide 1:

Items & Inventory

Welcome to the spoken tutorial on Items and Inventory in FrontAccounting.
Slide 2:

Learning Objectives

In this tutorial, we will learn to add the following in FrontAccounting:
  • Units of Measure
  • Items
  • Item Category and
  • Sales Pricing
Slide 3:

System Requirements

To record this tutorial, I am using
  • Ubuntu Linux OS version 16.04
  • FrontAccounting version 2.4.7
Slide 4:

Pre -requisites

To practise this tutorial, you must have knowledge of:

  • Higher secondary commerce & accounting
  • Principles of Bookkeeping
To practise this tutorial you must have knowledge of
  • Higher secondary commerce and accounting and
  • Principles of Bookkeeping
You should have already
  • Set up an Organisation/Company in FrontAccounting

If not, for relevant FrontAccounting tutorials please visit https://spoken-tutorial.org

And you should have already set up an Organisation/Company in FrontAccounting.

If not, for relevant FrontAccounting tutorials please visit this website.

Slide 5:

Start XAMPP service

Start the XAMPP services before you begin working on FrontAccounting interface.
Narration Before we start, let us understand what are Items in FrontAccounting.
Slide 6:

Items

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

Inventory

Inventory is a complete listing of
  • Stock in hand,
  • Work in progress,
  • Raw materials and
  • Finished goods in hand.
Narration Let us open the Frontaccounting interface.
Open browser >>localhost/account >> Press Enter Open the browser and type localhost slash account and press Enter.
Point to the page The login page appears.
Enter Username and Password >>

Click on the Login button

Type the username as admin and the password.

Click on Login button.

Narration The Frontaccounting interface opens.
Click on Items and Inventory Click on the Items and Inventory tab.
Point to the Maintenance panel.
  • Items
  • Units of Measure
  • Item Categories
Maintenance panel is used to set up Items and Inventory details.

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

  • Units of Measure
  • Items and
  • Item Categories
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.
Click on the Units of Measure option.

Point to default units

In the Maintenance panel, click on Units of Measure link.

By default you will see Each and hr as units of measure.

Narration Let us see how to add a new Units of Measure for kilograms.
Pause the tutorial here and fill in all the details
  • Unit Abbreviation - Kgs
  • Descriptive Name - Kilograms
  • Decimal Places - 0
Type the details for the unit kilograms as shown here.

In the Decimal places drop-down box, select zero.

Click Add new button

Point to the message prompted

“New unit has been added.”

Click on the Add new button at the bottom of the window 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.

Likewise you have to add the required Units of measure for your company’s items.

Click on the Back option. Click on Back link at the bottom of the window to go back to the FrontAccounting interface.
Point to Item Categories Now let us set the Item Categories to which the item belongs.

Item Categories helps us to group the items we buy and sell.

Click on Item Categories link. Click on Item Categories link.

We can see some default Item categories here - Charges, Components, Services and Systems.

Point to the Item Category option
  • Item tax type,
  • Item Type and
  • Units of Measure
We need to create our own Item category, which defines.
  • Item tax type,
  • Item Type and
  • Units of Measure

Say for example our company deals with finished goods i.e Laptops

So we will add a new Item category named Finished Goods.

Fill the details as shown here.
  • Category Name – Finished Goods
  • Item Tax Type - Regular
  • Item Type - Purchased
  • Units of Measure - Each

Default values:

  • Exclude from Sales
  • Sales Account
  • Inventory Account
  • C.O.G.S Account
  • Inventory Adjustment Account
  • Item Assembly Costs Account
Fill the details as shown here.
  • Category Name – Finished Goods
  • Item Tax Type - Regular
  • Item Type - Purchased
  • Units of Measure - Each

Keep all the remaining fields with default values.

Click on Add New button Click on the Add New button at the bottom of the window to save the entry.
Point to the newly added detail We can see that the newly added details are updated in the above table.

Click on Back link at the bottom of the window to go back to the FrontAccounting interface.

Narration Next let us create a new Item for this Item category.
Click on the Items option under Maintenance panel. In Maintenance panel, click on the Items link.
Highlight with a red box
  • Item Code - 8090
  • Name - Dell Laptop
  • Description - Dell Vostro 3480 Intel Core i3 8th Gen 14-inch HD Thin & Light Laptop
  • Category - Finished goods
  • Item tax type - Regular
  • Item type - Purchased
  • Units of Measure - Each
Here, we are prompted to fill in all the necessary information for the item.

Fill the details as shown here.

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

This is mandatory.

Point on Category Category is the Item category to which the item belongs.

We have selected Finished goods.

Point to Item type and click on the dropdown box and show
  • manufacturing
  • service
  • purchased
Item type is to know whether the item is used for:
  • manufacturing purpose
  • purchased from a supplier or
  • for a service
Scroll down.

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 at the bottom of the window.

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 drop-down box at the top of the window.

We can see that the new item has been added.

Slide 9:Assignment As an assignment:
  • Add two new items under Item category- Finished goods
  • Add two new items under Item category- Components
  • Refer to the Assignment link of this tutorial for details
Show the drop down box After completing the assignment, click on the drop-down box at the top of the window.

Now you should see 2 items under Components and 3 items under Finished goods.

Click on the Back option. Click on Back link at the bottom of the window to go back to the Frontaccounting interface.
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 the items or inventory.
Point on the Sales Pricing option This option is used to assign sales prices to individual Sales item.

Click on the Sales Pricing link.

Point and click on the dropdown box Click on the Item drop-down box.

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

Click>>Currency>> dropdown box.

Select the Indian Rupees option from the dropdown box

Now, click on the Currency drop-down box.

Select the currency as Indian 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 drop-down box.

There are two options:

  • Retail and
  • Wholesale

Here select the option, Retail.

Click>>Price>> dropdown box.

Type the amount for the Item.

Next, click on the Price field.

Type the Price against the Item as 53,000 per each.

Click on Add new button

Point to the message prompted

“The new price has been added.

Then click on Add New button at the bottom of the window.

The pop-up message shows that we have successfully added a Sales price for the item Dell Laptop.

Point to the above table with the updated entry being made. We can also see updated values in the table here.
Click on the Back option. Click on Back option at the bottom of the window to return back to the Frontaccounting interface.
Slide 9: This brings us to the end of this tutorial.

Let us summarize.

In this tutorial, we have learnt how to create,

  • Units of Measure
  • Items
  • Item Category and
  • Sales Pricing
Slide 10:Assignment As an assignment, add the sales price for the items shown below:
Item Price
Samsung Laptop 48,000
Lenovo Laptop 40,000
Motherboard 6,000
LCD Screen 5,000

Keep the Sales Type as Retail.

Slide 10:

Acknowledgement

Acknowledgement
  • The video at the following link summarises the Spoken Tutorial project.
  • Please download and watch it
Slide 11: The Spoken Tutorial Project Team conducts workshops and gives certificates.

For more details, please write to us.

Slide 12:

Forum for specific questions:

Please post your timed queries in this forum. 
Slide 13:

Acknowledgement

Spoken Tutorial project is funded by NMEICT, MHRD, Government of India.

More information on this mission is available at this link.

The script and video has been contributed by Spoken Tutorial team. This is Pratik Kamble signing off. Thanks for joining.

Contributors and Content Editors

Nancyvarkey, Nirmala Venkat