Billing measures

Measure Source and/or calculation
BH Additional Discount Base Amount BillingInvoice.AdditionalDiscountBaseAmount
BH Additional Discount Currency Amount BillingInvoice.AdditionalDiscountCurrencyAmount
BH Additional Discount Currency Rate BillingInvoice.EnteredDiscount.BaseAmount.EnteredCurrencyRate
BH Billing Invoice Count BillingInvoice.UniqueID
BH Commission Rate 1 BillingInvoice.CommissionRate1
BH Commission Rate 2 BillingInvoice.CommissionRate2
BH Commission Split Percentage BillingInvoice.CommissionSplitPercentage
BH Currency Rate BillingInvoice.CurrencyRate
BH Customs Total BillingInvoice.CustomsTotal
BH Discount Base Amount BillingInvoice.OrderDiscount.BaseAmount.EnteredCurrencyAmount
BH Discount Currency Amount BillingInvoice.OrderDiscount.TransactionAmount
BH Discount Currency Rate BillingInvoice.OrderDiscount.BaseAmount.EnteredCurrencyRate
BH Discountable BillingInvoice.Discountable
BH Down Payment Base Amount BillingInvoice.CashInAdvance.BaseAmount.EnteredCurrencyAmount
BH Down Payment Currency Amount BillingInvoice.CashInAdvance.TransactionAmount
BH Down Payment Currency Rate BillingInvoice.CashInAdvance.BaseAmount.EnteredCurrencyRate
BH Electronic Payment Settlement Base Amount BillingInvoice.ElectronicPaymentSettlementBaseAmount
BH Freight Charge Base Amount BillingInvoice.FreightChargeBaseAmount
BH Freight Charge Currency Amount BillingInvoice.FreightCharge.TransactionAmount
BH Freight Charge Currency Rate BillingInvoice.FreightCharge.BaseAmount.EnteredCurrencyRate
BH Freight Total BillingInvoice.FreightTotal
BH Gross Base Amount

IF [Grain(Billing Invoice Line).Sum: BL Entered Price] IS NOT NULL THEN

[BH Gross Base Amount] = [BL Billing Invoice.Total Inventory Goods Base Amount] + [BL Billing Invoice.Total Non Inventory Goods Base Amount] + [Grain(Billing Invoice Line).Sum: BL Entered Price] + [BL Billing Invoice.Total Add On Base Amount] + [BL Billing Invoice.Freight Charge Base Amount]

ELSE

[BH Gross Base Amount] = [BL Billing Invoice.Total Inventory Goods Base Amount] + [BL Billing Invoice.Total Non Inventory Goods Base Amount] + [BL Billing Invoice.Total Add On Base Amount] + [BL Billing Invoice.Freight Charge Base Amount]

END IF

BH Insurance Total BillingInvoice.InsuranceTotal
BH Invoice Net Base Amount

IF [Grain(Billing Invoice Line).Sum: BL Entered Price] IS NOT NULL THEN

[BH Invoice Net Base Amount] = [BL Billing Invoice.Total Inventory Goods Base Amount] + [BL Billing Invoice.Total Non Inventory Goods Base Amount] + [Grain(Billing Invoice Line).Sum: BL Entered Price] + [BL Billing Invoice.Total Add On Base Amount] + [BL Billing Invoice.Freight Charge Base Amount] - [BL Billing Invoice.Discount Base Amount] - [BL Billing Invoice.Additional Discount Base Amount]

ELSE

[BH Invoice Net Base Amount] = [BL Billing Invoice.Total Inventory Goods Base Amount] + [BL Billing Invoice.Total Non Inventory Goods Base Amount] + [BL Billing Invoice.Total Add On Base Amount] + [BL Billing Invoice.Freight Charge Base Amount] - [BL Billing Invoice.Discount Base Amount] - [BL Billing Invoice.Additional Discount Base Amount]

END IF

BH Invoice Net Due Base

IF [Grain(Billing Invoice Line).Sum: BL Entered Price] IS NOT NULL THEN

[BH Invoice Net Due Base] = [BL Billing Invoice.Total Inventory Goods Base Amount] + [BL Billing Invoice.Total Non Inventory Goods Base Amount] + [Grain(Billing Invoice Line).Sum: BL Entered Price] + [BL Billing Invoice.Total Add On Base Amount] + [BL Billing Invoice.Freight Charge Base Amount] - [BL Billing Invoice.Discount Base Amount] - [BL Billing Invoice.Additional Discount Base Amount] + [BL Billing Invoice.Tax Total Base Amount] - [BL Billing Invoice.Terms Discount Base Amount] - [BL Billing Invoice.Down Payment Base Amount]

ELSE

[BH Invoice Net Due Base] = [BL Billing Invoice.Total Inventory Goods Base Amount] + [BL Billing Invoice.Total Non Inventory Goods Base Amount] + [BL Billing Invoice.Total Add On Base Amount] + [BL Billing Invoice.Freight Charge Base Amount] - [BL Billing Invoice.Discount Base Amount] - [BL Billing Invoice.Additional Discount Base Amount] + [BL Billing Invoice.Tax Total Base Amount] - [BL Billing Invoice.Terms Discount Base Amount] - [BL Billing Invoice.Down Payment Base Amount]

END IF

BH Invoice Total Base Amount

IF [Grain(Billing Invoice Line).Sum: BL Entered Price] IS NOT NULL THEN

[BH Invoice Total Base Amount] = [BL Billing Invoice.Total Inventory Goods Base Amount] + [BL Billing Invoice.Total Non Inventory Goods Base Amount] + [Grain(Billing Invoice Line).Sum: BL Entered Price] + [BL Billing Invoice.Total Add On Base Amount] + [BL Billing Invoice.Freight Charge Base Amount] - [BL Billing Invoice.Discount Base Amount] - [BL Billing Invoice.Additional Discount Base Amount] + [BL Billing Invoice.Tax Total Base Amount]

ELSE

[BH Invoice Total Base Amount] = [BL Billing Invoice.Total Inventory Goods Base Amount] + [BL Billing Invoice.Total Non Inventory Goods Base Amount] + [BL Billing Invoice.Total Add On Base Amount] + [BL Billing Invoice.Freight Charge Base Amount] - [BL Billing Invoice.Discount Base Amount] - [BL Billing Invoice.Additional Discount Base Amount] + [BL Billing Invoice.Tax Total Base Amount]

END IF

BH Minimum Margin BillingInvoice.MinimumMargin
BH Minimum Margin Percent BillingInvoice.MinimumMarginPercent
BH Open Order Amount BillingInvoice.OpenOrderAmount
BH Other Add On Charges Total BillingInvoice.OtherAddOnChargesTotal
BH Proforma Prepay Amount BillingInvoice.ProformaPrepayAmount
BH Tax Total Base Amount BillingInvoice.TaxTotalBaseAmount
BH Tax Total Currency Amount BillingInvoice.TaxTotal.TransactionAmount
BH Tax Total Currency Rate BillingInvoice.TaxTotal.BaseAmount.EnteredCurrencyRate
BH Taxable Base Amount BillingInvoice.DerivedTaxableTotalBaseAmount
BH Taxable Total BillingInvoice.TaxableTotal
BH Terms Discount Base Amount BillingInvoice.Terms DiscountBaseAmount
BH Terms Discount Currency Amount BillingInvoice.TermsDiscount.TransactionAmount
BH Terms Discount Currency Rate BillingInvoice.TermsDiscount.BaseAmount.EnteredCurrencyRate
BH Total Add On Base Amount BillingInvoice.TotalAddOnBaseAmount
BH Total Goods Base Amount

IF [Grain(Billing Invoice Line).Sum: BL Entered Price] IS NOT NULL THEN

[BH Total Goods Base Amount] = [BL Billing Invoice.Total Inventory Goods Base Amount] + [BL Billing Invoice.Total Non Inventory Goods Base Amount] + [Grain(Billing Invoice Line).Sum: BL Entered Price]

ELSE

[BH Total Goods Base Amount] = [BL Billing Invoice.Total Inventory Goods Base Amount] + [BL Billing Invoice.Total Non Inventory Goods Base Amount]

END IF

BH Total Inventory Goods Base Amount BillingInvoice.TotalInventoryGoodsBaseAmount
BH Total Non Inventory Goods Base Amount BillingInvoice.Total Non Inventory Goods Base Amount
Line 1 Entered Price

IF [Grain(Billing Invoice Line).Sum: BL Entered Price] IS NOT NULL THEN

[Line 1 Entered Price] = [Grain(Billing Invoice Line).Sum: BL Entered Price]

ELSE

[Line 1 Entered Price] = 0

END IF

Released Invoice Count

IF [BL Billing Invoice.Status] != 'Unreleased' THEN

[Released Invoice Count] = 1

ELSE

[Released Invoice Count] = 0

END IF

BL Add On Discount BillingInvoiceLine.AddOnDiscount
BL Allocated Discount BillingInvoiceLine.AllocatedDiscount
BL Commission Rate 1 BillingInvoiceLine.CommissionRate1
BL Commission Rate 2 BillingInvoiceLine.CommissionRate2
BL Commission Split Percentage BillingInvoiceLine.CommissionSplitPercentage
BL Current Cost BillingInvoiceLine.CurrentCost
BL Discount Amount 1 BillingInvoiceLine.DiscountAccountArray.DiscountAccountGroup[1].DscAmt
BL Discount Amount 2 BillingInvoiceLine.DiscountAccountArray.DiscountAccountGroup[2].DscAmt
BL Discount Amount 3 BillingInvoiceLine.DiscountAccountArray.DiscountAccountGroup[3].DscAmt
BL Discount Base Amounts BillingInvoiceLine.DiscountBaseAmounts
BL Entered Discount BillingInvoiceLine.EnteredDiscount
BL Entered Price BillingInvoiceLine.EnteredPrice
BL Gross Amount BillingInvoiceLine.LineGrossAmount
BL Gross Base Amount BillingInvoiceLine.LineGrossBaseAmount
BL Invoice Catch Weight Quantity BillingInvoiceLine.InvoiceCatchWeightQuantity
BL Line Net Amount Currency Rate BillingInvoiceLine.LineNetAmount.BaseAmount.EnteredCurrencyRate
BL Line Net Base Amount BillingInvoiceLine.LineNetAmount_BaseAmount_EnteredCurrencyAmount
BL Line Net Currency Amount BillingInvoiceLine.LineNetAmount.TransactionAmount
BL Line Total Base ([BL Billing Invoice Line.Tax Total] + [BL Billing Invoice Line.Line Net Currency Amount]) * [BL Billing Invoice Line.Currency Rate]
BL Price In Selling Unit Of Measure BillingInvoiceLine.PriceInSellingUnitOfMeasure
BL Quantity BillingInvoiceLine.Quantity
BL Sell To Stock BillingInvoiceLine.SellToStock
BL Selling Price BillingInvoiceLine.SellingPrice
BL Selling Price To Stock Conversion Factor BillingInvoiceLine.SellingPriceToStockConversionFactor
BL Tax Total BillingInvoiceLine.TaxTotal
BL Taxable Base Amount BillingInvoiceLine.TaxableBaseAmount
BL Taxable Base Currency Amount BillingInvoiceLine.TaxableBaseCurrencyAmount
BL Total Discount Base ([BL Billing Invoice Line.Discount Amount 1] + [BL Billing Invoice Line.Discount Amount 2] + [BL Billing Invoice Line.Discount Amount 3]) * [BL Billing Invoice Line.Currency Rate]
BL Unit Cost BillingInvoiceLine.UnitCost
BL Unit Price BillingInvoiceLine.UnitPrice