Gross Amount Qty
YouTube: How to Configure Shortage (%) , Gross Qty , Net Qty , and Impact on Calculations in Sale Bill?
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:
Gross Amount Qty
Gross Quantity Change
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
Go 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:
Net Quantity
Gross Quantity
Below it, configure the related setting under the Other Settings - 3.
"Gross Quantity Change" Available options:
Update Net Quantity
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).
Configuration:
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
You apply 10% shortage
System Behavior:
Shortage Percent updates
Gross Quantity adjusts accordingly
Net Quantity remains unchanged
Gross Amount still based on Net Quantity
Gross Quantity Change = Quantity as Gross Quantity
Apply 10% shortage
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.
Configuration:
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
Apply 10% shortage
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
Apply 10% shortage
System Behavior:
Gross Quantity updates to 90
Net Quantity remains unchanged
Gross Amount is calculated using updated Gross Quantity (90)
Summary Table
Config
Shortage Applied
Gross Qty
Net Qty
Amount Based On
Gross Amt Qty = Net Qty GQ Change = Update Net Qty
10%
100
90
Net Qty (90)
Gross Amt Qty = Net Qty GQ Change = Update Shortage Only
10%
90
100
Net Qty (100)
Gross Amt Qty = Net Qty GQ Change = Qty as Gross Qty
10%
90
100
Net Qty (100)
Gross Amt Qty = Gross Qty GQ Change = Update Net Qty
10%
100
90
Gross Qty (100)
Gross Amt Qty = Gross Qty GQ Change = Update Shortage Only
10%
90
100
Gross Qty (90)
Gross Amt Qty = Gross Qty GQ Change = Qty as Gross Qty
10%
90
100
Gross Qty (90)
Final Notes
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