YouTube: How to Configure Shortage (%) , Gross Qty , Net Qty , and Impact on Calculations in Sale Bill?
This tutorial explains two key configuration parameters in the Sale Voucher Configuration:
These settings control how amounts are calculated based on net or gross quantity and how shortages affect quantity fields during sales billing.
Access Sale Voucher Configuration
Navigate to Sale Voucher Configuration.
Select the relevant Billing Series.
Under the Other Settings - 2.
Locate the option labeled as:
"Gross Amount Qty"
This option offers two modes:
Below it, configure the related setting under the Other Settings - 3.
"Gross Quantity Change"
Available options:
Update Shortage Percent Only
Quantity as Gross Quantity
"Let's understand both options of Gross Amount Qty one by one."
Option 1 - Gross Amount Qty = Net Quantity
In this mode, the gross amount is calculated based on the net quantity (after applying any shortage).
Gross Amount Qty = Net Quantity
Gross Quantity Change Options: Let’s explore all three one by one.
Gross Quantity Change = Update Net Quantity
Scenario: You enter 100 units and apply a 10% shortage.
System Behavior:
Net Quantity updates to 90
Gross Quantity remains at 100
Gross Amount is calculated based on Net Quantity (90)
Gross Quantity Change = Update Shortage Percent Only
System Behavior:
Gross Quantity adjusts accordingly
Net Quantity remains unchanged
Gross Amount still based on Net Quantity
Gross Quantity Change = Quantity as Gross Quantity
System Behavior:
Gross Quantity updates to 90
Net Quantity remains unchanged
Gross Amount is still calculated using Net Quantity
Option 2 - Gross Amount Qty = Gross Quantity
In this mode, the gross amount is calculated using the gross quantity.
Gross Amount Qty = Gross Quantity
Let’s now explore how each "Gross Quantity Change" parameter behaves.
Gross Quantity Change = Update Net Quantity
Apply 10% shortage on 100 units
System Behavior:
Net Quantity updates to 90
Gross Quantity remains at 100
Gross Amount is calculated using Gross Quantity (100)
Gross Quantity Change = Update Shortage Percent Only
System Behavior:
Shortage Percent is updated
Gross Quantity adjusts (e.g., from 100 to 90)
Net Quantity remains unchanged
Gross Amount is calculated using Gross Quantity
Gross Quantity Change = Quantity as Gross Quantity
System Behavior:
Gross Quantity updates to 90
Net Quantity remains unchanged
Gross Amount is calculated using updated Gross Quantity (90)
Gross Amt Qty = Net Qty
GQ Change = Update Net Qty
Gross Amt Qty = Net Qty
GQ Change = Update Shortage Only
Gross Amt Qty = Net Qty
GQ Change = Qty as Gross Qty
Gross Amt Qty = Gross Qty
GQ Change = Update Net Qty
Gross Amt Qty = Gross Qty
GQ Change = Update Shortage Only
Gross Amt Qty = Gross Qty
GQ Change = Qty as Gross Qty
Net Quantity: Used for actual stock movement.
Gross Quantity: Used for billing and calculation when shortages are involved.
Selecting the correct configuration depends on your business logic, shortage handling, and billing policy.
Last updated