cPanel add new domain

Adding a new domain in cPanel is pretty easy, in Addon Domains > Create an Addon domain. When having a website hosting at one provided, and a domain name registered at another provider – for example gandi.net or godaddy.com – it is necessary to add the domain name to the list of Addon Domains (or external domains), in order to have requests from that URL addressed to defined hosting....
Read more

Find a material classification in SAP

SAP’s Material Master Classification view (Fig 1) is very particular. It does not contain direct values from one or more tables, but it have values from several tables linked together. Even if the general links are quickly explained online[1], it may be useful to learn how to navigate in these tables, this in order to identify particuliar values, and find out easily these values for a group of materials. ...
Read more

How to create a FaceBook business page

Creating a business page on Facebook is pretty straightforward, by going to the specific business page on Facebook. Having a specific business page on Facebook will allow you to build and expand your on-line brand presence, connect and communicate with your customers, drive sales, manage ads, and access specific reports, which are for example not available in Facebook groups or standard profiles....
Read more

How to retrieve deleted WhatsApp messages

The way to restore a chat history is the same as transferring WhatsApp messages from a phone to another, by restoring a WhatsApp backup. Of course, the backups must have been properly setup first. To restore WhatsApp messages, or to transfer WhatsApp messages to a new phone, simply perform the following steps, depending on the exact situation....
Read more

How to share Instagram videos on WhatsApp status

The WhatsApp status being limited to 30 seconds videos, it is better to upload the video on Instagram or another video friendly platform, and share it on the WhatsApp status later on. On Instagram, all you have to do it to open the feed, find the video that you want to share, or the post in general, and tap on the three dots icon on the top right of the post....
Read more

Purchase Info Record in SAP MM S4HANA

A Purchase Info Record, usually simply called PIR, is the link between a material procured externally and the vendor that will effectively supply it. It is a standard data object in the SAP Master Data Management, and the most important information in contains, despite of the link between vendors and materials, is the price for the material per vendor, the conditions of delivery, limits for over-delivery or under-delivery, planned delivery dates, or also availability periods....
Read more

Batch rename files WordPress SEO optimisation

For a better WordPress SEO website optimization, but also not to share your local files names, especially for pictures / images media, and avoid sharing bad names like 11-finalresult.png in the example, but having a nicer ms-excel-2013-how-to-make-a-table-look-good-resize-columns-to-fit-content.png instead, an easy solution is to use an image renamer plugin for WordPress....
Read more

Turn on or off Facebook page reviews

By default, the visitors review on Facebook business page are not activated. In order to activate or deactivate them, go to Settings > Templates and Tabs > Add a Tab > Reviews. Start by opening a business page for which you are administrator, or at least Editor. If you don't have the right role, ask your administrator to grant you a sufficient access level....
Read more

Invoice mass reversal in SAP

Reverse a document in SAP is possible, using the mass reversal tcode in SAP FB08 for individual reversal, and F.80 for mass reversal. Starting with invoices that have been created for example in the transaction FB70 enter customer invoice, we might end up with several customer invoices that we want to cancel, or, to use the proper SAP terminology, to mass reverse....
Read more

Bluetooth paired but not connected Windows 10

It can happen that a Bluetooth device, such as a headset, which has been previously paired and connected on a Windows installation, is suddenly unable to reconnect, ending up with a Bluetooth speaker paired but no sound. There are several possible reasons to this, and several solutions which should allow you to reconnect your device....
Read more

Combine columns in Excel and generate all possible combinations

Having two different data sets, for example a customers list and a products list, and want to combine them to get a new list with all possible combinations of customers and products? The solution is pretty simple, feasible with MS Excel in a few minutes, and, even with thousands of entries, doesn't require much effort – much less than copy pasting the second list for each value of the first list – this last solution would take hours with hundreds of entries. See below how to combine Excel columns and generate all possible combinations Excel....
Read more

How to unlock your laptop when you forgot the Windows 10 password

Fingerprint blocked, PIN not working anymore, password forgotten, can't retrive the Microsoft account, and no WiFi connection ? See below a way to solve it without needing a reset disk - simply plug a phone with USB, sharing the internet connection and reset forgotten Windows 10 password !...
Read more

Amazon Associates OneLink - universal Amazon affiliate link

Amazon just launched Amazon OneLink affiliate, its own way to build global links for products on Amazon affiliate international traffic. Before, users had to manually provide links per Amazon international site to the website visitors, or provide a list of links and let the user choose which one to click on....
Read more

SAP Purchase Info Record Supplier not created by purchasing organization

During a Purchase Info Record (PIR) or PR creation in SAP, the message no 06321 Supplier not created by purchasing organization might occur - the most likely root cause being that the SAP supplier master data used isn't setup as a vendor master record, and therefore you need a business partner master data vendors to be created....
Read more

SAP How to solve Version is not defined for fiscal year

Facing the issue Version 0 is not defined for fiscal year 2017. message no. gp626, probably while trying to create a Purchase Order in SAP using ME21N ? As explained in the Performance Assistant error description, solution is to maintain the fiscal year dependent version, as the version 0 is not defined in controlling area 2000 for the fiscal year 2018....
Read more

Notepad++ install Python Script plugin with Plugin Manager

In order to be able to run a lot of interesting scripts (see Notepad++ randomize, sort lines random), written in Python language in Notepad++, you need to install the Python script plugin. You can either download and install it manually, or install it automatically with the Plugin Manager, that you can find in menu Plugins > Plugin Manager > Show Plugin Manager....
Read more

SAP define a Partner System for IDoc Inbound Processing

When trying to generate IDocs, getting the information message “No partner exists with the name ”, type ”” (Fig 1), means that a “Partner System” has to be set up. Defining a “Partner System” will allow to select IDocs for processing by “Partner System”, which can be set by project, in order to allow different teams to work on different IDocs at the same time for example....
Read more

SAP export LSMW batch input session results

Sometimes, when running an LSMW batch input session (Fig 1), we want to get the results in a useful format - like a spreadsheet, or a raw text file. This to handle, use and compare results. Once we ran our session, in transaction SM35 (Batch Input : Session Overview), we can select it, for example one in error. We choose it, and then select Log display (Fig 2). In the log display, we select the line, and click on "Display" (Fig 3). ...
Read more

SAP how to create a profit center - solve issue profit center does not exist

While creating a Cost Center in SAP, the issue KM701 Profit Center does not exist might arise - or, simply, looking how to create a Profit Center ? Or trying to use an inactive Profit Center, but getting the error KM738 Profit center saved in inactive status (see below for this last error) ? ...
Read more

SAP extract Forecasting parameters (MPOP structure)

SAP MPOP structure is not a real table, and is not directly accessible, for example using SE16N (Fig 1). Therefore, if we want to extract Material Master’s MPOP data for a given set of materials, it must be done by accessing several tables, MAPR (Fig 2) and PROP (Fig 3), which contains information from the Material Master’s Forecasting view (Fig 4). ...
Read more

Create a MySQL table with automatic creation date and modification date fields in PHPMyAdmin

Creating fields with time stamps that contains the creation and / or the last modification dates in MySQL using PHPMyAdmin is straightforward. No need for specific SQL code in latest versions, as it is now possible to have two different fields in the same table with current timestamp as default, and therefore no need to use triggers anymore for this purpose. ...
Read more

Fix Google PageSpeed Eliminate render-blocking JavaScript and CSS in above-the-fold content

The Google PageSpeed [1] test “Eliminate render-blocking JavaScript and CSS in above-the-fold content” propose you to delivers your site’s JS and CSS files after the HTML is fully loaded – and, therefore, do not pause your HTML loading to download them. ...
Read more

SAP Message C+302 – Material ledger not active in plant

When trying to start a job production startup of material ledger in transaction CKMSTART, the error message C+302, Material ledger not active in plant, might occur To solve this error, go to the customizing IMG, transaction SPRO, and navigate to Controlling > Product Cost Controlling > Actual Costing/Material Ledger > Activate Valuation Areas for Material Ledger ...
Read more