Tuesday, November 24, 2015

SAP ERP powered by SAP HANA at Wuerth

Telltale Signs You’ve Outgrown QuickBooks - 8 Part series

From ERP Software Blog - Telltale Signs You’ve Outgrown QuickBooks: All the Rubber Bands Holding Your Business Together Are Keeping You Up at Night
If you’ve built your business on QuickBooks or Peachtree, you know they're great entry-level accounting solutions. As your business flourishes, however, they may not be able to keep up. There are telltale signs you've hit your limits with your current systems and when those start to occur, its likely your future growth will be stifled until you step up to a more comprehensive business management solution.
We have compiled a list of growing pains businesses like yours are facing when outgrowing QuickBooks or Peachtree. In this blog series, we will address some of those common growing pains and how a business solution from Columbus and Microsoft goes beyond entry level accounting software to keep you on the path of growth.

Monday, October 5, 2015

Brazil Suspends Pharma Serialization And Tracing Requirements | RxTrace

"Last week, Brazil’s pharma industry regulatory agency, the National Agency of Sanitary Surveillance (ANVISA), announced that they were “suspending” at least part of RDC-54/2013, the declaration that mandated drug serialization and tracing, until further notice.  Thank you to all who forwarded the link to the official announcement.  I was able to translate and read it on Thursday, and I submitted a comment on my own last essay, “Pharma Serialization Deadlines In Flux“, to include the link.  Apparently shortly after that essay was published, ANVISA  publicly announced the suspension." Dirk Rodgers - Read the full article from Dirk here.

Sunday, September 27, 2015

Reimagine your business with SAP Internet of Things

How SAP Plans To Take CRM Beyond CRM - Tech Trends on CIO Today

SAP is aiming to go beyond customer relationship management (CRM) with its latest software innovation. The company recently introduced the concept of “integrated digital enterprise technologies” designed to transform the relationships companies have with their customers.
That’s a tall order but one that SAP is betting its hybris Profile solution can meet. As the name suggests, the new tools will help agents profile customers “in-the-moment.” The whole idea is to help a company's front office stay connected with the changing needs of customers and prospects by tapping into digital connectedness, customer service and support. “Companies can no longer rely on the costly, siloed systems of yesterday to engage with their customers, who are savvy, multidevice digital natives,” said Bill McDermott [pictured], CEO of SAP SE, in a statement. "They want their needs understood and met -- right now and every time.”  - Read the full article at How SAP Plans To Take CRM Beyond CRM - Tech Trends on CIO Today

Monday, September 14, 2015

ALV Enhancer

ALV Enhancer
  • Enhance standard SAP transactions
  • Add new fields to ALV controls without coding
  • Automatically add new functionality to standard ALV grids
  • Significantly reduce ABAP development effort

Tuesday, August 25, 2015

Success Story: Paul Vahle GmbH Reduces Delivery Times with Process Observer

I found this nice article on SCN about SAP POB that I thought to share here...
Paul Vahle GmbH & Co KG (The VAHLE Group) is a mid-sized company based in Kamen, Germany that has specialized in mobile power and data transmission since 1912.
They are active in 52 countries and have 13 subsidiaries worldwide. VAHLE develops, manufactures, and installs customized power and data transmission systems for various material handling applications.
VAHLE implemented the Business Suite Foundation component Process Observer together with SAP consulting partner Cubeserv in order to identify bottlenecks and streamline their order-to-cash process run on SAP ERP. The overall deployment time of the Process Observer component took only 10 days. The monitoring setup, on top of Process Observer, allowed them to identify gaps in material planning and in stocking processes that were slowing down product delivery. Appropriate training of business users and constant evaluation now enables them to deliver faster and make their customers happier.
The complete success story is published at SAP.com.

Tuesday, August 18, 2015

SAP SE Analyst Rating Update | American Trade Journal

Friday, August 14, 2015

How Do You Communicate: Direct EDI or VAN Based EDI? - ERP Software Blog

I found this article from Brian Lynch, of Data Masons Software. Take a read on his take on things...

Which is best for your company?

As a professional who has helped over 1,000 companies, during my career, to implement EDI with Dynamics as their back office, I often get asked “What method of EDI communication is best for MY company?” Since there are only two main methods of communications, an EDI Value added network (VAN) provider or Direct EDI, my response is typically the same. 20 years ago VAN’s were the only choice; however, most major trading partners support direct communications. Fortunately, the decision for most companies can be straightforward and should be based entirely on business requirements, such as volume of documents, IT support and services being provided by your EDI provider.

Thursday, August 13, 2015

Success Story: Merck Group uses Process Observer (POB) to Monitor Master Data Harmonization

I found this great use case for SAP POB on SCN - Thought I would share it here...
The Merck Group uses Process Observer in the context of Master Data Harmonization. While the core process of creating and changing master data is implemented using SAP Master Data Governance (SAP MDG-M, find the Success Story here), Process Observer is used for reporting and to make the process visible. A story about this was released at the SAP Forum in Austria 2013, DSAG Technologietage 2013 and at SAP TechEd in 2012. The presentation from the SAP Forum is online and can be reviewed here (the document is available in German only).
The basis for the integration of Process Observer into SAP MDG is the SAP Master Data Governance rapid-deployment solution. In the SAP Demo Store, a demo is available showcasing this integration: EIM MDG-M Create Material with Process Observer (Logon to the SAP Demo Store required).

The Internet of Things Changes the Game for Hamburg Port Authority

Check out how the Hamburg Port Authority used SAP Internet of Things to bring value to their process.

Wednesday, August 12, 2015

SAP Automates Workflow Processes Surrounding HR

Mike Vizard writes...
Time and again, business leaders will acknowledge that the most important resource that drives the success of their business is the people they hire. And yet, when it comes to managing those human resources, most of them have little insight into either the processes those employees directly impact or, vice versa, how much time and effort those employees waste navigating the company’s human resources (HR) bureaucracy.

SAP's SuccessFactors Launches Futuristic HCM Software

Germany-based global software company SAP’s  subsidiary, SuccessFactors, which provides cloud-based human resources software service, has introduced an advanced version of SAP SuccessFactors HCM Suite. The futuristic product is expected to herald a new era in human resource management.

zedSuite Delivers Certified SPS Commerce Integration for SAP Business One

San Francisco, CA (PRWEB) July 22, 2015 - zedSuite (http://www.zedsuite.com), a leading SAP software solution and technology partner, today announced the release of Cloud EDI 2.0 for SPS Commerce. With the addition of EDI transactions 940 and 945, the Cloud EDI Solution for SAP Business One provides a cloud-based service, integrating trading partners to the industry's broadest retail network comprising more than 60,000 members. This single integration between SAP Business One and the SPS Commerce Retail Network provides retailers and suppliers the industry's first SPS and SAP certified integration solution.

Tuesday, August 11, 2015

EXTOL EDI Integrator for i and EXTOL Secure Exchange Selected by Southern Motorcycle Supply, Inc.

POTTSVILLE, Pa., Aug. 11, 2015 /PRNewswire/ -- EXTOL International, a leading provider of e-business integration software and services, has been selected by Southern Motorcycle Supply to provide the EXTOL EDI Integrator for i (EEI) and EXTOL Secure Exchange (ESX) solutions.
Southern Motorcycle Supply, a parts and accessories distributor for motorcycles, personal watercraft, ATVs, small engines and performance craft, needed to meet two Amazon requirements: implement EDI documents and use the required AS2 communication. Their previous EDI vendor declined to help them with integration.
"Southern Motorcycle Supply's research on EDI vendors found EXTOL's native iSeries EDI integration platform to best support their EDI integration with Amazon," said Peter Harper, vice president of sales at EXTOL. "Our Professional Services team is now working with Southern Motorcycle Supply to migrate all of their EDI data to EEI so they can start rapidly on-boarding other trading partners, and provide end-to-end visibility of EDI transactions moving through their business."
To view the original version on PR Newswire, visit:PR Newswire - SOURCE EXTOL International

SAP releases S/4 HANA as free trial

The 30-day on-premise freebie aims to encourage more users onto new Business Suite software

SAP customers can try the latest version of Business Suite, S/4HANA, in a free, 30-day on-premise trial.
The trial gives access to a demo, with examples of typical installation scenarios and infrastructure trials so potential customers can view the insights it provides in real-life situations.
The suite allows businesses to explore instant insights across their entire organisation, including finance, procurement, sales and manufacturing, and they can also use the German tech giant's user experience software, Fiori, alongside it.

Monday, August 10, 2015

Mar-Kov provides Electronic Data Interchange (EDI) Functionality to the Process Manufacturing Industry

Mar-Kov Computer Systems has added EDI functionality to its standard suite including Manufacturing, Purchasing, Receiving, Sales, Shipping, Barcoding, Electronic Batch Recording (EBR), Lot Track/Trace, Recalls - See more at Global News Wire

International SAP Conference on Supply Chain

SAP and T.A.Cook are delighted to invite you to attend the International SAP Conference on Supply Chain
TITLE: International SAP Conference on Supply Chain
DATES: October 1-2, 2015
LOCATION: Darmstadt, Germany
EVENT WEB SITE: http://goo.gl/mZs5nC - use code ERPGSCM15_10 during the online registration, for an exclusive 10% discount for ERPGenie.COM subscribers


Event Highlights Include

  • Keynote presentations: Featuring the latest industry news, best practices and innovations. In addition, learn about market opinion from experts in the field and hear from SAP’s customers on their innovative approaches
  • Customer case studies: Gain an informed perspective from leading companies on implementing and working with SAP’s SCM applications
  • SAP sessions: Hear details of the latest industry trends, solution road maps, developments, and a vision for transformation from senior executives at SAP on topics including HANA and cloud-based innovations
  • Live demos: See demos of the applications first-hand and get answers to your questions about the featured SCM solutions from SAP and their partner organizations
  • Meet the experts: Get your questions answered. Visit the showfloor to discuss your challenges with SAP solution management, and hear more about new offerings and tools from leading SAP Partners
  • Network: In addition you will find ample time to get to know your peers and build lasting relations with subject-matter experts throughout the event.
Discover how SAP’s portfolio of supply chain management applications can support organizations across different business scenarios and industry sectors, while remaining compliant with today's more complex regulations.


Download the brochure by clicking the image

Early Bird Discount

Secure your place by Friday, 28 August 2015 to save on the pass price. Register now and save
Use code ERPGSCM15_10 during the online registration, for an exclusive 10% discount for ERPGenie.COM subscribers

Key Speakers From

Unilever, Mondelez, Whirlpool, Caterpillar, Philips, RWE, Boehringer, Nussbaum, ÖBB, M.Video

Friday, August 7, 2015

7 Interesting Big Data and Analytics Trends for 2015

Another nice posting by

"Here’s a list of what I find are the most interesting trends in analytics in 2015.
Why the italics? because most of what will happen this year can be summarized with a single word: more. Yes, there will be more data, more mobile analytics, more cloud analytics, more data discovery, more visualization, etc.—but these are the trends that I personally will be paying closer attention to over the year:

SAP Process Observer (POB) - What is it?

SAP Process Observer for Built-In Processes (POB) allows organizations to monitor and optimize core processes based on SAP Business Suite’s built-in business object events. It's been around quite a while - Since 2011, I believe. The functionality it provides is somewhat close to SAP Event Management but there are major differences in functionality and also in the scope of the process that each covers. Comment on the blog if you want more details on the differences. Below is a set of documents that are available on SCN that will help guide you through understanding what POB is and how to put it in...

Thursday, August 6, 2015

Video: SAP Business ByDesign Demo

FDA Looking For Consulting Org To Run DSCSA Pilots - RxTrace.com

Dirk Rodgers of RxTrace.com writes about an RFP the FDA issued last month that is due August 13th... Check it out, in full, on RxTrace.com...
Last week the FDA quietly posted a Request For Proposal (RFP) on the FedBizOpps.gov government bidding site for a consulting organization to design and implement a program of pilot projects that explore and evaluate methods to enhance the safety and security of the pharma supply chain.  The scope of work is:
“Development and implementation of a program for the pilot projects will include, but is not limited to: development of the program structure, determination of the scope of the pilot projects and what issues should be covered, ensuring the pilot project design fulfills the requirement of the DSCSA, development of an enrollment process for potential participants, development of timing and schedule, development of monitoring and reporting schedule, development of pilot project metrics and evaluation plan; and development of a communication plan. The pilot project(s) developed under the DSCSA need to explore and evaluate methods to enhance the safety and security of the pharmaceutical distribution supply chain, through
  1. utilization of the product identifier for tracing of a product throughout the supply chain and may include verification of product identifier, including the use of aggregation and inference;
  2. improvement of the technical capabilities of each sector and subsector to comply with systems and processes needed to utilize the product identifiers to enhance tracing of a product; and
  3. identification of system attributes that are necessary to implement the requirements established under the DSCSA.”
The RFP was posted on July 31, 2015 and responses must be submitted by midnight on August 13, 2015.  As part of developing the program, the contractor will also help the FDA run a public workshop and docket to collect ideas and comments that will help guide the design of the pilots.  The “period of performance” is eight months from date of the award.
Check out the full article at RxTrace.com...

Wednesday, August 5, 2015

Business Analytics vs Business Intelligence?

This is a great blog posting by
"What’s the difference between Business Analytics and Business Intelligence? The correct answer is: everybody has an opinion, but nobody knows, and you shouldn’t care.
Having worked in the industry over twenty years, I can confidently say that everybody has a different notion of what ANY particular term associated with analytics means.
For example, when SAP says “business analytics” instead of “business intelligence”, it’s intended to indicate that business analytics is an umbrella term including data warehousing, business intelligence, enterprise information management, enterprise performance management, analytic applications, and governance, risk, and compliance.
But other vendors (such as SAS) use “business analytics” to indicate some level of vertical/horizontal domain knowledge tied with statistical or predictive analytics.
At the end of the day, there are two things worth differentiating:
  1. The first is the business aspect of BI — the need to get the most value out of information. This need hasn’t really changed in over fifty years (although the increasing complexity of the world economy means it’s ever harder to deliver). And the majority of real issues that stop us from getting value out of information (information culture, politics, lack of analytic competence, etc.) haven’t changed in decades either.
  2. The second is the IT aspect of BI — what technology is used to help provide the business need. This obviously does change over time — sometimes radically.
The problems in nomenclature typically arise because “business intelligence” is commonly used to refer both of these, according to the context, thus confusing the heck out of everyone." by

TIP: Wrong IMG showing in your system

We recently encountered a situation that after an install of SAP EM on an SNC server the SAP Event Management node was missing in the IMG structure (t-code SPRO). A work-around using transaction SIMGH is doable but the permanent fix is shown below...

Tuesday, August 4, 2015

Video: 5 Brilliant Ways to Customize SAP Business ByDesign

Like snowflakes, no two businesses are alike, and at times it’s necessary to customize your ERP solution to ensure it works exactly the way your business does.
In this video we’ll demonstrate 5 brilliant examples of how you can customize SAP Business ByDesign to ensure it accommodates your most unique and critical business needs.
Specifically, the video covers:
  1. How Development Works in SAP Business ByDesign
  2. Basic User Assistance – Sales Order Duplicate Check
  3. More Advanced Validation – External Reference Required for Release
  4. Store Custom Data – Approved Supplier List
  5. Upload Custom Data – File Input
  6. Automate Processes – Freight on Customer Invoice

Monday, August 3, 2015

External Integration of Custom Solutions in SAP Business ByDesign / SAP Cloud for Customer

Document by Thomas Schneider : This document gives an overview on the capabilities of external integration of SAP Business ByDesign / SAP Cloud for Customer custom solutions developed with SAP Cloud Applications Studio. This document is relevant for you if:
  • You are developing (or planning) a custom solution for SAP Business ByDesign or SAP Cloud for Customer with SAP Cloud Applications Studio
  • You are searching for means of integrating this solution with an external system.

RxTrace.com: Estimated Rise in Serialized Drugs in The U.S. Supply Chain, 2015

Dirk Rodgers of rxtrace.com writes "It’s August and that means it is time to check in on the progress toward full serialization of drugs in the U.S. supply chain.  This is an annual look I’ve been doing for five years now.  For my previous essays, see:
In each essay I produced a graph of my own personal estimate of the likely rise in the percentage of drugs that I thought would result, based on the deadlines that were in place at the time.  Of course, things changed last year because the Drug Supply Chain Security Act had preempted the California Pedigree law the previous November, so last year I made a new estimate that took into consideration the DSCSA dates.

Saturday, August 1, 2015

TIP: List of Parameter IDs

Here is the great list of useful Parameter IDs. Parameter IDs allows users to set up defaults for most SAP fields that have a dropdown selection.  This is a great time saver to help to reduce the # of errors.

/SAPTRX/EE_MON_SEL    Display Monitor Fields
/SAPTRX/NOPERFPOPUP    Disable the performance warning for selections ('X')
/SDF/BT_ID    BusinessTransaction ID
AAT    Order type

Friday, July 31, 2015

Unilever uses SAP HANA to Enhance its Supply Chain Decision Making

Unilever uses COPA Accelerator to accelerate its month-end closing by 30-60%. And will be looking to SAP Business Suite powered by SAP HANA to further overcome supply chain bottlenecks and drive efficiencies, accessing 27 terabytes of data and 4.6 billion records in its ERP system.

TIPS: Basis tips and Tricks

Feel free to comment on new tips and tricks 
  •  In an R/3 screen, use %pc to download any TCode full page in any format you want.(.htm, .txt etc). Also use TCode /nSO21 to specify the default download location (this is very useful as saving all files to the sapworkdir can be little annoying at times)
  • Show Work Process usage over time by running SM50 -> List -> CPU. This shows CPU usage in minutes since startup. If all of your DIA WP's show time, then consider adding more.

Wednesday, July 29, 2015

Michael Management creating custom eLearning content for you

Creating Custom SAP Training Is Hard - Creating your own custom SAP eLearning requires subject matter experts, instructional designers, editors, voice actors, project managers, etc. In fact, developing just 1 hour of eLearning content can take 200+ hours of development time.
Let Michael Management do it for you instead. They can create new training or convert your existing paper-based training and turn it into engaging online content.

No Death-by-PowerPoint!!! All their training courses are hands-on simulations of real SAP screens - true learning-by-doing. 
  • Turn your paper-based training content into eLearning.
  • Customize training based on your business processes.
  • Train twice the people in half the time with less cost.
  • Use your SAP system, your data, your configuration.
Find out more at   Custom SAP eLearning

Now you can develop Fiori apps for SAP Event Management

SAP Web IDE version 1.13 will include the SAP Event Management plugin which enables developers to generate their own transactional SAP Fiori apps for SAP Event Management. Read the detailed developer guide on SCN.

Friday, July 24, 2015

An overview of SAP Business ByDesign

SAP Business ByDesign is a cloud-based global mid-market ERP system. It helps you manage all of your key functions, including finance, HR, CRM, supply chain, procurement, manufacturing, field service and project management.
Created by SAP from the ground up, and based on 40 years of experience with system design and best-practices, SAP Business ByDesign was built to offer an extensive out-of-the-box ERP solution that meets the most complex needs of midsized businesses.

Thursday, July 23, 2015

A day in the life of your Workflow Inbox - Understanding the Work item status...

The following diagram depicts the flow that a workflow item can take. Steps 1, 2, 3a and 3b are the statuses attributed to the most common path a work item takes. They are described in detail below.

  • STEP 1: Status = Ready – Ready to be processed by the next applicable agent. Anyone who has this item in their inbox can still execute or reserve this item. Double clicking a work item in this status moves the status to “Started” -> STEP 2
  • STEP 2: Status = Started – Busy working with the work item. The agent is still actively in the order summary screen.

Saturday, June 27, 2015

Understanding what SAP solutions are provided to help manage your Supply Chain

SAP provides a myriad of solutions covering all aspects of the supply chain. In addition they often provide more than one solution to the same requirement. This makes it quite a challenge to choose the right solution for your scenario. With that being said I'd prefer to have more options to choose from than no option at all...
In this blog I have collected the current suite of Supply Chain solution offerings from SAP and grouped them in to 3 categories:
  • Most commonly used solutions
  • Less commonly used solutions
  • Solutions that cover Supply Chain processes as well as the rest of your ERP needs
At Q Data USA we specialize on these types of solutions so feel free to reach out to us with any questions.

Friday, June 26, 2015

Social is for Closers! New eBook on Social Marketing with Microsoft Dynamics CRM

In order to keep up with today’s social and mobile world, businesses need to move at a faster pace, connect to customers on their terms, and share knowledge more broadly than ever before. Microsoft Dynamics CRM comes loaded with out-of-the-box social tools designed to empower your sales, service, and marketing teams to deliver better customer experiences and grow customer satisfaction.

Thursday, June 25, 2015

Application Identifier on Bar Codes in SAP Business ByDesign

It appears that there have been a number of questions raised on the ByDesign forums related to the use of the mobile devices with existing SAP Business ByDesign form templates, and errors due to a lack of an “Application Identifier” when trying to scan barcodes.
The reason for this is that not all standard form templates for ByDesign are built with mobile devices in mind. Luckily, the fix to this is very straightforward. By default, most of the forms do not include the “Application Identifier” for the related fields. The “Application Identifier” is a numeric code that represents what type of data is being scanned.
Take the use-case in which the product ID is expected to be scanned. The associated application identifier is “91”. Note that this is a ByDesign-specific application identifier (it is one of the “90 – 99” custom fields referenced in the GS1 specification). Therefore, the mobile device will expect that any barcode that represents a product ID will start with a “91”. However, the XML data that is used to generate the forms will not necessarily have information in this format – in general, it would come over with just the regular value.
With the example of a product ID “SKU1234”, the product ID on the form template would still be “SKU1234”. However, if this product ID needs to be scanned, then the application identifier would need to come first – the barcode would actually need to contain the value “91SKU1234” to scan correctly, with the “91” representing the application identifier. We can make this adjustment through the addition of a simple script in Adobe LiveCycle Designer.

Wednesday, June 24, 2015

What GTIN would you use under this co-marketing scenario?

I saw this conversation on Linked In and felt that it was worthy to repost here for preserving...
Here’s the scenario:
A large multi-national manufactures and packages pharmaceutical finished goods. One presentation of these finished goods are sold in the US through a Partner (co-marketing arrangement). The Artwork and GTIN (NDC) of the product is that of the Partner. However the manufacturing authorization holder (MAH) is the large multi-national brand owner. With Serialization according to the DSCSA, should the GTIN remain that of the Partner? Or, would it need to revert to the MAH?
My belief is that it would not change – remain that of the Partner. Curious if you have come across this and if so, what approach you would take. 

SAP Business ByDesign Customization: 4 Real-Life Examples

When it comes to ERP systems, a strong and diligent selection process can really help you meet your business needs without the requirement for any customization. While SAP Business ByDesign is able to fulfill the majority of common business requirements, there will always be industry-specific or customer-specific requirements. For these requirements, SAP provides a combination of tools: both front-end based adaptation and extensibility as well as the Cloud Applications Studio can be used to develop solutions to bridge any out-of-the-box gaps.
In the blog series below, we’ll explore four examples of customer-specific SAP Business ByDesign solutions built by FMT Consultants. While the level of effort behind each of these enhancements varies, the business impact for even the simple solutions has been substantial – improving efficiency, automation, visibility, and data integrity. The solutions are ordered from least complex to most complex. The first two solutions can be built without the use of the SAP Cloud Applications studio. The second two solutions do require a small customization to be built in the SAP Cloud Applications Studio.

4 SAP Business ByDesign Customization Examples - by FMT Consultants:

  1. Application Identifier on Bar Codes
  2. Detailed Material Description
  3. Actual Freight on Customer Invoice
  4. Material-Specific Lead Time

Actual Freight on Customer Invoice in SAP Business ByDesign

We’ve often come across the requirement to invoice customers for only the actual freight price or cost incurred related to the outbound delivery. In the example we explore here, the “Freight Price” is an extension field that has been added to the outbound delivery. The value in the field is actually being sent to SAP Business ByDesign from an external system, but this functionality could also work with a value entered manually on the outbound delivery itself.
Note that this customization was only built for a single-currency environment, but it would be very easy to adjust to a multicurrency environment by changing the “Freight Price” field to an “Amount”-type field instead of a “Text” type field. In this scenario, the external system did not send data in an “Amount” type structure.
The external system would send back the actual amount value to populate the “Freight Price” field once the outbound delivery had been processed.

Tuesday, June 23, 2015

How to Handle Three Common Outbound Logistics Deviation Scenarios inSAP Business ByDesign

As many of us have experienced, transactions flow pretty smoothly through an ERP system until a deviation from the norm occurs. Deviations from normal processes can cause incorrect transactions, workarounds, or lost productivity when users do not have sufficient instructions on how to handle these. This blog will cover how to handle three common scenarios within Outbound Logistics in SAP Business ByDesign where deviations from the regular processes might occur.

Thursday, June 18, 2015

10 Tips for Reports and Data Sources in SAP Business ByDesign

Author: Dan Edelman, Senior SAP Business ByDesign Consultant at FMT Consultants
This blog is intended to provide some tips and tricks for creating custom reports or data sources in SAP Business ByDesign. It’s aimed at users that don’t have a reporting background, so if you’re used to building SQL-based reports, just bear with me. This isn’t an end-to-end guide from data source to report, but serves as a reference to use if you’re just getting started, or have gotten stuck trying to figure out how to do something.

Wednesday, June 17, 2015

Video: 5 Brilliant Ways to Customize SAP Business ByDesign (by FMT Consultants)

Like snowflakes, no two businesses are alike, and at times it’s necessary to customize your ERP solution to ensure it works exactly the way your business does.
In this video we’ll demonstrate 5 brilliant examples of how you can customize SAP Business ByDesign to ensure it accommodates your most unique and critical business needs.
Specifically, the video covers:
  1. How Development Works in SAP Business ByDesign
  2. Basic User Assistance – Sales Order Duplicate Check
  3. More Advanced Validation – External Reference Required for Release
  4. Store Custom Data – Approved Supplier List
  5. Upload Custom Data – File Input
  6. Automate Processes – Freight on Customer Invoice

Sunday, June 14, 2015

Enhancement Framework – Introduction

The ABAP Enhancement Implementation concept allows you to easily enhance the standard SAP delivered functionality with your desired one. The ABAP Enhancement Implementation concepts have been in SAP for quite some time now.

What is an Enhancement

An enhancement is used when you need to enhance any standard SAP delivered functionality by introducing new code. There are certain ways to achieve the enhancement:
  • Core Modification – You obtain the access key by registering the object with SAP and make the necessary changes. This is more dangerous and thus least preferable among other techniques. What makes it more dangerous is when SAP provides any OSS note, or during an upgrade, there is a chance of losing your changed functionality if you don’t perform the proper SPAU activity.
  • User Exit – You find SAP delivered Subroutines (PERFORM) which begins with USEREXIT_ in the standard SAP programs. To implement the user exit, you would need to also register the object through OSS. They are little bit safer from an upgrade point of view as they are in a separate include.
  • Customer Exit – You find SAP provided function exits with CALL CUSTOMER FUNCTION ‘001’. This would be a FM with an include. This include would not be delivered by SAP. If you need your new functionality, you need to create the include and implement your code. You would need to create Customer Enhancement Project in CMOD using the Enhancement which houses the Exit function SMOD.
  • BADI (Business Add Ins) – are based on the Object Oriented Concept. Std SAP provides you with the BADI calls. You would need to Create the BADI implementation based on the BADI definition. Then you can add your code in the implementation which is essentially a method in the class. You can implement the same BADI multiple times, if the BADI is set for multiple implementations.

Wednesday, June 10, 2015

Microsoft Dynamics CRM Dynamic Help Feature

Overview: This feature was introduced in the Dynamics CRM 2015 for Outlook Client and is referred to as “Dynamic Help”. Prior to this feature, the Outlook Client included a help link that always directed you to the same troubleshooting page regardless of which error you encountered. For each error code that occurs during configuration, Dynamic Help can now direct you to a KB article designed to help resolve that specific issue. This feature was also backported to CRM 2013 Update Rollup 1 for Service Pack 1 and CRM 2011 Update Rollup 18. The Dynamic Help feature is also included in the new CRM App for Outlook.

Tuesday, June 9, 2015

Why serialization is vital for pharmaceutical product integrity in the cold chain

Read entire article at the Cold Chain View blog.
More than ever before, drug security is an important issue in ensuring the integrity of medicines and vaccines reaching patients. The industry needs to demonstrate that we care for patients, and are putting all necessary measures in place to ensure that medicines are safe to be taken.
That means knowing the entire journey of a medicine through the supply chain, and having fully automated documentation about the conditions on its journey. One of the ways in which this can be addressed in the cold supply chain is through serialization. A key driver for implementing serialization will be global compliance requirements coming into play. The USA introduced the Drug Supply Chain Security Act at the end of 2013, which will require the availability of information at individual package level about where a drug has been in the supply chain.

Monday, June 8, 2015

Making the business case for implementing serialization cost-effectively in the supply chain

Read the full article at the Cold Chain View blog.

As part of the implementation of serialization, automation of the process will become law within 10 years. As already highlighted previously, serialization provides accountability and traceability of every item shipped in the supply chain. The need to conform to these new requirements might at first glance look like it would require costly additional investment. But it need not be – and it might even be more cost-effective, once you take into account the additional benefits that could be obtained.

‘The Smallest Individual Saleable Unit’ In The DSCSA - RxTrace

Drawing from the GS1 Healthcare GTIN Allocation Rules document showing how to assign GTINs in multi-pack scenarios.  Click image to enlarge.
Drawing from the GS1 Healthcare GTIN Allocation Rules document showing how to assign GTINs in multi-pack scenarios. Click image to enlarge.
The U.S. Drug Supply Chain Security Act (DSCSA) requires manufacturers and repackagers to place DSCSA-specific “product identifiers” on all drug packages and homogeneous cases by November 27, 2017 (2018 for repackagers).  These product identifiers must include a Standardized Numeric Identifier (SNI), which is composed of the drugs National Drug Code (NDC) and a unique serial number (for more on DSCSA “product identifiers”, see “The DSCSA Product Identifier On Drug Packages“, for more on the SNI, see “FDA Aligns with GS1 SGTIN For SNDC“, and for more on the NDC, see “Anatomy Of The National Drug Code“).

Thursday, June 4, 2015

SAP Business ByDesign Customization Use-Case: Approved Supplier Lists for Medical Device Manufacturer

"While SAP Business ByDesign has an extraordinary array of out-of-the-box functionality in both breadth and depth, there will always be customer-specific scenarios and use-cases that are not natively handled entirely through standard functionality. Though most ERP systems allow customization to handle these scenarios, what sets Business ByDesign apart is the ability to quickly and easily create custom functionality that can be an integral part of standard processes.

Wednesday, June 3, 2015

How to Create Custom Records in NetSuite – Step by Step Instructions: Part I


In NetSuite, Custom Records are essentially everything and anything.
My bet is that whenever you need a process or a functionality that is not available in NetSuite out-of-the-box, custom records can help you! Custom Records are dynamic and customizable building blocks that allow you to create custom fields, lists and special links with other NetSuite records and transactions.
Custom Records in NetSuite

Tuesday, June 2, 2015

ASAP Methodology Documentation

You can access the entire ASAP methodology in MS excel which shows the phases and sub phases as well as the required resource roles, core subjects and project document template names by clicking here:  ASAP 7.2 Excel

If you are looking for the descriptions of the phases as well as the standard project phase document templates you can access them from here: ASAP Documentation

Monday, June 1, 2015

TIP: Remove “Copy From” in Solman title

ISSUE: When copying a document in Solution Manager, the original title gets “Copy From” as a prefix as the new title. This can cause issues when the length of a document title approaches the limit of 64 characters. Relevant parts at the end of the title can get truncated.
SOLUTION: To solve this you can remove the prefix by following the instruction in SAP note – 1605780. This correction avoids the prefix and thus keeps the original title for the copied document.

Increase User Adoption with Your Own In-House CRM Support Entity in Dynamics CRM 2013 – a Step-by-Step Guide

Increase User Adoption with Your Own In-House CRM Support Entity in Dynamics CRM 2013 – a Step-by-Step Guide - A Blog by FMT Consultants
"User adoption is pivotal when implementing Microsoft Dynamics CRM within your organization. A key component to turning your CRM implementation into a successful investment is by providing timely post go-live and on-going support in a manner that reassures your users that the system will be properly supported. Support could range from training, user feedback, suggestions, enhancement requests, technical issues, bugs, reporting requests, etc.
It’s best to have a solid plan in place, whether that’s using an existing I.T. ticketing system or having dedicated staff. But the reality is that many companies don’t have the time and/or resources to put something in place until after the first critical user adoption period has passed. If users don’t adopt to the system initially, it makes it much harder to get them on board later on.

3PL Operation Under The DSCSA - RxTrace.com paper

Photo from Wikipedia
Dirk Rodgers has written another great article covering the impact on 3PLs when considering the DSCSA - Read the full article on RxTrace.com
Another type of business affected by the U.S. Drug Supply Chain Security Act (DSCSA) is the third party logistics provider (3PL) business.
I wrote an RxTrace essay about the impact of the California pedigree law on 3PLs back in 2013 (see “3PL Operation Under California ePedigree“).  This is an update of that essay to address the impacts of the new DSCSA on 3PLs since the California pedigree law is now obsolete.
There are a number of important differences between wholesale distributors and 3PLs as defined in the DSCSA.

Sunday, May 31, 2015

TIP: Deactivating the SAP menu or user menus

ISSUE: There may be a need to switch off the ability to see the standard SAP menu or the user menu. How can we accomplish that?

Saturday, May 30, 2015

Testing or executing a function module without having access to SE37

ISSUE: In certain environments you may be restricted from using SE37 to execute or test a function module. There is a way around it if you have access to SE38 or SA38.
SOLUTION: Simply use SE38 or SA38 to execute program RSFUNCTIONBUILDER. This brings up a very similar screen to SE37 as shown below, where you can then proceed to test out your function module

Friday, May 29, 2015

TIP: Debugging a popup window

Debugging a report is pretty simple but there is a trick to stopping a debug session when a popup window happens. If the popup window is a result of a message and you know the message number you can search and potentially put a break-point in the code but sometimes you can't do that. In order to stop the code at the popup window do the following:
  • Create and save a TXT file with the following text:
[Function] Command=/H Type=SystemCommand
  • Execute the program and when the popup happens you can drag and drop the TXT file on to the popup window in SAP. Continuing will launch you in to the debugger

Thursday, May 28, 2015

TIP: ABAP System Fields – Structure SYST

Name Type Length Use Description
ABCDE CHAR 26 Constants Alphabet (A,B,C,…)

APPLI RAW 2 Obsolete

BATCH CHAR 1 Background processing Program runs in the background

BATZD CHAR 1 Obsolete

BATZM CHAR 1 Obsolete

BATZO CHAR 1 Obsolete

BATZS CHAR 1 Obsolete

BATZW CHAR 1 Obsolete

BINPT CHAR 1 Batch input Program runs under batch input