Update Rates from formula before saving

YouTube: How to Update Rates from Formula before Saving in Purchase?

How to Update Rates from Formula before Saving in Purchase?

 In this tutorial, we will discuss an essential feature in purchase entry that allows automated rate calculation using predefined formulas.

Steps to Configure & Apply the Feature:

  • Navigate to the "Purchase Voucher Configuration".

  • Locate the option and enable "Update Rates from formula before saving".

Let's keep this feature enable to observe it's Impact.

Implement in Purchase Voucher:

  • Create a new "Purchase Voucher".

  • Define the item and its details.

  • The purchase rate is automatically calculated using a predefined formula set in the purchase voucher configuration.

  • Save the purchase voucher.

    • Note: Currently, we have not defined the scheme amount, so the purchase rate is 1048.95.

This picture displays the Rate without the Scheme Rs.

Define Scheme Amount:

  • To define the scheme in rupees, press Shift + F5 in the rate field.

Define the Scheme Rs here as instructed.

Purchase Rate After Defining Scheme(Rs)

  • Modify the Recently Created Purchase Bill

In this picture, you can see that the rate has been updated successfully.

Result: The purchase rate is successfully updated as per the predefined formula.

Conclusion

This feature helps in automating purchase rate calculations, reducing manual errors, and ensuring accurate billing.

Last updated