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:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.