Hi there,
I have finally managed to understand the use of the FORMULA column in the conversion files, and how to make it work. But I have come across another problem.
I am trying to load a file with more than one column (i.e. period) of data - my file contains Jan, Feb, Mar, etc. But the conversion formula only seems to apply to the FIRST column of data (in this case, January, but it doesn't matter what month the first column represents).
The rest of the columns are loaded as per the data file, with the formulas only being applied to the first column.
If I use * in both the INTERNAL and EXTERNAL columns in the conversion file, the formula will then apply to all periods, but I can't use this approach as the formula used is dependent on the particular account it relates to.
I thought this was an "undocumented feature" but I have since tested this in both 5.1 and 7.02 with the same result. Is this deliberate, or is there a way around it?
Has anyone come across this and found a way around it?
Many thanks,
Jason