Freelancers using SAP in Karachi

Freelancers using SAP in KarachiFreelancers using SAP in Karachi

Projects People

Tabish Khan

Karachi, Pakistan

I fix warehouse chaos SOPs, SAP & Excel system for ops team

5.0: Rating

3: Followers

I fix warehouse chaos SOPs, SAP & Excel system for ops team

In 15 minutes, I can usually find at least one thing that's costing a warehouse time or money. Sometimes it's a layout issue. Sometimes it's a process that made sense two years ago but doesn't anymore. Sometimes it's a blind spot the team is too close to see. I've done this across FMCG facilities — and this month, I'm offering free 15-minute virtual audits to a handful of operations. Here's what you get: → A virtual walkthrough of your warehouse → A written summary of what I observe → Zero obligation, zero sales pitch If you're running a warehouse and curious what an outside eye might catch — let's talk. Comment below or send me a DM to claim a spot.

Cover image for How I reduced a 10-minute

How I reduced a 10-minute SAP process to 1.5 minutes using Excel VBA — and saved 255 minutes every day This isn't a theory post. This is something I built, tested, and deployed across 2 manufacturing plants in Pakistan. If your team is running repetitive SAP transactions manually every day, this will show you exactly what's possible — and how I did it with nothing but Excel VBA. The problem In my last FMCG role we ran STOs (Stock Transfer Orders) daily. An STO is a stock movement between two plants or warehouses in SAP — and it requires 3 separate transactions to complete: → PO Creation — run NME21N, select PO type, enter shipping code, item codes, quantities, receiving plant, SLOC for each SKU → Delivery Creation — run NVL10B, go to purchase order, paste PO number, execute, click line item, save → Shipment Creation — run NVT01N, enter FK02, Z004, select P&G Interplant, click delivery tab, paste delivery number, execute, set shipping point, select date, click planning, check in, select date, click shipment start, save 50 manual steps per STO. 10 STOs per shift. 3 shifts per day. That's 1,500 manual steps every 24 hours — and 2.5 hours of pure manual work daily across all shifts. The errors The process wasn't just slow — it was a trap. The most common error: copying an 8-digit PO number and missing one digit. You wouldn't catch it until the next transaction failed — then you'd go back, find the correct PO, and restart. SAP also disconnected occasionally mid-process. When it did, you started from scratch. 30 STOs a day meant 30 chances to make a mistake. And mistakes had real consequences — wrong stock movements, delayed shipments, production line stoppages. The solution I mapped every single step across all 3 transactions. Every click, every field, every copy-paste, every keyboard shortcut. Then I built an Excel VBA tool that automated the entire flow. The tool: → Opens SAP automatically → Copies all item codes across 6 SKUs in one action → Pastes all quantities across 6 SKUs in one action → Clicks create STO — completing all 3 transactions automatically The new process: Open tool Open SAP Copy item codes Paste quantities Click create 5 steps. That's it. The results Before After Steps per STO 50 Time per STO 10 min 1.5 min Steps per day 1,500 150 Time per day 150 min 45 min Steps saved daily 1,350 Minutes saved daily 255 The impact It took me 3 months to build. Nights, weekends, failed scripts, late fixes. When it worked — it really worked. The tool was rolled out across 2 plants in Pakistan. I shared it with the regional council and they couldn't believe it was built in Excel — not by an SAP consultant, not with an IT budget, not through a formal project. I received a company award for it. What this means for your operation If your team is running repetitive SAP transactions manually, you almost certainly have the same opportunity. The tool doesn't require SAP customization. It doesn't require an IT team. It works alongside your existing SAP setup — not instead of it. Every warehouse or production operation running SAP has at least one process like this. A task done 20, 30, 50 times a day that nobody has ever stopped to question. That's where the biggest wins are hiding. Want this built for your operation? I offer SAP & Excel process consulting for warehouse and production teams. If you're running repetitive SAP transactions manually and want to explore what automation could look like for your specific setup, book a free discovery call below. 👉 [View my SAP Consulting Service]https://contra.com/s/7lbgEqRc-sap-and-erp-process-consulting-for-warehouse-operations 👉 [Schedule a Call]https://appointment.briskcloudware.com/book.html?r=lLixzwVO

Cover image for 5 Excel formulas every inventory

5 Excel formulas every inventory planner must know You don't need a fancy WMS to manage inventory well. You need Excel and the right formulas. After years of managing inventory in FMCG operations, these are the 5 formulas I use constantly — and the ones I build into every custom Excel system I deliver for clients. 1. SUMIFS — your most powerful counting tool Instead of filtering manually, SUMIFS lets you sum quantities based on multiple conditions at once. =SUMIFS(quantity_column, SKU_column, "SKU001", warehouse_column, "WH-A") Use it for: total stock by SKU and location, total dispatched by date range, production output by shift. 2. IFERROR — stop broken formulas from crashing your sheet When a formula can't find a value it returns an error. IFERROR catches it and shows something cleaner. =IFERROR(VLOOKUP(A2,data_range,2,0),"Not found") Use it for: wrapping any VLOOKUP or INDEX/MATCH so your sheet doesn't fill with #N/A errors. 3. INDEX/MATCH — better than VLOOKUP VLOOKUP breaks when you add columns. INDEX/MATCH never does. =INDEX(return_column,MATCH(lookup_value,lookup_column,0)) Use it for: pulling SAP data into your planning sheet, matching SKU codes to descriptions, linking sheets without breaking. 4. COUNTIFS — find gaps instantly COUNTIFS counts rows that meet multiple conditions. Use it to spot where data is missing or incomplete. =COUNTIFS(status_column,"Pending",date_column,"<"&TODAY()) Use it for: overdue orders, pending GRs, items with zero stock, SKUs not yet received. 5. TODAY() and date logic — automate your daily planning Stop manually updating dates. TODAY() always returns the current date — build your planning triggers around it. =IF(reorder_date<=TODAY(),"Order Now","OK") Use it for: reorder alerts, overdue shipment flags, days-since-last-receipt calculations. These 5 formulas are the foundation of every inventory Excel system I build. Master them and you can automate 80% of your daily planning without spending a rupee on software. Need a custom Excel system built around your operation? Check out my services below.

tentative and current planning Dashboard

SAP(6)

Ahmed Amanatullah

Karachi, Pakistan

Innovative Product Manager & Designer for MVPs

Innovation Centers of Two Fortune 500 Companies

mCollect - Field Collections :: Behance

Mall Marketing Analytics App :: Behance

I am a professional in Data Analytics and VA

MS Excel Data Analysis

Excel Data Analysis

Data Cleaning

View more →

SAP(1)