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
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.
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.
This brings up the bifurcation of all Additional Costs.
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 Units and Tail units of Compound Units.
To view configuration screen, press F12: Configure from Stock Item Movement Analysis report
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 |
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.
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.
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 |
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. |