This blog post shows, how easy it is to import advanced G/L account determination rules in SAP Business One via Excel. This post provides a coresuite customize new menu rule plus an Excel template.
This blog shows how to solve the issue when the drill through in Excel fails and following error message appears: XML for analysis parser error: The LocaleIdentifier property is not overwritable and cannot be assigned a new value.
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.