www.TallyERP9Help.Com

Materials Consumption Summary Report in Tally.ERP 9

To view the Material Consumption Summary report, scroll down to the line Consumption in Job Work Analysis Report and press Enter.

The Material Consumption Summary report is displayed.


[Img-30]

Here it will display Opening Value, Inward Value, Consumption, Other Transfers and Closing Value.


[Img-31]

 

It will display the Godown of the particular Job/Project:

Detailed view of  Inward Value, Consumption and Other Transfers:

Press F12 and set  Show goods inwards in detail, Show goods Consumption in detail and Show goods outwards in detail to Yes.


[Img-32]

 

Material Consumption Summary will appear as below:


[Img-33]

 

Further drill down from Material Consumption Summary to Material Consumption Stock Summary, would enable the user to view the Stock Group:


[Img-34]

 

This Report displays the material consumed for the Job/Project. Details of Opening value, Inward Value, consumption, other transfers and Closing value is shown – Drill down:

Opening Value: Opening Balance of the items which are tagged to the Godowns (Job/Project) is displayed here.

Inwards:

  • Purchase: The value of the materials which are purchased for the project is displayed here.

  • Manufacturing Journal: The value of the materials which are produced by passing Manufacturing Journal voucher tagging to the appropriate godown, is displayed here under Inwards.  

  • Inter Project Transfer: The value of the  transfer entry which is made by using ‘Class’ created for ‘Stock Journal’ and tagging to the appropriate godown is displayed here.  

  • Other Transfers:  Transfer of materials which are done by NOT using the ‘Transfer Class’ created for Stock Journal would appear here.

Consumption:

  • Cost of Sales:  The Value of Cost of Sales will be displayed here. Cost of Sales is nothing but Number of quantities (Sold) x Cost of Purchase. Sales which is made by usingItem invoice will appear here.

  • Job Consumption: The value of the entries which are made using ‘Consumption Class’ create for Stock Journal is displayed here.

Outwards:

  • Manufacturing Journal: The value of the materials which are used\ consumed for a Job/Project in the manufacturing journal voucher entry is displayed here.

  • Inter Project Transfer:  The value of the  transfer entry which is made by using ‘Class’ created for ‘Stock Journal’ and tagging to the appropriate godown is displayed here.  

  • Other Transfers:  Transfer of materials which are done by NOT using the ‘Transfer Class’ created for Stock Journal would appear here.

Closing Value:

Closing value of an item will be determined based on costing method.

Closing value = Opening Value + Inwards – Consumption – Other Transfers

Drill down from the above report, will display the Stock items used for Job/Project


[Img-35]

Drill down further to display the Godown Voucher screens.


[Img-36]

It displays the report godown wise - Inwards, Outwards and Closing Balance.

To view total material consumption of all the Job/Projects

The button Auto Column is available to view all the Job/Projects material consumption report in one sheet. Press Alt+N.


[Img-37]

 


[Img-38]

 

For comparison of one Job/Project material consumption with other Job/Project.

The button New Column is also available in the report to view the period for a particular period that can be selected from the list – Press Atl+C


[Img-39]

 


[Img-40]

 

Viewing other Job/project from the screen on one Job/Project:

The button Alter Column is also available in the report to view the other job or Project. Press  Alt+A


[Img-41]

 


[Img-42]

 

F4 button:

Click this button to select the other Job/Project from the list.

F7: Button or Show:

Profit button is available in the Material Consumption Stock Summary report, to view the Gross Profit with Percentage for a particular Job/Project.


[Img-43]

 
 
 
 
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