www.TallyERP9Help.Com

Stock Item Analysis  in Tally.ERP 9

Item Movement Analysis

Item Movement Analysis is the next level of information (press Enter on the Stock Item or Display > Inventory Books > Stock Item Analysis). This brings up the Party-wise/Transfer-wise detail of Movements. The Inward detail displays the Basic Invoice Rate and Effective Rate.

To view Stock Item Movement Analysis,

Go to Gateway of Tally > Display-Inventory Books > Movement Analysis > Stock Item Analysis

 
[Img-90]

This report will help you in comparing Purchase Costs across suppliers.

Press Enter on the Party Name or Stock Journal Name to display the transaction-level details on Date of goods received/sold, Quantities, Basic Rates, Addl. Costs, and Effective Rate for each transaction.


[Img-91]

The default screen displays the Addl.Costs (if any), in a single column. To view the spread of costs, press F12: Configure and select to view Show Addl. Costs.

 
[Img-92]

This brings up the bifurcation of all Additional Costs.


[Img-93]

The report displays every purchase made during the period specified with break-down of Basic Value and Additional Cost. You can also view the above reports in the Alternate Unitsand Tail units of Compound Units.

F12: Configuration in Stock Item Movement Analysis Report

To view configuration screen, press F12: Configure from Stock Item Movement Analysis report


[Img-94]

Show Supplier’s Section

Supplier wise i.e., details of all the suppliers for the particular stock item will be displayed.

Show Transfers Inward (Production) Section

Vouchers of Stock Journals or Manufacturing Journals (Production) for the particular item will be display here

Show Buyer’s Section

Buyer wise i.e., details of all the Buyers for the particular stock item will be displayed.

Show Transfers Outward (Consumption) Section

Vouchers of Stock Journals or Manufacturing Journals (Consumption) for the particular item will be display here

The Configuration settings Show Quantities, Show Rates, Show Values are self explanatory.

Buttons available in the Stock Item Movement Analysis screen:

Buttons

Shortcut Keys

Description and Use

F4:Item

F4

Navigation to other Stock Item from the same report is possible.

C:New Column

Alt + C

You can view the report of various Stock Items in the single screen. In the column details screen under ‘Name of Item’ select the required item, ‘New Column’ will be displayed in the existing screen along the item selected earlier.

A:Alter Column

Alt + A

If you like to alter the existing stock item display and like to view the report of other stock item, ‘Alter Column’ can be selected

N:Auto Column

Alt + N

This option will enable you to view the report Weekly, Fortnightly, Monthly, Yearly, Orders & Stock Details, Stock Valuation methods, etc, of all Stock Item.

Further drill down from Movement Inward or Movement Outward will display the Item Voucher Analysis report.


[Img-95]

Voucher entries for the particular stock item will be displayed here. The details of the stock item along with Basic Value, Addl. Cost, Eff. Rate etc will be displayed here.

Click on F12: Configure or press F12 to change the default display of Item Voucher Analysis report.


[Img-96]

F12: Configuration in Item Voucher Analysis Report

Show Addl.Cost Column

If any of the vouchers raised with the Addl.cost details, it will display the details of the same.

Show Full Addl.Cost Details

By default this option will be set ‘No’, if you like to view the report will details of the addl costs, then set this option so ‘Yes’, it will display the details of the Addl. Cost.

Format

You can select the format ‘Condensed’ or ‘Detailed’ to view the report.

Show Narrations

Once you set the Format as Detailed it will display the option. Once you set this option to Yes it will display the narration for the vouchers.

Show Billed Qty Column  

The quantities displayed are Actual Quantities of movement (which, in some cases, may be different from the Billed Qty in the transactions.) then set this option to ‘Yes’.

Show using Alternate Units

By default this option will be set to ‘No’, if you like to view the ‘Alternate units’ details of the stock item then set it to ‘Yes’.

Show Tail Units of Compound Units

By default this option will be set to ‘No’, if you like to view the ‘Compound units’ details of the stock item then set it to ‘Yes’.

The Configuration settings Show Base Rate Column, Show Base Value Column are self explanatory.

Show Total Value

Total Value = Basic Value + Addl.Cost

Show Eff.Rate Column

Eff. Rate = Total Value / Quantity

Buttons available in the Item Voucher Analysis screen:

Buttons

Shortcut Keys

Description and Use

F4:Item

F4

Navigation to other Stock Item from the same report is possible.

F5:Vch Type

F5

If you drill down from Transfers Inwards or Transfers Outwards it will display the F5:Vch Type or if we drill down from Suppliers or Buyers  it will display F5:Ledgers. The navigation to other voucher types or ledgers from the same screen is possible.


 
 
 
 
Tally.ERP 9 Reference Manual LIBRARY
1.
Installation of Tally.ERP9
2.
Site Licensing of Tally.ERP9
3.
Shortcut Keys in Tally.ERP9
4.
Maintaining Company Data
5.
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
6.
Voucher Entry
7.
Reports in Tally.ERP9
8.
Excise for Dealer
9.
Excise for Manufacturer
10.
Reports [ Excise for Manufacturer]
11.
Excise for Importer
12.
Service Tax in Tally.ERP9
13.
Tax Collected at Source (TCS) in Tally.ERP9
14.
Tax Deducted at Source (TDS) in Tally.ERP9
15.
Value Added Tax (VAT) in Tally.ERP9
16.
Central Sales Tax (CST) in Tally.ERP9
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
Our Portal : www.TallyERP9Book.Com www.IncomeTaxManagement.Com www.Tally9Book.com www.TallyERP9Help.Com
Disclaimer :
Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.
The visitors may click here to visit the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications