Calculation

YouTube: How to Configure Bill-Wise or Item-Wise Calculation of Taxes and Discounts in Sale Bill ?

How to Configure Bill-Wise or Item-Wise Calculation of Taxes and Discounts in Sale Bill?

 In this tutorial, we’ll guide you through the Calculation Mode feature in Logic ERP and how to configure it for your sales billing process.


Access Sales Voucher Configuration

  • Navigate to Sales Voucher Configuration.

  • Select the relevant Billing Series.

  • Locate the option labeled "Calculation".

  • You will find two modes available:

    • Bill Wise

    • Item Wise

As mentioned above, follow the given steps and select the appropriate option from the dropdown as per your requirement.

Bill Wise Calculation Mode

  • Select Bill Wise in the Calculation setting.

  • Then, navigate to the Billing and create a new Sale Bill.

  • Choose a Tax Region and define the Tax Type from the dropdown next to it.

How It Works:

  • Taxes are applied uniformly based on the selected Tax Type for the entire bill, not per item.

  • All applicable discounts are also applied bill-wise.

The image shows that despite the second item exceeding ₹1000, 5% GST is applied due to Bill Wise tax settings, which apply a uniform rate to all items.

Example:

  • Two items are billed under the Apparel Trade category:

    • Item 1: Price < ₹1000 → 5% Tax

    • Item 2: Price > ₹1000 → Still 5% Tax

  • Reason: The selected Tax Type in the bill header overrides item-specific tax rates.

When to Use:

  • Ideal when taxes and discounts should apply to the total value of the invoice.

  • Common in industries with uniform tax slabs or discount structures.


Item Wise Calculation Mode

  • Select Item Wise in the Calculation setting.

How It Works:

  • Taxes are applied individually, based on each item's tax configuration in the Item Master.

  • Discounts can also be set and applied item-wise.

The image shows item-wise tax application, with each item taxed per its defined rate.

Example:

  • Each item is taxed according to its actual tax slab.

  • Discounts vary per item and are not dependent on the overall bill total.

When to Use:

  • Useful when different items in the bill have distinct tax rates or discounts.

  • Ideal for mixed-item transactions across multiple tax brackets.


Summary Table

Calculation Mode

Tax Application

Discount Application

Use Case

Bill Wise

Based on bill header

On total bill

Uniform tax/discount on entire invoice

Item Wise

Based on each item master

Individually per item

Mixed tax rates and discount structures

Last updated