Divide Bill Wise Amounts

YouTube: How to Distribute Bill-Wise Charges or Discounts to Line Items in Sale Bill ?

How to Distribute Bill-Wise Charges or Discounts to Line Items in Sale Bill?

 In this tutorial, we’ll explore a powerful feature in Logic ERP that lets you distribute bill-wise discounts either by gross amount or quantity, offering enhanced control and accuracy in billing.


Access Sales Voucher Configuration

  • Navigate to the Sales Voucher Configuration.

  • Select the Relevant Billing Series.

  • Locate the option: "Divide Bill Wise Amounts".

    This option provides two settings:

    • Divide on Gross Amount Basis

    • Divide on Quantity Basis

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

Option 1: Divide on Gross Amount Basis

  • Select "Divide Bill Wise Amounts on Gross Amount Basis".

  • Save the configuration.

  • Proceed to the Sales Billing Window.

  • Add multiple items to the bill.

  • Apply a Special Discount (e.g., ₹500) under Other Details.

As shown in the image above, enter the discount amount in the "Sp Disc (Rs)" column.
  • Save the voucher.

  • Generate the Sales Report.

Observation:

The special discount is proportionally distributed based on each item’s gross amount.

This image illustrates the proportional distribution of the special discount based on each item's gross amount.

Option 2: Divide on Quantity Basis

  • Return to Sale Voucher Configuration and Locate the option: "Divide Bill Wise Amounts on Quantity Basis".

  • Save the changes.

  • Create a New Sales Bill with the same items, quantity, and rate.

  • Again, apply a ₹500 special discount.

As shown in the image above, enter the discount amount in the "Sp Disc (Rs)" column.
  1. Save the bill.

  2. Open the Sales Report.

  3. Select the respective entries and generate the report.

Observation:

This time, the special discount is distributed based on the quantity of each item, regardless of the item's value.

This image shows the special discount distributed by item quantity, not item value.

Summary Table

Option

Discount Allocation Based On

Gross Amount Basis

Proportional to the total value of each item

Quantity Basis

Proportional to the quantity of each item


Last updated