Please help me MIS REPORT FOR PURCHASE DEPARTMENT. How to find Pending order and balance material, costing of material etc.. if there is anything excel format is available pl send.
From India, Thane
1From India, Thane
Dear Sadhana,
You could have given little more information about yourself. What is your designation? What is the volume of procurement spend in your company? How many POs are issued per month?
If not many POs are issued per month then tracking the POs on Excel should not be a problem. You can reconcile POs with Goods Receipt Note (GRN) from the store. If getting GRN takes longer time, then you may start reconciliation with security itself.
When you say the "costing of the material", do you mean to say that you wanted to track the stock value per day? For this, you may download relevant software on inventory management from the following website:
Windows PC software downloads and reviews from CNET Download.com
Alternatively, do you mean to say that that you wanted to know how to do costing while procuring the material from the vendor? This is a very deep subject. For this, you need to take the formal training.
I conduct training in the field of Purchase and Inventory Management. To know more about my training activities, you may <link outdated-removed> .
Thanks,
Dinesh Divekar
From India, Bangalore
You could have given little more information about yourself. What is your designation? What is the volume of procurement spend in your company? How many POs are issued per month?
If not many POs are issued per month then tracking the POs on Excel should not be a problem. You can reconcile POs with Goods Receipt Note (GRN) from the store. If getting GRN takes longer time, then you may start reconciliation with security itself.
When you say the "costing of the material", do you mean to say that you wanted to track the stock value per day? For this, you may download relevant software on inventory management from the following website:
Windows PC software downloads and reviews from CNET Download.com
Alternatively, do you mean to say that that you wanted to know how to do costing while procuring the material from the vendor? This is a very deep subject. For this, you need to take the formal training.
I conduct training in the field of Purchase and Inventory Management. To know more about my training activities, you may <link outdated-removed> .
Thanks,
Dinesh Divekar
From India, Bangalore
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
MIS Report.xls
MIS Report.doc