Stock Value Report?

May 08, 2007 1 Replies

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.


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:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required