Work
SAP Business One Account Determination manual updated
I just updated a few account on the SAP Business One GL account determination guide.
Tools
Advanced cube reporting with budgets based on Excel formulas
This blog shows the Excel formulas CUBEVALUE and CUBEMEMBER for advanced self-BI in Microsoft Excel. The example report compares actuals and budget of sales grouped by item group and month.
Tools
How to place Excel-based cube-reports in SAP menu
After installing coresuite cube, pre-defined reports which contain inspiring content are directly available in the SAP menu. This blog post shows, how users can add additional Excel Reports to the SAP menu.
Work
Process coresuite cubes with customize
When installing coresuite cube, the load jobs will be triggered by default at midnight. What is, when the CFO makes some financial transactions and want to see the result immediately in his Excel-Report based on the cube?
Work
SAP Business One Transaction Notification Part 2
Introduction Sometimes it is necessary to block transactions in SAP. For example manual bookings to the inventory account, or a wrong currency in a price list and so on. Because there are many ways to modify data in SAP (UI, AddOn, B1i, other connectors), the one and only way to Read more…
Work
SAP Business One Transaction Notification Part 1
Sometimes it is necessary to block transactions in SAP. For example manual bookings to the inventory account, or a wrong currency in a price list and so on. Because there are many ways to modify data in SAP (UI, AddOn, B1i, other connectors), the one and only way to validate data is the SAP transaction notification.
Work
SAP Business One Form Types and Object Types
Nothing special, just a small overview of SAP Business One (sbo) Object Types and Form Types
Tools
SAP B1 8.81 PL 08 with BI OnDemand Integration
With the patch 08 of SAP B1 8.81, there is a small integration to bi.ondemand.com. This blog post shows, how it works.
Tools
SAP B1 8.81, multi dimensional cost accounting and coresuite cube
What was already possible in the B-Cluster of SAP 2007, is now also possible with SAP 8.81 for the different localizations: Multi dimensional distribution rules, mandatory distribution rules, manual distribution rules. Here you find a small overview, how it works, and how it is possible to browse the data in Excel with the coresuite cube.
Tools
SAP 8.81 with nice “relationship map”
The latest patch (PL 05) of SAP 8.81 has a new functionality, called “relationship map”, which can be opened in the right-click menu of a document.