Stock Value Report?

Posted by Tara on May 8, 2007, 8:16 am

Please log in for more thread options

Does anyone have a report or a means of getting a figure for the total value
of stock based of selling price? I'd like a figure that inclusive of VAT and
another thats exclusive. Any help would be appreciated.

Posted by Akber Alwani on May 9, 2007, 2:31 am

Please log in for more thread options

HI Tara, just add the sale price @value column to Item Quantity List.grp
report.
To accomplish this you can add the below code anywhere in the abvoe
mentioned report.

Begin Column
FieldName = "ValueCost"
DrillDownFieldName = ""
DrillDownReportName = ""
StoreIDFieldName = ""
Title = "Value @ SellingPrice"
VBDataType = vbCurrency
Formula = "Price * (Quantity - QuantityCommitted)"
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1300
GroupMethod = groupmethodNone
ColFormat = ""
End Column

You can also add the above code in any other report where you have make the
inventory quantity printed.

"Tara" wrote:

> Does anyone have a report or a means of getting a figure for the total value

> of stock based of selling price? I'd like a figure that inclusive of VAT and

> another thats exclusive. Any help would be appreciated.