How to do calculation before import of data
I have a situation here where I need to map accounts to specific BPC accounts and use them in formula at the same time:
Ex. I have accounts Stock Value A and Stock Value B both mapped to account Stock Value, Product A and Product B both mapped to account Product. Then, I have an account Total Net Cost which is Stock Value less Product. Now, I need to break Net Cost into two child Net Cost A and Net Cost B wherein Net Cost A = Stock Value A - Product A and Net Cost B = Stock Value B - Product B. But in my structure I only have:
Net Cost A
Net Cost B
Of course I could simply create sub-accounts for Stock Value and Product and map the data accordingly to arrive at individual values of Net Cost A and B but I have conflict the Planning side of our application, so I'm thinking if there is a way I could use the conversion file to do the calculation so that before the values for Stock Value and Product are imported, I've already calculated the individual values of Net Cost A and B.