Mastering SCM Efficiency with AI & Automation
If you are an SCM professional, you probably start your day with a routine: Open SAP Logon, find the server, type your ID, and then your password. It’s a repetitive “digital chore” that drains your focus before the real work even begins. In the SCM Automation Lab, we believe in working smarter. Today, we will … Read more
If you are a Production Planner or an SCM professional, you know the drill. Every morning starts with logging into SAP, downloading several reports, and spending hours copy-pasting them into Excel. What if I told you that you could do all of that with a single click? Welcome to the first step of your automation … Read more
1. Problem Situation In real-world data handling, it is often necessary to apply filtering to a large data table based on specific criteria (e.g., specific period, particular department) and then calculate the sum of only the cells visible on the screen. If you use the standard SUM function (e.g., =SUM(A1:A10)), it includes the values from … Read more
[The Problem] Have you ever been stuck in this situation while working on a report? “I need the total sales, but I want to exclude all ‘Refunded’ items…” Usually, people calculate the grand total and then manually subtract the specific items using a calculator. If you have hundreds of rows, this is not only time-consuming … Read more