Calculate S.R. Through Formula

YouTube: How to Calculate Sale Rate Using a Formula in Purchase ?

How to Calculate Sale Rate Using a Formula in Purchase?

In this tutorial, we will demonstrate how Logic ERP can automatically calculate the sale rate based on a predefined formula within the purchase voucher.

Step-by-Step Guide:

• Navigate to Purchase Configuration.

• Locate and enable the option: “Calculate S.R. Through Formula.”

• Define the Sale Rate Formula:

  • Navigate to the Define Rate Formulas Other Settings - 1.

  • Specify the Expense Name relevant to the calculation.

  • Set the Base Rate, usually the Purchase Rate.

  • Optionally, define a default value for any expense that needs to be added or subtracted from the base rate.

• Use Related Fields in Formula:

  • You can include variables such as margin percentage, additional costs, or discounts.

  • Example: If the Purchase Rate is ₹100 and a 20% margin is added, the Sale Rate will be ₹120.

Create a Purchase Voucher:

• Enter the transaction details and input the basic purchase rate for each item.

• The Sale Rate will now be automatically calculated based on your defined formula.

Conclusion:

This feature helps automate pricing, eliminate manual errors, and ensures consistency in sale rates across transactions in Logic ERP.