Altering Amount in Entry Field - Solved

My Greetings,
I want to know if the Amount column in the Voucher Entry screen is editable. For example I want (column1 * column2 * Column3 * Rate * Qty) on the amount field (VCH Value). I tried adding an option in the field and deleted the set as and set by condition and added a new condition to calculate what I mentioned but its not working. But if I calculate everything except rate then it is calculated into Amount field (VCH Value) but when i go to the rate column the rate is adapted to the amount and qty. And yes i have deleted the set as and set by condition in VCH Rate too. Kindly guide me to solve this.

This is my Code

Code:

[#Field    : VCH Rate]
 
    Option        : Ray VCH Rate    : @@ISSales
 
[!Field    : Ray VCH Rate]
 
    Delete    : Set By Condition
    Delete    : Set as
 
[#Field: VCH VALUE]

    Option        : Ray VCH Amt    : @@ISSales

[!Field    : Ray VCH Amt]
 
    Set By Condition    : Yes    : @@AmtCalculation
    Set Always: Yes
 
[System    : Formula]
 
    AmtCalculation    : $$AsAmount:$RayVCHCalc1 * $$AsAmount:$RayVCHCalc2 * $$AsAmount:$RayVCHCalc3 * $$AsAmount:$BilledQty * $Rate

 

Try With :

Resetval@AmtCalculation

 

First of all, Thank you for replying

i tried the method you suggested and it didn't work. I added a new dummy field to store the rate and calculate. Now the calculation is working but the problem is that the Rate field is changing in respect with the Quantity and Rate instead of taking my New fields into account and staying the same.

 

I think i figured it out with the help of your Idea. Thank you Mr. Johar. I will revert if i have any other issue going forward.