This report shows the details of inward and outward transactions carried out for all the stock items in that group.
To view Item Movement Analysis for a specific stock group:
Go to Gateway of Tally > Display > Inventory Books > Movement Analysis > Stock Group Analysis > Select Name of the group
Movement Analysis of a selected stock group displays the Total Inward and Outward movement of all the items in a selected Stock Group.
The quantities displayed are Actual Quantities of movement (which, in some cases, may be different from the Billed Qty in the transactions.)
The Inward detail displays the Effective Rate or Final Landed Cost of the materials, after considering all overhead costs. If the Effective Rate varies from the Basic Invoice Rate of the materials, it is highlighted. The Outward detail displays the Basic Invoice Rate and Value of goods sold/transferred out.
To view configuration screen, press F12: Configure from Stock Group Movement Analysis report
Format
You can select the format ‘Condensed’ or ‘Detailed’ to view the report.
Show Inwards Column
By default this option will be set to ‘Yes’, if you don’t want to view the ‘Inward’ details then set it to ‘No’.
Show Outwards Column
By default this option will be set to ‘Yes’, if you don’t want to view the ‘Outward’ details then set it to ‘No’.
Show Quantities
By default this option will be set to ‘Yes’, if you don’t want to view the ‘Quantities’ detail then set it to ‘No’.
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 Rates and Show Values are self explanatory.
Further drill down will take you to the particular Stock Item Movement Analysis report.
This report will enable you to know ‘Movement Inward’ and ‘Movement Outward’ of the stock item. It will display the Purchase, Transfers Inward (Production), Sales, Transfer Outwards (Consumption) of a particular stock item of the stock group selected.
Buttons |
Shortcut Keys |
Description and Use |
F4:Godown |
F4 |
Navigation to other Stock Group from the same report is possible. |
F5:Item-wise |
F5 |
If any of the items are created under Sub-Group of the stock group, initially it will display the name of the Sub-Groups of the stock group. But you will be able to see Item-wise report from the same screen by pressing F5:Item-wise button. |
F6:By Ledger |
F6 |
Movement of the stock item by ledger is possible from the same report. i.e., by sundry creditor, sundry debtor, Cash-in-Hand, Bank Accounts etc. |
C:New Column |
Alt + C |
You can view the report of various Stock groups in the single screen. In the column details screen under ‘Name of Group’ select the required group, ‘New Column’ will be displayed in the existing screen along the group selected earlier. |
A:Alter Column |
Alt + A |
If you like to alter the existing stock group display and like to view the report of other stock group, ‘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 Groups. |