Virtual Properties

Virtual properties are used with calculated properties to create the formulas you want to apply to your data. How to access the properties is found at Add and Edit Record Properties. This section lists the properties available to you as default with your software. Your administrator can always add properties and there may be properties unique to your organization that are not listed in this section.

Adjusted History¶

This Adjusted History group property is used to improve reporting. Use it to change how many months of adjusted history you want and from where you want to start. The data displays in the forecast as a green line instead of blue.

Code: safesum(AdjustedHistory(12,0))

Code Explanation: This code multiplies the number of periods (12 in this example) by the when to start (for example, 0 starts from now, 2 would be to start from 2 periods ago)

Property Name: $AdjustedHistory

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Annual Revenue¶

This Forecast group property is used to determine the current fiscal year revenue.

Code: Forecast({unit:"Unit_$ASP",period:yr,daterange:AscToday})

Code Explanation: This code multiplies the Annual forecast units and average selling price per unit.

Property Name: $AnnualRevenue

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Forecast COGS¶

This Forecast group property is used to determine the cost of goods sold.

Code: Forecast({unit:'Unit_$COGS'})

Code Explanation: This code multiplies the forecast and the cost each units.

Property Name: $FCUnit_$COGS

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

Forecast Revenue¶

This Forecast group property is used to determine the revenue.

Code: Forecast({unit:'Unit_$ASP'})

Code Explanation: This code multiples forecast and the cost per unit.

Property Name: $FCUnit_$ASP

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

Forecast Units¶

This Forecast group property is used to determine the number of units.

Code: Forecast()

Code Explanation: This code ....

Property Name: $FCUnits

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

Bias Method¶

This Forecast Accuracy group property is used to determine bias in the data. Forecast bias is the tendency to either over-forecast or under-forecast, which leads to a forecasting error. Once bias is identified, it is corrected with a formula that is basically BIAS = Historical Forecast Units (2-months frozen) minus Actual Demand Units. If the forecast is greater than actual demand than the bias is positive (indicates over-forecast). The inverse results in a negative bias (indicates under-forecast).

Code:

if(RangeEnd>ForecastStart) return 0;
var dates=.$DATERANGE-.$PERIOD*(n-1)..0;
var fc=Forecast({daterange:dates,checkpoint:"Demand",offset:2da});
var ac=Forecast({daterange:dates});
100*(fc-ac)+i*abs(ac);

Code Explanation: This code ....

Property Name: $Bias(n)

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Bias-1¶

This Forecast Accuracy group property uses the Bias Method and offsets the data by one period.

Code: .$Bias(1)

Code Explanation: This code ....

Property Name: $Bias1

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

Bias-2¶

This Forecast Accuracy group property uses the Bias Method and offsets the data by two periods.

Code: .$Bias(2)

Code Explanation: This code ....

Property Name: $Bias2

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

Bias-3¶

This Forecast Accuracy group property uses the Bias Method and offsets the data by three periods.

Code: .$Bias(3)

Code Explanation: This code ....

Property Name: $Bias3

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

FVA Naïve Method¶

This Forecast Accuracy group property is used to compare the forecast value added method with the naïve method. FVA is an additional metric to help gauge the effectiveness of the process. The naïve model uses a minimum amount of effort and manipulation of data to prepare a forecast (for example the random walk or a seasonal random walk). This comparison can be used for each sequential step in a forecasting process to evaluate the value of causal inputs, sales overrides, or the consensus forecasting process.

Code:

if(RangeEnd>ForecastStart) return 0;
var dates=.$DATERANGE-.$PERIOD*(n-1)..0;
var at=Forecast({daterange:.$DATERANGE-.$PERIOD*n})*n;
var fc=Forecast({daterange:dates,checkpoint:"Demand",offset:2da});
var ac=Forecast({daterange:dates});
100*(abs(at-ac)-abs(fc-ac))+i*abs(ac);

Code Explanation: This code ....

Property Name: $FVAN(n)

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

FVA Naïve-1¶

This Forecast Accuracy group property uses the FVA Naïve Method over one period.

Code: .$FVAN(1)

Code Explanation: This code ....

Property Name: $FVAN1

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

FVA Naïve-2¶

This Forecast Accuracy group property uses the FVA Naïve Method over two periods.

Code: .$FVAN(2)

Code Explanation: This code ....

Property Name: $FVAN2

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

FVA Naïve-3¶

This Forecast Accuracy group property uses the FVA Naïve Method over three periods.

Code: .$FVAN(3)

Code Explanation: This code ....

Property Name: $FVAN3

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

FVA Stat Method¶

This Forecast Accuracy group property is used to compare the forecast value added method with the statistical forecast method. FVA is an additional metric to help gauge the effectiveness of the process. Statistical forecasting uses historical data to project what could happen in the future.

Code:

if(RangeEnd>ForecastStart) return 0;
var dates=.$DATERANGE-.$PERIOD*(n-1)..0;
var at=Forecast({daterange:dates,checkpoint:"Auto",offset:2da});
var fc=Forecast({daterange:dates,checkpoint:"Demand",offset:2da});
var ac=Forecast({daterange:dates});
100*(abs(at-ac)-abs(fc-ac))+i*abs(ac);

Code Explanation: This code ....

Property Name: $FVAS(n)

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

FVA Stat-1¶

This Forecast Accuracy group property uses the FVA Stat Method over one period.

Code: .$FVAS(1)

Code Explanation: This code ....

Property Name: $FVAS1

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

FVA Stat-2¶

This Forecast Accuracy group property uses the FVA Stat Method over two periods.

Code: .$FVAS(2)

Code Explanation: This code ....

Property Name: $FVAS2

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

FVA Stat-3¶

This Forecast Accuracy group property uses the FVA Stat Method over three periods.

Code: .$FVAS(3)

Code Explanation: This code ....

Property Name: $FVAS3

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

WMAPE Method¶

This Forecast Accuracy group property is used to determine the weighted mean absolute percent error. WMAPE is a measure of prediction accuracy of a forecasting method where errors are weighted by values of actuals (for example, in sales forecasting, errors are weighted by sales volume).

Code:

if(RangeEnd>ForecastStart) return 0;
var dates=.$DATERANGE-.$PERIOD*(n-1)..0;
var fc=Forecast({daterange:dates,checkpoint:"Demand",offset:2da});
var ac=Forecast({daterange:dates});
100*abs(fc-ac)+i*abs(ac);

Code Explanation: This code ....

Property Name: $WMAPE(n)

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

WMAPE-1¶

This Forecast Accuracy group property uses the WMAPE Method over one period.

Code: .$WMAPE(1)

Code Explanation: This code ....

Property Name: $WMAPE1

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

WMAPE-2¶

This Forecast Accuracy group property uses the WMAPE Method over two periods.

Code: .$WMAPE(2)

Code Explanation: This code ....

Property Name: $WMAPE2

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

WMAPE-3¶

This Forecast Accuracy group property uses the WMAPE Method over three periods.

Code: .$WMAPE(3)

Code Explanation: This code ....

Property Name: $WMAPE3

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

LADZ¶

This Forecast Alert group property determines the Last Absolute Deviation Z-score. The LADZ is the Wolters Kluwer-recommended approach to getting an actionable measure of forecast error. This measure is very useful in checking your historical data for anomalies in the last period. The Z-Score represents the standard deviation from the last period's forecasts and its actuals. A Z-Score or standard deviation of two or more indicates a recent significant structural change. Z-Score, unlike other measures, relies on the most recent data rather than an average of all historic forecasts and actuals. The Z-Score represents the standard deviation from the last period’s forecasts and its actuals. A Z-Score or standard deviation of two or more indicates a recent significant structural change. Was an item discontinued? Did a large new client recently join? Did a competitor exit, causing sales to ramp up?

Code:

var res=.forecast-.actual;
IF(count(res)>=2&&mask(std(res)),abs(last(res))/std(res),0);

Code Explanation: This code ....

Property Name: $LADZ

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

User Changes¶

This Forecast Alert group property is used to indicate forecast settings overridden by a user.

Code: UserChanges

Code Explanation: This code is on/off code to mark code that is no longer original and has be changed by the user.

Property Name: $UserOverrides

Source: Default

Data Type: Text

Grid Filter Type: Hidden

Expandable Timeline: No

Fitted Bias¶

This Forecast Fit group property determines bias percent.

Code: 100*(sum(.forecast)-sum(.actual))+i*abs(sum(.actual))

Code Explanation: This code ....

Property Name: $FBias

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Fitted MAD¶

This Forecast Fit group property determines mean absolute deviation.

Code: avg(abs(.forecast-.actual))+i

Code Explanation: This code ....

Property Name: $FMAD

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Fitted MAPE¶

This Forecast Fit group property determines mean absolute percent error.

Code: 100*avg(both(IF(a,abs(f-a)/a),f,a,.forecast,.actual))+i

Code Explanation: This code ....

Property Name: $FMAPE

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Fitted SMAPE¶

This Forecast Fit group property determines symmetric mean absolute percent error.

Code: 100*avg(both(IF(a,abs(f-a)/a),f,a,.forecast,.actual))+i

Code Explanation: This code ....

Property Name: $FSMAPE

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Fitted WMAPE¶

This Forecast Fit group property determines weighted mean absolute percent error.

Code: 100*sum(abs(.forecast-.actual))+i*sum(abs(.actual))

Code Explanation: This code ....

Property Name: $FWMAPE

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Prob Stockout¶

This Inventory Alerts group property determines the probability of stockout. The probability of stockout is the likelihood that insufficient inventory is available to completely fulfill a request.

Code:

if(!.exptype) return 0;
$this.expdata.pstkout*100;

Code Explanation: This code ....

Property Name: $PStockOut

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Stockout Days¶

This Inventory Alerts group property determines how many days an inventory item will be out of stock until it can be refilled.

Code: InvStockoutDays(.name)

Code Explanation: This number is hard-coded as part of the inventory data. This field calls the stockout days value.

Property Name: $StockoutDays

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Available¶

This Inventory Current group property determines the number of units currently available.

Code:

if(!.exptype) return 0;
max(0,round(.$OnHand-$this.expdata.rol));

Code Explanation: This code determines the available inventory by subtracting the forecasted inventory from the on hand inventory.

Property Name: $Available

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Current DOH¶

This Inventory Current group property determines the number of units on hand at a point in time.

Code:

if(!.exptype) return 0;
.$OnHand+i*Forecast({period:mo,daterange:AscToday})/mo*da;

Code Explanation: This code uses the on hand inventory value and forecast inventory at a specific month/day to determine how much will be on hand at that point in time.

Property Name: $CDOH

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Current On Hand¶

This Inventory Current group property determines the number of units currently on hand.

Code:

if(!.exptype) return 0;
InvGetValue(AspList[.exptype].params.onhand,this,0);

Code Explanation: This code ....

Property Name: $OnHand

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Current On Hand Cost¶

This Inventory Current group property uses the Current On Hand formula to determine the cost of keeping an inventory item on hand. Use this to compare with the Current On Hand Cost to decide which is better, keeping it in inventory or ordering it as request comes in.

Code: .$OnHand*.$InvCost

Code Explanation: This code ....

Property Name$OnHandCog

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Current On Order¶

This Inventory Current group property determines the number of units on order.

Code:

if(!.exptype) return 0;
InvGetValue(AspList[.exptype].params.onorder,this,0);

Code Explanation: This code ....

Property Name: $OnOrder

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Current On Order Cost¶

This Inventory Current group property uses the Current On Order formula to determine the cost of ordering an inventory item. Use this to compare with the Current On Hand Cost to decide which is better, keeping it in inventory or ordering it as sale comes in.

Code: .$OnOrder*.$InvCost

Code Explanation: This code ....

Property Name$OnOrderCog

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Current Turns¶

This Inventory Current group property uses the On Hand formula to determine how often an inventory item is ordered.

Code:

if(!.exptype) return 0;
Forecast({period:mo,daterange:AscToday})/mo*yr+i*.$OnHand;

Code Explanation: This code ....

Property Name: $CTurns

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Current WOH¶

This Inventory Current group property determines the number of weeks on hand left of an inventory item.

Code:

if(!.exptype) return 0;
.$OnHand+i*Forecast({period:mo,daterange:AscToday})/mo*wk;

Code Explanation: This code ....

Property Name: $CWOH

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Days to Stockout¶

This Inventory Current group property determines the number of days on hand left of an inventory item if no new orders are placed.

Code:

if(!.exptype) return 0;
$this.expdata.doh;

Code Explanation: This code ....

Property Name: $DOH

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

EOQ¶

This Inventory Current group property determines the economic order quantity. EOQ is the ideal order quantity a company should purchase to minimize inventory costs such as holding costs, shortage costs, and order costs.

Code:

if(!.exptype) return 0;
round($this.expdata.eoq);

Code Explanation: EOQ is defined in another part of the program. This field calls the EOQ value and rounds it to the nearest whole number.

Property Name: $EOQ

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Fill Rate¶

This Inventory Current group property determines how often an inventory item should be ordered.

Code:

if(!.exptype) return 0;
100*$this.expdata.fillrate;

Code Explanation: This code is defined in another part of the program. This field calls the fill rate value and multiplies it by 100.

Property Name: $FillRate

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Maximum¶

This Inventory Current group property determines the maximum number of an inventory item that should be ordered.

Code:

if(!.exptype) return 0;
round($this.expdata.rol+$this.expdata.eoq);

Code Explanation: This code adds the . . .

Property Name: $MaxInv

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Minimum¶

This Inventory Current group property determines the minimum number of a unit that should be inventory to trigger a re-order.

Code:

if(!.exptype) return 0;
round($this.expdata.rol);

Code Explanation: This code ....

Property Name: $MinInv

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Order Next¶

This Inventory Current group property determines how many units should be ordered after today.

Code:

if(!.exptype) return 0;
var schedule=each(IF(s[0]>=$this.expdata.plandate,s),s,$this.expdata.schedule);
round(IF($this.expdata.ordernow,schedule[1][1],schedule[0][1]));

Code Explanation: This code ....

Property Name: $OrderNext

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Order Next Cost¶

This Inventory Current group property uses the Order Next and Unit Cost formulas to determine how many much the next order costs.

Code: .$OrderNext*.$InvCost

Code Explanation: This code ....

Property Name: $OrderNextCog

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Order Today¶

This Inventory Current group property determines how many units are planned to be ordered today.

Code:

if(!.exptype) return 0;
round(sum(eachptr(IF(s[0]>=$this.expdata.plandate&&s[0]<now,s[1]),s,$this.expdata.cschedule)));

Code Explanation: This code ....

Property Name: $OrderToday

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Order Today Cost¶

This Inventory Current group property uses the Order Today and Inventory Cost formulas to determine how many much today's order costs.

Code: .$OrderToday*.$InvCost

Code Explanation: This code ....

Property Name: $OrderTodayCog

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Safety Stock¶

This Inventory Current group property determines the minimum number of a unit that should be kept in inventory to prevent a stockout.

Code:

if(!.exptype) return 0;
round($this.expdata.safety);

Code Explanation: This code ....

Property Name: $Safety

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Suggested Order¶

This Inventory Current group property determines how many units should be ordered now.

Code:

if(!.exptype) return 0;
round($this.expdata.ordernow);

Code Explanation: This code ....

Property Name: $OrderNow

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Suggested Order Cost¶

This Inventory Current group property uses the Order Now and Inventory Cost formulas to determine how many much an order costs right now.

Code: .$OrderNow*.$InvCost

Code Explanation: This code ....

Property Name: $OrderNowCog

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Unit Cost¶

This Inventory Current group property determines the standard unit cost for an inventory item.

Code:

if(!.exptype) return 0;
InvGetValue(AspList[.exptype].params.cost,this,0)*ExchangeRate;

Code Explanation: This code ....

Property Name: $InvCost

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Unit Price¶

This Inventory Current group property determines the standard unit selling price for an inventory item.

Code:

if(!.exptype) return 0;
InvGetValue(AspList[.exptype].params.price,this,0)*ExchangeRate;

Code Explanation: This code ....

Property Name: $InvPrice

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Forecast Arrivals¶

This Inventory Forecast group property determines when an inventory item will arrive.

Code:

if(!.exptype) return 0;
var start=RangeStart;
var end=RangeEnd;
sum(each(IF(x[2]>=start&&x[2]<end,x[1]),x,$this.expdata.schedule));

Code Explanation: This code ....

Property Name: $Arrivals

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

Forecast Arrivals Cost¶

This Inventory Forecast group property uses the Forecast Arrivals and Unit Cost formulas to determine how many much an order will cost when an inventory item arrives.

Code: .$Arrivals*.$InvCost

Code Explanation: This code ....

Property Name: $Arrivals_COGS

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

Forecast DOH¶

This Inventory Forecast group property forecasts the number of days on hand left of an inventory item if no new orders are placed.

Code:

if(!.exptype) return 0;
Inventory+i*Forecast({period:mo})/mo*da;

Code Explanation: This code ....

Property Name: $FDOH

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

Forecast Inventory¶

This Inventory Forecast group property forecasts the number of units of an inventory item.

Code:

if(!.exptype) return 0;
Inventory;

Code Explanation: This code ....

Property Name: $Inventory

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

Forecast Inventory Cost¶

This Inventory Forecast group property uses the Forecast Inventory and Unit Cost formulas to forecast the cost an inventory item.

Code: Inventory*.$InvCost

Code Explanation: This code ....

Property Name: $Inventory_COGS

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

Forecast Orders¶

This Inventory Forecast group property forecasts the number of units of an inventory item.

Code:

if(!.exptype) return 0;
var start=RangeStart;
var end=RangeEnd;
sum(each(IF(x[0]>=start&&x[0]<end,x[1]),x,$this.expdata.schedule));

Code Explanation: This code ....

Property Name: $Orders

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

Forecast Orders Cost¶

This Inventory Forecast group property uses the Forecast Orders and Unit Cost formulas to forecast the cost orders.

Code: .$Orders*.$InvCost

Code Explanation: This code ....

Property Name: $Order_COGS

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

Forecast Spoilage¶

This Inventory Forecast group property forecasts the number of units of an inventory item that is expected to spoil.

Code:

if(!.exptype) return 0;
var start=RangeStart;
var end=RangeEnd;
sum(each(IF(x[0]>=start&&x[0]<end,x[1]),x,$this.expdata.expirations));

Code Explanation: This code determines the spoilage by using the expiration dates, when the inventory is fresh, and when the inventory is spoiled.

Property Name: $Spoilage

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

Forecast Spoilage Cost¶

This Inventory Forecast group property uses the Forecast Spoilage and Unit Cost formulas to forecast the cost of the inventory that is expected to spoil.

Code: .$Spoilage*.$InvCost

Code Explanation: This code multiplies the spoilage forecasted by the cost per unit to predict the cost of the spoilage.

Property Name: $SpoilageCog

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

Forecast Turns¶

This Inventory Forecast group property uses the Forecast Inventory formula to forecast how often an inventory item will need to be ordered.

Code:

if(!.exptype) return 0;
Forecast({period:mo})/mo*yr+i*Inventory;

Code Explanation: This code ....

Property Name: $FTurns

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

Forecast WOH¶

This Inventory Forecast group property forecasts the number of weeks on hand left of an inventory item.

Code:

if(!.exptype) return 0;
Inventory+i*Forecast({period:mo})/mo*wk;

Code Explanation: This code ....

Property Name: $FWOH

Source: Default

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: Yes

Available (COGS)¶

This Other group property is used to determine the cost of goods sold that are available for your entire inventory.

Code: Virtual_AvailableCog.value

Code Explanation: This code is defined in another part of the program. This field calls the available cost of goods sold value to use with another function.

Property Name: $AvailableCog

Source: DLM

Data Type: Auto

Grid Filter Type: Hidden

Expandable Timeline: No

Expected Spoilage¶

This Other group property is used to determine how much inventory is expected to spoil.

Code: Virtual_Spoilage.value

Code Explanation: This code is defined in another part of the program. This field calls the expected spoilage value to use with another function.

Property Name: $Spoilage

Source: DLM

Data Type: Auto

Grid Filter Type: Hidden

Expandable Timeline: No

Transfer¶

This Other group property is used to determine how much inventory is expected to transfer from one location to another, for example, from warehouse to warehouse.

Code: Virtual_Transfer.value

Code Explanation: This code is defined in another part of the program. This field calls the transfer value to use with another function.

Property Name: $Transfer

Source: DLM

Data Type: Auto

Grid Filter Type: Hidden

Expandable Timeline: No

Count¶

This Pivot Chart group property is used to count. This property can be "paired" with whatever you need to count, for example, the number of rows or column in a pivot chart, the number of inventory items listed.

Code: 1

Code Explanation: This code returns the number of elements in a list if only one argument is supplied, or the number of arguments if more than one argument is supplied. See count for examples.

Property Name: $COUNT

Source: System

Data Type: Numeric

Grid Filter Type: Hidden

Expandable Timeline: No

Data Label¶

This Pivot Chart group property is used to add a column or row label to a pivot chart.

Code:

Code Explanation: This code returns any text entered as a row or column heading.

Property Name: $DATA

Source: System

Data Type: Text

Grid Filter Type: Hidden

Expandable Timeline: No

Month¶

This Pivot Chart group property is used to add months to a pivot chart.

Code: $MONTH

Code Explanation: This code returns the month derived from a date-time serial number. See month for examples.

Property Name: $MONTH

Source: System

Data Type: Text

Grid Filter Type: Hidden

Expandable Timeline: No

Timeline¶

This Pivot Chart group property is used to add a timeline to a pivot chart.

Code: $TIME

Code Explanation: This code returns the time derived from a date-time serial number. See time for examples.

Property Name: $TIME

Source: System

Data Type: Text

Grid Filter Type: Hidden

Expandable Timeline: No

Year¶

This Pivot Chart group property is used to add a year to a pivot chart.

Code: $YEAR

Code Explanation: This code returns the year derived from a date-time serial number. See year for examples.

Property Name: $YEAR

Source: System

Data Type: Text

Grid Filter Type: Hidden

Expandable Timeline: No

✓¶

This System group property is used in the system when an approval is needed

Code: $Approve

Code Explanation: This code is an on/off field to show a checkmark when an item is approved.

Property Name: $Approve

Source: System

Data Type: Text

Grid Filter Type: Hidden

Expandable Timeline: No