About Roelofg

Problem Statement: We develop a table setting out the results of transactions per code type across multiple categories (AP, AR, GL. etc). The results are calculated from detailed transactions  . The customer process dictates that the amounts determined should allow for overrides to assign the amounts (all or a portion) to another area within the same code e.g. Code BO87 from AR to AP on the same code using an override column per category     The underpinning formulas are:  Requirement: The Override column must enable user inputs (overrides) and the results has be recalculated. The layout and results does not allow for manual input       ... View more

I am busy with the level 2 training and hit a small hick-up   I build a few modules referring to the P3 SKU list and worked fine until yesterday.   This morning i get this message: But if i look at the list, i can see the list items  There are no sub sets     Where do you  suggest that i have to look to resolve this challenge?   ... View more

I spend the last 2 days trying to dynamically linked a specific date (specified by a user)   I created a module to have visible the versions, country and initiatives (as my lists) and of course the line cost items and calculate the monthly charge per cost line item per costing type based on the elapse time between start and end dates   One of the line items is start date (there is an End Date as well but i think it will be resolved as for the Start Date). The monthly cost items has to be linked to the dates   This is part of an "input sheet"      Then to assign the cost to time, I created another Module. This one will assign the  monthly costs to time based on the versions, country and initiatives.   The idea to determine the monthly cost per cost type and per cost item and the first occurrence on the time line has to correspond with the start date on the input sheet and of course the last occurrence the end date.   Now – the problem statement:   My plan was to use the start date and end date to assign start and end dates  to determine start and end time periods.    I have tried numerous options without success:     ... View more