In a prior post, I'd asked if there was a way to use the FINDITEM function to determine if a list item is a member of a subset. The answer at the time was no, but you could create a line item with an Applies To on the subset, and set the formula to TRUE, then you could create another line item with Applies To on the full list and reference the subset line item. Turns out, you can use FINDITEM on a subset, but you have to type out the subset name, as opposed to navigating to the list and clicking the subset header. This was demonstrated in the line item subset training, which I validated in my L1MB model. This might be common knowledge, but I wanted to put it out there, in case there are any out there that were like me thinking, "There's got to be a better way!"
... View more
I have an issue in which we currently control user Read/Write access to Forecast and Budget versions via ROLES. This appeared to work well as it allows the users to view data within the platform and not change values via input. However, we recently had an issue in which a user utilizing a Role that was currently set to Read Only inadvertently clicked on a Process button embedded within one of the classic dashboards and it ran the underlying actions. Has anyone else encountered this? If so, was there a resolution other than turning Actions off and on?
... View more
Hi, When adding the formulas to the line items for REV05 Price Growth Rates Staging module, I get the following error: The formula for 'REV05 Price Growth Rates Staging'.Unit Cost % is invalid: 'REV05 Price Growth Rates Staging'.Unit Cost % = 'REV04 Price Growth Rates'.Unit Cost %[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product Family] Any help is appreciated. Thanks.
... View more
Hello, 3.3.5.1 Create Inventory Ordering Module I'm having the hardest time understanding which line item to use in the Confirmed PO Delivery formula. The threads I've read keep referring me to the POST function, but I'm not at that point in the training yet. The following set of instructions are confusing me: Set the Confirmed PO Delivery line item to use the PO Submitted 1 value and OFFSET it based on the number of weeks between the order and delivery. For example, if a PO Submitted has a value in Week 1 and the Shipping Time Weeks has a value of 2, there would be a value of 1 in the Confirmed PO Delivery line item in Week 3. Use the OFFSET function and reference the Shipping Time Weeks line items (should pull the value from the periods prior)" My formula is:IF PO Submitted = 1 THEN OFFSET(-Ending Inventory, Shipping Time Weeks, 0) ELSE 0 I guess I don't understand how the output of this value relates to the user story or why we need it, or perhaps I could figure out which line item to use.
... View more
Hi, We have implemented DCA and applied the Read/Write access drivers in other Modules , post which it has actions to be executed. Once the processes are run, DCA works differently in 2 scenarios as mentioned below: 1. The data for the process "creation of staging list" executes but does not update the data (Step C : Ignored: 40608 ->as displayed in picture below). Rest of the processes runs as per expectation. 2. The process "creation of staging list" is FAILED . Due to which next 2 processes are also failing. This issue hampers the space in system as the Staging list is created (STEP. a), but not getting deleted at the final process as per the expectation. Please see below picture for the error.@ Please do let me know how to rectify this so that the Step C does not fail in 2nd scenario. The expectation is to make it work as mentioned in 1st scenario stated above. Thanks, Shradha
... View more