Hi All,We're currently trying to map IC relationships in the transformation rules where the source data doesn't contain this field. We can map this based on the GL account from the ERP system but just unsure on how to do this in OneStream. Essentiall...
Hi, I have some accounts I either need to map to an asset account (100000) or liability account (200000). The mapping should be based on the total account incl. sum of all dimensions. e.g. A#12345:I#IcpA = 2000 A#12345:I#ICPB = -3000 Then both accoun...
Hi all,I'm having an issue whereby I'm importing profit and loss actual's data via a csv file into one of the data upload workflow steps we have set up.However some of the data is being loaded into months it shouldn't be, even though on the in the cs...
Hi! I have a matrix source file with cost centers (UD1) in different columns. As I see it I run in to two problems. First one is that I extract a separate file for each entity, and different entities have different amount of cost centers. The second ...
Hi experts, I have a group of GL accounts that I need to map to either an expense / revenue based on the sum of the balances.I thought this would be easy enough with a derivative rule; first create an interim rule to aggregate the accounts and then c...
