📚 MRF Utility Excel Add-In

Welcome to the MRF Utility—an advanced Excel add-in designed to optimize stock-taking and tallying processes. Whether you're managing stock data or automating workflows, this tool ensures precision and saves valuable time.

📑 Table of Contents

• Key Features
• Prerequisites
• Installation Steps
• How to Use
• Updates & Version Control
• Continuous Improvement
• Support

---

🚀 Key Features

Feature	Description	SAP Transaction
📦 Stock Taking	Easily manage stock-taking sheets by Product Groups and efficiently tally data for the INS Tube Flap	ZNBPSTK, ZDL
✅ Set Checker	Validate and cross-check set billings instantly with a single click	ZIRN_VIEW_LINES
🔍 Find Error Invoice	Retrieve invoice numbers and dates where proper set billing were missing	(Run after completion of Set Checker)
📈 Pull Compliance	Automate FDC-to-SOF workflows using predefined templates	(Run on un-edited downloaded Pull file)
🚚 Load Factor	Generate automated interactive dashboards, load factor analysis and trip-wise summaries	ZGFN_FREIGHT

---

📋 Prerequisites

Important

🛡️ Trust Center Settings: Before using this add-in, you must configure your Excel Trust Center settings in your system to allow the add-in to work. (Just a One-Time Setup). 📄See the step-by-step setup guide.

• Microsoft Excel: 2010 or later.

---

🛠️ Installation Steps

1. Download: Grab the latest .xlam add-in release : 📥Download, or visit the GitHub Releases Page.

2. Unblock the File: > Important Windows Security Step: > Locate the downloaded .xlam add-ins file, right-click it, and select Properties. At the bottom of the General tab under Security, check the Unblock box, and click OK.

3. Open Excel: Launch Microsoft Excel.

4. Navigate to Add-ins: Go to File > Options > Add-ins.

5. Manage Add-ins: At the bottom of the window, ensure Manage is set to Excel Add-ins, then click Go....

6. Browse and Install: Click Browse, locate your downloaded unblocked .xlam add-in file, select it, and click OK.

7. Access the Utility: You will now see a dedicated M R F tab in your Excel Ribbon!

Note

Troubleshooting: If you have followed all the above Installation steps properly and still the M R F ribbon tab does not appear, simply restart the Excel.

---

⚙️ How to Use

1. Export Data from SAP: Generate and download your spreadsheets from the relevant SAP transactions.

2. Open the M R F Tab: Navigate to the new custom tab in your Excel ribbon.

3. Execute Workflows:

   • ⚡Stock Taking Tool: Run to process product-group-wise stock-taking sheets and to review the INS Tube Flap discrepancy in stock. Use SAP transactions (ZNBPSTK, ZDL). 📄See the Instruction Guide.

   • ⚡Set Checker Tool: Run the validation to instantly report on incorrect set billings. Use SAP transaction (ZIRN_VIEW_LINES). 📄See the Instruction Guide.

   • ⚡Find Error Invoice Tool: Run to quickly review Invoice numbers and dates of Improper Set Billings. This tool is designed to be executed only after the Set Checker process completes.

   • ⚡Load Factor Dashboard Tool: Run to instantly generate comprehensive pivot dashboards, Route Analysis, and Trip-wise Summaries. Important: Export data using T-code (ZGFN_FREIGHT) and ensure you select the proper layout with Subtotals containing the required columns before exporting to spreadsheet.

   • ⚡Pull Compliance Tool: Run directly on downloaded un-edited Pull file to manage FDC to SOF workflows using T-Code ME21N, MB1B. Make sure the Source File.xlsx Excel workbook is available in the FDC TO SOF folder on your D Drive. (Path: D:\FDC TO SOF\SOURCE FILE.xlsx).

Warning

⚠️ Very Important Pull Compliance Step | Only for FDC to SOF Pull Purpose : Users must manually review & update the given Source File.xlsx workbook located in D:\FDC TO SOF\ themselves for any missing/Incorrect material codes where correct INS Tube/Flaps are not appearing. You must also add any new Tube-Type Tyre sizes to the list from time to time to ensure proper set billing from FDC to SOF's in IBTAs. Keeping this file up to date is essential for accurate set billing to SOF's.

---

🔄 Updates & Version Control

This add-in will automatically check against the GitHub repository to notify you if a newer version of the utility is available, ensuring you are always running the latest code and features.

---

💡 Suggesting Enhancements for Continuous Improvement

Excited to collaborate with contributors! To help enhance this tool & add your own features, please follow these steps:

1. Fork this repository.

   git clone [https://github.com/YOUR-USERNAME/MRF.git](https://github.com/YOUR-USERNAME/MRF.git)   

2. Create a new branch for your feature:

   git checkout -b feature/your-feature-name

3. Commit your changes:

   git commit -m "Add your feature"

4. Push the branch:

   git push origin feature/your-feature-name
   

---

💬 Support

Have questions, suggestions, or running into issues? Reach out for any required help via the Issues section on GitHub. Happy to help!