ContributionsMost RecentMost LikesSolutionsRe: Liquidated entities with nil balance in forms Thanks for that MG - I must admit I did think it was more an accounting treatment issue after typing this all out. I'll go and check the balances etc based on your suggestions. Liquidated entities with nil balance in forms Hi all, I'm after some guidance for a capex form that I'm currently developing. Simply, it's a form that takes the current month closing balance (BS accounts) less the prior month closing balance,...SolvedCombining data from 2 cubes to calculate Creditor days Hi all, I'm after a bit of advice. We have a STAT cube which has BS and PL data and there is a MGMT cube which has PL data but goes to the level of Regions (UD1) and Departments (UD2). There is...Re: Amount and Pct variance confirmation rules for all base accounts Thanks Henning - much appreciated. A lot of useful tips in there, but I still can't quite nail what I need. I guess this is where my lack of vb.net knowledge comes in... I've used manage to source ...Amount and Pct variance confirmation rules for all base accounts Hi all, I'm putting together confirmation rules for various forms, and have got a few working where the explained items clears a check to zero. These checks are isolated to a few accounts, and are...Re: Value from CustomCalc not storing after processing cube - DM Roll Forward Form job Thank you Henning, that's solved the problem.I'm still learning business rules as I go, so I do miss some of the syntax rules every so often. In hindsight, maybe I hadn't previously processed the...Value from CustomCalc not storing after processing cube - DM Roll Forward Form job Hi all, I have developed a process to rollover a form from one period to the next. Specifically prepayments, where the monthly movement is explained for 4 GL accounts using 20ish flows. The user e...SolvedRetaining parameter value when navigating between forms - is it possible? Hi all, I am building some form templates for my workflow profiles, and have a query regarding the best way to setup the form template and entity parameter (setup below): I woul...Changing the Cube Root Workflow Profile via button Hi all, I am designing a dashboard home page whereby users can navigate directly to the different Workflows for Statutory reporting and Management Reporting, via a button. I am utilising the Change...Re: BI Viewer - linking with Cube Views JackLacavaI have successfully created a Lamp state indicator which pulls in my BS check value. However, there doesn't seem to be any way to use the lamp indicator with an action to open the cube vie...