Skip to main content

Invoice Charge Calculation Methods

Distributor reference for how each invoice charge calculation method in Encompass computes tax, split-case bottle charges, deposits, fuel surcharges and per-gallon or proof-gallon charges. Requires v23.01+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 23.01

Steps

Tax Based Calculation Methods:
​
​

1,1) Percentage of Invoice Total (Tax);

  • InvoiceTrans.NumUnits * InvoiceTrans.UnitPrice


6,6) Percentage of Invoice Total Display In-Line Only;

  • InvoiceTrans.NumUnits * InvoiceTrans.UnitPrice


7,7) Split Case Percentage of Invoice Total (Tax);

  • CASE WHEN Products.WholesaleUnitsPerCase > 1 THEN

  • CASE WHEN CAST(InvoiceTrans.NumUnits AS signed) % Products.WholesaleUnitsPerCase <> 0 THEN Round((InvoiceTrans.NumUnits * InvoiceTrans.UnitPrice), 2)

  • ELSE 0 END

  • ELSE

  • CASE WHEN 1 * (InvoiceTrans.NumUnits % 1) <> 0 THEN Round((InvoiceTrans.NumUnits * InvoiceTrans.UnitPrice), 2)

  • ELSE 0 END

  • END


8,8) Per Gallon (Volume Tax);

  • (InvoiceTrans.NumUnits * Products.Ounces / Products.WholesaleUnitsPerCase) / 128


9,9) Per Liter (Volume Tax);

  • (InvoiceTrans.NumUnits * Products.Ounces / Products.WholesaleUnitsPerCase) * 0.0295735296875


10,10) Percentage of Invoice Total + Invoice Charges;

  • InvoiceTrans.NumUnits * (InvoiceTrans.UnitPrice + InvoiceTrans.InvoiceCharge1 + InvoiceTrans.InvoiceCharge2 + InvoiceTrans.InvoiceCharge3 + InvoiceTrans.InvoiceCharge4 + InvoiceTrans.InvoiceCharge5)


18,18) Michigan Liquor Tax 4% 3 Times;

  • InvoiceTrans.NumUnits * 3 * Round(0.04 * InvoiceTrans.FullPrice, 2)


20,20) Per Proof Gallon;

  • CASE WHEN IFNULL(PackageConversions.UnitofMeasure, 0) = (Gallons) THEN PackageConversions.ConversionUnits * (InvoiceTrans.NumUnits / Products.WholesaleUnitsPerCase) * ((Brands.AlcoholByVolume * 2) / 100) ELSE 0 END


Split Case Calculation Methods:
​
​

4,4) Split Case Bottle Charge;

  • When Products.WholesaleUnitsPerCase > 1, InvoiceTrans.NumUnits % Products.WholesaleUnitsPerCase Else (InvoiceTrans.NumUnits % 1) * Packages.UnitsPerCase


11,11) Split Case Bottle Charge Positive Units Only;

  • InvoiceTrans.NumUnits must be greater than 0.

  • When Products.WholesaleUnitsPerCase > 1, InvoiceTrans.NumUnits % Products.WholesaleUnitsPerCase Else (InvoiceTrans.NumUnits % 1) * Packages.UnitsPerCase


16,16) Split Case Bottle Charge Except Free Goods;

  • CASE WHEN CustomerHistory.Backorder > 0 AND CustomerHistory.BackorderDate = (Invoice Date)THEN

  • CASE WHEN (InvoiceTrans.UnitPrice > 0) THEN

  • CASE WHEN Products.WholesaleUnitsPerCase > 1 THEN (CAST(InvoiceTrans.NumUnits + CustomerHistory.Backorder AS signed) % Products.WholesaleUnitsPerCase)

  • ELSE (ROUND((InvoiceTrans.NumUnits % 1) * Packages.UnitsPerCase, 0)) END

  • ELSE 0 END

  • ELSE

  • CASE WHEN (InvoiceTrans.UnitPrice > 0) THEN

  • CASE WHEN Products.WholesaleUnitsPerCase > 1 THEN (CAST(InvoiceTrans.NumUnits AS signed) % Products.WholesaleUnitsPerCase)

  • ELSE (ROUND((InvoiceTrans.NumUnits % 1) * Packages.UnitsPerCase, 0)) END

  • ELSE 0 END

  • END


21,21) Split Case Bottle Charge Except Free Goods Positive Units Only;

  • InvoiceTrans.NumUnits must be greater than 0.

  • CASE WHEN CustomerHistory.Backorder > 0 AND CustomerHistory.BackorderDate = (Invoice Date)THEN

  • CASE WHEN (InvoiceTrans.UnitPrice > 0) THEN

  • CASE WHEN Products.WholesaleUnitsPerCase > 1 THEN (CAST(InvoiceTrans.NumUnits + CustomerHistory.Backorder AS signed) % Products.WholesaleUnitsPerCase)

  • ELSE (ROUND((InvoiceTrans.NumUnits % 1) * Packages.UnitsPerCase, 0)) END

  • ELSE 0 END

  • ELSE

  • CASE WHEN (InvoiceTrans.UnitPrice > 0) THEN

  • CASE WHEN Products.WholesaleUnitsPerCase > 1 THEN (CAST(InvoiceTrans.NumUnits AS signed) % Products.WholesaleUnitsPerCase)

  • ELSE (ROUND((InvoiceTrans.NumUnits % 1) * Packages.UnitsPerCase, 0)) END

  • ELSE 0 END

  • END


​
Other Invoice Charges:


2,2) Per Invoice (Fuel Surcharge);

  • 1*rate per invoice


3,3) Per Product (Bottle Deposit);

  • InvoiceTrans.NumUnits * InvoiceCharges.Units


5,5) Percentage of Invoice Value (Handling Charge);

  • Absolute Value(InvoiceTrans.NumUnits * InvoiceTrans.UnitPrice)


19,19) Percentage of Full Price;

  • (Round(InvoiceTrans.NumUnits * InvoiceTrans.FullPrice * InvoiceCharges.Units, 6))


22,22) Per Product (Bottle Deposit) Positive Units Only

  • InvoiceTrans.NumUnits must be greater than 0.

  • InvoiceTrans.NumUnits * InvoiceCharges.Units

Did this answer your question?