| 3 Months Average Inventory |
Sum ( AvgInv 1 +….+Avg 3)/3
|
| 6 Months Average Inventory |
Sum ( AvgInv 1 +….+Avg 6)/6
|
| 9 Months Average Inventory |
Sum ( AvgInv 1 +….+Avg 9)/9
|
| 12 Months Average Inventory |
Sum ( AvgInv 1 +….+Avg 12)/12
|
| 15 Months Average Inventory |
Sum ( AvgInv 1 +….+Avg 15)/15
|
| 18 Months Average Inventory |
Sum ( AvgInv 1 +….+Avg 18)/18
|
| 3 Months COGS |
Sum (Cost 1 +….+Cost 3)
|
| 6 Months COGS |
Sum (Cost 1 +….+Cost 6)
|
| 9 Months COGS |
Sum (Cost 1 +….+Cost 9)
|
| 12 Months COGS |
Sum (Cost 1 +….+Cost 12)
|
| 15 Months COGS |
Sum (Cost 1 +….+Cost 15)
|
| 18 Months COGS |
Sum (Cost 1 +….+Cost 18)
|
| 3 Months Turn |
IF([IU_Inventory_date: Sum: IU_3_MonthsInv] is null or [IU_Inventory_date: Sum: IU_3_MonthsInv] = 0,0,(IFNULL([IU_Inventory_date: Sum: IU_3Months_COGS],0.00)/[IU_Inventory_date: Sum: IU_3_MonthsInv])*4)
|
| 6 Months Turn |
IF([IU_Inventory_date: Sum: IU_6_MonthsInv] is null or [IU_Inventory_date: Sum: IU_6_MonthsInv] = 0,0,(IFNULL([IU_Inventory_date: Sum: IU_6Months_COGS],0.00)/[IU_Inventory_date: Sum: IU_6_MonthsInv])*2)
|
| 9 Months Turn |
IF([IU_Inventory_date: Sum: IU_9_MonthsInv] is null or [IU_Inventory_date: Sum: IU_9_MonthsInv] = 0,0,(IFNULL([IU_Inventory_date: Sum: IU_9Months_COGS],0.00)/[IU_Inventory_date: Sum: IU_9_MonthsInv])*1.333333)
|
| 12 Months Turn |
IF([IU_Inventory_date: Sum: IU_12_MonthsInv] is null or [IU_Inventory_date: Sum: IU_12_MonthsInv] = 0,0,(IFNULL([IU_Inventory_date: Sum: IU_12Months_COGS],0.00)/[IU_Inventory_date: Sum: IU_12_MonthsInv])*1)
|
| 15 Months Turn |
IF([IU_Inventory_date: Sum: IU_15_MonthsInv] is null or [IU_Inventory_date: Sum: IU_15_MonthsInv] = 0,0,(IFNULL([IU_Inventory_date: Sum: IU_15Months_COGS],0.00)/[IU_Inventory_date: Sum: IU_15_MonthsInv])/1.25)
|
| 18 Months Turn |
IF([IU_Inventory_date: Sum: IU_18_MonthsInv] is null or [IU_Inventory_date: Sum: IU_18_MonthsInv] = 0,0,(IFNULL([IU_Inventory_date: Sum: IU_18Months_COGS],0.00)/[IU_Inventory_date: Sum: IU_18_MonthsInv])/1.5)
|
| Inventory Turns |
Cost of Goods Sold / Average Inventory
|
| Cost |
IF([ICSWU_DS.icswu_avginvval_1]=0 and [ICSWU_DS.icswu_statustype]='o',0,IIF(IFNULL([ICSWU_DS.icswu_overusage_1],0.00) <> 0 or [ICSWU_DS.icswu_overreasty_1] is not null,(IFNULL([ICSWU_DS.icswu_overusage_1],0.00)*IFNULL([ICSWU_DS.icswu_unitcost_1],0.00)),(IFNULL([ICSWU_DS.icswu_normusage_1],0.00)*IFNULL([ICSWU_DS.icswu_unitcost_1],0.00))))
|
| Line Hits |
Line Hits = # of times a product appears on a sales order
[IU_Inventory_date: Sum: IU_linehits]
|
| Lost Business Hits |
# of times a product is marked as Lost Business on a sales order
[IU_Inventory_date: Sum: IU_linehitslb]
|
| Warehouse Transfer Hits |
# of times a product has been transferred on an order
[IU_Inventory_date: Sum: IU_linehitswt]
|
| Total Hits |
Line Hits + Lost Business Hits + Warehouse Transfer Hits
IU_linehits + : IU_linehitslb + : IU_linehitswt
|
| On Hand Quantity |
icsw.qtyonhand – icsw.qtyreservd – icsw.qtycommit - icsw.qtybo – icsw.qtydemand + icsw.qtyrcv
|
|
[icqty]=([ICSW.qtyonhand][ICSW.qtyunavail]+[ICSW.qtyrcvd])- ([ICSW.custqtyonhand]+[ICSW.custqtyunavail]+[ICSW.custqtyrcvd])
|
| On Hand Average Inventory Value |
((IFNULL([ICSW.icsw_qtyonhand],0.00)-IFNULL([ICSW.icsw_qtyreservd],0.00)-IFNULL([ICSW.icsw_qtycommit],0.00)-IFNULL([ICSW.icsw_qtybo],0.00)-IFNULL([ICSW.icsw_qtydemand],0.00)+IFNULL([ICSW.icsw_qtyrcvd],0.00)) * IFNULL([ICSW.icsw_avgcost],0.00))
|
| On Hand Standard Inventory Value |
((IFNULL([ICSW.icsw_qtyonhand],0.00)-IFNULL([ICSW.icsw_qtyreservd],0.00)-IFNULL([ICSW.icsw_qtycommit],0.00)-IFNULL([ICSW.icsw_qtybo],0.00)-IFNULL([ICSW.icsw_qtydemand],0.00)+IFNULL([ICSW.icsw_qtyrcvd],0.00)) * IFNULL([ICSW.icsw_stndcost],0.00))
|
| Normal Usage |
[IU_Inventory_date: Sum: IU_normusage]
|
| Transfer Usage |
[IU_Inventory_date: Sum: IU_transusage]
|
| Override Usage |
[IU_Inventory_date: Sum: IU_overusage]
|
| Hits % All Items |
IF([oeel_invoicedt: # lineno] is null or [IU_Inventory_date: Total Hits] = 0,0,([oeel_invoicedt: # lineno]/[IU_Inventory_date: Total Hits])*100)
|
| Inventory Value (Avg) |
[icsw_InventoryValue_Avgcost]=[ICSW.avgcost]+IIF([Level(SASC.SASC).sasc_icincaddgl]='true',[ICSW.addoncost],0)*[costperunitstk]*[icqty]
|
| Inventory Value (Lst) |
[icsw_InventoryValue_Lastcost]=[ICSW.lastcost]+IIF([Level(SASC.SASC).sasc_icincaddgl]='true',[ICSW.addoncost],0)*[costperunitstk]*[icqty]
|
| Inventory Value (Repl) |
[icsw_InventoryValue_Replcost]=[ICSW.replcost]+IIF([Level(SASC.SASC).sasc_icincaddgl]='true',[ICSW.addoncost],0)*[costperunitstk]*[icqty]
|
| Inventory Value (Stnd) |
[icsw_InventoryValue_Stndcost]=[ICSW.stndcost]+IIF([Level(SASC.SASC).sasc_icincaddgl]='true',[ICSW.addoncost],0)*[costperunitstk]*[icqty]
|