Please help me with the MIS report for the Purchase Department. How can I find pending orders, balance material, costing of materials, etc.? If there is an Excel format available, please send it to me.
From India, Thane
Acknowledge(0)
Amend(0)
1From India, Thane
Acknowledge(0)Amend(0)
Dear Sadhana,
You could have given a 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, 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, then you may start reconciliation with security itself.
When you say the "costing of the material," do you mean 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 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 formal training.
I conduct training in the field of Purchase and Inventory Management. To know more about my training activities, you may visit <link outdated-removed>.
Thanks,
Dinesh Divekar
From India, Bangalore
Acknowledge(0)Amend(0)
You could have given a 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, 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, then you may start reconciliation with security itself.
When you say the "costing of the material," do you mean 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 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 formal training.
I conduct training in the field of Purchase and Inventory Management. To know more about my training activities, you may visit <link outdated-removed>.
Thanks,
Dinesh Divekar
From India, Bangalore
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Register and Log In.
MIS Report.xls
MIS Report.doc