Translation rules doesn't execute

Hello all,

below rules doesn't seem to work. I input rates in A#IS13ActRate. I wanted HFM to translate all accts with C2 ISRate_13 using the rates in A#IS13ActRate and write it back in the same C2. but HFM ignored this rule and continued use the rate I loaded to [None] for the current period. does anyone know how to resolve it?

Sub Translate()

    

     HS.TransPeriodic "C2#ISRate_13","C2#ISRate_13","A#IS13ActRate",""

End Sub