#Bizoneness While I had planned something about the General Ledger for this newsletter, circumstances changed, so I'll do something entirely different. As many of you know, I'm no longer with Scientific Device Laboratory. If you'd like to know more about that situation, I have described it in detail here, but the very short version is that … Continue reading Introducing HANA
In the ERP application, we have established credits and debits on a ledger with the five major accounts. However, we don't know what those credits and debits do. We want the ledger to tell the story of how we moved our money around. Our transaction list from last time doesn't do that well. Which assets … Continue reading LucaP02 The Chart of Accounts
How do you start to understand the workings of an ERP system? By making one. In this biweekly column, we’ll make an ERP system and start at the core of it all: accounting. This lesson will be longer than subsequent lessons, as I will have to do some background and definitions so everyone has an … Continue reading LucaP ERp Part 1: The Basic Equation
If you are in a regulated industry or are ISO certified, you may run into the issue of software validation of SAP Business One. While Scientific Device Laboratory has an ISO 13485 certification, I have no software that's part of a product. Still, as mentioned in the ISO guidelines, ISO-certified agencies will require you to … Continue reading A simple way to Validate SAP B1 for ISO audits
For most batch updates of information in SAP Business One, you'll use Data transfer Workbench, usually referred to as DTW. This process requires a system administrator or Channel partner to do the work, as DTW is external to SAP Business One. However, you can use the Import From Excel module inside Sap Business One for a … Continue reading Is Import for Excel DTW Lite? Importing Data to SAP B1
It's that quarter again when many companies prepare for a price change at the beginning of the year. I've discussed price lists in SAP Business One: Production and Logistics in the LinkedIn learning library. However, I want to discuss one special scenario for pricing I didn't cover there: Manual price changes. Many companies will raise their prices … Continue reading Pricing on Time: Double Pricelists for Accurate Manual Pricing
Life and MRP are more than the sum of their parts. In SAP Business One: Production and logistics, I introduced MRP and gave you the fundamentals to use MRP. However, I glazed over some subtleties that come into play with mass production. You can ask it with one question: What happens when you have parts … Continue reading Manual Units of Measure for MRp in Production
Suppose you want to figure how much you invoiced a specific customer. However, you also want to list any Credit memos for returns. How would you do this? In my course SAP B1: Reporting and Customization, I cover much of SQL, but I didn't get to all of it. This week I'd like to introduce you … Continue reading Learn the Power of UNION to Combine Two Reports Into One
We've been preparing data for a bulk change in SAP Business one using Data Transfer Workbench in previous newsletters. This week we'll make those changes. Before we do, there are cautions. The first should be obvious: you are changing your business data, which requires a meticulous approach. Change the data in a sandbox company first … Continue reading Import Mass Changes to DTW
In the last newsletter, We exported data from an SAP SQL Query and changed it for a mass change. I picked an example of preparing for MRP implementation. With the data changed, This time I'll show you how to prepare your data for import in DTW. Preparation is the most critical step to get right. Whether … Continue reading Three Steps to Data Transfer Workbench: Preparing Data for Import.
BizOneness 